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: *

A database is configured to use automatic undo management with temporary undo enabled.
An UPDATE is executed on a temporary table.
Where is the UNDO stored?

• A.in the undo tablespace
• B.in the SYSAUX tablespace
• C.in the SGA
• D.in the PGA
• E.in the temporary tablespace

Comment: *

Name: *

Email: *

Verification: *

Which two queries execute successfully?

• A.SELECT 2TOLLIF(100, 'A') FROM DUAL;
• B.SELECT NULLIF(100,100) FROM DUAL;
• C.SELECT NULLIF(NULL, 100) FROM DUAL;
• D.SELECT COALESCE(100, NULL, 200) FROM DUAL;
• E.SELECT COALESCE (100, 'AM FROM DUAL;

Comment: *

Name: *

Email: *

Verification: *

Which two are true about complete recovery? (Choose two.)

• A.It is possible only when the database is in MOUNT state
• B.The database must have FLASHBACK enabled in order to perform it.
• C.Uncommitted transactions will be rolled back after it completes.
• D.Incremental backups can be used to roll forward the database while performing it.
• E.Only RMAN backupsets can be used to restore a database as part of it.

Comment: *

Name: *

Email: *

Verification: *

Which is true about roles?

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

Comment: *

Name: *

Email: *

Verification: *