Which of the following statements is correct? (refer to the tables in the JustLee Books database) a. A table can contain a maximum of only one column marked as unused. b. You can delete a table by removing all columns in the table. c. Using the SET UNUSED clause allows you to free up storage space used by a column. d. None of the above statements are correct.

Which of the following statements is correct? (refer to the tables in the JustLee Books database) a. A table can contain a maximum of only one column marked as unused. b. You can delete a table by removing all columns in the table. c. Using the SET UNUSED clause allows you to free up storage space used by a column. d. None of the above statements are correct.

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter3: Table Creation And Management

Section: Chapter Questions

Problem 8MC: Which of the following statements is correct? A table can contain a maximum of only one column...

See similar textbooks

Similar questions

Which of the following is true? All data in a table can be recovered if the table is dropped with the PURGE option. All data in a table can be recovered from the recycle bin if the table is dropped. All data in a table is lost if the table is dropped. All of the above statements are true.
Which of the following statements deletes all rows in the HOMEWORK10 table? a. DELETE FROM homework10; b. DELETE . FROM homework10; c. DELETE FROM homework10; d. DELETE FROM homework10 WHERE amid = ; e. Both c and d delete all rows in the HOMEWORK10 table.
Which of the following is a correct statement? You can restore the data deleted with the DROP COLUMN clause, but not the data deleted with the SET UNUSED clause. You can’t create empty tables—all tables must contain at least three rows of data. A table can contain a maximum of 1000 columns. The maximum length of a table name is 265 characters.
Which object in the data dictionary enables you to verify DEFAULT column settings? DEFAULT_COLUMNS DEF_TAB_COLUMNS USER_TAB_COLUMNS None of the above
Which of the following is not a correct statement? A table can be modified only if it doesn’t contain any rows of data. The maximum number of characters in a table name is 30. You can add more than one column at a time to a table. You can’t recover data contained in a table that has been truncated.
Which of the following data dictionary objects should be used to view information about the constraints in a database? USER_TABLES USER_RULES USER_COLUMNS USER_CONSTRAINTS None of the above objects should be used.
Which of the following characters can be used in a table name? a. b. ( c. % d. !
Which command can you use to change the existing data in a table?
Which of the following is a correct statement? ( refer to the tables in the JustLee Books database) a. You can restore the data deleted with the DROP COLUMN clause, but not the data deleted with the SET UNUSED clause. b. You can’t create empty tables—all tables must contain at least three rows of data. c. A table can contain a maximum of 1000 columns. d. The maximum length of a table name is 265 characters.
Which of the following statements is correct? (refer to the tables in the JustLee Books database.)a. The IN comparison operator can’t be used with a subquery that returns only one row of results.b. The equals (=) comparison operator can’t be used with a subquery that returns morethan one row of results.c. In an uncorrelated subquery, statements in the outer query are executed first, and thenstatements in the subquery are executed.d. A subquery can be nested only in the outer query’s SELECT clause.
Which of the following statements is correct? ( refer to the tables in the JustLee Books database). a. A PRIMARY KEY constraint allows NULL values in the primary key column(s). b. You can enable a dropped constraint if you need it in the future. c. Every table must have at least one PRIMARY KEY constraint, or Oracle 12 c doesn’t allow the table to be created. d. None of the above statements is correct
Which of the following operators is considered a single-row operator? (refer to the tables in the JustLee Books database.)a. INb. ALLc. <>d. <>ALL