Which three statements are true about single-row functions? (Choose three.)

• A.They return a single result row per table
• B.The data type returned can be different from the data type of the argument
• C.They can accept only one argument
• D.They can be nested to any level
• E.They can be used only in the WHERE clause of a SELECT statement
• F.The argument can be a column name, variable, literal or an expression

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about inner and outer joins? (Choose three.)

• A.A full outer join returns matched and unmatched rows
• B.An inner join returns matched rows
• C.Outer joins can only be used between two tables per query
• D.A full outer join must use Oracle syntax
• E.Outer joins can be used when there are multiple join conditions on two tables
• F.A left or right outer join returns only unmatched rows

Comment: *

Name: *

Email: *

Verification: *

Which two are true about RETENTION GUARANTEE? (Choose two.)

• A.It is a tablespace attribute.
• B.It prevents FLASHBACK DATABASE operation failure.
• C.It is a static parameter.
• D.It prevents "Snapshot too old" errors.
• E.It prevents out-of-space errors.

Comment: *

Name: *

Email: *

Verification: *

Examine these SQL statements which execute successfully:

Which two statements are true after execution?

• A.The foreign key constraint will be enabled and deferred.
• B.The primary key constraint will be enabled and deferred.
• C.The foreign key constraint will be disabled.
• D.The foreign key constraint will be enabled and immediate.
• E.The primary key constraint will be enabled and immediate.

Comment: *

Name: *

Email: *

Verification: *

Examine the description of the CUSTOMERS table:

For customers whose income level has a value, you want to display the first name and due amount as 5% of their credit limit. Customers whose due amount is null should not be displayed.
Which query should be used?

• A.SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT
  FROM customers
  WHERE cust_income_level != NULL
  AND due_amount != NULL;
• B.SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT
  FROM customers
  WHERE cust_income_level <> NULL
  AND due_amount <> NULL;
• C.SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT
  FROM customers
  WHERE cust_income_level IS NOT NULL
  AND due_amount IS NOT NULL;
• D.SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT
  FROM customers
  WHERE cust_income_level IS NOT NULL
  AND cust_credit_limit IS NOT NULL;
• E.SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT
  FROM customers
  WHERE cust_income_level != NULL
  AND cust_credit_level !=NULL;

Comment: *

Name: *

Email: *

Verification: *