Which is true about roles?

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

Comment: *

Name: *

Email: *

Verification: *

In which three situations does a new transaction always start? (Choose three.)

• A.when issuing a SELECT FOR UPDATE statement after a CREATE TABLE AS SELECT statement was issued in the same session
• B.when issuing a TRUNCATE statement after a SELECT statement was issued in the same session
• C.when issuing a CREATE TABLE statement after a SELECT statement was issued in the same session
• D.when issuing the first Data Manipulation Language (DML) statement after a COMMIT OR ROLLBACK statement was issued in the same session
• E.when issuing a CREATE INDEX statement after a CREATE TABLE statement completed successfully in the same session
• F.when issuing a DML statement after a DML statement failed in the same session

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(cust_credit_limit * .15, 'Not Available') FROM customers;
• B.SELECT NVL(TO_CHAR(cust_credit_limit * .15), 'Not Available') FROM customers;
• C.SELECT NVL2(cust_credit_limit, TO_CHAR(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: *

Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)

• A.The ADR base defaults to $ORACLE_HOME/rdbms/admin if neither DIAGNOSTIC_DEST nor ORACLE_BASE is set
• B.The ADR base defaults to $ORACLE_HOME/dbs if the DIAGNOSTIC_DEST parameter and the ORACLE_BASE environment variable are not set
• C.It supports diagnostics for Automatic Storage Management (ASM)
• D.It supports diagnostics for Oracle Clusterware
• E.It is held inside an Oracle database schema

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about dropping and unused columns in an Oracle database? (Choose three.)

• A.A primary key column referenced by another column as a foreign key can be dropped if using the CASCADE option.
• B.An UNUSED column's space is reclaimed automatically when the block containing that column is next queried.
• C.A column that is set to UNUSED still counts towards the limit of 1000 columns per table
• D.Partition key columns cannot be dropped.
• E.An UNUSED column's space is reclaimed automatically when the row containing that column is next queried.
• F.A DROP COLUMN command can be rolled back

Comment: *

Name: *

Email: *

Verification: *