Which two are true about instance recovery for a database that is open in read write mode?
(Choose two.)

• A.The database opens after the roll forward phase of instance recovery has completed.
• B.Only the CURRENT REDO log group is required to perform instance recovery.
• C.It is always performed when opening a database.
• D.It always occurs during instance startup performed immediately after a SHUTDOWN ABORT.
• E.No users can log on until instance recovery has completed.
• F.It is guaranteed to complete within fast_start_mttr_target number of seconds.

Comment: *

Name: *

Email: *

Verification: *

What is true about non-equijoin statement performance? (Choose two.)

• A.Table aliases can improve performance
• B.The BETWEEN condition always performs better than using the >= and <= conditions
• C.The join syntax used makes no difference to performance
• D.The BETWEEN condition always performs less well than using the >= and <= conditions
• E.The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax

Comment: *

Name: *

Email: *

Verification: *

You want to apply the principle of Least Privilege in all your live databases.
One of your requirements is to revoke unnecessary privileges from all users who have them using Privilege Analysis.
Which three types of analyses can be done using the DBMS_PRIVILEGE_CAPTURE package?
(Choose three.)

• A.analysis of all privileges used by all users including administrative users in the database
• B.analysis of all privileges used by all users but excluding administrative users in the database
• C.analysis of privileges that a user has on their own schema objects that they did not use
• D.analysis of privileges that a user has on their own schema objects that they did use
• E.analysis of privileges granted directly to a role that are then used by a user who has been granted that role
• F.analysis of privileges granted indirectly to a role that are then used by a user who has been granted that role

Comment: *

Name: *

Email: *

Verification: *

You have been tasked to create a table for a banking application.
One of the columns must meet three requirements:
1. Be stored in a format supporting date arithmetic without using
conversion functions
2. Store a loan period of up to 10 years
3. Be used for calculating interest for the number of days the loan
remains unpaid
Which data type should you use?

• A.TIMESTAMP WITH TIMEZONE
• B.INTERVAL YEAR TO MONTH
• C.INTERVAL DAY TO SECOND
• D.TIMESTAMP WITH LOCAL TIMEZONE
• E.TIMESTAMP

Comment: *

Name: *

Email: *

Verification: *

The SALES_Q1 and USERS tablespaces exist in one of your databases and TEMP is a temporary tablespace.
Segment creation is not deferred.
You execute this command:

Which three statements must be true so that the SALES user can create tables in SALES_Q1?
(Choose three.)

• A.The sales user must have been granted the CREATE TABLE privilege
• B.The sales user must have a quota on the TEMP tablespace
• C.The sales user must have their quota on the users tablespace removed
• D.The sales user must have a quota on the SALES_Q1 tablespace to hold the initial extends of all tables they plan to create in their schema
• E.The sales user must have a quota on the SALES_Q1 tablespace to hold all the rows to be inserted into any table in their schema
• F.The sales user must have been granted the CREATE SESSION privilege

Comment: *

Name: *

Email: *

Verification: *