Examine these SQL statements which execute successfully:

Which two statements are true after execution? (Choose two.)

• A.The foreign key constraint will be enabled and DEFERRED.
• B.The primary key constraint will be enabled and IMMEDIATE.
• C.The foreign key constraint will be disabled.
• D.The foreign key constraint will be enabled and IMMEDIATE.
• E.The primary key constraint will be enabled and DEFERRED.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about creating tables in an Oracle database?

• A.The same table name can be used for tables in different schemas.
• B.A create table statement can specify the maximum number of rows the table will contain.
• C.A primary key constraint is manadatory.
• D.Creating an external table will automatically create a file using the specified directory and file name.
• E.A system privilege is required.

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the data in the PRODUCTS table.

You must display product names from the PRODUCTS table that belong to the 'Software/other' category with minimum prices as either $2000 or $4000 and with no unit of measure.
You issue this query:

Which statement is true?

• A.It generates an error because the condition specified for the PROD_CATEGORY column is not valid.
• B.It generates an error because the condition specified for PROD_UNIT_OF_MEASURE is not valid.
• C.It executes successfully and returns the required result.
• D.It executes successfully but returns no result.

Comment: *

Name: *

Email: *

Verification: *

You create a table by using this command:
CREATE TABLE rate_list (rate NUMBER(6,2));
Which two are true about executing statements? (Choose two.)

• A.INSERT INTO rate_list VALUES (87654.556)inserts the value as 87654.6.
• B.INSERT INTO rate_list VALUES (0.551)inserts the value as .55.
• C.INSERT INTO rate_list VALUES (-10)produces an error.
• D.INSERT INTO rate_list VALUES (-.9)inserts the value as -.9.
• E.INSERT INTO rate_list VALUES (-99.99)inserts the value as 99.99.
• F.INSERT INTO rate_list VALUES (0.999) produces an error.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about queries using set operators (UNION, UNION ALL, INTERSECT and MINUS)?

• A.There must be an equal number of columns in each SELECT list.
• B.The name of each column in the first SELECT list must match the name of the corresponding column in each subsequent SELECT list.
• C.Each SELECT statement in the query can have an ORDER BY clause.
• D.None of the set operators can be used when selecting CLOB columns.
• E.The FOR UPDATE clause cannot be specified.

Comment: *

Name: *

Email: *

Verification: *