Online Access Free 1z1-034 Practice Test

You are using Recovery Manager (RMAN) for backup and recovery operations with a recovery catalog. You have been taken database backups every evening. On November 15, 2007, at 11:30 AM, you were informed that the USER_DATA tablespace was accidentally dropped. On investigation, you found that the tablespace existed until 11:00 AM, and important transactions were done after that.
So you decided to perform incomplete recovery until 11:00 AM. All the archive logs needed to perform recovery are intact. In NOMOUNT state you restored the control file that has information about the USER_DATA tablespace from the latest backup. Then you mounted
the database. Identify the next set of commands that are required to accomplish the task?

• A.Option D
• B.Option B
• C.Option A
• D.Option C

The DB_BLOCK_CHECKING parameter is set to FALSE. What level of block checking will be performed?

• A.The Oracle database will perform block checking for the data blocks in the SYSTEM and SYSAUX tablespaces.
• B.The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only.
• C.The Oracle database will perform block checking for the data blocks in all user tablespaces.
• D.The Oracle database will not perform block checking for any of the data blocks.
• E.The Oracle database will perform block checking for the default permanent tablespace only.

Which two statements are correct about database transportation? (Choose two.)

• A.The transported database must have the same database identifier (DBID) as the source database and cannot be changed
• B.The COMPATIBLE parameter must be set to 10.0.0.0 or higher and the database must be opened in readonly mode before being transported
• C.Redo logs, control files and temp files are also transported
• D.Recovery Manager (RMAN) is used to convert the necessary data files of the database if the target platform is different and has different endian format
• E.The source and target platforms must be the same

Which three statements are true about windows?

• A.Windows work with job classes to control resource allocation
• B.Only one window can be open at any given time
• C.Windows can automatically start job or change resource allocation among jobs for various time periods.
• D.Consumer groups are associated with windows
• E.The database service name must be provided during windows creation

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_16K_CACHE_SIZE=10M;
• D.ALTER SYSTEM SET DB_4K_CACHE_SIZE=10M;