Question 1

____________________ words are words used by SQL to perform specific functions.

Accepted Answer

The answer of ____________________ words are words used by SQL...

Question 2

To delete a row from the PRODUCT table,use the ____ command.

Accepted Answer

A)   COMMIT
B)   DELETE
C)   ERASE
D)   KILLE) All of the above
F) None of the above

Question 3

The special operator used to check whether an attribute value is within a range of values is ____.

Accepted Answer

A)   BETWEEN
B)   NULL
C)   LIKE
D)   INE) B) and D)
F) A) and D)

Question 4

SQL is considered difficult to learn; its command set has a vocabulary of more than 300 words.

Accepted Answer

A) True 
 B)False

Question 5

What are the wildcard characters that are used with the LIKE command? Provide one or more examples of each.

Accepted Answer

% means any and all following or precedi...

Question 6

Which query will list all the rows in which the inventory stock dates occur on or after January 20,2010?

Accepted Answer

A)   SELECT P_DESCRIPT,P_QOH,P_MIN,P_PRICE,P_INDATEFROM PRODUCTWHERE P_INDATE >= '20-JAN-2010'
B)   SELECT P_DESCRIPT,P_QOH,P_MIN,P_PRICE,P_INDATEFROM PRODUCTWHERE P_INDATE >= $20-JAN-2010$
C)   SELECT P_DESCRIPT,P_QOH,P_MIN,P_PRICE,P_INDATEFROM PRODUCTWHERE P_INDATE 
D)   SELECT P_DESCRIPT,P_QOH,P_MIN,P_PRICE,P_INDATEFROM PRODUCTWHERE P_INDATE >= {20-JAN-2010}E) A) and B)
F) All of the above

Question 7

A(n)____________________ is a group of database objects,such as tables and indexes,that are related to each other.

Accepted Answer

The answer of A(n)____________________ is a group of database objects,such...

Question 8

What command is used to save changes to the database? What is the syntax for this command?

Accepted Answer

Any changes made to the table contents a...

Question 9

ANSI-standard SQL allows the use of special operators in conjunction with the WHERE clause.

Accepted Answer

A) True 
 B)False

Question 10

Date procedures are often more software-specific than other SQL procedures.

Accepted Answer

A) True 
 B)False

Question 11

In the SQL environment,the word ____________________ covers both questions and actions.

Accepted Answer

The answer of In the SQL environment,the word ____________________ covers...

Question 12

Which query will output the table contents when the value of the character field P_CODE is alphabetically less than 1558-QW1?

Accepted Answer

A)   SELECT P_CODE,P_DESCRIPT,P_QOH,P_MIN,P_PRICEFROM PRODUCTWHERE P_CODE 
B)   SELECT P_CODE,P_DESCRIPT,P_QOH,P_MIN,P_PRICEFROM PRODUCTWHERE P_CODE = [1558-QW1]
C)   SELECT P_CODE,P_DESCRIPT,P_QOH,P_MIN,P_PRICEFROM PRODUCTWHERE P_CODE = (1558-QW1) 
D)   SELECT P_CODE,P_DESCRIPT,P_QOH,P_MIN,P_PRICEFROM PRODUCTWHERE P_CODE = {1558-QW1}E) C) and D)
F) B) and C)

Question 13

SQL allows the use of logical restrictions on its inquiries such as OR,AND,and NOT.

Accepted Answer

A) True 
 B)False

Question 14

Which query will use the given columns and column aliases from the PRODUCT table to determine the total value of inventory held on hand and display the results in a column labeled TOTVALUE?

Accepted Answer

A)   SELECT P_DESCRIPT,P_QOH,P_PRICE,P_QOH*P_PRICE AS TOTVALUEFROM PRODUCT;
B)   SELECT P_DESCRIPT,P_QOH,P_PRICE,P_QOH=P_PRICE AS TOTVALUEFROM PRODUCT;
C)   SELECT P_DESCRIPT,P_QOH,P_PRICE,P_QOH/P_PRICE AS TOTVALUEFROM PRODUCT;
D)   SELECT P_DESCRIPT,P_QOH,P_PRICE,P_QOH-P_PRICE AS TOTVALUEFROM PRODUCT;E) B) and D)
F) A) and D)

