View the exhibit and examine the structure of the SALES, CUSTOMERS, PRODUCTS and TIMES tables.

The PROD_ID column is the foreign key in the SALES tables, which references the PRODUCTS table.
Similarly, the CUST_ID and TIME_ID columns are also foreign keys in the SALES table referencing the CUSTOMERS and TIMES tables, respectively.
Evaluate the following CREATE TABLE command:
CREATE TABLE new_sales (prod_id, cust_id, order_date DEFAULT SYSDATE)
AS
SELECT prod_id, cust_id, time_id
FROM sales;
Which statement is true regarding the above command?

• A.The NEW_SALES table would not get created because the DEFAULT value cannot be specified in the column definition.
• B.The NEW_SALES table would not get created because the column names in the CREATE TABLE command and the SELECT clause do not match.
• C.The NEW_SALES table would get created and all the NOT NULL constraints defined on the specified columns would be passed to the new table.
• D.The NEW_SALES table would get created and all the FOREIGN KEY constraints defined on the specified columns would be passed to the new table.

Comment: *

Name: *

Email: *

Verification: *

The ORDERS table has a primary key constraint on the ORDER_ID column.
The ORDER_ITEMS table has a foreign key constraint on the ORDER_ID column, referencing the primary key of the ORDERS table.
The constraint is defined with ON DELETE CASCADE.
There are rows in the ORDERS table with an ORDER_TOTAL of less than 1000.
Which three DELETE statements execute successfully?

• A.DELETE order_id FROM orders WHERE order_total < 1000;
• B.DELETE * FROM orders WHERE order_total < 1000;
• C.DELETE FROM orders;
• D.DELETE FROM orders WHERE order_total < 1000;
• E.DELETE orders WHERE order_total < 1000;

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the structure of the EMP table which is not partitioned and not an index-organized table. (Choose two.)

Evaluate this SQL statement:
ALTER TABLE emp
DROP COLUMN first_name;
Which two statements are true?

• A.The drop of the FIRST_NAME column can be rolled back provided the SET UNUSED option is added to the SQL statement.
• B.The FIRST_NAME column would be dropped provided it does not contain any data.
• C.The FIRST_NAME column would be dropped provided at least one column remains in the table.
• D.The FIRST_NAME column can be dropped even if it is part of a composite PRIMARY KEY provided the CASCADE option is added to the SQL statement.

Comment: *

Name: *

Email: *

Verification: *

Which three actions can you perform on an existing table containing data? (Choose three.)

• A.Change the default value of a column
• B.Define a default value that is automatically inserted into a column containing nulls
• C.Add a new column as the table's first column
• D.Add a new NOT NULL column with a DEFAULT value
• E.Change a DATE column containing data to a NUMBER data type
• F.Increase the width of a numeric column

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about GLOBAL TEMPORARY TABLES?

• A.Any GLOBAL TEMPORARY TABLE rows existing at session termination will be deleted.
• B.A DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back.
• C.GLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session whose user has been granted select on the table.
• D.A TRUNCATE command issued in a session causes all rows in a GLOBAL TEMPORARY TABLE for the issuing session to be deleted.
• E.GLOBAL TEMPORARY TABLE space allocation occurs at session start.
• F.A GLOBAL TEMPORARY TABLE's definition is available to multiple sessions.

Comment: *

Name: *

Email: *

Verification: *