Question 1

Indexes generally slow down access speed in most RDMS.

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

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

Question 3

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 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 FROM clause is the first statement processed in an SQL command.

Accepted Answer

A) True 
 B)False

Question 6

SQL originated from a project called System-S.

Accepted Answer

A) True 
 B)False

Question 7

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 8

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

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

There are three classes or types of SQL ...

Question 13

What three clauses are contained in most SQL retrieval statements?

Accepted Answer

The SELECT clause, which lists the colum...

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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 16

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 17

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 18

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 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

Exam 5: Introduction to SQL

Indexes generally slow down access speed in most RDMS.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedB

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

SQL originated from a project called System-S.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedC

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedThere are three classes or types of SQL ...View AnswerShow Answer

What three clauses are contained in most SQL retrieval statements?

Correct AnswerverifiedThe SELECT clause, which lists the colum...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The benefits of a standardized relational language include:

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedFalse

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified
B

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
C

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
There are three classes or types of SQL ...
View Answer

Correct Answer
verified
The SELECT clause, which lists the colum...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
False

Correct Answer
verified

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

Correct Answer
verified

Correct Answer
verified