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

• 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: *

View the exhibit and examine the description of the PRODUCT_INFORMATION table.

Which SQL statement would retrieve from the table the number of products having LIST_PRICE as NULL?

• A.SELECT COUNT (list_price)FROM product_informationWHERE list_price i= NULL
• B.SELECT COUNT (DISTINCT list_price)FROM product_informationWHERE list_price is NULL
• C.SELECT COUNT (NVL(list_price, 0))FROM product_informationWHERE list_price is NULL
• D.SELECT COUNT (list_price)FROM product_informationWHERE list_price is NULL

Comment: *

Name: *

Email: *

Verification: *

Examine the commands used to create DEPARTMENT_DETAILS and
COURSE_DETAILS:
SQL>CREATE TABLE DEPARTMENT_DETAILS
(DEPARTMENT_ID NUMBER PRIMARY KEY,
DEPARTMENT_NAMEVARCHAR2(50),
HODVARCHAR2(50));
SQL>CREATE TABLE COURSE_DETAILS
(COURSE_IDNUMBER PRIMARY KEY,
COURSE_NAMEVARCHAR2(50),
DEPARTMENT_IDVARCHAR2(50));
You want to generate a list of all department IDs along with any course IDs that may have been assigned to them.
Which SQL statement must you use?

• A.SELECT d.department_id, c.course_id FROM department_details d RIGHT OUTER JOIN course_details c ON (d.department_id=c. department_id);
• B.SELECT d.department_id, c.course_id FROM department_details d LEFT OUTER JOIN course_details c ON (d.department_id=c. department_id);
• C.SELECT d.department_id, c.course_id FROM department_details d RIGHT OUTER JOIN course_details c ON (c.department_id=d. department_id);
• D.SELECT d.department_id, c.course_id FROM course_details c LEFT OUTER JOIN department_details d ON (c.department_id=d. department_id);

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about conditional INSERT ALL?

• A.Each row returned by the subquery can be inserted into only a single target table.
• B.Each WHEN condition is tested for each row returned by the subquery.
• C.The total number of rows inserted is always equal to the number of rows returned by the subquery.
• D.It cannot have an ELSE clause.
• E.A single WHEN condition can be used for multiple INTO clauses.

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the structures of the employees and departments tables.

You must update the employees table according to these requirements::
-Update only those employees who work in Boston or Seattle (locations 2900 and 2700).
-Set department_id for these employees to the department id corresponding to London (locationid 2100).
-Set the employees' salary in iocation_id 2100 to 1.1 times the average salary of their department.
-Set the employees' commission In location_id 2100 to 1.5 times the average commission of their department.
You issue this command:

What is the result?

• A.It executes successfully but does not produce the desired update.
• B.It executes successfully and produces the desired update.
• C.It generates an error because multiple columns cannot be specified together in an UPDATE statement.
• D.It generates an error because a subquery cannot have a join condition in an update statement.

Comment: *

Name: *

Email: *

Verification: *