Question 1

Any create command may be reversed by using a(n) ________ command.

Accepted Answer

A)   undo
B)   drop
C)   delete
D)   unpack B

Question 2

What result set will the following query return? 
SELECT Item_No, description
FROM item
WHERE weight > 100 and weight < 200;

Accepted Answer

A)   The Item_No and description for all items weighing less than 100
B)   The Item_No for all items weighing between 101 and 199
C)   The Item_No and description for all items weighing between 101 and 199
D)   The Item_No for all items weighing more than 200 C

Question 3

The following query totals sales in state= 'MA' for each salesperson.
SELECT salesperson_id, sum(sales)
FROM salesperson
GROUP BY salesperson_id
HAVING state = 'MA';

Accepted Answer

A) True 
 B)False  False

Question 4

In order to update data in SQL, one must inform the DBMS which relation, columns, and rows are involved.

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

The benefits of a standardized relational language include:

Accepted Answer

A)   application turnover.
B)   increased training costs.
C)   cross-system communication.
D)   confusing the SQL programmers.

Question 7

Which of the following questions is answered by the SQL statement? 
SELECT COUNT (Product_Description) FROM Product_T;

Accepted Answer

A)   How many products are in the table Product_T?
B)   How many products have product descriptions in the Product Table?
C)   How many characters are in the field name "Product_Description"?
D)   How many different columns named "Product_Description" are there in table Product_T?

Question 8

COUNT(*) tallies only those rows that contain a value, while COUNT counts all rows.

Accepted Answer

A) True 
 B)False

Question 9

The FROM clause is the first statement processed in an SQL command.

Accepted Answer

A) True 
 B)False

Question 10

SQL originated from a project called System-S.

Accepted Answer

A) True 
 B)False

Question 11

The ALTER TABLE command is used to change a table definition.

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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 14

Indexes generally slow down access speed in most RDMS.

Accepted Answer

A) True 
 B)False

Question 15

Explain the three classes of SQL commands and when they would be used.

Accepted Answer

The answer of Explain the three classes of SQL commands...

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

In an SQL statement, which of the following parts states the conditions for row selection?

Accepted Answer

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

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 table
B)   Creates the Customer_T table
C)   Deletes the Customer_T table
D)   Updates the Customer_T table

Question 19

SQL has been implemented only in the mainframe and midrange environments.

Accepted Answer

A) True 
 B)False

Question 20

What three clauses are contained in most SQL retrieval statements?

Accepted Answer

The answer of What three clauses are contained in most...

Exam 5: Introduction to SQL

Any create command may be reversed by using a(n) ________ command.

What result set will the following query return? SELECT Item_No, description FROM item WHERE weight > 100 and weight < 200;

The following query totals sales in state= 'MA' for each salesperson. SELECT salesperson_id, sum(sales) FROM salesperson GROUP BY salesperson_id HAVING state = 'MA';

In order to update data in SQL, one must inform the DBMS which relation, columns, and rows are involved.

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

The benefits of a standardized relational language include:

Which of the following questions is answered by the SQL statement? SELECT COUNT (Product_Description) FROM Product_T;

COUNT(^*) tallies only those rows that contain a value, while COUNT counts all rows.

The FROM clause is the first statement processed in an SQL command.

SQL originated from a project called System-S.

The ALTER TABLE command is used to change a table definition.

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

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

Indexes generally slow down access speed in most RDMS.

Explain the three classes of SQL commands and when they would be used.

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

In an SQL statement, which of the following parts states the conditions for row selection?

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

SQL has been implemented only in the mainframe and midrange environments.

What three clauses are contained in most SQL retrieval statements?