Examine the commands used to create DEPARTMENT_DETAILSand COURSE_DETAILS tables:

You want to generate a list of all department IDs that do not exist in the COURSE_DETAILStable.
You execute the SQL statement:

What is the outcome?

• A.It fails because the ON clause condition is not valid.
• B.It executes successfully but displays an incorrect list.
• C.It executes successfully and displays the required list.
• D.It fails because the join type used is incorrect.

Comment: *

Name: *

Email: *

Verification: *

Examine this SELECT statement and view the Exhibit to see its output: (Choose two.)

SELECT constraints_name, constraints_type, search_condition, r_constraints_name, delete_rule, status, FROM user_constraints WHERE table_name = 'ORDERS'; Which two statements are true about the output?

• A.The R_CONSTRAINT_NAME column contains an alternative name for the constraint.
• B.In the second column, 'c' indicates a check constraint.
• C.The STATUS column indicates whether the table is currently in use.
• D.The DELETE_RULE column indicates the desired state of related rows in the child table when the corresponding row is deleted from the parent table.

Comment: *

Name: *

Email: *

Verification: *

Evaluate the following statement.

Which statement is true regarding the evaluation of rows returned by the subquery in the INSERT statement?

• A.The INSERT statement will return an error because the ELSE clause is missing.
• B.Each row is evaluated by the first WHEN clause and if the condition is false then the row would be evaluated by the subsequent when clauses.
• C.Each row is evaluated by the first WHEN clause and if the condition is true, then the row would be evaluated by the subsequent when clauses.
• D.All rows are evaluated by all the three WHEN clauses.

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true? (Choose three.)

• A.The data dictionary is created and maintained by the database administrator.
• B.Data dictionary views consist of joins of dictionary base tables and user-defined tables.
• C.The usernames of all users including database administrators are stored in the data dictionary.
• D.The USER_CONS_COLUMNS view should be queried to find the names of columns to which constraints apply.
• E.Both USER_OBJECTS and CAT views provide the same information about all objects that are owned by the user.
• F.Views with the same name but different prefixes, such as DBA, ALL and USER, reference the same base tables from the data dictionary.

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the data in EMP and DEPT tables.

In the DEPT table, DEPTNO is the PRIMARY KEY.
In the EMP table, EMPNO is the PRIMARY KEY and DEPTNO is the FOREIGN KEY referencing the DEPTNO column in the DEPT table.
What would be the outcome of the following statements executed in the given sequence?
DROP TABLE emp;
FLASHBACK TABLE emp TO BEFORE DROP;
INSERT INTO emp VALUES (2, 'SCOTT', 10);
INSERT INTO emp VALUES (3, 'KING', 55);

• A.Only the first INSERT statement would succeed because all constraints except the primary key constraint are automatically retrieved after a table is flashed back.
• B.Only the SECOND INSERT statement would succeed because all the constraints except referential integrity constraints that reference other tables are retrieved automatically after the table is flashed back.
• C.Both the INSERT statements would succeed because none of the constraints on the table are automatically retrieved when the table is flashed back.
• D.Both the INSERT statements would fail because the constraints are automatically retrieved when the table is flashed back.

Comment: *

Name: *

Email: *

Verification: *