Question 1. 1. (TCO 6) Which of the following keywords is used to remove a row i

Question

Question 1. 1. (TCO 6) Which of the following keywords is used to remove a row in a table? (Points : 2)        DROP
       DELETE
       REMOVE
       MODIFY Question 2. 2. (TCO 6) When a column is added to a table, it is the _____ column in the table. (Points : 2)        first
       last
       second
       third Question 3. 3. (TCO 6) Which of the following keywords is used to remove a database table in Oracle? (Points : 2)        DROP TABLE
       ALTER TABLE...DROP
       DELETE TABLE
       TRUNCATE TABLE Question 4. 4. (TCO 8) Which of the following is NOT a valid statement? (Points : 2)        A single value function cannot be nested inside a group function.
       Group functions can be nested inside other group functions.
       Group functions can be nested inside single row functions.
       A single row function can be nested inside a single row function. Question 5. 5. (TCO 8) Based upon the contents of the BOOKS table shown below, which of the following will find the retail price of the most expensive book in the COMPUTER category?

(Points : 2)        SELECT MAX(retail)
FROM books
GROUP BY category;
       SELECT MAXIMUM(retail)
FROM books
WHERE category = 'COMPUTER';
       SELECT MAX(retail)
FROM books
WHERE category = 'COMPUTER';
       SELECT MAXIMUM(retail)
FROM books
HAVING category = 'COMPUTER'; Question 6. 6. (TCO 8) Which of the following subqueries returns more than one row of results to the outer query? (Points : 2)        Multiple-column subquery
       Single-row subquery
       Multiple-row or IN subquery
       Correlated subquery Question 7. 7. (TCO 8) The following SQL statement contains which type of subquery?
SELECT title, retail, category FROM books
WHERE retail IN (SELECT MAX(retail) FROM books
GROUP BY category); (Points : 2)        Single-row (WHERE)
       Multiple-row (IN)
       Multiple-column
       Correlated Question 8. 8. (TCO 9) Which of the following clauses of the UPDATE command is optional? (Points : 2)        UPDATE
       SET
       WHERE
       FROM Question 9. 9. (TCO 9) Which of the following is not a valid SQL command? (Points : 2)        UPDATE acctmanager SET amedate = SYSDATE WHERE amid = 'J500';
       UPDATE acctmanager SET amname = UPPER(amname);
       UPDATE acctmanager SET amname = UPPER(amname) WHERE amid = 'J500';
       UPDATE acctmanager WHERE amid = 'J500'; Question 10. 10. (TCO 9) Which of the following statements about the DELETE command is incorrect? (Points : 2)        The DELETE command applies to an entire row and cannot be applied to specific columns within a row.
       The proper command syntax for the DELETE command is DELETE FROM tablename;.
       If you omit the optional WHERE clause, then all the rows in the table will be deleted.
       If you omit the mandatory WHERE clause, an error message will be issued. Question 11. 11. (TCO 8) Using the BOOK_ORDER table shown below as a reference, write the query that would show the number of orders that have been shipped and list the column name as Number of Orders Shipped.

(Points : 10)       
      

Explanation / Answer

1.DELETE
2. last
3. DELETE TABLE
4.Group functions can be nested inside single row functions.
5.SELECT MAX(retail)
FROM books
WHERE category = 'COMPUTER';
6. Multiple-row or IN subquery
7.Multiple-column
8.FROM
9. UPDATE acctmanager WHERE amid = 'J500';
10. If you omit the optional WHERE clause, then all the rows in the table will be deleted.

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.