100% Correct Database 11g 1z0-034 practice test

Exambible offers free demo for 1z0-034 exam. "Upgrade Oracle9i/10g OCA to Oracle Database 11g OCP", also known as 1z0-034 exam, is a Oracle Certification. This set of posts, Passing the Oracle 1z0-034 exam, will help you answer those questions. The 1z0-034 Questions & Answers covers all the knowledge points of the real exam. 100% real Oracle 1z0-034 exams and revised by experts!


2020 Oracle Official New Released 1z0-034 ♥♥
https://www.certifytools.com/1z0-034-exam.html


Q1. What happens when you run the SQL Tuning Advisor with limited scope? 

A. Access path analysis is not performed for SQL statements. 

B. SQL structure analysis is not performed for SQL statements. 

C. SQL Profile recommendations are not generated for SQL statements. 

D. Staleness and absence of statistics are not checked for the objects in the query supplied to the SQL Tuning Advisor. 

Answer:

Q2. 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 shut down the database instance to perform the backups. 

B. You must configure the flash recovery area (fast recovery area) for the database. 

C. You can perform complete database backups without closing the database. 

D. All the previous closed database backups including control files become invalid after you configure the database to ARCHIVELOG mode. 

Answer: C,D 

Q3. 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. 2, 4, and 5 

B. All the steps 

C. 2, 3, 4 and 5 

D. 1, 2, 4, 5 and 6 

Answer:

Refer to here. Generate a Transportable Tablespace Set read_only--expdp--4-import-read_wrtie 

1, 2, 4, 5, 6 (optional) 

If both platforms have the same endianness, no conversion is necessary. Otherwise you must do 

aconversion of the tablespace set either at the source or destination database. 

Transport the dump file to the directory pointed to by the DATA_PUMP_DIR directory object, or to 

any otherdirectory of your choosing. 

Run the following query to determine the location of DATA_PUMP_DIR: 

SELECT * FROM DBA_DIRECTORIES WHERE DIRECTORY_NAME = 'DATA_PUMP_DIR' 

Transport the data files to the location of the existing data files of the destination database. On the UNIX and Linux platforms, this location is typically /u01/app/oracle/oradata/SID/ or +DISKGROUP/SID/datafile/. 

Q4. Identify two options that Oracle recommends while configuring the backup and recovery environment for your recovery catalog. (Choose two.) 

A. configuring control file autobackup to be ON 

B. backing up data filed only and not the archived redo log files 

C. running the recovery catalog database in NOARCHIVELOG mode. 

D. setting the retention policy to a REDUNDANCY value greater than 1 

E. backing up the recovery catalog to the same disk as that of the target database 

Answer: A,D 

Refer to here. 

Configuring the Recovery Catalog Database 

When you use a recovery catalog, RMAN requires that you maintain a recovery catalog schema. 

The recovery catalog is stored in the default tablespace of the schema. The SYS user cannot be the owner of the recovery catalog. 

Decide which database you will use to install the recovery catalog schema, and also how you will back up this database. Also, decide whether to operate the catalog database in ARCHIVELOG mode, which is recommended. 

Note: Do not use the target database to be backed up as the database for the recovery catalog. 

The recovery catalog must be protected if the target database is lost. 

Q5. The Automatic Workload Repository (AWR) snapshot interval is set to 1 hour. A user of your database notifies you that the system was slow between 10:00 PM and 10:10 PM, but the Automatic Database Diagnostic Management (ADDM) analysis for the time period between 10:00 PM and 11:00 PM does not show this performance problem. 

What would you suggest to analyze this performance problem for the user? 

A. SQL Tuning Advisor 

B. SQL Performance Analyzer 

C. Active Session History report 

D. AWR Compare Periods report 

Answer:

Q6. Examine these Data Pump commands to import objects to non-existent users hr1 and oe1. 

S expdp system/manager Schemas =hr,oe directory =EXP_ DIR include = table 

