Free Oracle 1z0-034 Exam Dumps Questions & Answers

You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOG mode. Which two statements are true in this scenario?

• A.  You must configure the flash recovery area (fast recovery area) for the database.
• B.  You can perform complete database backups without closing the database.
• C.  All the previous closed database backups including control files become invalid after you configure the database to ARCHIVELOG mode.
• D.  You must shut down the database instance to perform the backups.

Identify three key features of Oracle Data Pump (Choose three.)

• A.  Data Pump uses relative path instead of absolute path
• B.  Data Pump uses absolute path instead of relative path
• C.  Data Pump can stop a running job and resume it later
• D.  Data Pump can perform import using database link
• E.  Data Pump can perform incremental and cumulative exports

The DB_BLOCK_CHECKING parameter is set to FALSE. What level of block checking will be performed?

• A.  The Oracle database will perform block checking for the data blocks in all user tablespaces.
• B.  The Oracle database will perform block checking for the data blocks in the SYSTEM and SYSAUX tablespaces.
• C.  The Oracle database will perform block checking for the default permanent tablespace only.
• D.  The Oracle database will not perform block checking for any of the data blocks.
• E.  The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only.

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 remote database links stored in the XML file that are available to the users of the database.
• B.  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.
• C.  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.
• D.  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.

You work with a newly created database. Presently, there is no application load on the database instance. You want to create a baseline for tuning the application, so you decide to collect recommendations that can be implemented to improve application performance.
What action must you take to achieve this?

• A.  Run the Automatic Workload Repository (AWR) report.
• B.  Run Segment Advisor.
• C.  Run the SQL Tuning Advisor (STA).
• D.  Run the SQL Access Advisor with a hypothetical workload.