Introduction to SQL, Chapter 8

What is the SQL syntax to list the table contents for either V_CODE = 21344 or V_CODE = 24288?
1. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE = 21344 OR V_CODE < = 24288;
2. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE = 21344 OR V_CODE = > 24288;
3. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE = 21344 OR V_CODE > 24288;
4. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE = 21344 OR V_CODE = 24288;
What is the syntax to create a view?
1. CREATE viewname AS SELECT query
2. CREATE VIEW viewname AS SELECT query
3. DECLARE VIEW viewname AS SELECT query
4. NEW VIEW viewname AS SELECT query
Some RDBMSs (like Oracle) will automatically ____ data changes when issuing data definition commands.
1. ROLLBACK
2. COMMIT
3. UPDATE
4. INVOKE
What is the command used to list the P_CODE, P_DESCRIPT, P_INDATE, and P_PRICE fields from the PRODUCT table in ascending order by P_PRICE?
1. SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE FROM PRODUCT SEQUENCE BY P_PRICE
2. SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE FROM PRODUCT LIST BY P_PRICE;
3. SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE FROM PRODUCT ORDER BY P_PRICE;
4. SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE FROM PRODUCT ASCENDING BY P_PRICE
To join tables, you simply enumerate the tables in the ____ clause of the SELECT statement.
1. FROM
2. JOIN
3. WHERE
4. TABLES
Which of the following character strings has the greatest value?
1. DB
2. A
3. CC
4. AB
What happens when you issue the DELETE FROM tablename command without specifying a WHERE condition?
1. no rows will be deleted
2. the first row will be deleted
3. the last row will be deleted
4. all rows will be deleted
What is wrong with the following query? SELECT V_CODE, P_CODE, P_DESCRIPT, P_PRICE FROM PRODUCT GROUP BY V_CODE;
1. no aggregate function is used
2. no where clause is specified
3. no table name is specified
4. nothing is wrong
The ____ command is used to modify the table structure by adding, removing, or renaming columns.
1. DROP
2. ALTER
3. DELETE
4. ERASE
A multilevel ordered sequence is known as a ____ order sequence.
1. layered
2. cascading
3. 2-tier
4. 3-tier
Frequency distributions can be created quickly and easily using the ____ clause within the SELECT statement.
1. SUM
2. DIST
3. ORDER BY
4. GROUP BY
Which query would be used to output the table contents where the value of V_CODE is less than or equal to 21344?
1. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE < > 21344;
2. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE < =21344;
3. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE = > 21344;
4. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE = 21344;
What is the name for the following query? SELECT PRODUCT.P_CODE, VENDOR.V_CODE, V_NAME FROM VENDOR RIGHT JOIN PRODUCT ON VENDOR.V_CODE = PRODUCT.V_CODE;
1. rigth outer join
2. left outer join
3. recursive query
4. view
What is the command 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 P_PRICE?
1. SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE < > VENDOR.V_CODE; ORDER BY P_PRICE;
2. SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE = > VENDOR.V_CODE; ORDER BY P_PRICE;
3. SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE < = VENDOR.V_CODE; ORDER BY P_PRICE;
4. SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE = VENDOR.V_CODE; ORDER BY P_PRICE;
Which command uses columns and column aliases to determine the total value of each of the products held on hand and display the results in a column labeled TOTVALUE?
1. SELECT P_DESCRIPT, P_QOH, P_PRICE,P_QOH*P_PRICE AS TOTVALUE FROM PRODUCT;
2. SELECT P_DESCRIPT, P_QOH, P_PRICE,P_QOH=P_PRICE AS TOTVALUE FROM PRODUCT;
3. SELECT P_DESCRIPT, P_QOH, P_PRICE,P_QOH/P_PRICE AS TOTVALUE FROM PRODUCT;
4. SELECT P_DESCRIPT, P_QOH, P_PRICE,P_QOH-P_PRICE AS TOTVALUE FROM PRODUCT;
To list all the contents of the PRODUCT table you would use ____.
1. LIST * FROM PRODUCT;
2. SELECT * FROM PRODUCT;
3. DISPLAY * FROM PRODUCT;
4. SELECT ALL FROM PRODUCT;
The SQL command that lets you list attributes from rows in one or more tables or views is ____.
1. INSERT
2. SELECT
3. COMMIT
4. UPDATE
The ____ operator is used to define a range limit.
1. BETWEEN
2. NULL
3. LIKE
4. IN
Which command would you use when changing the date in the PRODUCT table?
1. CHANGE PRODUCT SET P_INDATE = '18-JAN-2006' WHERE P_CODE = '13-Q2/P2';
2. ROLLBACK PRODUCT SET P_INDATE = '18-JAN-2006' WHERE P_CODE = '13-Q2/P2';
3. EDIT PRODUCT SET P_INDATE = '18-JAN-2006' WHERE P_CODE = '13-Q2/P2';
4. UPDATE PRODUCT SET P_INDATE = '18-JAN-2006' WHERE P_CODE = '13-Q2/P2';
The basic SQL aggregate function that gives the arithmetic mean for the specific column is ____.
1. COUNT
2. AVG
3. MAX
4. SUM

Introduction to SQL, Chapter 8

Quiz