Examine these SQL statements that are executed in the given order:

What will be the status of the foreign key EMP_MGR_FK?

• A.It will be enabled and immediate.
• B.It will remain disabled and can be enabled only by dropping the foreign key constraint and re-creating it.
• C.It will remain disabled and can be re-enabled manually.
• D.It will be enabled and deferred.

Comment: *

Name: *

Email: *

Verification: *

Which two queries execute successfully?

• A.SELECT NULLIF (100) FROM DUAL;
• B.SELECT NULLIF (100, 'A') FROM DUAL;
• C.SELECT COALESCE(100, NULL, 200) FROM DUAL;
• D.SELKCT COALESCE (100, 'A') FROM DUAL;
• E.SELECT NULLIF(NULL, 100) FROM DUAL;

Comment: *

Name: *

Email: *

Verification: *

In which three situations does a transaction complete?

• A.when a PL/SQL anonymous block is executed
• B.when a DELETE statement is executed
• C.when a ROLLBACK command is executed
• D.when a data definition language (DDL) statement is executed
• E.when a TRUNCATE statement is executed after the pending transaction

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the description of the EMPLOYEES table.

You want to calculate the total remuneration for each employee. Total remuneration is the sum of the annual salary and the percentage commission earned for a year. Only a few employees earn commission.
Which SQL statement would you execute to get the desired output?

• A.SELECT first_name, salary, salary*12 + NVL(salary,0)*commission_pct, "Total"FROM EMPLOYEES;
• B.SELECT first_name, salary (salary + NVL (commission_pct, 0)*salary)*12 "Total"FROM EMPLOYEES;
• C.SELECT first_name, salary, salary*12+(salary*NVL2 (commission_pct,
  salary,salary+commission_pct))"Total"FROM EMPLOYEES;
• D.SELECT first_name, salary, salary*12+salary*commission_pct "Total"FROM EMPLOYEES;

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about Data Manipulation Language (DML) statements?

• A.An INSERT INTO...VALUES.. statement can add multiple rows per execution to a table.
• B.An UPDATE... SET... statement can modify multiple rows based on multiple conditions on a table.
• C.A DELETE FROM..... statement can remove rows based on only a single condition on a table.
• D.An INSERT INTO... VALUES..... statement can add a single row based on multiple conditions on a table.
• E.A DELETE FROM..... statement can remove multiple rows based on multiple conditions on a table.
• F.An UPDATE....SET.... statement can modify multiple rows based on only a single condition on a table.

Comment: *

Name: *

Email: *

Verification: *