Which statement falls to execute successfully?

• A.SELECT *
  FROM employees e
  JOIN departments d
  ON e.department_id=d.department_id
  AND d.department_id=90;
• B.SELECT *
  FROM employees e
  JOIN departments d
  ON e.department_id=d.department_id
  WHERE d.department_id=90;
• C.SELECT *
  FROM employees e
  JOIN departments d
  ON d.departments_id=90
  WHERE e.department_id=d.department_id;
• D.SELECT *
  FROM employees e
  JOIN department d
  WHERE e.department_id=d.department_id
  AND d.department_id=90;

Comment: *

Name: *

Email: *

Verification: *

Examine the types and examples of relationship that follow:
1 One-to-one a) teacher to Student
2 One-to-many b) Employees to Manager
3 Many-to-one c) Person to SSN
4 Many-to-many d) Customers to Products
Which option indicates correctly matched relationships?

• A.1-a, 2-b, 3-c, and 4-d
• B.1-c, 2-d, 3-a, and 4-b
• C.1-d, 2-b, 3-a, and 4-c
• D.1-c, 2-a, 3-b, and 4-d

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about INTERVAL data types? (Choose two.)

• A.The YEAR field in an INTERVAL YEAR TO MONTHcolumn must be a positive value.
• B.INTERVAL DAY TO SECONDcolumns support fractions of seconds.
• C.INTERVAL YEAR TO MONTHcolumns only support monthly intervals within a single year.
• D.INTERVAL YEAR TO MONTHcolumns support yearly intervals.
• E.INTERVAL YEAR TO MONTHcolumns only support monthly intervals within a range of years.
• F.The value in an INTERVAL DAY TO SECONDcolumn can be copied into an INTERVAL YEAR TO MONTH column.

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the data in the PRODUCTS table.

You must display product names from the PRODUCTS table that belong to the 'Software/other' category with minimum prices as either $2000 or $4000 and with no unit of measure.
You issue this query:

Which statement is true?

• A.It executes successfully and returns the required result.
• B.It generates an error because the condition specified for PROD_UNIT_OF_MEASURE is not valid.
• C.It generates an error because the condition specified for the PROD_CATEGORY column is not valid.
• D.It executes successfully but returns no result.

Comment: *

Name: *

Email: *

Verification: *

View the exhibit and examine the description of the DEPARTMENTS and EMPLOYEES tables.

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 SELECT clause.
• B.The NATURAL JOIN clause is missing the USING clause.
• C.The DEPARTMENTS table is not used before the EMPLOYEES table in the FROM clause.
• D.The EMPLOYEES and DEPARTMENTS tables have more than one column with the same column name and data type.

Comment: *

Name: *

Email: *

Verification: *