Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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

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 5

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

Accepted Answer

A) True 
 B)False

Question 6

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 7

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 8

How is the having clause different from the where clause?

Accepted Answer

While the where clause works on each row...

Question 9

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 10

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

Accepted Answer

relation,c...

Question 11

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 12

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

Accepted Answer

data contr...

Question 13

The ________ command enables one to change table definitions.

Accepted Answer

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

Question 14

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 15

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 16

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

Accepted Answer

A) True 
 B)False

Question 17

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 18

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

Accepted Answer

A) True 
 B)False

Question 19

Indexes generally slow down access speed in most RDMS.

Accepted Answer

A) True 
 B)False

Question 20

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

Exam 6: Introduction to SQL

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Indexes generally slow down access speed in most RDMS.

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct Answerverifiedrelation,c...View AnswerShow Answer

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

Correct Answerverifieddata contr...View AnswerShow Answer

How is the having clause different from the where clause?

Correct AnswerverifiedWhile the where clause works on each row...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The ________ command enables one to change table definitions.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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.

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

Correct Answer
verified

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

Correct Answer
verified
relation,c...
View Answer

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

Correct Answer
verified
data contr...
View Answer

Correct Answer
verified
While the where clause works on each row...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

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.

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified