The Secret of Oracle 1z0-034 exam

We provide real 1z0-034 exam questions and answers braindumps in two formats. Download PDF & Practice Tests. Pass Oracle 1z0-034 Exam quickly & easily. The 1z0-034 PDF type is available for reading and printing. You can print more and practice many times. With the help of our Oracle 1z0-034 dumps pdf and vce product and material, you can easily pass the 1z0-034 exam.

2020 Oracle Official New Released 1z0-034 ♥♥

Q1. Which two statements are true regarding the functionality of the remap command in ASMCMD? 

A. It repairs blocks that have read disk I/O errors. 

B. It checks whether the alias metadata directory and the file directory are linked correctly. 

C. It repairs blocks by always reading them from the mirror copy and writing them to the original location. 

D. It reads the blocks from a good copy of an ASM mirror and rewrites them to an alternate location on disk if the blocks on the original location cannot be read properly. 

Answer: A,D 

Q2. 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. 


Q3. In which two situations would you rebuild an index using the ALTER INDEX----- REBUILD command? 

A. to change a unique index into a non-unique index 

B. to change index storage options 

C. to enable index monitoring 

D. to move the index to another tablespace 

E. to improve performance of an INDEX CLUSTER 

Answer: B,D 

Q4. You observed the following output for a user session: 

What do you infer from the preceding output? 

A. Resumable set for session with sid 18 

B. The user session has entered into a deadlock 

C. The database instance is enabled to use asynchronous commit 

D. The threshold warning limit is exceeded for the tablespace that is used by the user session 


Q5. View the following SQL statements: Transaction T1 

SQL> INSERT INTO hr.regions 2 VALUES (5,'Pole'); 3 COMMIT; 

Transaction T2 

SQL> UPDATE hr.regions 2 SET region_name='Poles' 3 WHERE region_id = 5; 4 COMMIT; 

Transaction T3 

SQL> UPDATE hr.regions 2 SET region_name='North and South Poles' 3 WHERE region_id = 5; You want to back out transaction T2. Which option would you use? 

A. It is possible, but transaction T3 also backs out. 

B. It is possible with the NOCASCADE_FORCE option. 

C. It is possible with the NONCONFLICT_ONLY option. 

D. It is not possible because it has conflicts with transaction T3. 


Table 12-2 Flashback TRANSACTION_BACKOUT Options 


Backs out specified transactions and all dependent transactions in a post-order fashion (that is, children arebacked out before parents are backed out). 

Without CASCADE, if any dependent transaction is not specified, an error occurs. 


Default. Backs out specified transactions, which are expected to have no dependent transactions. 

Firstdependent transactions causes an error and appears in *_FLASHBACK_TXN_REPORT. 


Backs out specified transactions, ignoring dependent transactions. Server runs undo SQL statements forspecified transactions in reverse order of commit times.If no constraints break and you are satisfied with the result, you can commit the changes; otherwise, you canroll them back. 


Backs out changes to nonconflicting rows of the specified transactions. Database remains consistent, buttransaction atomicity is lost. 

Q6. Identify two correct statements about the Active Session History (ASH) data. 

A. A part of SGA memory is used to store ASH data as rolling buffer. 

B. The ASH data can be analyzed between any two small time intervals. 

C. All ASH data in memory are flushed to disk by MMON in every 3 seconds. 

D. All ASH data in memory are flushed to disk by MMNL process whenever the buffer is full. 

Answer: A,B 

Q7. You are managing an Oracle Database 11g ASM instance with a disk group dg01 having three disks. 

One of the disks in the disk group becomes unavailable because of power failure. You issued the following command to change the DISK_REPAIR_TIME attribute from 3.6 hours to 5 hours: 

ALTER DISKGROUP dg01 SET ATTRIBUTE *disk_repair_time' = '5h' 

To which disks in the disk group will the new value be applicable? 

A. all disks in the disk group 

B. all disks that are currently in OFFLINE mode 

C. all disks that are not currently in OFFLINE mode 

D. all disks in the disk group only if all of them are ONLINE 


Check out the answer options, it is tricky. The NOT OFFLINE disks equals ONLINE disks. Refer to Set the DISK_REPAIR_TIME Disk Group Attribute Appropriately. The DISK_REPAIR_TIME disk group attribute specifies how long a disk remains offline before Oracle ASM drops the disk. If a disk is made available before the DISK_REPAIR_TIME parameter has expired, the storage administrator can issue the ONLINE DISK command and Oracle ASM resynchronizes the stale data from the mirror side. In Oracle Database 11g, the online disk operation does not restart if there is a failure of the instance on which the disk is running. You must reissue the command manually to bring the disk online. 

Q8. There was media failure and you decide to check the data files for block corruption. Which would you use to create a report on any corruptions found? 

A. the DBNEWID utility 

B. the DBVERIFY utility 

C. the ANALYZE command 

D. the RMAN REPORT command 

E. the RMAN CROSSCHECK command 

F. the CHECK_OBJECT procedure of the DBMS_REPAIR package 


Q9. While exporting data with Data Pump, you find that the export takes longer than expected. You decide to stop the job and restart it during off-peak hours. 

Which view would you query to determine the name and status of the stopped job? 







When a Datapump Export or Import session is launched, a Datapump Job is automatically tarted. This way, we can:* detach from and reattach to long-running jobs without affecting the job itself. 

* monitor jobs from multiple locations 

* stop a job: suspend it temporarily to leave other applications requesting more resources to get them restart itlater 

* kill any Datapump job anytime 

* see the progress of the import or export operations 

REF.: Metalink Note: 262557.1 

Q10. View the Exhibit to observe the error. 

You receive this error regularly and have to shutdown the database instance to overcome the error. AutomaticShared Memory Management is configured for the instance. 

What can you do to reduce the chance of this error in the future? 

A. Increase the value of SGA_MAX_SIZE 

B. Enable automatic memory management 

C. Set the PRE_PAGE_SGA parameter to true 

D. Lock the System Global Area (SGA) in memory 


ORA-04031: unable to allocate string bytes of shared memory ("string","string","string","string") Cause: More shared memory is needed than was allocated in the shared pool or Streams pool. Action: If the shared pool is out of memory, either use the DBMS_SHARED_POOL package to pin largepackages, reduce your use of shared memory, or increase the amount of available shared memory byincreasing the value of the initialization parametersSHARED_POOL_RESERVED_SIZE andSHARED_POOL_SIZE. If the large pool is out of memory, increase the initialization parameterLARGE_POOL_SIZE. If the error is issued from an Oracle Streams or XStream process, increase theinitialization parameter STREAMS_POOL_SIZE or increase the capture or apply parameter MAX_SGA_SIZE.