$ impdp system/manager Schemas = hr1,oe1 Directory = EXP_DIR Dumpfile = export.dat Remap_schema =hr:hr1,oe :oe1 

What would be achieved by running the above commands? 

A. expdp will fail because no path has been defined for the dumpfile. 

B. expdp will succeed but Impdp will fail because users do not exist. 

C. impdp will create two users called hrl and oe1 and import all objects to the new schemas 

D. impdp will create two users called hrl and oe1 and import tables owned by hr and oe schemas to hr1 and oe1 schemas, respectively. 

Answer:

Q7. You executed the following command In Recovery Manager {RMAN): 

RMAN>REPORTNEEDBACKUPdays 3; 

What is the output of this command? 

A. a list of files that require a backup within three days 

B. a list of files requiring more than 3 days of archive logs to apply 

C. a list of files that RMAN recommends be backed up only once in every three days, based on low volatility 

D. a list of files for which a backup has already been performed in the last three days and which is required tobe backed up again based on the high number of transactions performed on them 

Answer:

Using RMAN REPORT NEED BACKUP with Different Retention Policies (link) 

You can specify different criteria for REPORT NEED BACKUP, using one of the following forms of 

the command: 

REPORT NEED BACKUP RECOVERY WINDOW OF n DAYS 

Displays objects requiring backup to satisfy a recovery window-based retention policy 

REPORT NEED BACKUP REDUNDANCY n 

Displays objects requiring backup to satisfy a redundancy-based retention policy 

REPORT NEED BACKUP DAYS n 

Displays files that require more than n days' worth of archived redo log files for recovery 

REPORT NEED BACKUP INCREMENTAL n 

Displays files that require application of more than n incremental backups for recovery 

Q8. Which data dictionary view would you query to find the name of the default permanent tablespace of the database? 

A. DICTIONARY 

B. DBA_TABLESPACES 

C. DBA_DIRECTORIES 

D. DBA_STORED_SETTINGS 

E. DATABASE_PROPERTIES 

F. DBA_TABLESPACE_GROUPS 

Answer: E SQL*Plus: Release 10.2.0.1.0 – Production on Sat Feb 4 20:31:26 2006 Copyright 

(c) 1982, 2005, Oracle. All rights reserved. SQL> conn / as sysdba Connected. SQL>desc DATABASE_PROPERTIES Name Null? Type —————————————– ——– ——————– PROPERTY_NAME NOT NULL VARCHAR2(30) PROPERTY_VALUE VARCHAR2(4000) DESCRIPTION VARCHAR2(4000) SQL> SELECT PROPERTY_NAME, PROPERTY_VALUE 2 FROM DATABASE_PROPERTIES 3WHERE PROPERTY_NAME=’DEFAULT_PERMANENT_TABLESPACE; PROPERTY_NAME PROPERTY_VALUE ———- —————————-DEFAULT_PERMANENT_TABLESPACE USERS 

Q9. View the Exhibit and examine the steps that you executed to create a database resource plan. 

Subsequently, you execute the following procedure which results in an error: 

SQL> EXECUTE dbms_resources_manager.validate_pending_area ( ); 

What could be the reason? 

A. The pending area is automatically submitted after the plan creation 

B. The procedure must be executed before creating the resources plan directive 

C. The SYS_GROUP resource consumer group is not included in the resource plan directive 

D. The OTHER_GROUPS resources consumer group is not included in the resource plan directive 

Answer:

Q10. Note the following parameter settings: Which setting is NOT allowed? 

A. ALTER SYSTEM SET DB_CACHE_SIZE=50M; 

B. ALTER SYSTEM SET DB_8K_CACHE_SIZE=10M; 

C. ALTER SYSTEM SET DB_4K_CACHE_SIZE=10M; 

D. ALTER SYSTEM SET DB_16K_CACHE_SIZE=10M; 

Answer: