Question 1

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

Question 2

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

Question 3

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  VENDOR.V_CODE;

Question 4

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

Accepted Answer

A) alias 
B) operator 
C) nested 
D) view

Question 5

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

Question 6

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;

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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 9

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

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

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

Question 13

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

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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,VENDOR
WHERE 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,VENDOR
WHERE 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,VENDOR
WHERE PRODUCT.V_CODE <= VENDOR.V_CODE; ORDER BY PRODUCT.P_PRICE; 
D) SELECT PRODUCT.P_DESCRIPT,PRODUCT.P_PRICE,VENDOR.V_NAME,VENDOR.V_CONTACT, VENDOR.V_AREACODE,VENDOR.V_PHONE FROM PRODUCT,VENDOR
WHERE PRODUCT.V_CODE = VENDOR.V_CODE; ORDER BY PRODUCT.P_PRICE;

Question 16

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 17

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

Question 19

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

Question 20

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 operations

Exam 7: Introduction to Structured Query Language SQL

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

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

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 .

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

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

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

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

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

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

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

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

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

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

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

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 .

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

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

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

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

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