Ch. 7/P1

Question 1

The SQL command that lets you insert data into a table, one row at a time, is ________.

a. SELECT
b. COMMIT
c. UPDATE
d. INSERT

Answer 1

d. INSERT

Question 2

SQL command that lets you save your work to disk is ________.

a. UPDATE
b. INSERT
c. COMMIT
d. SELECT

Answer 2

c. COMMIT

Question 3

The SQL command used to list the contents of a table is ________.

a. SELECT
b. UPDATE
c. INSERT
d. COMMIT

Answer 3

a. SELECT

Question 4

The SQL command that enables you to make changes in the data is ________.

a. COMMIT
b. INSERT
c. UPDATE
d. SELECT

Answer 4

c. UPDATE

Question 5

The current fully approved version of standard SQL prescribed by the American National Standards Institute is ________.

a. SQL2
b. SQL-4
c. SQL-99
d. SQL-2003

Answer 5

d. SQL-2003

Question 6

________ is/are SQL character data type(s).

a. VARCHAR2 only
b. ALPHANUMERIC
c. CHAR only
d. CHAR and VARCHAR2

Answer 6

d. CHAR and VARCHAR2

Question 7

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

a. SELECT ALL FROM PRODUCT;
b. SELECT * FROM PRODUCT;
c. DISPLAY * FROM PRODUCT;
d. LIST * FROM PRODUCT;

Answer 7

b. SELECT * FROM PRODUCT;

Question 8

In Oracle, the ________ command is used to place a $ in front of a numeric value.

a. CHAR
b. CONVERT
c. DISPLAY
d. FORMAT

Answer 8

d. FORMAT

Question 9

Using MySQL, which command would you use when changing the date in one record of the PRODUCT table?

a. update PRODUCT set P_INDATE=’2011-18-02’ where P_CODE=’13-Q2/P2’;
b. update PRODUCT set P_INDATE=’2011-02-18’ where P_CODE=’13-Q2/P2’;
c. update PRODUCT set P_INDATE=’02-18-2011’ where P_CODE=’13-Q2/P2’;
d. update PRODUCT set P_INDATE=’FEB-18-2011’ where P_CODE=’13-Q2/P2’;

Answer 9

b. update PRODUCT set P_INDATE=’2011-02-18’ where P_CODE=’13-Q2/P2’;

Question 10

Which command is used to restore the table contents?

a. COMMIT; BACKUP;
b. COMMIT; RESTORE;
c. COMMIT; ROLLBACK;
d. ROLLBACK;

Answer 10

d. ROLLBACK;

Question 11

Which command would be used to delete the table row where the P_CODE = ‘2238/QPD’?

a. DELETE ALL table WHEN ‘2238/QPD’=P_CODE;
b. DELETE FROM table WHERE P_CODE=’2238/QPD’;
c. DELETE table WHERE P_CODE=’2238/QPD’;

d.
REMOVE FROM table WHERE P_CODE=’2238/QPD’;

Answer 11

b. DELETE FROM table WHERE P_CODE=’2238/QPD’;

Question 12

Some RDBMSs (like Oracle) will automatically ________ data changes when issuing data definition commands.

a. INVOKE
b. UPDATE
c. COMMIT
d. ROLLBACK

Answer 12

c. COMMIT

Question 13

What happens when you issue the DELETE FROM tablename command without specifying a WHERE condition?

a. no rows will be deleted
b. all rows will be deleted
c. the first row will be deleted
d. the last row will be deleted

Answer 13

b. all rows will be deleted

Question 14

Which command is used to select partial table contents?

a. SELECT P_CODE, P_DESCRIPT, V_CODE, FROM PRODUCT;
b. SELECT * FROM PRODUCT;
c. SELECT PARTIAL FROM PRODUCT;
d. SELECT P_CODE, P_DESCRIPT, V_CODE FROM PRODUCT;

Answer 14

d. SELECT P_CODE, P_DESCRIPT, V_CODE FROM PRODUCT;

Question 15

Which query would be used to output the table contents where the value of V_CODE is equal to 21344?

a. OUTPUT * FROM table WHERE V_CODE=21344;
b. DISPLAY * FROM table V_CODE=21344;
c. SELECT ALL FROM table WHERE V_CODE=21344;
d. SELECT * FROM table WHERE V_CODE=21344;

Answer 15

d. SELECT * FROM table WHERE V_CODE=21344;

Question 16

Which query would be used to output the table contents where the value of the character field P_CODE is 1558-QW1?

a. SELECT * FROM table WHERE P_CODE EQUAL TO ‘15558-QW1’;
b. SELECT * FROM table WHERE P_CODE==’1558-QW1’;
c. SELECT * FROM table WHERE P_CODE=’1558-QW1’;
d. SELECT * FROM table IF P_CODE=’1558-QW1’;

Answer 16

c. SELECT * FROM table WHERE P_CODE=’1558-QW1’;

Question 17

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

a. SELECT * FROM table WHERE P_CODE >= ‘20-Jan-2006’;
b. SELECT * FROM table WHERE P_CODE => ‘20-Jan-2006’;
c. SELECT * FROM table WHERE P_CODE >= #20-Jan-06#;
d. SELECT * FROM table WHERE P_CODE >= %20-Jan-2006%;

Answer 17

c. SELECT * FROM table WHERE P_CODE >= #20-Jan-06#;

Question 18

Which command uses columns and column aliases to determine the total value of each of the products held on hand and displays the results in a column labeled TOTVALUE?

a. SELECT P_DESCRIPT, P_QOH, P_PRICE,P_QOH/P_PRICE AS TOTVALUE
FROM PRODUCT;

b. SELECT P_DESCRIPT, P_QOH, P_PRICE,P_QOH*P_PRICE AS TOTVALUE
FROM PRODUCT;

c. SELECT P_DESCRIPT, P_QOH, P_PRICE,P_QOH-P_PRICE AS TOTVALUE
FROM PRODUCT;

d. SELECT P_DESCRIPT, P_QOH, P_PRICE,P_QOH=P_PRICE AS TOTVALUE
FROM PRODUCT;

Answer 18

b. SELECT P_DESCRIPT, P_QOH, P_PRICE,P_QOH*P_PRICE AS TOTVALUE
FROM PRODUCT;

Question 19

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

a. data type
b. alias
c. trigger
d. stored function

Answer 19

b. alias

Question 20

What is the SQL syntax to list the table contents for either V_CODE = 21344 or V_CODE = 24288?

a. SELECT P_CODE FROM PRODUCT WHERE V_CODE == 21344 OR V_CODE == 24288;
b. SELECT P_CODE FROM PRODUCT WHERE V_CODE = 21344 OR = 24288;
c. SELECT P_CODE FROM PRODUCT WHERE V_CODE = 21344 OR V_CODE = 24288;
d. SELECT P_CODE FROM PRODUCT WHERE V_CODE = 21344 AND V_CODE = 24288;

Answer 20

c. SELECT P_CODE FROM PRODUCT WHERE V_CODE = 21344 OR V_CODE = 24288;

Question 21

The ________ operator is used to check whether an attribute value is null.

a. LIKE
b. IN
c. BETWEEN
d. IS NULL

Answer 21

d. IS NULL

Question 22

The ________ operator is used to define a range limit.

a. BETWEEN
b. NULL
c. IN
d. LIKE

Answer 22

a. BETWEEN

Question 23

The ________ operator is used to check whether an attribute has a value.

a. IN
b. BETWEEN
c. LIKE
d. EXISTS

Answer 23

d. EXISTS