* MANAGER is an existing role with no privileges or roles.
* EMP is an existing role containing the CREATE TABLEprivilege.
* EMPLOYEES is an existing table in the HR schema.
Which two commands execute successfully?

• A.GRANT CREATE TABLE, SELECT ON hr.employees TO manager;
• B.GRANT CREATE SEQUENCE TO manager, emp;
• C.GRANT CREATE ANY SESSION, CREATE ANY TABLE TO manager;
• D.GRANT CREATE TABLE, emp TP manager;
• E.GRANT SELECT, INSERT ON hr.employees TO manager WITH GRANT OPTION;

Comment: *

Name: *

Email: *

Verification: *

Examine the data in the CUST_NAME column of the CUSTOMERS table. CUST_NAME
Renske Ladwig Jason Mallin
Samuel McCain
Allan MCEwen
Irene Mikkilineni
Julia Nayer
You need to display customers' second names where the second name starts with "Mc" or "MC."
Which query gives the required output?

• A.SELECT SUBSTR(cust_name, INSTR(cust_name,' ')+1)
  FROM customers
  WHERE INITCAP(SUBSTR(cust_name, INSTR(cust_name,' ')+1)) LIKE 'Mc%';
• B.SELECT SUBSTR(cust_name, INSTR(cust_name,' ')+1)
  FROM customers
  WHERE SUBSTR(cust_name, INSTR(cust_name,' ')+1) LIKE INITCAP('MC%');
• C.SELECT SUBSTR(cust_name, INSTR(cust_name,' ')+1)
  FROM customers
  WHERE INITCAP(SUBSTR(cust_name, INSTR(cust_name,' ')+1))='Mc';
• D.SELECT SUBSTR(cust_name, INSTR(cust_name,' ')+1)
  FROM customers
  WHERE INITCAP(SUBSTR(cust_name, INSTR(cust_name,' ')+1)) = INITCAP('MC%');

Comment: *

Name: *

Email: *

Verification: *

In the EMPLOYEES table there are 1000 rows and employees are working in the company for more than 10 years.
Evaluate the following SQL statement:
What would be the result?

• A.It gives an error because NVL function cannot be used with UPDATE.
• B.It executes successfully and updates the records of those employees who have been working in the company for more than 600 days.
• C.It gives an error because multiple NVL functions are used in an expression.
• D.It executes successfully but no rows updated.

Comment: *

Name: *

Email: *

Verification: *

For each employee in department 90 you want to display:
1. their last name
2. the number of complete weeks they have been employed
The output must be sorted by the number of weeks, starting with the longest serving employee
first.Which statement will accomplish this?

• A.SELECT last_name, ROUND( (SYSDATE - hire_ date) 17) AS tenure
  FROM employees
  WHERE department_ id = 90
  ORDER BY tenure DESC;
• B.SELECT last_name, TRUNC( (SYSDATE - hire_ date) 1 7) AS tenure
  FROM employees
  WHERE department_ id = 90
  ORDER BY tenure ;
• C.SELECT last_name, ROUND( (SYSDATE - hire_ date) 1 7) AS tenure
  FROM employees
  WHERE department_ id = 90
  ORDER BY tenure ;
• D.SELECT last_name, TRUNC ( (SYSDATE - - hire_ date) 1 7) AS tenure
  FROM employees
  WHERE department_id = 90
  ORDER BY tenure DESC;

Comment: *

Name: *

Email: *

Verification: *

In the customers table, the CUST_CITY column contains the value 'Paris' for the CUST_FIRST_NAME 'Abigail'.
Evaluate the following query:

What would be the outcome?

• A.Abigail Pa
• B.Abigail IS
• C.An error message
• D.Abigail PA

Comment: *

Name: *

Email: *

Verification: *