A : This statement is false. You cannot add a foreign key to a global temporary table because the data in a global temporary table is session-specific, while a foreign key constraint implies a permanent relationship.

B : This statement is false. The ON COMMIT PRESERVE ROWS clause specifies that the data in the table should be preserved until the end of the session, not deleted at the end of the transaction.

C : This statement is false. You can drop a global temporary table without truncating it first.

D : This statement is true. You can alter a global temporary table to add columns within a session.

E : This statement is false. Data in a global temporary table with the ON COMMIT PRESERVE ROWS clause is private to the session that inserted the data, and cannot be seen by other sessions.

In Oracle Database, object privileges are rights to perform a particular action on a specific object in the database. Here ' s why the other options are incorrect:

A. UPDATE can be granted on tables, views, and materialized views, but not sequences. B. DELETE cannot be granted on sequences because sequences do not store data that can be deleted. D. INSERT cannot be granted on sequences; sequences are used to generate numbers, not to be inserted into directly. C. REFERENCES allows the grantee to create a foreign key that references the table or the columns of the table. It is applicable only to tables and views. E. SELECT can indeed only be granted on tables and views (including materialized views). F. ALTER is an object privilege that can be granted on tables and sequences but not views.

For more details, one may refer to the Oracle Database SQL Language Reference documentation, which specifies the types of object privileges and the objects they apply to.

In Oracle Database 12c, the operations related to dropping columns from a table include several behaviors, each specified clearly in Oracle documentation and best practices:

B. A column drop is implicitly committed: Dropping a column in Oracle using the ALTER TABLE ... DROP COLUMN command is a DDL (Data Definition Language) operation, which means it cannot be rolled back. DDL commands in Oracle are automatically and implicitly committed, meaning that once a column is dropped, the action is finalized immediately.

C. A column that is referenced by another column in any other table cannot be dropped: In Oracle, if a column is being referenced by a foreign key constraint or any dependency from another table, you cannot directly drop it until those references are removed or disabled. This ensures data integrity across related tables.

E. A primary key column cannot be dropped: The primary key constraint is critical for identifying unique rows within a table. Oracle does not allow the dropping of columns that are part of a primary key without first dropping the constraint or modifying it to exclude the column you intend to drop.

References:

Oracle Database SQL Language Reference 12c, specifically sections discussing DDL operations and constraints.

In Oracle Database 12c, the operations related to dropping columns from a table include several behaviors, each specified clearly in Oracle documentation and best practices:

B. A column drop is implicitly committed: Dropping a column in Oracle using the ALTER TABLE ... DROP COLUMN command is a DDL (Data Definition Language) operation, which means it cannot be rolled back. DDL commands in Oracle are automatically and implicitly committed, meaning that once a column is dropped, the action is finalized immediately.

C. A column that is referenced by another column in any other table cannot be dropped: In Oracle, if a column is being referenced by a foreign key constraint or any dependency from another table, you cannot directly drop it until those references are removed or disabled. This ensures data integrity across related tables.

E. A primary key column cannot be dropped: The primary key constraint is critical for identifying unique rows within a table. Oracle does not allow the dropping of columns that are part of a primary key without first dropping the constraint or modifying it to exclude the column you intend to drop.

References:

Oracle Database SQL Language Reference 12c, specifically sections discussing DDL operations and constraints.

The SQL query must find all customers with last names starting with A or B, regardless of case, and a credit limit below 1000:

B. WHERE (INITCAP(cust_last_name) LIKE ‘A% ' OR INITCAP(cust_last_name) LIKE ‘B% ' ) AND cust_credit_limit <</b> 1000: The INITCAP function initializes the first letter to uppercase for comparison. However, it should be noted that using INITCAP is not necessary when using the LIKE operator with a wildcard % following a single character, because it will not correctly filter all last names that start with an upper or lower case A or B.

D. WHERE (UPPER(cust_last_name) LIKE ' A%’ OR UPPER(cust_last_name) LIKE ‘B%’) AND cust_credit_limit <</b> 1000: This correctly filters last names beginning with A or B in any case and includes only those with a credit limit below 1000. The UPPER function is used to convert cust_last_name to uppercase before comparison.

References:

Oracle Database SQL Language Reference 12c, especially sections on string functions and conditions.