Question 1

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

Accepted Answer

There are three classes or types of SQL

Question 2

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

Question 3

Relational databases are heavily based on the mathematical concept of:

Accepted Answer

A)  Set Theory. 
B)  Bet Theory. 
C)  Get Theory. 
D)  Met Theory. 
A)  Set Theory. 
B)  Bet Theory. 
C)  Get Theory. 
D)  Met Theory.

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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 relationship 
A)  create table 
B)  alter table 
C)  create view 
D)  create relationship

Question 6

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

Accepted Answer

A)  DML 
B)  DDL 
C)  DCL 
D)  DPL 
A)  DML 
B)  DDL 
C)  DCL 
D)  DPL

Question 7

INSERT INTO is an example of ________ code.

Accepted Answer

A)  DDL 
B)  DML 
C)  DCL 
D)  TIO 
A)  DDL 
B)  DML 
C)  DCL 
D)  TIO

Question 8

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 9

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 10

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)  specific 
A)  alter 
B)  distinct 
C)  check 
D)  specific

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

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 13

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

Accepted Answer

A) True 
 B)False

Question 14

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

Question 15

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

Question 16

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

Accepted Answer

A)  DML 
B)  DDL 
C)  DCL 
D)  DPL 
A)  DML 
B)  DDL 
C)  DCL 
D)  DPL

Question 17

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

Question 18

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

The command for creating a database is:

Accepted Answer

A)  create table. 
B)  create view. 
C)  create schema. 
D)  create authorization. 
A)  create table. 
B)  create view. 
C)  create schema. 
D)  create authorization.

Question 20

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

Accepted Answer

A) True 
 B)False

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

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

Relational databases are heavily based on the mathematical concept of:

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

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

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

INSERT INTO is an example of ________ code.

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

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

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

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

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

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

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

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

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

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

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

The command for creating a database is:

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

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

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

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

Relational databases are heavily based on the mathematical concept of:

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

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

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

INSERT INTO is an example of ________ code.

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

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

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

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

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

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

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

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

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

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

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

The command for creating a database is:

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

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