Question 1

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) C) and D)
F) A) and B)

Question 2

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) A) and B)
F) A) and C)

Question 3

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

Accepted Answer

A)   COMMIT
B)   DELETE
C)   ERASE
D)   KILLE) A) and B)
F) B) and D)

Question 4

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 5

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 6

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) C) and D)
F) None of the above

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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) None of the above
F) All of the above

Question 9

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 10

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 11

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 12

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 13

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) A) and C)
F) B) and D)

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

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

Question 16

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) A) and B)
F) All of the above

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

String comparisons are made from left to right.

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

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

Question 20

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

Exam 7: Introduction to Structured Query Language Sql

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

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

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

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 insert rows into a table is .

Correct AnswerverifiedShow Answer

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

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

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

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

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

Correct AnswerverifiedShow Answer

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

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

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

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

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

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

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

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

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

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

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