Examine the description of the SALES table:

The SALES table has 55,000 rows.
Examine this statement:

Which two statements are true?

• A.SALES1 has NOT NULL constraints on any selected columns which had those constraints in the SALES table.
• B.SALES1 is created with 55,000 rows.
• C.SALES1 has PRIMARY KEY and UNIQUE constraints on any selected columns which had those constraints in the SALES table.
• D.SALES1 is created with no rows.
• E.SALES1 is created with 1 row.

Comment: *

Name: *

Email: *

Verification: *

Examine the commands used to create DEPARTMENT_DETAILS and COURSE_DETAILS tables:

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 (c.department_id=d.department_id);
• B.SELECT d.department_id, c.course_id FROM course_details c LEFT OUTER JOIN department_details d ON (c.department_id=d.department_id);
• C.SELECT d.department_id, c.course_id FROM department_details d RIGHT OUTER JOIN course_details c ON (d.department_id=c.department_id);
• D.SELECT d.department_id, c.course_id FROM department_details d LEFT OUTER JOIN course_details c ON (d.department_id=c.department_id);

Comment: *

Name: *

Email: *

Verification: *

View the exhibit and examine the structure of the EMPLOYEEStable.

You want to display all employees and their managers having 100 as the MANAGER_ID. You want the output in two columns: the first column would have the LAST_NAMEof the managers and the second column would have LAST_NAMEof the employees.
Which SQL statement would you execute?

• A.SELECT m.last_name "Manager", e.last_name "Employee"
  FROM employees m JOIN employees e
  ON m.employee_id = e.manager_id
  WHERE e.manager_id = 100;
• B.SELECT m.last_name "Manager", e.last_name "Employee"
  FROM employees m JOIN employees e
  ON e.employee_id = m.manager_id
  WHERE m.manager_id = 100;
• C.SELECT m.last_name "Manager", e.last_name "Employee"
  FROM employees m JOIN employees e
  WHERE m.employee_id = e.manager_id and AND e.manager_id = 100
• D.SELECT m.last_name "Manager", e.last_name "Employee"
  FROM employees m JOIN employees e
  ON m.employee_id = e.manager_id
  WHERE m.manager_id = 100;

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the description of the tables.

You execute this SQL statement:

Which three statements are true? (Choose three.)

• A.The statement will fail because a subquery may not be contained in a VALUESclause.
• B.A customer can exist in many countries.
• C.The statement will execute successfully and a new row will be inserted into the SALES table.
• D.The SALEStable has five foreign keys.
• E.The statement will fail if a row already exists in the SALEStable for product 23.
• F.A product can have a different unit price at different times.

Comment: *

Name: *

Email: *

Verification: *

View the exhibit and examine the description of the DEPARTMENTSand EMPLOYEEStables.

You wrote this SQL statement to retrieve EMPLOYEE_ID, FIRST_NAME, and DEPARTMENT NAME, for all employees:
SELECT employee_id, first_name, department_name
FROM employees
NATURAL JOIN departments;
The desired output is not obtained after executing the above SQL statement. What could be the reason for this?

• A.The table prefix is missing for the column names in the SELECTclause.
• B.The NATURAL JOINclause is missing the USINGclause.
• C.The DEPARTMENTStable is not used before the EMPLOYEEStable in the FROMclause.
• D.The EMPLOYEESand DEPARTMENTStables have more than one column with the same column name and data type.

Comment: *

Name: *

Email: *

Verification: *