Question 1

What does the following SQL statement do? 
UPDATE Product_T
SET Unit_Price = 775
WHERE Product_ID = 7

Accepted Answer

A)  Changes the price of a unit called Product_T to 7 
B)  Changes the unit price of Product 7 to 775 
C)  Changes the length of the Unit_Price field to 775 
D)  Updates the Product_T table to have a unit price of 775 
A)  Changes the price of a unit called Product_T to 7 
B)  Changes the unit price of Product 7 to 775 
C)  Changes the length of the Unit_Price field to 775 
D)  Updates the Product_T table to have a unit price of 775

Question 2

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

One of the original purposes of the SQL standard was to provide a vehicle for portability of database definition and application modules between conforming DBMSs.

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

Which of the following will produce the minimum of all standard prices?

Accepted Answer

A)  SELECT Standard_Price FROM Product_V WHERE Standard_Price = min; 
B)  SELECT MIN(Standard_Price) FROM Product_V; 
C)  SELECT Standard_Price FROM min(Product_V); 
D)  SELECT MIN(Standard_Price) FROM Product_V WHERE Standard_Price = min(Standard_Price); 
A)  SELECT Standard_Price FROM Product_V WHERE Standard_Price = min; 
B)  SELECT MIN(Standard_Price) FROM Product_V; 
C)  SELECT Standard_Price FROM min(Product_V); 
D)  SELECT MIN(Standard_Price) FROM Product_V WHERE Standard_Price = min(Standard_Price);

Question 6

When creating a table, it is not important to consider foreign key-primary key mates.

Accepted Answer

A) True 
 B)False

Question 7

The HAVING clause and the WHERE clause perform the same operation.

Accepted Answer

A) True 
 B)False

Question 8

Which of the following finds all groups meeting stated conditions?

Accepted Answer

A)  SELECT 
B)  WHERE 
C)  HAVING 
D)  FIND 
A)  SELECT 
B)  WHERE 
C)  HAVING 
D)  FIND

Question 9

Which of the following is a technique for optimizing the internal performance of the relational data model?

Accepted Answer

A)  Avoiding indexes on secondary keys 
B)  Clustering data 
C)  Not reporting statistics to save machine resources 
D)  Using random index organizations 
A)  Avoiding indexes on secondary keys 
B)  Clustering data 
C)  Not reporting statistics to save machine resources 
D)  Using random index organizations

Question 10

Which of the following can produce scalar and vector aggregates?

Accepted Answer

A)  Order By 
B)  Group By 
C)  Having 
D)  Sort 
A)  Order By 
B)  Group By 
C)  Having 
D)  Sort

Question 11

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 12

The first in a series of steps to follow when creating a table is to:

Accepted Answer

A)  identify columns that must be unique. 
B)  identify each attribute and its characteristics. 
C)  create an index. 
D)  identify columns that must be null. 
A)  identify columns that must be unique. 
B)  identify each attribute and its characteristics. 
C)  create an index. 
D)  identify columns that must be null.

Question 13

If multiple Boolean operators are used in an SQL statement, NOT is evaluated first, then AND, then OR.

Accepted Answer

A) True 
 B)False

Question 14

The asterisk (*) wildcard designator can be used to select all fields from a table as well as in WHERE clauses when an exact match is not possible.

Accepted Answer

A) True 
 B)False

Question 15

The SQL command used to populate tables is the INSERT command.

Accepted Answer

A) True 
 B)False

Question 16

A referential integrity constraint specifies that the existence of an attribute in one table depends upon the existence of a foreign key in the same or another table.

Accepted Answer

A) True 
 B)False

Question 17

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 18

A single value returned from an SQL query that includes an aggregate function is called a(n):

Accepted Answer

A)  agate. 
B)  scalar aggregate. 
C)  vector aggregate. 
D)  summation. 
A)  agate. 
B)  scalar aggregate. 
C)  vector aggregate. 
D)  summation.

Question 19

What will result from the following SQL Select statement? 
SELECT MIN(Product_Description)
FROM Product_V;

Accepted Answer

A)  The minimum value of Product_Description will be displayed. 
B)  An error message will be generated. 
C)  The first product description alphabetically in Product_V will be shown. 
D)  SELECT @ will be displayed. 
A)  The minimum value of Product_Description will be displayed. 
B)  An error message will be generated. 
C)  The first product description alphabetically in Product_V will be shown. 
D)  SELECT @ will be displayed.

Question 20

The main concept of relational databases was published in 1970 by:

Accepted Answer

A)  Itzak Ben-Gan. 
B)  Hoffer. 
C)  Mills. 
D)  E.F.Codd. 
A)  Itzak Ben-Gan. 
B)  Hoffer. 
C)  Mills. 
D)  E.F.Codd.

What does the following SQL statement do? UPDATE Product_T SET Unit_Price = 775 WHERE Product_ID = 7

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

One of the original purposes of the SQL standard was to provide a vehicle for portability of database definition and application modules between conforming DBMSs.

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

Which of the following will produce the minimum of all standard prices?

When creating a table, it is not important to consider foreign key-primary key mates.

The HAVING clause and the WHERE clause perform the same operation.

Which of the following finds all groups meeting stated conditions?

Which of the following is a technique for optimizing the internal performance of the relational data model?

Which of the following can produce scalar and vector aggregates?

What results will be produced by the following SQL query? SELECT SUM(Standard_Price) as Total_Price From Product_V Where Product_Type = 'WOOD';

The first in a series of steps to follow when creating a table is to:

If multiple Boolean operators are used in an SQL statement, NOT is evaluated first, then AND, then OR.

The asterisk (*) wildcard designator can be used to select all fields from a table as well as in WHERE clauses when an exact match is not possible.

The SQL command used to populate tables is the INSERT command.

A referential integrity constraint specifies that the existence of an attribute in one table depends upon the existence of a foreign key in the same or another table.

Relational databases are heavily based on the mathematical concept of:

A single value returned from an SQL query that includes an aggregate function is called a(n):

What will result from the following SQL Select statement? SELECT MIN(Product_Description) FROM Product_V;

The main concept of relational databases was published in 1970 by:

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 does the following SQL statement do? UPDATE Product_T SET Unit_Price = 775 WHERE Product_ID = 7

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

One of the original purposes of the SQL standard was to provide a vehicle for portability of database definition and application modules between conforming DBMSs.

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

Which of the following will produce the minimum of all standard prices?

When creating a table, it is not important to consider foreign key-primary key mates.

The HAVING clause and the WHERE clause perform the same operation.

Which of the following finds all groups meeting stated conditions?

Which of the following is a technique for optimizing the internal performance of the relational data model?

Which of the following can produce scalar and vector aggregates?

What results will be produced by the following SQL query? SELECT SUM(Standard_Price) as Total_Price From Product_V Where Product_Type = 'WOOD';

The first in a series of steps to follow when creating a table is to:

If multiple Boolean operators are used in an SQL statement, NOT is evaluated first, then AND, then OR.

The asterisk (*) wildcard designator can be used to select all fields from a table as well as in WHERE clauses when an exact match is not possible.

The SQL command used to populate tables is the INSERT command.

A referential integrity constraint specifies that the existence of an attribute in one table depends upon the existence of a foreign key in the same or another table.

Relational databases are heavily based on the mathematical concept of:

A single value returned from an SQL query that includes an aggregate function is called a(n):

What will result from the following SQL Select statement? SELECT MIN(Product_Description) FROM Product_V;

The main concept of relational databases was published in 1970 by:

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