Which of the following is true? a. All data in a table can be recovered if the table is dropped with the PURGE option. b. All data in a table can be recovered from the recycle bin if the table is drop…
Which of the following is true?
a. All data in a table can be recovered if the table is dropped with the PURGE option.
b. All data in a table can be recovered from the recycle bin if the table is dropped.
c. All data in a table is lost if the table is dropped.
d. All of the above statements are true.
15. Which of the following commands is valid?
a. RENAME customer# TO customernumber FROM customers;
b. ALTER TABLE customers RENAME customer# TO customernum;
c. DELETE TABLE customers;
d. ALTER TABLE customers DROP UNUSED COLUMNS;
16. Which of the following commands creates a new table containing two columns?
a. CREATE TABLE newname (coll DATE, col2 VARCHAR2);
b. CREATE TABLE newname AS (SELECT title, retail, cost FROM books);
c. CREATE TABLEnewname (coll, col2);
d. CREATE TABLE newname (coll DATE DEFAULT SYSDATE, col2 VARCHAR2 (1));
17. Which of the following is a valid table name?
a. 9NEWTABLE
b. DATE9
c. NEW”TABLE
d. None of the above are valid table names.
18. Which of the following is a valid datatype?
a. CHAR3
b. VARCHAR4(3)
c. NUM
d. NUMBER
19. Which object in the data dictionary enables you to verify DEFAULT column settings?
a. DEFAULT_COLUMNS
b. DEF_TAB_COLUMNS
c. USER_TAB_COLUMNS
d. None of the above
20. Which of the following SQL statements changes the size of the Title column in the BOOKS
table from the current length of 30 characters to the length of 35 characters?
a. ALTER TABLE books CHANGE title VARCHAR(35);
b. ALTER TABLE books MODIFY (title VARCHAR2(35));
c. ALT
OR