=>'group1', COMMENT => 'New Group'); This command errors out displaying the following message:
ERROR at line 1:
ORA-29371: pending area is not active
ORA-06512: at "SYS.DBMS_RMIN", line 115
ORA-06512: at "SYS.DBMS_RESOURCE_MANAGER", line 108 ORA-06512: at line 1
What action would you take to overcome this error?
A. activate the Pending Area before creating the consumer group B. create the Pending Area before creating the consumer group C. increase the size of the database buffer cache to accommodate the Pending Area D. increase the size of the shared pool to accommodate the Pending Area E. increase the size of the large pool to accommodate the Pending Area
B. create the Pending Area before creating the consumer group
Question 82:
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.
C. SQL Profile recommendations are not generated for SQL statements.
Question 83:
Which statements describe the capabilities of the DBMS_NETWORK_ACL_ADMIN package? (Choose all that apply.)
A. It can be used to allow the access privilege settings for users but not roles. B. It can be used to allow the access privilege settings for users as well as roles. C. It can be used to control the time interval for which the access privilege is available to a user. D. It can be used to selectively restrict the access for each user in a database to different host computers. E. It can be used to selectively restrict a user's access to different applications in a specific host computer.
B. It can be used to allow the access privilege settings for users as well as roles. C. It can be used to control the time interval for which the access privilege is available to a user. D. It can be used to selectively restrict the access for each user in a database to different host computers.
Question 84:
Note the following statements that use flashback technology:
1.
FLASHBACK TABLE
TO SCN ;
2.
SELECT * FROM
AS OF SCN 123456;
3.
FLASHBACK TABLE
TO BEFORE DROP;
4.
FLASHBACK DATABASE TO TIMESTAMP ;
5.
SELECT * FROM
VERSIONS AS OF SCN 123456 AND 123999;
Which of these statements will be dependent on the availability of relevant undo data in the undo segment?
A. 1, 2, and 5 B. 1, 3, and 4 C. 2, 3, 4, and 5 D. 1, 2, 3, 4, and 5
A. 1, 2, and 5
Question 85:
Which four resources can directives be specified by using the Oracle Resource Manager?
A. CPU usage B. degree of parallelism C. number of open cursors D. number of sorts performed E. idle time for blocking sessions F. number of I/Os requests
A. CPU usage B. degree of parallelism E. idle time for blocking sessions F. number of I/Os requests
Question 86:
You execute the following command to set the redundancy retention policy in Recovery Manager (RMAN):
RMAN> CONFIGURE RETENTION POLICY TO REDUNDANCY 3;
Identify the statement that correctly describes the implications of this command.
A. when there are already three backups, for the fourth backup RMAN removes the oldest backup. B. When there are already three backups, for the fourth backup RMAN marks the oldest backup as obsolete. C. the number of backups that are retained is equal to three and it includes full, incremental, and cumulativebackups. D. when there are already three backup, one of the existing backups must be removed manually before takingthe fourth backup.
B. When there are already three backups, for the fourth backup RMAN marks the oldest backup as obsolete.
Question 87:
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.
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.
Question 88:
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. Mount the database B. Open the database in NORMAL mode C. Open the database in RESTRICTED mode D. Open the database with the RESETLOGS option
A. Mount the database
Question 89:
Tablespaces of certain types or in certain states can be renamed. Which four of these situations permit renaming a tablespace?
A. the SYSTEM tablespace B. the default permanent tablespace for the non-SYSTEM users C. an offline tablespace D. a temporary tablespace E. a read-only tablespace F. an undo tablespace
B. the default permanent tablespace for the non-SYSTEM users D. a temporary tablespace E. a read-only tablespace F. an undo tablespace
Question 90:
Which steps are mandatory to enable Direct NFS?
1.
Mount all required file systems using the kernel NFS driver.
2.
Create an oranfstab file containing the attributes for each NFS server to be accessed using Direct NFS.
3.
Replace the ODM library libodm11.so_stub with libodm11.so.
Nowadays, the certification exams become more and more important and required by more and more
enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare
for the exam in a short time with less efforts? How to get a ideal result and how to find the
most reliable resources? Here on Vcedump.com, you will find all the answers.
Vcedump.com provide not only Oracle exam questions,
answers and explanations but also complete assistance on your exam preparation and certification
application. If you are confused on your 1Z0-034 exam preparations
and Oracle certification application, do not hesitate to visit our
Vcedump.com to find your solutions here.