Examine these statements executed in a single Oracle session:

Which three statements are true? (Choose three.)

• A.The code for fountain penis 3.
• B.There is no row containing fountain pen.
• C.The code for penis 10.
• D.There is no row containing pen.
• E.There is no row containing pencil.
• F.The code for penis 1.

Comment: *

Name: *

Email: *

Verification: *

View the exhibit for the structure of the STUDENTand FACULTYtables.

You need to display the faculty name followed by the number of students handled by the faculty at the base location.
Examine the following two SQL statements:
Statement 1
SQL>SELECT faculty_name, COUNT(student_id)
FROM student JOIN faculty
USING (faculty_id, location_id)
GROUP BY faculty_name;
Statement 2
SQL>SELECT faculty_name, COUNT(student_id)
FROM student NATURAL JOIN faculty
GROUP BY faculty_name;
Which statement is true regarding the outcome?

• A.Both statements 1 and 2 execute successfully and give different results.
• B.Only statement 1 executes successfully and gives the required result.
• C.Both statements 1 and 2 execute successfully and give the same required result.
• D.Only statement 2 executes successfully and gives the required result.

Comment: *

Name: *

Email: *

Verification: *

View the exhibit and examine the data in the PROJ_TASK_DETAILS table. (Choose the best answer.)

The PROJ_TASK_DETAILS table stores information about project tasks and the relation between them.
The BASED_ON column indicates dependencies between tasks.
Some tasks do not depend on the completion of other tasks.
You must generate a report listing all task IDs, the task ID of any task upon which it depends and the name of the employee in charge of the task upon which it depends.
Which query would give the required result?

• A.SELECT p.task_id, p.based_on, d.task_in_charge
  FROM proj_task_details p JOIN proj_task_details d
  ON (p.task_id = d.task_id);
• B.SELECT p.task_id, p.based_on, d.task_in_charge
  FROM proj_task_details p FULL OUTER JOIN proj_task_details d
  ON (p.based_on = d.task_id);
• C.SELECT p.task_id, p.based_on, d.task_in_charge
  FROM proj_task_details p JOIN proj_task_details d
  ON (p.based_on = d.task_id);
• D.SELECT p.task_id, p.based_on, d.task_in_charge
  FROM proj_task_details p LEFT OUTER JOIN proj_task_details d
  ON (p.based_on = d.task_id);

Comment: *

Name: *

Email: *

Verification: *

The user SCOTTwho is the owner of ORDERSand ORDER_ITEMStables issues this GRANTcommand:
GRANT ALL
ON orders, order_items
TO PUBLIC;
What must be done to fix the statement?

• A.PUBLICshould be replaced with specific usernames.
• B.ALLshould be replaced with a list of specific privileges.
• C.WITH GRANT OPTIONshould be added to the statement.
• D.Separate GRANTstatements are required for ORDERSand ORDER_ITEMS tables.

Comment: *

Name: *

Email: *

Verification: *

Examine the structure of the MEMBERStable.

Which query can be used to display the last names and city names only for members from the states MO and MI?

• A.SELECT last_name, city FROM members WHERE state ='MO' AND state ='MI';
• B.SELECT DISTINCT last_name, city FROM members WHERE state ='MO' OR state
  ='MI';
• C.SELECT last_name, city FROM members WHERE state LIKE 'M%';
• D.SELECT last_name, city FROM members WHERE state IN ('MO', 'MI');

Comment: *

Name: *

Email: *

Verification: *