You must write a query that prompts users for column names and conditions every time it is executed. (Choose the best answer.) The user must be prompted only once for the table name.
Which statement achieves those objectives?

• A.SELECT &col1, '&col2'FROM &tableWHERE &&condition = '&cond';
• B.SELECT &col1, &col2 FROM &&tableWHERE &condition = &&cond
• C.SELECT &col1, &col2 FROM "&table"WHERE &condition = &cond;
• D.SELECT &col1, &col2 FROM &&tableWHERE &condition = &cond;

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the structure of the EMPLOYEES table.
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_NAME of the managers and the second column would have LAST_NAME of 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 e.employee_id = m.manager_id
  WHERE m.manager_id=100;
• B.SELECT m.last_name "Manager", e.last_name "Employee"
  FROM employees m JOIN employees e
  WHERE m.employee_id = e.manager_id AND e.managerjd=100;
• C.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;
• D.SELECT m.last_name "Manager", e.last_name "Employee"
  FROM employees m JOIN employees e
  ON m.employee_id = e.manager_id
  WHERE e.managerjd=100;

Comment: *

Name: *

Email: *

Verification: *

Which two are true about external tables that use the ORACLE_DATAPUMPaccess driver? (Choose two.)

• A.When creating an external table, data can be selected from another external table or from a table whose rows are stored in database blocks.
• B.Creating an external table creates a dump file that can be used only by an external table in the same database.
• C.When creating an external table, data can be selected only from a table whose rows are stored in database blocks.
• D.Creating an external table creates a directory object.
• E.Creating an external table creates a dump file that can be used by an external table in the same or a different database.

Comment: *

Name: *

Email: *

Verification: *

You need to display the first names of all customers from the CUSTOMERStable that contain the character 'e' and have the character 'a' in the second last position.
Which query would give the required output?
SELECT cust_first_name

• A.FROM customers
  WHERE INSTR(cust_first_name, 'e')<>0 AND
  SUBSTR(cust_first_name, LENGTH(cust_first_name), -2)='a';
• B.FROM customers
  WHERE INSTR(cust_first_name, 'e')IS NOT NULL AND
  SUBSTR(cust_first_name, 1, -2)='a';
  SELECT cust_first_name
• C.FROM customers
  WHERE INSTR(cust_first_name, 'e')<>0 AND
  SUBSTR(cust_first_name, -2, 1)='a';
  SELECT cust_first_name
• D.FROM customers
  WHERE INSTR(cust_first_name, 'e')<>'' AND
  SUBSTR(cust_first_name, -2, 1)='a';
  SELECT cust_first_name

Comment: *

Name: *

Email: *

Verification: *

You execute this query:

What is the result?

• A.It generates an error.
• B.It returns the date for the first Monday of the next month.
• C.It returns the date for the last Monday of the current month.
• D.It executes successfully but does not return any result.

Comment: *

Name: *

Email: *

Verification: *