Question 1

Relational databases are heavily based on the mathematical concept of:

Accepted Answer

A)   Set Theory.
B)   Bet Theory.
C)   Get Theory.
D)   Met Theory.E) B) and D)
F) None of the above

Question 2

To eliminate duplicate rows in a query, the ________ qualifier is used in the SQL Select command.

Accepted Answer

A)   alter
B)   distinct
C)   check
D)   specificE) B) and C)
F) A) and D)

Question 3

________ is a set of commands used to control a database, including security.

Accepted Answer

A)   DML
B)   DDL
C)   DCL
D)   DPLE) B) and C)
F) A) and C)

Question 4

The DELETE TABLE DDL command is used to remove a table from the database.

Accepted Answer

A) True 
 B)False

Question 5

INSERT INTO is an example of ________ code.

Accepted Answer

A)   DDL
B)   DML
C)   DCL
D)   TIOE) B) and C)
F) C) and D)

Question 6

SQL is both an American and international standard for database access.

Accepted Answer

A) True 
 B)False

Question 7

The command for creating a database is:

Accepted Answer

A)   create table.
B)   create view.
C)   create schema.
D)   create authorization.E) B) and C)
F) C) and D)

Question 8

Which of the following is a purpose of the SQL standard?

Accepted Answer

A)   To specify syntax and semantics of SQL data definition and manipulation
B)   To specify maximum and incomplete standards
C)   To define every operation for every SQL database
D)   To permit no degrees of freedom for SQL DBMSE) B) and D)
F) All of the above

Question 9

What results will be produced by the following SQL query? Select sum(standard_price)  as Total_Price
From Product_V
Where Product_Type = 'WOOD';

Accepted Answer

A)   The total price of all products that are of type wood
B)   The total price of all products
C)   The Standard_Price of the first wood product in the table
D)   The Standard_Price of any wood product in the tableE) B) and C)
F) None of the above

Question 10

The ORDER BY clause sorts the final results rows in ascending or descending order.

Accepted Answer

A) True 
 B)False

Question 11

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 DenverE) A) and B)
F) A) and C)

Question 12

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

Question 13

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?E) A) and B)
F) A) and C)

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

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

Accepted Answer

There are three classes or types of SQL ...

Question 16

The SQL command ________ adds one or more new columns to a table.

Accepted Answer

A)   create table
B)   alter table
C)   create view
D)   create relationshipE) A) and B)
F) A) and C)

Question 17

________ is a set of commands used to update and query a database.

Accepted Answer

A)   DML
B)   DDL
C)   DCL
D)   DPLE) None of the above
F) A) and B)

Question 18

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

Accepted Answer

A)   SELECT
B)   FROM
C)   WHERE
D)   ORDER BYE) B) and C)
F) None of the above

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 "*"E) All of the above
F) A) and B)

Question 20

What does the following SQL statement do? Delete from Customer_T
Where state = 'HI';

Accepted Answer

A)   Deletes all records from customer_t where the state is equal to HI
B)   Removes the Customer_T table from the database
C)   Deletes all records from the Customer_T table
D)   Doesn't delete anything because of a syntax errorE) A) and C)
F) B) and C)

Exam 6: Introduction to SQL

What results will be produced by the following SQL query? Select sum(standard_price) as Total_Price From Product_V Where Product_Type = 'WOOD';

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The command for creating a database is:

Correct AnswerverifiedShow Answer

The ORDER BY clause sorts the final results rows in ascending or descending order.

Correct AnswerverifiedShow Answer

________ is a set of commands used to control a database, including security.

Correct AnswerverifiedShow Answer

INSERT INTO is an example of ________ code.

Correct AnswerverifiedShow Answer

What does the following SQL statement do? Select * From Customer Where Cust_Type = "Best"

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedThe following were the original purposes...View AnswerShow Answer

Which of the following is a purpose of the SQL standard?

Correct AnswerverifiedShow Answer

Relational databases are heavily based on the mathematical concept of:

Correct AnswerverifiedShow Answer

What does the following SQL statement do? Delete from Customer_T Where state = 'HI';

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

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

The SQL command ________ adds one or more new columns to a table.

Correct AnswerverifiedShow Answer

Which of the following questions is answered by the SQL statement? Select Count (Product_Description) from Product_T;

Correct AnswerverifiedShow Answer

To eliminate duplicate rows in a query, the ________ qualifier is used in the SQL Select command.

Correct AnswerverifiedShow Answer

________ is a set of commands used to update and query a database.

Correct AnswerverifiedShow Answer

SQL is both an American and international standard for database access.

Correct AnswerverifiedShow Answer

The DELETE TABLE DDL command is used to remove a table from the database.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
The following were the original purposes...
View Answer

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

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified