Free Oracle 1z0-034 Exam Dumps Questions & Answers

You want to perform an RMAN backup of database as a copy. Which two factors will you consider while performing the backup operation?

• A.  The backup as copy can only be taken to disk
• B.  Backup can be performed only when the instance is shutdown
• C.  The backup as copy can only be taken to tape
• D.  Backup will constitute all used and unused blocks in the database

Which three tasks can be performed using a duplicate database? (Choose three.)

• A.  Testing the backup and recovery procedures
• B.  Testing the upgrade of an Oracle database to a new release
• C.  Testing the effect of an application changes on database performance
• D.  Continuously updating archive log files from the target database to support failover

Which three elements can a job chain process involve? (Choose three)

• A.  a schedule
• B.  a lightweight job
• C.  an event
• D.  a program
• E.  another chain

You executed the following query:
SELECT oldest_flashback_scn, oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG;
Considering that all the redo logs are available, what information can you derive from the output of the preceding query?

• A.  The approximate time and the lowest system change number (SCN) to which you can flash back your database
• B.  The time when the last flashback operation in your database was performed
• C.  The time when the first flashback operation in your database was performed
• D.  The system change number (SCN) and the time when the Flashback Database was enabled in the database instance

Evaluate the following block of code:

What is the outcome of the above code?

• A.  It creates an access control list (ACL) with the user ACCT_MGR who gets the CONNECT and RESOLVE privileges.
• B.  It produces an error because the range of ports associated with the hosts has not been specified.
• C.  It creates an access control list (ACL) with the user ACCT_MGR who gets the CONNECT privilege but not the RESOLVE privilege.
• D.  It produces an error because a fully qualified host name needs to be specified.