Question 1

The ON UPDATE ________ option allows changes to a parent table to pass onto a child table or tables.

Accepted Answer

The answer of The ON UPDATE ________ option allows changes...

Question 2

The ________ command enables one to change table definitions.

Accepted Answer

The answer of The ________ command enables one to change...

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

Expressions are mathematical manipulations of data in a table that may be included as part of the SELECT statement.

Accepted Answer

A) True 
 B)False

Question 6

In SQL the ________ and ________ clauses are required,while the ________ clause is needed when only certain rows are to be retrieved or multiple tables are to be joined.

Accepted Answer

The answer of In SQL the ________ and ________ clauses...

Question 7

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

Question 8

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 9

A DBMS that manages data as a collection of tables in which all data relationships are represented by common values in related tables is called a(n)________ DBMS.

Accepted Answer

The answer of A DBMS that manages data as a...

Question 10

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 11

The ________ Boolean operator joins two or more conditions and returns results only when all conditions are true.

Accepted Answer

The answer of The ________ Boolean operator joins two or...

Question 12

Indexes generally slow down access speed in most RDMS.

Accepted Answer

A) True 
 B)False

Question 13

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

Question 14

A database table is defined using the data definition language (DDL).

Accepted Answer

A) True 
 B)False

Question 15

A ________ is a virtual table that is created dynamically upon request to a user.

Accepted Answer

The answer of A ________ is a virtual table that...

Question 16

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 Product Table? 
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 17

To update data in SQL we must inform the DBMS what ________,________,and ________ are involved.

Accepted Answer

The answer of To update data in SQL we must...

Question 18

Commands used to control a database are part of the ________ or ________.

Accepted Answer

The answer of Commands used to control a database are...

Question 19

How is the having clause different from the where clause?

Accepted Answer

The answer of How is the having clause different from...

Question 20

The views are created by executing a CREATE VIEW SQL command.

Accepted Answer

A) True 
 B)False

Exam 6: Introduction to SQL

The ON UPDATE ________ option allows changes to a parent table to pass onto a child table or tables.

The ________ command enables one to change table definitions.

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

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

Expressions are mathematical manipulations of data in a table that may be included as part of the SELECT statement.

In SQL the and clauses are required,while the clause is needed when only certain rows are to be retrieved or multiple tables are to be joined.

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

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.

A DBMS that manages data as a collection of tables in which all data relationships are represented by common values in related tables is called a(n)________ DBMS.

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

The ________ Boolean operator joins two or more conditions and returns results only when all conditions are true.

Indexes generally slow down access speed in most RDMS.

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

A database table is defined using the data definition language (DDL).

A ________ is a virtual table that is created dynamically upon request to a user.

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

To update data in SQL we must inform the DBMS what ,,and are involved.

Commands used to control a database are part of the or .

How is the having clause different from the where clause?

The views are created by executing a CREATE VIEW SQL command.