Question 1

Of the following column names, which one is most likely a primary key column?

Accepted Answer

A)  Price 
B)  Description 
C)  ItemNumber 
D)  Quantity 
A)  Price 
B)  Description 
C)  ItemNumber 
D)  Quantity

Question 2

Appending the attribute ;create=true to the database URL:

Accepted Answer

A)  creates a new database 
B)  creates a new table 
C)  creates a new row 
D)  creates a new column 
A)  creates a new database 
B)  creates a new table 
C)  creates a new row 
D)  creates a new column

Question 3

This type of SQL statement is used to retrieve the rows from a table.

Accepted Answer

A)  GET 
B)  SELECT 
C)  READ 
D)  RETRIEVE 
A)  GET 
B)  SELECT 
C)  READ 
D)  RETRIEVE

Question 4

In SQL, this statement is used to change the contents of an existing row in a table:

Accepted Answer

A)  SET ROW 
B)  CHANGE 
C)  UPDATE 
D)  REFRESH 
A)  SET ROW 
B)  CHANGE 
C)  UPDATE 
D)  REFRESH

Question 5

In SQL, this character can be used as a wildcard to represent a single character.

Accepted Answer

A)  % 
B)  $ 
C)  _ 
D)  * 
A)  % 
B)  $ 
C)  _ 
D)  *

Question 6

Column names in a database are:

Accepted Answer

A)  case sensitive 
B)  similar to Java data types 
C)  not case sensitive 
D)  always uppercase letters 
A)  case sensitive 
B)  similar to Java data types 
C)  not case sensitive 
D)  always uppercase letters

Question 7

SQL stands for:

Accepted Answer

A)  structured query language 
B)  standard equivalent language 
C)  semiconductor qualified language 
D)  Simple equation library 
A)  structured query language 
B)  standard equivalent language 
C)  semiconductor qualified language 
D)  Simple equation library

Question 8

This is the standard language for working with database management systems.

Accepted Answer

A)  SQL 
B)  BASIC 
C)  ADA 
D)  COBOL 
A)  SQL 
B)  BASIC 
C)  ADA 
D)  COBOL

Of the following column names, which one is most likely a primary key column?

Appending the attribute ;create=true to the database URL:

This type of SQL statement is used to retrieve the rows from a table.

In SQL, this statement is used to change the contents of an existing row in a table:

In SQL, this character can be used as a wildcard to represent a single character.

Column names in a database are:

SQL stands for:

This is the standard language for working with database management systems.

Introduction to Computers and Java

Java Fundamentals

Decision Structures

Loops and Files

Methods

A First Look at Classes

Arrays and the Arraylist Class

A Second Look at Classes and Objects

Text Processing and More About Wrapper Classes

Inheritance

Exceptions and Advanced File IO

A First Look at GUI Applications

Advanced GUI Applications

Applets and More

Creating GUI Applications With Javafx and Scene Builder

Recursion

Filters

Exam 17: Databases

Of the following column names, which one is most likely a primary key column?

Appending the attribute ;create=true to the database URL:

This type of SQL statement is used to retrieve the rows from a table.

In SQL, this statement is used to change the contents of an existing row in a table:

In SQL, this character can be used as a wildcard to represent a single character.

Column names in a database are:

SQL stands for:

This is the standard language for working with database management systems.

Introduction to Computers and Java

Java Fundamentals

Decision Structures

Loops and Files

Methods

A First Look at Classes

Arrays and the Arraylist Class

A Second Look at Classes and Objects

Text Processing and More About Wrapper Classes

Inheritance

Exceptions and Advanced File IO

A First Look at GUI Applications

Advanced GUI Applications

Applets and More

Creating GUI Applications With Javafx and Scene Builder

Recursion

Filters