Examine the structure of the PROMOTIONS table: (Choose the best answer.)

Management requires a report of unique promotion costs in each promotion category.
Which query would satisfy this requirement?

• A.SELECT promo_category, DISTINCT promo_cost FROM promotions
• B.SELECT DISTINCT promo_cost, promo_category FROM promotions
• C.SELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1
• D.SELECT DISTINCT promo_cost, DISTINCT promo_category FROM promotions;

Comment: *

Name: *

Email: *

Verification: *

Examine this query and its output:

Examine this query with an incomplete was WHERE clause:

Which two are true about operators that can be used In the WHERE clause?

• A.Using <> any will display all the product names.
• B.Using not in or <> all will give the same result.
• C.Using not in or <> any will give the same result.
• D.Using <> any will display all the product names except the product named Fork.
• E.Using in will display all the product names,

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the descriptions of the DEPT and LOCATIOMS tables.

You want to update the CITY column of the DEPT table for all the rows with the corresponding value in the CITY column of the LOCATIONS table for each department.
Which SQL statement would you execute to accomplish the task?

• A.UPDATE dept d
  SET city = ALL (SELECT city
  FROM locations l
  WHERE d.location_id = l.location_id);
• B.UPDATE dept d
  SET city = (SELECT city FROM locations l)
  WHERE d.location_id = l.location_id;
• C.UPDATE dept d
  SET city = ANY (SELECT city FROM locations l);
• D.UPDATE dept d
  SET city = (SELECT city
  FROM locations l
  WHERE d.location_id = l.location_id);

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.Only statement 2 executes successfully and gives the required result.
• B.Both statements 1 and 2 execute successfully and give different results.
• C.Only statement 1 executes successfully and gives the required result.
• D.Both statements 1 and 2 execute successfully and give the same required result.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about the data dictionary?

• A.The data dictionary is constantly updated to reflect changes to database objects, permissions, and data.
• B.All users have permissions to access all information in the data dictionary by default
• C.All user actions are recorded in the data dictionary.
• D.Base tables in the data dictionary have the prefix DBA_.
• E.The SYS user owns all base tables and user-accessible views in the data dictionary.

Comment: *

Name: *

Email: *

Verification: *