. Which of the following is not a valid statement? (refer to the tables in the JustLee Books database) a. You can change the name of a table only if it doesn’t contain any data.b. You can change the length of a column that doesn’t contain any data.c. You can delete a column that doesn’t contain any data.d. You can add a column to a table.

. Which of the following is not a valid statement? (refer to the tables in the JustLee Books database) a. You can change the name of a table only if it doesn’t contain any data.b. You can change the length of a column that doesn’t contain any data.c. You can delete a column that doesn’t contain any data.d. You can add a column to a table.

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter5: Data Manipulation And Transaction Control

Section: Chapter Questions

Problem 4MC: Which of the following statements deletes all rows in the HOMEWORK10 table? a. DELETE FROM...

See similar textbooks

Similar questions

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 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 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 SQL statements is invalid and returns an error message? ALTER TABLE books ADD CONSTRAINT books_pubid_uk UNIQUE (pubid); ALTER TABLE books ADD CONSTRAINT books_pubid_pk PRIMARY KEY (pubid); ALTER TABLE books ADD CONSTRAINT books_pubid_nn NOT NULL (pubid); ALTER TABLE books ADD CONSTRAINT books_pubid_fk FOREIGN KEY (pubid) REFERENCES publisher (pubid); All of the above statements are invalid.
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. 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 operators is considered a single-row operator? (refer to the tables in the JustLee Books database.)a. INb. ALLc. <>d. <>ALL
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 is not a valid statement? (refer to the tables in the JustLee Books database.)a. You must enter the ALL keyword in a group function to include all duplicate values.b. The AVG function can be used to find the average calculated difference between twodates.c. The MIN and MAX functions can be used on any type of data.d. all of the abovee. none of the above
Which of the following characters can be used in a table name?a. –b. (c. %d. !
Which function can be used to add spaces to a column until it’s a specific width? (refer to the tables in the JustLee Books database.)a. TRIMLb. PADLc. LWIDTHd. none of the above