Evaluate this query:
SQL> SELECT TRUNC(ROUND(156.00,-1),-1)
FROM DUAL;
What will be the result?

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

Comment: *

Name: *

Email: *

Verification: *

Which three SQL statements would display the value 1890.55 as $1,890.55? (Choose three.)

• A.SELECT TO_CHAR (1890.55, '$99,999D99')
  FROM DUAL;
• B.SELECT TO_CHAR (1890.55, '$99G999D99')
  FROM DUAL
• C.SELECT TO_CHAR (1890.55, '$99G999D00')
  FROM DUAL
• D.SELECT TO_CHAR (1890.55, '$9,999V99')
  FROM DUAL;
• E.SELECT TO_CHAR (1890.55, '$0G000D00')
  FROM DUAL;

Comment: *

Name: *

Email: *

Verification: *

These are the steps for a correlated subquery, listed in random order:
* The WHERE clause of the outer query is evaluated.
* A candidate row is fetched from the table specified in the outer query.
* This is repeated for the subsequent rows of the table, until all the rows are processed.
* Rows are returned by the inner query, after being evaluated with the value from the candidate row in the outer query.
Which is the correct sequence in which the Oracle server evaluates a correlated subquery?

• A.2, 1, 4, 3
• B.4, 1, 2, 3
• C.4, 2, 1, 3
• D.2, 4, 1, 3

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about views in an Oracle Database? (Choose three.)

• A.Views can join tables only if they belong to the same schema.
• B.A view can be created that refers to a non-existent table in its defining query.
• C.Views have no object number.
• D.Views have no segment.
• E.Rows inserted into a table using a view are retained in the table if the view is dropped.
• F.A SELECT statement cannot contain a WHERE clause when querying a view containing a WHEREclause in its defining query.

Comment: *

Name: *

Email: *

Verification: *

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 executes successfully and introduces an 'sat the end of each promo_namein the output.
• C.It produces an error because the data types are not matching.
• D.It produces an error because flower braces have been used.

Comment: *

Name: *

Email: *

Verification: *