Online Access Free 1z1-062 Practice Test

What is a requirement for creating a remote database scheduler job?

• A.The target remote database on which the job is scheduled must be Oracle Database 11g Release 2 or later.
• B.A private database link must be created from the originating database to the target remote database.
• C.The remote database job must run as a user that is valid on the target remote database.
• D.The target remote database must be on a different host form the originating scheduler database host.

Your database is open in read/write mode and multiple users are connected to the database instance.
You execute the following command:
SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;
What would be the effect on current sessions?

• A.They are not affected.
• B.They are terminated immediately.
• C.They are terminated after completing the transaction.
• D.They are not terminated but may only issue queries.

Which two statements are true about SQL*Loader Express Mode in an Oracle 12c database? (Choose two.)

• A.It can load data in parallel
• B.It requires Enterprise Manager Express to be configured
• C.No data file needs to be specified
• D.It loads data faster than conventional SQL*Loader
• E.It loads data more efficiently than conventional SQL*Loader

A database is open READ WRITE and the instance has multiple sessions some of which have active transactions.
You execute this command:
SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;
Which three are true about the active transactions? (Choose three.)

• A.They may continue to issue queries
• B.They are rolled back automatically
• C.They may issue COMMIT OR ROLLBACK statements
• D.They may continue to issue DML statements
• E.They are suspended and unable to issue any statements
• F.They are terminated immediately

Which three tools or tasks are run by default as part automated maintenance tasks? (Choose three.)

• A.Segment Advisor
• B.Automatic Database Diagnostic Monitor
• C.Optimizer statistics gathering
• D.SQL Access Advisor
• E.Automatic SQL Tuning Advisor