Question 1

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

Question 2

Only numeric data types can be added and subtracted in SQL.

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

An example of a command a user would use when making changes to a PRODUCT table is .

Accepted Answer

A)  CHANGE PRODUCT SET P_INDATE = '18-JAN-2004' WHERE P_CODE = '13-Q2/P2';
B)  ROLLBACK PRODUCT SET P_INDATE = '18-JAN-2004' WHERE P_CODE = '13-Q2/P2';
C)  EDIT PRODUCT SET P_INDATE = '18-JAN-2004' WHERE P_CODE = '13-Q2/P2';
D)  UPDATE PRODUCT SET P_INDATE = '18-JAN-2004' WHERE P_CODE = '13-Q2/P2';E) B) and C)
F) B) and D)

Question 5

The special operator used to check whether an attribute value matches a given string pattern is .

Accepted Answer

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

Question 6

A(n) is a query that is embedded inside another query.

Accepted Answer

A)  alias
B)  operator
C)  nested
D)  viewE) None of the above
F) B) and D)

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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

Question 9

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

Question 10

According to the rules of precedence,which of the following computations should be completed first?

Accepted Answer

A)  performing additions and subtractions
B)  performing multiplications and divisions
C)  performing operations within parentheses
D)  performing power operationsE) None of the above
F) All of the above

Question 11

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 and the output is ordered by the price is .

Accepted Answer

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

Question 12

The command would be used to delete the table row where the P_CODE is 'BRT-345'.

Accepted Answer

A)  DELETE FROM PRODUCT WHERE P_CODE = 'BRT-345';
B)  REMOVE FROM PRODUCT WHERE P_CODE = 'BRT-345';
C)  ERASE FROM PRODUCT WHERE P_CODE = 'BRT-345';
D)  ROLLBACK FROM PRODUCT WHERE P_CODE = 'BRT-345';E) A) and B)
F) A) and C)

Question 13

A(n)is performed when data are retrieved from more than one table at a time.

Accepted Answer

The answer of A(n)is performed when data are retrieved from...

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

The command is used to restore the database to its previous condition.

Accepted Answer

A)  COMMIT; RESTORE;
B)  COMMIT; BACKUP;
C)  COMMIT; ROLLBACK;
D)  ROLLBACK;E) B) and C)
F) A) and B)

Question 16

The command,coupled with appropriate search conditions,is an incredibly powerful tool that enables a user to transform data into information.

Accepted Answer

The answer of The command,coupled with appropriate search conditions,is an...

Question 17

A(n) is an alternate name given to a column or table in any SQL statement.

Accepted Answer

A)  alias
B)  data type
C)  stored function
D)  triggerE) All of the above
F) A) and B)

Question 18

The constraint assigns a value to an attribute when a new row is added to a table.

Accepted Answer

A)  CHECK
B)  UNIQUE
C)  NOT NULL
D)  DEFAULTE) None of the above
F) All of the above

Question 19

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 20

A(n)character is a symbol that can be used as a general substitute for other characters or commands.

Accepted Answer

The answer of A(n)character is a symbol that can be...

Exam 7: Introduction to Structured Query Language SQL

A(n) is an alternate name given to a column or table in any SQL statement.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The special operator used to check whether an attribute value matches a given string pattern is .

Correct AnswerverifiedShow Answer

Only numeric data types can be added and subtracted in SQL.

Correct AnswerverifiedShow Answer

According to the rules of precedence,which of the following computations should be completed first?

Correct AnswerverifiedShow Answer

An example of a command a user would use when making changes to a PRODUCT table is .

Correct AnswerverifiedShow Answer

A(n)is performed when data are retrieved from more than one table at a time.

Correct AnswerverifiedShow Answer

The constraint assigns a value to an attribute when a new row is added to a table.

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 and the output is ordered by the price is .

Correct AnswerverifiedShow Answer

The command is used to restore the database to its previous condition.

Correct AnswerverifiedShow Answer

A(n)character is a symbol that can be used as a general substitute for other characters or commands.

Correct AnswerverifiedShow Answer

A(n) is a query that is embedded inside another query.

Correct AnswerverifiedShow Answer

The command would be used to delete the table row where the P_CODE is 'BRT-345'.

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

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The command,coupled with appropriate search conditions,is an incredibly powerful tool that enables a user to transform data into information.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

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

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