Question 1

The SQL query to output the contents of the EMPLOYEE table sorted by last name, first name, and initial is _____.

Accepted Answer

A)   SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONE FROM EMPLOYEE LIST BY EMP_LNAME, EMP_FNAME, EMP_INITIAL;
B)   SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONE FROM EMPLOYEE ORDER BY EMP_LNAME, EMP_FNAME, EMP_INITIAL;
C)   SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONE FROM EMPLOYEE DISPLAY BY EMP_LNAME, EMP_FNAME, EMP_INITIAL;
D)   SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONE FROM EMPLOYEE SEQUENCE BY EMP_LNAME, EMP_FNAME, EMP_INITIAL;E) All of the above
F) A) and C)

Question 2

U.S. state abbreviations are always two characters, so (2) is a logical choice for the data type representing a state column.

Accepted Answer

The answer of U.S. state abbreviations are always two characters,...

Question 3

A(n) order sequence is a multilevel ordered sequence that can be created easily by listing several attributes, separated by commas, after the ORDER BY clause.

Accepted Answer

The answer of A(n) order sequence is a multilevel ordered...

Question 4

When joining three or more tables, you need to specify a join condition for one pair of tables.

Accepted Answer

A) True 
 B)False

Question 5

Which of the following queries will output the table contents when the value of V_CODE is equal to 21344?

Accepted Answer

A)   SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE  21344;
B)   SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE 
C)   SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE = 21344;
D)   SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE => 21344;E) A) and C)
F) A) and B)

Question 6

The SQL command that allows a user to insert rows into a table is .

Accepted Answer

A)   INSERT
B)   SELECT
C)   COMMIT
D)   UPDATEE) None of the above
F) A) and B)

Question 7

Some RDBMSs, such as Microsoft Access, automatically make the necessary conversions to eliminate case sensitivity.

Accepted Answer

A) True 
 B)False

Question 8

Which of the following queries 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_PRICE FROM PRODUCT WHERE P_CODE 
B)   SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE FROM PRODUCT WHERE P_CODE = [1558-QW1];
C)   SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE FROM PRODUCT WHERE P_CODE = (1558-QW1) ;
D)   SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE FROM PRODUCT WHERE P_CODE = {1558-QW1};E) C) and D)
F) All of the above

Question 9

To remove a row from the PRODUCT table, one must use the command.

Accepted Answer

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

Question 10

Mathematical operators cannot be used to place restrictions on character-based attributes.

Accepted Answer

A) True 
 B)False

Question 11

UPDATE tablename *****
[WHERE conditionlist];
The command replaces the ***** in the syntax of the UPDATE command, shown above.

Accepted Answer

A)   SET columnname = expression
B)   columnname = expression
C)   expression = columnname
D)   LET columnname = expressionE) A) and C)
F) C) and D)

Question 12

Although SQL commands can be grouped together on a single line, complex command sequences are best shown on separate lines, with space between the SQL command and the command's components.

Accepted Answer

A) True 
 B)False

Question 13

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 14

The COUNT function is designed to tally the number of non-null "values" of an attribute, and is often used in conjunction with the DISTINCT clause.

Accepted Answer

A) True 
 B)False

Question 15

Oracle users can use the Access QBE (query by example) query generator.

Accepted Answer

A) True 
 B)False

Question 16

The SQL command that allows a user to permanently save data changes is .

Accepted Answer

A)   INSERT
B)   SELECT
C)   COMMIT
D)   UPDATEE) B) and C)
F) A) and D)

Question 17

The query to join the P_DESCRIPT and P_PRICE fields from the PRODUCT table and the V_NAME, V_AREACODE, V_PHONE, and V_CONTACT fields from the VENDOR table where the values of V_CODE match is .

Accepted Answer

A)   SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE  VENDOR.V_CODE;
B)   SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE = VENDOR.V_CODE;
C)   SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE 
D)   SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE => VENDOR.V_CODE;E) B) and C)
F) C) and D)

Question 18

A table can be deleted from the database by using the command.

Accepted Answer

A)   DROP TABLE
B)   DELETE TABLE
C)   MODIFY TABLE
D)   ERASE TABLEE) None of the above
F) A) and B)

Question 19

To make the output more readable, the SQL standard permits the use of aliases for any column in a statement.

Accepted Answer

The answer of To make the output more readable, the...

Question 20

String comparisons are made from left to right.

Accepted Answer

A) True 
 B)False

Exam 7: Introduction to Structured Query Language Sql

The SQL command that allows a user to insert rows into a table is .

Correct AnswerverifiedShow Answer

When joining three or more tables, you need to specify a join condition for one pair of tables.

Correct AnswerverifiedShow Answer

The query to join the P_DESCRIPT and P_PRICE fields from the PRODUCT table and the V_NAME, V_AREACODE, V_PHONE, and V_CONTACT fields from the VENDOR table where the values of V_CODE match is .

Correct AnswerverifiedShow Answer

Oracle users can use the Access QBE (query by example) query generator.

Correct AnswerverifiedShow Answer

Some RDBMSs, such as Microsoft Access, automatically make the necessary conversions to eliminate case sensitivity.

Correct AnswerverifiedShow Answer

Although SQL commands can be grouped together on a single line, complex command sequences are best shown on separate lines, with space between the SQL command and the command's components.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

String comparisons are made from left to right.

Correct AnswerverifiedShow Answer

UPDATE tablename ***** [WHERE conditionlist]; The command replaces the ***** in the syntax of the UPDATE command, shown above.

Correct AnswerverifiedShow Answer

Which of the following queries will output the table contents when the value of V_CODE is equal to 21344?

Correct AnswerverifiedShow Answer

A table can be deleted from the database by using the command.

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

To remove a row from the PRODUCT table, one must use the command.

Correct AnswerverifiedShow Answer

To make the output more readable, the SQL standard permits the use of aliases for any column in a statement.

Correct AnswerverifiedShow Answer

The SQL query to output the contents of the EMPLOYEE table sorted by last name, first name, and initial is _____.

Correct AnswerverifiedShow Answer

Mathematical operators cannot be used to place restrictions on character-based attributes.

Correct AnswerverifiedShow Answer

U.S. state abbreviations are always two characters, so (2) is a logical choice for the data type representing a state column.

Correct AnswerverifiedShow Answer

A(n) order sequence is a multilevel ordered sequence that can be created easily by listing several attributes, separated by commas, after the ORDER BY clause.

Correct AnswerverifiedShow Answer

The SQL command that allows a user to permanently save data changes is .

Correct AnswerverifiedShow Answer

The COUNT function is designed to tally the number of non-null "values" of an attribute, and is often used in conjunction with the DISTINCT clause.

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

UPDATE tablename * [WHERE conditionlist]; The command replaces the * in the syntax of the UPDATE command, shown above.

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

Correct Answer
verified

Correct Answer
verified