Consider the following statement on a RANGE partitioned table: ALTER TABLE orders DROP PARTITION p1, p3;
What is the outcome of executing the above statement?（）

You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace:
ALTER TABLE employees SHRINK SPACE CASCADE;
Which statement is correct in this scenario?（）

You need to perform these tasks:
1. Create and assign a MANAGER role to Blake and Clark
2. Grant CREATE TABLE and CREATE VIEW privileges to Blake and Clark
Which set of SQL statements achieves the desired results? （）

An application needs a table for each connection that tracks the ID and Name of all items previously ordered and committed within the connection. The table also needs to be cleaned up and automatically removed each time a connection is ended. Assuming the ITEMS table was created with the following SQL statement:
CREATE TABLE items item_no INT, item_name CHAR(5), item_qty INT)
Which of the following SQL statements will provide the table definition that meets the specified requirements?（）