1z0-034 試験問題を無料オンラインアクセス

Your database is in NOARCHIVELOG mode.
One of the two data files belonging to the SYSTEM tablespace is corrupt.
You discover that all online redo logs have been overwritten since the last backup.
Which method would you use to recover the data file using RMAN?

• A.Shut down the instance if not already shut down, restart In NOMOUNT state, restore all data files for the entire database from the last backup, and restart the instance.
• B.Shut down the instance if not already shut down, restart in MOUNT state, restore both data files belonging to the SYSTEM tablespace from the last backup, and restart the instance.
• C.Shut down the instance if not already shut down, restart in mount state, restore the corrupted data file belonging to the system tablespace from the last backup, and restart the instance.
• D.Shut down the instance if not already shut down, restart In MOUNT state, restore all data files belonging to the SYSTEM tablespace from the last backup, and restart the instance.
• E.Shut down the instance if not already shut down, restart in mount state, restore all data files for the entire database from the last backup, and restart the instance.

The DB_BLOCK_CHECKING parameter is set to FULL.
What checks occur each time the DBWnprocess(es) writes?

• A.The DBWn and the direct loader will calculate a checksum and store it in the cache header of every data block when writing it to disk.
• B.The Oracle database will check data blocks in the SYSTEM and SYSAUX tablespaces only, by going through the data on each block, making sure the data is self-consistent.
• C.The Oracle database will check data blocks belonging to the SYSAUX tablespace only, by going through the data on each block, making sure the data is self-consistent.
• D.The Oracle database will check all data blocks by going through the data on each block, making sure the data is self-consistent.
• E.The Oracle database will check data blocks belonging to the SYSTEM tablespace only, by going through the data on each block, making sure the data is self-consistent.

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

• A.ALTER SYSTEM SET DB_8K_CACHE_SIZE=10M;
• B.ALTER SYSTEM SET DB_4K_CACHE_SIZE=10M;
• C.ALTER SYSTEM SET DB_CACHE_SIZE=50M;
• D.ALTER SYSTEM SET DB_16K_CACHE_SIZE=10M;

Given below is a list of scenarios:
1) A user terminates his session abnormally.
2) The connection between the server and the client application terminates because of a
network failure.
3) A schema is accidentally dropped.
4) The tablespace is accidentally dropped from the database.
5) The hard disk gets corrupted and the data files in the disk are lost.
6) The database instance abnormally shuts down because of power failure.
Which scenarios require DBA intervention to perform recovery?

• A.3, 4, and 5
• B.4, 5, and 6
• C.1, 2, and 6
• D.1, 3, and 6

You want to create a consumer group, GROUP1, and you execute the following command
in the command-line interface: SQL> EXEC DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP (CONSUMER_GROUP
=>'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.create the Pending Area before creating the consumer group
• B.increase the size of the large pool to accommodate the Pending Area
• C.increase the size of the shared pool to accommodate the Pending Area
• D.increase the size of the database buffer cache to accommodate the Pending Area
• E.activate the Pending Area before creating the consumer group