Free Oracle 1z1-034 Exam Dumps Questions & Answers

You realize that the control file is damaged in your production database. After restoring the control file from autobackup, what is the next step that you must do to proceed with the database recovery?

• A.  Open the database in RESTRICTED mode
• B.  Open the database in NORMAL mode
• C.  Mount the database
• D.  Open the database with the RESETLOGS option

ENCRYPT_TS is an encrypted tablespace that contains tables with data.
Which statement is true regarding the effect of queries and data manipulation language (DML) statements on the encrypted data in the tables?

• A.  The data is decrypted during SORT and JOIN operations.
• B.  The data remains encrypted when it is stored in the redo logs.
• C.  The data remains encrypted in the UNDO tablespace provided that the UNDO tablespace was created with the encryption option enabled.
• D.  The data remains encrypted when it is read into memory.

You need to configure fine-grained access control to external network resources from within your database. You create an access control list (ACL) using the DBMS_NETWORK_ACL_ADMIN package.
Which statement is true regarding the ACL created?

• A.  It is a list of users and network privileges stored in the XML file according to which a group of users canconnect to one or more hosts.
• B.  It is the list of the host names or the IP addresses stored in the data dictionary that can connect to yourdatabase through PL/SQL network utility packages such as UTL_TCP.
• C.  It is a list of users and network privileges stored in the data dictionary according to which a group of userscan connect to one or more hosts.
• D.  It is a list of remote database links stored in the XML file that are available to the users of the database.

As part of archiving the historical data, you want to transfer data from one database to another database, whichis on another server. All tablespaces in the source database are read/write and online. The source and targetdatabases use the same compatibility level and character sets. View the Exhibit and examine the features inthe source and target database.
Which of the following steps are required to transport a tablespace from the database to the targetdatabase:
1.Make the tablespace read-only at the source database.
2.Export metadata from the source database.
3.Convert data filed by using Recovery Manager (RMAN).
4.Transfer the dump file and data filed to the target machine.
5.Import metadata at the target database.
6.Make the tablespace read/write at the target database.
Exhibit:

• A.  1, 2, 4, 5 and 6
• B.  2, 3, 4 and 5
• C.  All the steps
• D.  2, 4, and 5

The EMP table exists in your schema. You want to execute the following query:
SELECT ename, sal
FROM emp
AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '6' MINUTE)
WHERE ename = 'ALLEN';
What are the minimum requirements for the statement to execute successfully? (Choose all that apply)

• A.  ARCHIVELOG mode must be enabled
• B.  FLASHBACK must be set to ON for the database
• C.  Row Movement must be enabled for the table
• D.  The UNDO_MANAGEMENT parameter must be set to AUTO
• E.  The UNDO_RETENTION parameter must be set appropriately