Question 1

What result set is returned from the following query? 
SELECT Customer_Name, telephone
FROM customers
WHERE city in ('Boston','New York','Denver');

Accepted Answer

A)  The Customer_Name and telephone of all customers 
B)  The Customer_Name and telephone of all customers living in either Boston, New York or Denver 
C)  The Customer_Name and telephone of all customers living in Boston and New York and Denver 
D)  The Customer_Name of all customers living in Boston, New York or Denver 
A)  The Customer_Name and telephone of all customers 
B)  The Customer_Name and telephone of all customers living in either Boston, New York or Denver 
C)  The Customer_Name and telephone of all customers living in Boston and New York and Denver 
D)  The Customer_Name of all customers living in Boston, New York or Denver

Question 2

What steps should be followed when preparing to create a table?

Accepted Answer

When preparing to create a table, one sh

Question 3

Implementation of a standard can never stifle creativity and innovation.

Accepted Answer

A) True 
 B)False

Question 4

Discuss when to use the GROUP BY clause.

Accepted Answer

The GROUP BY clause is useful when you h

Question 5

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 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

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.

Question 8

Adding the DISTINCT keyword to a query eliminates duplicates.

Accepted Answer

A) True 
 B)False

Question 9

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 10

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 11

A single value returned from an SQL query that includes an aggregate function is called a vector aggregate.

Accepted Answer

A) True 
 B)False

Question 12

The views are created by executing a CREATE VIEW SQL command.

Accepted Answer

A) True 
 B)False

Question 13

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 by adding 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 by adding a field called "Type" 
D)  Alters the Customer_T table by adding a 2-byte field called "Varchar"

Question 14

What were the original purposes of SQL, and does SQL as we know it today live up to those standards?

Accepted Answer

The following were the original purposes

Question 15

A view may not be updated directly if it contains:

Accepted Answer

A)  the SELECT clause. 
B)  the HAVING clause. 
C)  the FROM clause. 
D)  the WHERE clause. 
A)  the SELECT clause. 
B)  the HAVING clause. 
C)  the FROM clause. 
D)  the WHERE clause.

Question 16

When the SELECT clause in the create view statement contains the keyword DISTINCT, the view can be used to update data.

Accepted Answer

A) True 
 B)False

Question 17

What is a materialized view, and when would it be used?

Accepted Answer

Materialized views are just like dynamic

Question 18

The first part of an SQL query to be read is the ________ statement.

Accepted Answer

A)  SELECT 
B)  FROM 
C)  WHERE 
D)  ORDER BY 
A)  SELECT 
B)  FROM 
C)  WHERE 
D)  ORDER BY

Question 19

What does the following SQL statement do?
SELECT * From Customer WHERE Cust_Type = "Best"

Accepted Answer

A)  Selects all the fields from the Customer table for each row with a customer labeled "Best" 
B)  Selects the "*" field from the Customer table for each row with a customer labeled "Best" 
C)  Selects fields with a "*" in them from the Customer table 
D)  Selects all the fields from the Customer table for each row with a customer labeled "*" 
A)  Selects all the fields from the Customer table for each row with a customer labeled "Best" 
B)  Selects the "*" field from the Customer table for each row with a customer labeled "Best" 
C)  Selects fields with a "*" in them from the Customer table 
D)  Selects all the fields from the Customer table for each row with a customer labeled "*"

Question 20

The last part of an SQL query to be read is the ________ statement.

Accepted Answer

A)  SELECT 
B)  FROM 
C)  WHERE 
D)  ORDER BY 
A)  SELECT 
B)  FROM 
C)  WHERE 
D)  ORDER BY

What result set is returned from the following query? SELECT Customer_Name, telephone FROM customers WHERE city in ('Boston','New York','Denver');

What steps should be followed when preparing to create a table?

Implementation of a standard can never stifle creativity and innovation.

Discuss when to use the GROUP BY clause.

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

What result set will the following query return? SELECT Item_No FROM Order_V WHERE quantity > 10;

Indexes are created in most RDBMSs to:

Adding the DISTINCT keyword to a query eliminates duplicates.

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

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;

A single value returned from an SQL query that includes an aggregate function is called a vector aggregate.

The views are created by executing a CREATE VIEW SQL command.

What does the following SQL statement do? ALTER TABLE Customer_T ADD (Type Varchar (2));

What were the original purposes of SQL, and does SQL as we know it today live up to those standards?

A view may not be updated directly if it contains:

When the SELECT clause in the create view statement contains the keyword DISTINCT, the view can be used to update data.

What is a materialized view, and when would it be used?

The first part of an SQL query to be read is the ________ statement.

What does the following SQL statement do? SELECT ^* From Customer WHERE Cust_Type = "Best"

The last part of an SQL query to be read is the ________ statement.

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model

Logical Database Design and the Relational Model

Advanced SQL

Databases in Applications

Physical Database Design and Database Infrastructure

Data Warehousing and Data Integration

Big Data Technologies

Analytics and Its Implications

Data and Database Administration With Focus on Data Quality

Distributed Databases

Object-Oriented Data Modeling

Filters

Exam 5: Introduction to SQL

What result set is returned from the following query? SELECT Customer_Name, telephone FROM customers WHERE city in ('Boston','New York','Denver');

What steps should be followed when preparing to create a table?

Implementation of a standard can never stifle creativity and innovation.

Discuss when to use the GROUP BY clause.

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

What result set will the following query return? SELECT Item_No FROM Order_V WHERE quantity > 10;

Indexes are created in most RDBMSs to:

Adding the DISTINCT keyword to a query eliminates duplicates.

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

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;

A single value returned from an SQL query that includes an aggregate function is called a vector aggregate.

The views are created by executing a CREATE VIEW SQL command.

What does the following SQL statement do? ALTER TABLE Customer_T ADD (Type Varchar (2));

What were the original purposes of SQL, and does SQL as we know it today live up to those standards?

A view may not be updated directly if it contains:

When the SELECT clause in the create view statement contains the keyword DISTINCT, the view can be used to update data.

What is a materialized view, and when would it be used?

The first part of an SQL query to be read is the ________ statement.

What does the following SQL statement do? SELECT * From Customer WHERE Cust_Type = "Best"

The last part of an SQL query to be read is the ________ statement.

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model

Logical Database Design and the Relational Model

Advanced SQL

Databases in Applications

Physical Database Design and Database Infrastructure

Data Warehousing and Data Integration

Big Data Technologies

Analytics and Its Implications

Data and Database Administration With Focus on Data Quality

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;

What does the following SQL statement do? SELECT ^* From Customer WHERE Cust_Type = "Best"