Refer to the exhibit.

Which two queries will result in an error?

• A.SELECT FIRST_NAME LAST_NAME FROM EMPLOYEES;
• B.SELECT LAST_NAME,12 * SALARY AS ANNUAL_SALARY
  FROM EMPLOYEES
  WHERE 12 * SALARY > 100000
  ORDER BY 12 * SALARY;
• C.SELECT LAST_NAME,12 * SALARY AS ANNUAL_SALARY
  FROM EMPLOYEES
  WHERE ANNUAL_SALARY > 100000
  ORDER BY ANNUAL_SALARY;
• D.SELECT FIRST_NAME,LAST_NAME FROM EMPLOYEES;
• E.SELECT LAST_NAME,12 * SALARY AS ANNUAL_SALARY
  FROM EMPLOYEES
  WHERE ANNUAL_SALARY > 100000
  ORDER BY 12 * SALARY ;
• F.SELECT LAST_NAME,12 * SALARY AS ANNUAL_SALARY
  FROM EMPLOYEES
  WHERE 12 * SALARY > 100000
  ORDER BY ANNUAL_SALARY;

Comment: *

Name: *

Email: *

Verification: *

Evaluate the following SQL commands:

The command to create a table fails. Identify the reason for the SQL statement failure.

• A.You cannot use SYSDATEin the condition of a CHECKconstraint.
• B.You cannot use the BETWEENclause in the condition of a CHECKconstraint.
• C.You cannot use the NEXTVALsequence value as a DEFAULTvalue for a column.
• D.You cannot use ORD_NOand ITEM_NOcolumns as a composite primary key because ORD_NOis also the FOREIGN KEY.

Comment: *

Name: *

Email: *

Verification: *

Examine the SQL statement used to create the TRANSACTION table.
SQL > CREATE TABLE transaction
(trn_id char(2) primary key,
Start_date date DEFAULT SYSDATE,
End_date date NOT NULL);
The value 'A1' does not exist for trn_id in this table.
Which SQL statement successfully inserts a row into the table with the default value for START_DATE?

• A.INSERT INTO transaction VALUES ('A1', DEFAULT, TO_DATE('SYSDATE+10'))
• B.INSERT INTO transaction (trn_id, end_date) VALUES ('A1', '10-DEC-2014')
• C.INSERT INTO transaction (trn_id, start_date, end_date) VALUES ('A1', , '10-DEC-2014')
• D.INSERT INTO transaction VALUES ('A1', DEFAULT, TO_DATE(DEFAULT+10))

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the structure of the SALES and PRODUCTS tables. (Choose two.)

In the SALES table, PROD_ID is the foreign key referencing PROD_ID in the PRODUCTS table. You must list each product ID and the number of times it has been sold.
Examine this query which is missing a JOIN operator:

Which two JOIN operations can be used to obtain the required output? (Choose two.)

• A.FULL OUTER JOIN
• B.JOIN
• C.RIGHT OUTER JOIN
• D.LEFT OUTER JOIN

Comment: *

Name: *

Email: *

Verification: *

Which two queries will result in an error?

• A.SELECT FIRST_NAME LAST_NAME FROM EMPLOYEES;
• B.SELECT LAST_NAME,12 * SALARY AS ANNUAL_SALARY
  FROM EMPLOYEES
  WHERE 12 * SALARY > 100000
  ORDER BY ANNUAL_SALARY;
• C.SELECT LAST_NAME,12 * SALARY AS ANNUAL_SALARY
  FROM EMPLOYEES
  WHERE ANNUAL_SALARY > 100000
  ORDER BY 12 * SALARY ;
• D.SELECT LAST_NAME,12 * SALARY AS ANNUAL_SALARY
  FROM EMPLOYEES
  WHERE 12 * SALARY > 100000
  ORDER BY 12 * SALARY;
• E.SELECT LAST_NAME,12 * SALARY AS ANNUAL_SALARY
  FROM EMPLOYEES
  WHERE ANNUAL_SALARY > 100000
  ORDER BY ANNUAL_SALARY;
• F.SELECT FIRST_NAME,LAST_NAME FROM EMPLOYEES;

Comment: *

Name: *

Email: *

Verification: *