Free Oracle 1z0-034 Exam Dumps Questions & Answers

You are in the process of creating a virtual private catalog in your Oracle Database 11g database. The PROD1,PROD2, and PROD3 Oracle Database 10g databases are registered in the base recovery catalog. The databaseuser who owns the base recovery catalog is CATOWNER. CATOWNER executes the following command to grantprivileges to a new user VPC1 using Oracle Database 11g RMAN executables:
RMAN> GRANT CATALOG FOR DATABASE prod1, prod2 TO vpc1;
Then you issue the following commands:
RMAN> CONNECT CATALOG vpc1/oracle@catdb;
RMAN> SQL "EXEC catowner.dbms_rcvcat.create_virtual_catalog;"
What is the outcome of the above commands?

• A.  They produce an error because you need to connect to the target database to execute this packagedprocedure.
• B.  They produce an error because you need to connect as CATOWNER to execute this packaged procedure.
• C.  They execute and create a virtual catalog for pre-Oracle 11g clients.
• D.  They produce an error because PROD1 and PROD2 databases belong to the older version.

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 with the NONCONFLICT_ONLY option.
• B.  It is possible with the NOCASCADE_FORCE option.
• C.  It is possible, but transaction T3 also backs out.
• D.  It is not possible because it has conflicts with transaction T3.

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

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

Which four resources can directives be specified by using the Oracle Resource Manager?

• A.  degree of parallelism
• B.  number of sorts performed
• C.  CPU usage
• D.  idle time for blocking sessions
• E.  number of I/Os requests
• F.  number of open cursors

The database users regularly complain about the difficulty in performing transactions. On investigation, you find that some users perform long-running transactions that consume huge amounts of space in the undo tablespace, which caused the problem. You want to control the usage of the undo tablespace only for these user sessions and you do not want these sessions to perform long-running operations.
How would you achieve this?

• A.  Implement a profile for the users.
• B.  Implement a Database Resource Manager plan.
• C.  Implement external roles for the users.
• D.  Set the threshold for the undo tablespace.