Question 1

The content of dynamic views is generated when they are referenced.

Accepted Answer

A) True 
 B)False

Question 2

Requiring a CustomerID to exist in a Primary table before it can exist in a foreign table is an example of:

Accepted Answer

A)  Referential Referring. 
B)  Referential Integrity. 
C)  Ethical Integrity. 
D)  the Hoffer Principle. 
A)  Referential Referring. 
B)  Referential Integrity. 
C)  Ethical Integrity. 
D)  the Hoffer Principle.

Question 3

Which of the following is true of the order in which SQL statements are evaluated?

Accepted Answer

A)  The SELECT clause is always processed first. 
B)  The SELECT clause is always processed last. 
C)  The SELECT clause is processed before the ORDER BY clause. 
D)  The GROUP BY clause is processed before the WHERE clause. 
A)  The SELECT clause is always processed first. 
B)  The SELECT clause is always processed last. 
C)  The SELECT clause is processed before the ORDER BY clause. 
D)  The GROUP BY clause is processed before the WHERE clause.

Question 4

The comparison operators = and != are used to establish a range of values.

Accepted Answer

A) True 
 B)False

Question 5

Multiple values returned from an SQL query that includes an aggregate function are called:

Accepted Answer

A)  vector aggregates. 
B)  scalar aggregates. 
C)  agates. 
D)  summations. 
A)  vector aggregates. 
B)  scalar aggregates. 
C)  agates. 
D)  summations.

Question 6

What result set will the following query return? Select Item_No
From Order_V
Where quantity > 10;

Accepted Answer

A)  The Item_No of all orders that had more than 10 items 
B)  The Order_Id of all orders that had more than one item 
C)  The Order_Id of all orders that had more than 10 items 
D)  The Item_No of all orders that had 10 or more items 
A)  The Item_No of all orders that had more than 10 items 
B)  The Order_Id of all orders that had more than one item 
C)  The Order_Id of all orders that had more than 10 items 
D)  The Item_No of all orders that had 10 or more items

Question 7

Expressions are mathematical manipulations of data in a table that may be included as part of the SELECT statement.

Accepted Answer

A) True 
 B)False

Question 8

DCL is used to update the database with new records.

Accepted Answer

A) True 
 B)False

Question 9

The SQL command used to populate tables is the INSERT command.

Accepted Answer

A) True 
 B)False

Question 10

What does the following SQL statement do? Alter Table Customer_T
Add (Type Varchar (2));

Accepted Answer

A)  Alters the Customer_T table to accept Type 2 Varchars 
B)  Alters the Customer_T table to be a Type 2 Varchar 
C)  Alters the Customer_T table, and adds a field called "Type" 
D)  Alters the Customer_T table by adding a 2-byte field called "Varchar" 
A)  Alters the Customer_T table to accept Type 2 Varchars 
B)  Alters the Customer_T table to be a Type 2 Varchar 
C)  Alters the Customer_T table, and adds a field called "Type" 
D)  Alters the Customer_T table by adding a 2-byte field called "Varchar"

Question 11

Which of the following is the wildcard operator in SQL statements?

Accepted Answer

A)   
B)  * 
C)  = 
D)  & 
A)   
B)  * 
C)  = 
D)  &

Question 12

Which of the following counts ONLY rows that contain a value?

Accepted Answer

A)  Count 
B)  Count(*) 
C)  Tally(*) 
D)  Checknum 
A)  Count 
B)  Count(*) 
C)  Tally(*) 
D)  Checknum

Question 13

The following insert command would work fine:
insert into budget values 121,222,111;

Accepted Answer

A) True 
 B)False

Question 14

The HAVING clause and the WHERE clause perform the same operation.

Accepted Answer

A) True 
 B)False

Question 15

Which of the following will produce the minimum of all standard prices?

Accepted Answer

A)  Select standard_price from Product_V where Standard_Price = min; 
B)  Select min(standard_price) from Product_V; 
C)  Select Standard_Price from min(Product_V); 
D)  Select min(Standard_Price) from Product_V where Standard_Price = min(Standard_Price); 
A)  Select standard_price from Product_V where Standard_Price = min; 
B)  Select min(standard_price) from Product_V; 
C)  Select Standard_Price from min(Product_V); 
D)  Select min(Standard_Price) from Product_V where Standard_Price = min(Standard_Price);

Question 16

The CREATE SCHEMA DDL command is used to create a table.

Accepted Answer

A) True 
 B)False

Question 17

What will be returned when the following SQL query is executed? Select driver_no, count(*) as num_deliveries
From deliveries
Group by driver_no
Having count(*) > 2;

Accepted Answer

