Which two actions does an incremental checkpoint perform?

• A.It signals CKPT to write the checkpoint position to the data file headers.
• B.It writes the checkpoint position to the data file headers.
• C.It advances the checkpoint position in the checkpoint queue.
• D.It writes the checkpoint position to the control file.

Comment: *

Name: *

Email: *

Verification: *

In your Oracle 12c database, you invoke SQL *Loader Express Mode command to load data:
$> sqlldr hr/hr table=employees
Which two statements are true about this command? (Choose two.)

• A.It fails because the SQL *Loader control file location is not specified.
• B.It succeeds and creates the EMPLOYEEStable in the HRschema if the table does not exist.
• C.It fails because the SQL *Loader data file location is not specified.
• D.It succeeds with default settings if the EMPLOYEEStable belonging to the HRschema is already defined
  in the database.
• E.It succeeds even if the HR user does not have the CREATE DIRECTORYprivilege.

Comment: *

Name: *

Email: *

Verification: *

A user establishes a connection to a database instance by using an Oracle Net.
You want to ensure that:
1 . The user account must be locked after five consecutive unsuccessful login attempts.
2 . Data read per session must be limited for the user.
3 . The user cannot have more than three simultaneous sessions.
4 . The user must have a maximum of 10 minutes session idle time before being logged off automatically.
Which two would you do to implement this? (Choose two.)

• A.by using appropriate KERNEL parameters set in the profile assigned to the user
• B.by alerting the appropriate user attributes with an ALTER USER command
• C.by implementing Database Resource Manager and assign it a profile for the user
• D.by using appropriate PASSWORD parameters set in the profile assigned to the user
• E.by implementing Database Resource Manager and assign it a role for the user

Comment: *

Name: *

Email: *

Verification: *

A database is stored in an Automatic Storage Management (ASM) disk group, disk group, DGROUP1 with SQL:

There is enough free space in the disk group for mirroring to be done.
What happens if the CONTROLLER1 failure group becomes unavailable due to error of for maintenance?

• A.Transactions and queries accessing database objects contained in any tablespace stored in DGROUP1 will fall.
• B.Mirroring of allocation units will be done to ASM disks in the CONTROLLER2 failure group until the CONTROLLER1 for failure group is brought back online.
• C.The data in the CONTROLLER1 failure group is copied to the controller2 failure group and rebalancing is initiated.
• D.ASM does not mirror any data until the controller failure group is brought back online, and newly allocated primary allocation units (AU) are stored in the controller2 failure group, without mirroring.
• E.Transactions accessing database objects contained in any tablespace stored in DGROUP1 will fail but queries will succeed.

Comment: *

Name: *

Email: *

Verification: *

You perform RMAN backups for your database and use a recovery catalog for managing the backups. To free space,
you execute this command:
RMAN> DELETE OBSOLETE;
Which three statements are true is this scenario?

• A.The physical files related to the backup need to be manually deleted.
• B.The backups deleted are based on the backup retention policy.
• C.The information related to the backups is removed from the recovery catalog and the control file.
• D.A backup sets marked as expired are deleted.
• E.The physical files related to the backup are deleted automatically.

Comment: *

Name: *

Email: *

Verification: *