Evaluate the following query:

What would be the outcome of the above query?

• A.It executes successfully and displays the literal " {'s start date was \> "for each row in the output.
• B.It produces an error because the data types are not matching.
• C.It produces an error because flower braces have been used.
• D.It executes successfully and introduces an 'sat the end of each promo_namein the output.

Comment: *

Name: *

Email: *

Verification: *

View the exhibit and examine the structure of the EMPLOYEEStable.

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_NAMEof the managers and the second column would have LAST_NAMEof the employees.
Which SQL statement would you execute?

• A.SELECT m.last_name "Manager", e.last_name "Employee"
  FROM employees m JOIN employees e
  WHERE m.employee_id = e.manager_id and AND e.manager_id = 100
• B.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;
• C.SELECT m.last_name "Manager", e.last_name "Employee"
  FROM employees m JOIN employees e
  ON m.employee_id = e.manager_id
  WHERE e.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 m.manager_id = 100;

Comment: *

Name: *

Email: *

Verification: *

Which statement is true regarding the INTERSECT operator?

• A.The names of columns in all SELECT statements must be identical.
• B.Reversing the order of the intersected tables alters the result.
• C.It ignores NULLs.
• D.The number of columns and data types must be identical for all SELECT statements in the query.
  INTERSECT Returns only the rows that occur in both queries' result sets, sorting them and removing duplicates.
  The columns in the queries that make up a compound query can have different names, but the output result set will use the names of the columns in the first query.

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about GLOBAL TEMPORARY TABLES?

• A.A GLOBAL TEMPORARY TABLE can be referenced in the defining query of a view.
• B.A GLOBAL TEMPORARY TABLE can have only one index.
• C.A GLOBAL TEMPORARY TABLE can have multiple indexes.
• D.A GLOBAL TEMPORARY TABLE cannot have a PUBLIC SYNONYM.
• E.A trigger can be created on a GLOBAL TEMPORARY TABLE.
• F.Data Manipulation Language (DML) on GLOBAL TEMPORARY TABLES generates no REDO.

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the details of the PRODUCT_INFORMATION table.

Evaluate this SQL statement:
SELECT TO_CHAR (list_price, '$9,999')
From product_information;
Which two statements are true regarding the output? (Choose two.)

• A.A row whose LIST_PRICE column contains value 1123.90 would be displayed as $1,124.
• B.A row whose LIST_PRICE column contains value 11235.90 would be displayed as $1,123.
• C.A row whose LIST_PRICE column contains value 1123.90 would be displayed as $1,123.
• D.A row whose LIST_PRICE column contains value 11235.90 would be displayed as #######.

Comment: *

Name: *

Email: *

Verification: *