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

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

Comment: *

Name: *

Email: *

Verification: *

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

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

Comment: *

Name: *

Email: *

Verification: *

Which is true about roles?

• A.A role can be password-protected only if it has been granted system privileges.
• B.Roles can be created only by SYS or SYSTEM.
• C.All roles belong to the SYSTEM schema.
• D.A role can be granted to other roles.
• E.Roles containing object privileges can be created only by the object owner.

Comment: *

Name: *

Email: *

Verification: *

The CUSTOMERS table has a CUST_CREDIT_LIMIT column of data type NUMBER.
Which two queries execute successfully? (Choose two.)

• A.SELECT NVL(TO_CHAR(cust_credit_limit * .15), 'Not Available') FROM customers;
• B.SELECT NVL2(cust_credit_limit, TO_CHAR(cust_credit_limit * .15), 'Not Available') FROM customers;
• C.SELECT NVL(cust_credit_limit * .15, 'Not Available') FROM customers;
• D.SELECT NVL2(cust_credit_limit * .15, 'Not Available') FROM customers;
• E.SELECT TO_CHAR(NVL(cust_credit_limit * .15, 'Not Available')) FROM customers;

Comment: *

Name: *

Email: *

Verification: *

The ORCL database has RESUMABLE__TIMEOUT = 7200 and DEFERRED_SEGMENT_CREATION = FALSE User U1 has a 1 MB quota in tablespace DATA.
U1 executes this command:
SQL> CREATE TABLE t1 AS
(SELECT object_name, sharing, created
FROM dba_objects);
U1 complains that the command is taking too long to execute.
In the alert log, the database administrator (DBA) finds this:
2017/3/6 14:45:17
statement in resumable session 'User U1(136), Session 1, Instance 1' was suspended due to ORA-01536: space quota exceeded for tablespace 'DATA' Which are three actions any one of which the DBA could take to resume the session? (Choose three.)

• A.Grant UNLIMITED TABLESPACE to U1
• B.Drop other U1 objects in DATA
• C.Increase U1's quota sufficiently in DATA
• D.Set DEFERRED_SEGMENT_CREATION to TRUE
• E.Set AUTOEXTEND ON for data files in DATA
• F.Add a data file to DATA

Comment: *

Name: *

Email: *

Verification: *