Question 15

If you have not yet used the COMMIT command to store the changes permanently in the database,you can restore the database to its previous condition with the ROLLBACK command.

Accepted Answer

A) True 
 B)False

Question 16

With the exception of the ____________________ process,most RDBMS vendors use SQL that deviates little from the ANSI standard SQL.

Accepted Answer

The answer of With the exception of the ____________________ process,most...

Question 17

In Oracle,the ____ command is used to change the display for a column,for example,to place a $ in front of a numeric value.

Accepted Answer

A)   DISPLAY
B)   FORMAT
C)   CHAR
D)   CONVERTE) A) and B)
F) None of the above

Question 18

To list all the contents of the PRODUCT table,you would use ____.

Accepted Answer

A)   LIST * FROM PRODUCT;
B)   SELECT * FROM PRODUCT;
C)   DISPLAY * FROM PRODUCT;
D)   SELECT ALL FROM PRODUCT;E) A) and C)
F) A) and B)

Question 19

What is a subquery? When is it used? Does the RDBMS deal with subqueries any differently from normal queries?

Accepted Answer

A subquery,also known as a nested query ...

Question 20

A common practice is to create a(n)____________________ on any field that is used as a search key,in comparison operations in a conditional expression,or when you want to list rows in a specific order.

Accepted Answer

The answer of A common practice is to create a(n)____________________...

Exam 7: Introduction to Structured Query Language (SQL)

To delete a row from the PRODUCT table,use the ____ command.

Correct AnswerverifiedShow Answer

With the exception of the ____________________ process,most RDBMS vendors use SQL that deviates little from the ANSI standard SQL.

Correct AnswerverifiedShow Answer

Date procedures are often more software-specific than other SQL procedures.

Correct AnswerverifiedShow Answer

A common practice is to create a(n)____________________ on any field that is used as a search key,in comparison operations in a conditional expression,or when you want to list rows in a specific order.

Correct AnswerverifiedShow Answer

____________________ words are words used by SQL to perform specific functions.

Correct AnswerverifiedShow Answer

Which query will list all the rows in which the inventory stock dates occur on or after January 20,2010?

Correct AnswerverifiedShow Answer

To list all the contents of the PRODUCT table,you would use ____.

Correct AnswerverifiedShow Answer

ANSI-standard SQL allows the use of special operators in conjunction with the WHERE clause.

Correct AnswerverifiedShow Answer

What is a subquery? When is it used? Does the RDBMS deal with subqueries any differently from normal queries?

Correct AnswerverifiedA subquery,also known as a nested query ...View AnswerShow Answer

Which query will use the given columns and column aliases from the PRODUCT table to determine the total value of inventory held on hand and display the results in a column labeled TOTVALUE?

Correct AnswerverifiedShow Answer

A(n)____________________ is a group of database objects,such as tables and indexes,that are related to each other.

Correct AnswerverifiedShow Answer

SQL allows the use of logical restrictions on its inquiries such as OR,AND,and NOT.

Correct AnswerverifiedShow Answer

If you have not yet used the COMMIT command to store the changes permanently in the database,you can restore the database to its previous condition with the ROLLBACK command.

Correct AnswerverifiedShow Answer

What are the wildcard characters that are used with the LIKE command? Provide one or more examples of each.

Correct Answerverified% means any and all following or precedi...View AnswerShow Answer

The special operator used to check whether an attribute value is within a range of values is ____.

Correct AnswerverifiedShow Answer

Which query will output the table contents when the value of the character field P_CODE is alphabetically less than 1558-QW1?

Correct AnswerverifiedShow Answer

In Oracle,the ____ command is used to change the display for a column,for example,to place a $ in front of a numeric value.

Correct AnswerverifiedShow Answer

What command is used to save changes to the database? What is the syntax for this command?

Correct AnswerverifiedAny changes made to the table contents a...View AnswerShow Answer

In the SQL environment,the word ____________________ covers both questions and actions.

Correct AnswerverifiedShow Answer

SQL is considered difficult to learn; its command set has a vocabulary of more than 300 words.

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
A subquery,also known as a nested query ...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
% means any and all following or precedi...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Any changes made to the table contents a...
View Answer

Correct Answer
verified

Correct Answer
verified