Examine the structure of the EMPLOYEES table. (Choose the best answer.) You must display the details of employees who have manager with MANAGER_ID 100, who were hired in the past 6 months and who have salaries greater than 10000.

• A.(SELECT last_name, hire_date, salaryFROM employeesWHERE salary > 10000UNION ALLSELECT last_name, hire_date, salaryFROM employeesWHERE manager_ID = (SELECT employee_id FROM employees WHERE employee_id = 100))UNIONSELECT last_name, hire_date, salaryFROM employeesWHERE hire_date > SYSDATE -180;
• B.SELECT last_name, hire_date, salaryFROM employeesWHERE salary > 10000UNION ALL SELECT last_name, hire_date, salaryFROM employeesWHERE manager_ID = (SELECT employee_id FROM employees WHERE employee_id
  100)INETRSECTSELECT last_name, hire_date, salaryFROM employees WHERE
  hire_date > SYSDATE- 180;
• C.SELECT last_name, hire_date, salaryFROM employeesWHERE manager_id
  (SELECT employee_id FROM employees WHERE employee_id = '100')UNIONSELECT last_name, hire_date, salaryFROM employeesWHERE hire_date > SYSDATE -
  180INTERSECTSELECT last_name, hire_date, salaryFROM employeesWHERE salary >
  10000;
• D.SELECT last_name, hire_date, salaryFROM employeesWHERE manager_id
  (SELECT employee_id FROM employees WHERE employee_id = 100)UNION
  ALL(SELECT last_name, hire_date, salaryFROM employeesWHERE hire_date >
  SYSDATE -180INTERSECTSELECT last_name, hire_date, salaryFROM
  employeesWHERE salary > 10000);

Comment: *

Name: *

Email: *

Verification: *

Examine the data in the CUST_NAME column of the CUSTOMERS table:

You want to display the CUST_NAME values where the last name starts with Mc or MC.
Which two WHERE clauses give the required result?

• A.WHERE SUBSTR (cust_name, INSTR (cust_name, '') +1) LIKE 'Mc%' OR 'MC%'
• B.WHERE INITCAP (SUBSTR (cust_name, INSTR(cust_name, '')+1)) LIKE 'Mc%'
• C.WHERE UPPER (SUBSTR (cust_name, INSTR(cust_name, '')+1)) LIKE UPPER ('MC%')
• D.WHERE SUBSTR (cust_name, INSTR (cust_name, '') +1) LIKE 'Mc%'
• E.WHERE INITCAP (SUBSTR (cust_name, INSTR(cust_name, '')+1)) IN ('MC%', 'Mc%)

Comment: *

Name: *

Email: *

Verification: *

Examine this query:
SELECT TRUNC(ROUND(156.00, -2), -1) FROM DUAL;
What is the result?

• A.16
• B.200
• C.100
• D.160
• E.150

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true regarding indexes?

• A.A table belonging to one user can have an index that belongs to a different user,
• B.An update to a table can result in updates to any or all of the table's indexes.
• C.When a table is dropped and is moved to the RECYCLE BIN, all Indexes built on that table are permanently dropped.
• D.A SELECT statement can access one or more indices without accessing any tables.
• E.An update to a table can result in no updates to any of the table's indexes.
• F.A UNIQUE index can be altered to be non-unique.

Comment: *

Name: *

Email: *

Verification: *

View the exhibit and examine the description of the EMPLOYEES table. (Choose two.)

You executed this SQL statement:
SELECT first_name, department_id, salary
FROM employees
ORDER BY department_id, first_name, salary desc;
Which two statements are true regarding the result?

• A.The values in the SALARY column would be returned in descending order for all employees having the same value in the DEPARTMENT_ID and FIRST_NAME column.
• B.The values in the all columns would be returned in descending order.
• C.The values in the SALARY column would be returned in descending order for all employees having the same value in the DEPARTMENT_ID column.
• D.The values in the FIRST_NAME column would be returned in ascending order for all employees having the same value in the DEPARTMENT_ID column.
• E.The values in the FIRST_NAME column would be returned in descending order for all employees having the same value in the DEPARTMENT_ID column.

Comment: *

Name: *

Email: *

Verification: *