Which two statements are true about the configuration and use of UNDO_RETENTION with GURANTEED RETENTION? (Choose two.)

• A.UNDO_RETENTION specifies for how long Oracle attempts to keep unexpired UNDO.
• B.UNDO_RETENTION specifies for how long Oracle attempts to keep expired and unexpired UNDO.
• C.Active UNDO is always retained.
• D.Unexpired UNDO is always retained.
• E.UNDO_RETENTION specifies how long all types of UNDO are retained.

Comment: *

Name: *

Email: *

Verification: *

You want to use table compression suitable for OLTP that will:
1. Compress rows for all DML statements on that table
2. Minimize the overheads associated with compression
Which compression option is best suited for this?

• A.COLUMN STORE COMPRESS FOR QUERY LOW
• B.ROW STORE COMPRESS BASIC
• C.COLUMN STORE COMPRESS FOR ARCHIVE LOW
• D.COLUMN STORE COMPRESS FOR ARCHIVE HIGH
• E.ROW STORE COMPRESS ADVANCED

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about Oracle synonyms? (Choose three.)

• A.A synonym cannot be created for a PL/SQL package
• B.A synonym can be available to all users
• C.A SEQUENCE can have a synonym
• D.A synonym created by one user can refer to an object belonging to another user
• E.Any user can drop a PUBLIC synonym

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about Enterprise Manager Database Express? (Choose two.)

• A.It is available only when the database is open
• B.It can be used to perform database recovery
• C.The same port number can be used for Database Express configurations for databases on different hosts
• D.It can be used to switch a database into ARCHIVELOGMODE
• E.The same port number can be used for multiple Database Express configurations for multiple databases on the same host

Comment: *

Name: *

Email: *

Verification: *

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

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