In one of your databases, you create a user, HR, and then execute this command:
GRANT CREATE SESSION TO hr WITH ADMIN OPTION;
Which three actions can HR perform? (Choose three.)

• A.Revoke the CREATE SESSION privilege from other users
• B.Revoke the CREATE SESSION privilege from user HR
• C.Log in to the database instance
• D.Grant the CREATE SESSION privilege with ADMIN OPTION to other users
• E.Execute DDL statements in the HR schema
• F.Execute DML statements in the HR schema

Comment: *

Name: *

Email: *

Verification: *

View the Exhibits and examine the structure of the COSTS and PROMOTIONS tables.
You want to display PROD_IDS whose promotion cost is less than the highest cost PROD_ID in a promotion time interval.
Examine this SQL statement:

Exhibit 1.

Exhibit 2.

What will be the result?

• A.It executes successfully and gives the required result
• B.It gives an error because the GROUP BY clause is not valid
• C.It gives an error because the ALL keyword is not valid
• D.It executes successfully but does not give the required result

Comment: *

Name: *

Email: *

Verification: *

Which three instance situations are possible with the Oracle Database server without multi-tenant? (Choose three.)

• A.one instance on one server associated with two or more databases on the same server
• B.one instance on one server associated with two or more databases on separate servers
• C.one instance on one server not associated with any database
• D.one instance on one server associated with one database
• E.two or more instances on separate servers all associated with one database

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 two statements are true about UNDO and REDO? (Choose two.)

• A.The generation of UNDO generates REDO
• B.DML modifies Oracle database objects and only generates UNDO
• C.The generation of REDO generates UNDO
• D.DML modifies Oracle database objects and only generates REDO
• E.DML modifies Oracle database objects and generates UNDO and REDO

Comment: *

Name: *

Email: *

Verification: *