A)  A listing of all drivers who made more than 2 deliveries as well as a count of the number of deliveries 
B)  A listing of all drivers 
C)  A listing of the number of deliveries greater than 2 
D)  A listing of all drivers who made more than 2 deliveries 
A)  A listing of all drivers who made more than 2 deliveries as well as a count of the number of deliveries 
B)  A listing of all drivers 
C)  A listing of the number of deliveries greater than 2 
D)  A listing of all drivers who made more than 2 deliveries

Question 18

What does the following SQL command do? insert into Customer_T values (001,'John Smith','231 West St','Boston','MA','02115');

Accepted Answer

A)  Adds a new record to the Customer_T 
B)  Creates the Customer_T table 
C)  Deletes the Customer_T table 
D)  Updates the Customer_T table 
A)  Adds a new record to the Customer_T 
B)  Creates the Customer_T table 
C)  Deletes the Customer_T table 
D)  Updates the Customer_T table

Question 19

When creating tables, it's important to decide which columns will allow null values before the table is created.

Accepted Answer

A) True 
 B)False

Question 20

Indexes are created in most RDBMSs to:

Accepted Answer

A)  provide a quicker way to store data. 
B)  decrease the amount of disk space utilized. 
C)  provide rapid random and sequential access to base-table data. 
D)  increase the cost of implementation. 
A)  provide a quicker way to store data. 
B)  decrease the amount of disk space utilized. 
C)  provide rapid random and sequential access to base-table data. 
D)  increase the cost of implementation.

The content of dynamic views is generated when they are referenced.

Requiring a CustomerID to exist in a Primary table before it can exist in a foreign table is an example of:

Which of the following is true of the order in which SQL statements are evaluated?

The comparison operators = and != are used to establish a range of values.

Multiple values returned from an SQL query that includes an aggregate function are called:

What result set will the following query return? Select Item_No From Order_V Where quantity > 10;

Expressions are mathematical manipulations of data in a table that may be included as part of the SELECT statement.

DCL is used to update the database with new records.

The SQL command used to populate tables is the INSERT command.

What does the following SQL statement do? Alter Table Customer_T Add (Type Varchar (2));

Which of the following is the wildcard operator in SQL statements?

Which of the following counts ONLY rows that contain a value?

The following insert command would work fine: insert into budget values 121,222,111;

The HAVING clause and the WHERE clause perform the same operation.

Which of the following will produce the minimum of all standard prices?

The CREATE SCHEMA DDL command is used to create a table.

What will be returned when the following SQL query is executed? Select driver_no, count() as num_deliveries From deliveries Group by driver_no Having count() > 2;

What does the following SQL command do? insert into Customer_T values (001,'John Smith','231 West St','Boston','MA','02115');

When creating tables, it's important to decide which columns will allow null values before the table is created.

Indexes are created in most RDBMSs to:

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model

Logical Database Design and the Relational Model

Physical Database Design and Performance

Advanced SQL

Database Application Development

Data Warehousing

Data Quality and Integration

Big Data and Analytics

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Filters

Exam 6: Introduction to SQL

The content of dynamic views is generated when they are referenced.

Requiring a CustomerID to exist in a Primary table before it can exist in a foreign table is an example of:

Which of the following is true of the order in which SQL statements are evaluated?

The comparison operators = and != are used to establish a range of values.

Multiple values returned from an SQL query that includes an aggregate function are called:

What result set will the following query return? Select Item_No From Order_V Where quantity > 10;

Expressions are mathematical manipulations of data in a table that may be included as part of the SELECT statement.

DCL is used to update the database with new records.

The SQL command used to populate tables is the INSERT command.

What does the following SQL statement do? Alter Table Customer_T Add (Type Varchar (2));

Which of the following is the wildcard operator in SQL statements?

Which of the following counts ONLY rows that contain a value?

The following insert command would work fine: insert into budget values 121,222,111;

The HAVING clause and the WHERE clause perform the same operation.

Which of the following will produce the minimum of all standard prices?

The CREATE SCHEMA DDL command is used to create a table.

What will be returned when the following SQL query is executed? Select driver_no, count(*) as num_deliveries From deliveries Group by driver_no Having count(*) > 2;

What does the following SQL command do? insert into Customer_T values (001,'John Smith','231 West St','Boston','MA','02115');

When creating tables, it's important to decide which columns will allow null values before the table is created.

Indexes are created in most RDBMSs to:

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model

Logical Database Design and the Relational Model

Physical Database Design and Performance

Advanced SQL

Database Application Development

Data Warehousing

Data Quality and Integration

Big Data and Analytics

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Filters

What will be returned when the following SQL query is executed? Select driver_no, count() as num_deliveries From deliveries Group by driver_no Having count() > 2;