Chapter 5, Problem 18MC

Create a set of lookup tables.

If you add a record to the wrong table, what’s the simplest way to remove the record from the table?

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.

What is the most efficient way to write a trigger that updates a large number of rows?     Specify "for each statement"     Specify "for each row"     Specify "for each table"     Specify "referencing new row"

Which of the following is not a correct statement?a. A table can be modified only if it doesn’t contain any rows of data.b. The maximum number of characters in a table name is 30.c. You can add more than one column at a time to a table.d. You can’t recover data contained in a table that has been truncated.

A select operation pares down a table in a relational database by eliminating columns according to certain criteria. true or false?

What is the single most important consideration when clearing out rows, columns, and tables?

what does aggregate function do? a) It eliminates  one or more columns of a table. b) it list  combinations of rows in two tables. c) it selects roes that appear in one table but another. d) it compares values over a set of rows

Which database operation reads table block directly a) Index scan b) Binary search c) Table scan d) Fan out