Most Recent 1Z0-053 Practice Test For Oracle Database 11g: Administration II Certification

NEW QUESTION 1

Which two initialization parameters would you set to enable Automatic Shared Memory Management? (Choose two.)

• A. set SHARED_POOL_SIZE to zero
• B. set STATISTICS_LEVEL to BASIC
• C. set SGA_TARGET to a non-zero value
• D. set DB_CACHE_SIZE to a non-zero value
• E. set STATISTICS_LEVEL to TYPICAL or ALL

Answer: AC

NEW QUESTION 2

If you issue the command shutdown abort prior to trying to put the database in ARCHIVELOG mode, what will be the result when you issue the command alter database archivelog?

• A. The alter database archivelog command will fail.
• B. The alter database archivelog inconsistent command must be used to put the database in ARCHIVELOG mode.
• C. The alter database archivelog command will succeed.
• D. The alter database archivelog command will ask if you want to make the database consistent first.
• E. There is no alter database archivelog comman
• F. The correct command is alter database alterlogging.

Answer: A

Explanation:
Before you change database to archivelog mode, you need to have a clean database shutdown.

NEW QUESTION 3

You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the user RCO11. The INST1 database contains an Oracle Database version 10.1 catalog schema owned by the user RCAT10.
You want the RMAN to import metadata for database IDs 1423241 and 1423242, registered in RCAT10, into the recovery catalog owned by RCO11.
You executed the following RMAN commands:
RMAN> CONNECT CATALOG rco11/password@catdb RMAN> IMPORT CATALOG rcat10/oracle@inst1;
What happens when you execute the above commands? (Choose all that apply.)

• A. They deregister all databases registered in the RCAT10 catalog.
• B. They import metadata for all registered databases in the RCAT10 database.
• C. They register all the RCAT10-catalog registered databases in the RCO11 catalog.
• D. They overwrite all stored scripts in the RCO11 catalog with the same name as that in the RCAT10 catalog.

Answer: ABC

NEW QUESTION 4

What are the advantages of variable extent size support for large ASM files? (Choose two.)

• A. It improves resync operations when the disk comes online after being taken offline for maintenance purposes.
• B. It improves performance in the extended cluster configuration by reading from a local copy of an extent.
• C. Fewer extent pointers are needed to describe the file and less memory is required to manage the extent maps in the shared pool.
• D. This feature enables faster file opens because of the reduction in the amount of memory that is required to store file extents.

Answer: CD

NEW QUESTION 5

You execute the following RMAN command to perform the backup operation:
RMAN> RUN
{
ALLOCATE CHANNEL c1 DEVICE TYPE disk MAXOPENFILES 8; BACKUP DATABASE FILESPERSET 4;
}
What is the multiplexing level in the preceding backup process?

• A. 4
• B. 8
• C. 7

Answer: A

NEW QUESTION 6

A database instance is using an Automatic Storage Management (ASM) instance, which has a disk group, DGROUP1, created as follows:
SQL> CREATE DISKGROUP dgroup1 NORMAL REDUNDANCY
FAILGROUP controller1 DISK '/devices/diska1', '/devices/diska2' FAILGROUP controller2 DISK '/devices/diskb1', '/devices/diskb2';
What happens when the whole CONTROLLER1 Failure group is damaged?

• A. The transactions that use the disk group will halt.
• B. The mirroring of allocation units occurs within the CONTROLLER2 failure group.
• C. The data in the CONTROLLER1 failure group is shifted to the CONTROLLER2 failure group and implicit rebalancing is triggered.
• D. The ASM does not mirror any data and newly allocated primary allocation units (AU) are stored in the CONTROLLER2 failure group.

Answer: C

NEW QUESTION 7

What Oracle process runs when the database is in ARCHIVELOG mode but not when it is in NOARCHIVELOG mode?

• A. MMON
• B. LGWR
• C. ARCH
• D. ARWR
• E. COPY

Answer: C

NEW QUESTION 8

Which of the following options describes Segment Shrink?

• A. Reclaims space above and below the high-water mark without using additional space
• B. Moves rows to a new physical location, resetting the high-water mark, but uses additional space during the operation
• C. Deallocates space above the high-water mark that is currently not in use
• D. None of the above

Answer: A

NEW QUESTION 9

Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query:
SQL> SELECT * FROM sales;
Which process would retrieve the result from the database and return it to the client program?

• A. User process
• B. Server process
• C. System Monitor (SMON)
• D. Process Monitor (PMON)
• E. Checkpoint process (CKPT)

Answer: B

NEW QUESTION 10

What are the two different types of database duplication? (Choose two.)

• A. Active
• B. Passive
• C. Online
• D. Backup-based
• E. Failure driven

Answer: AD

NEW QUESTION 11

What is the impact of the results of the output of the following command?
RMAN> report unrecoverable database;
Report of files that need backup due to unrecoverable operations File Type of Backup Required Name
---- ----------------------- -----------------------------------
4 full or incremental C:\ORACLE\ORADATA\ORCL\USERS01.DBF

• A. There are no backup sets with any backups of the users01.dbf datafile.
• B. The users01.dbf datafile has had unrecoverable operations occur in i
• C. It will need to be backed up or some data loss is possible during a recovery.
• D. The users01.dbf datafile is corrupted.
• E. The users01.dbf datafile backup exceeds the retention criteria.
• F. The last backup of the users01.dbf datafile failed and must be rerun.

Answer: D

NEW QUESTION 12

Which of the following restrictions are NOT true with respect to tablespace point-in-time recovery? (Choose all that apply.)

• A. The target database must be in NOARCHIVELOG mode.
• B. No backup is required of the database before you perform a TSPITR.
• C. You must have all archived redo logs generated since the last backup up to the point to which you want to restore the transport set.
• D. If you rename a tablespace, you can not perform a TSPITR to any point in time before that rename operation occurred.
• E. If you have tables in tablespace_1 that have associated constraints in tablespace_2, then you must transport both tablespaces.

Answer: AB

NEW QUESTION 13

Which three actions are required to configure the Flashback Database? (Choose three.)

• A. set Flash Recovery Area
• B. enable Flashback logging
• C. create FLASHBACK tablespace
• D. start the database in the ARCHIVELOG mode
• E. start the database in the NOARCHIVELOG mode

Answer: ABD

NEW QUESTION 14

How would you grant the RVPC user access to specific RMAN database records in the
RMAN virtual private catalog?

• A. Issue the grant command from the SYS user (or equivalent) of the target database.
• B. Issue the grant command from the SYS user (or equivalent) of the recovery-catalog database.
• C. Issue the grant command from the recovery catalog-owning schema user account in the recovery catalog.
• D. Issue the grant command from RMAN when connected to the recovery catalog-owning schema.
• E. Issue the grant command from RMAN when connected to the target database.

Answer: D

NEW QUESTION 15

What can you determine about the following linguistic sorts based only on their names?
1. GERMAN
2. FRENCH_M

• A. 1 is a monolingual sort.
• B. 2 is a monolingual sort.
• C. 1 is case insensitive.
• D. Both 1 and 2 are case insensitive.
• E. Case sensitivity is unknown.

Answer: A

NEW QUESTION 16

Given the following RMAN commands, choose the option that reflects the order required to restore your currently operational ARCHIVELOG mode database.
a: restore database; b: recover database;
c: shutdown immediate d: startup
e: restore archivelog all; f: alter database open

• A. a, b, c, d, e, f
• B. c, b, a, d, e, f
• C. c, b, a, d, f
• D. c, a, b, d
• E. c, a, e, b, d, f

Answer: C

NEW QUESTION 17

USER_DATA is a nonencrypted tablespace that contains a set of tables with data. You want to convert all existing data in the USER_DATA tablespace and the new data into the
encrypted format. Which methods would you use to achieve this? (Choose all that apply.)

• A. Use Data Pump to transfer the existing data to a new encrypted tablespace.
• B. Use ALTER TABLE MOVE to transfer the existing data to a new encrypted tablespace.
• C. Use CREATE TABLE AS SELECT to transfer the existing data to a new encrypted tablespace.
• D. Enable row movement for each table to be encrypted and then use ALTER TABLESPACE to encrypt the tablespace.
• E. Encrypt the USER_DATA tablespace using the ALTER TABLESPACE statement so that all the data in the tablespace is automatically encrypted.

Answer: ABC

NEW QUESTION 18

You enable block change tracking. You issue the following command: BACKUP INCREMENTAL LEVEL 0 DATABASE;
The next day, you issue the following command:
BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;
Which statement about the use of the change tracking file is true?

• A. RMAN reads the block change tracking file only when it performs the incremental level 0 backup.
• B. RMAN reads the block change tracking file when it performs both incremental backups.
• C. RMAN reads the block change tracking file only when it performs the incremental level 1 backup.
• D. RMAN does not read the block change tracking file when it performs either incremental backup.

Answer: C

NEW QUESTION 19

For which of the following can you use Segment Shrink? (Choose all that apply.)

• A. Heap tables
• B. Tables with function-based indexes
• C. Indexes
• D. Partitions and subpartitions
• E. None of the above

Answer: ACD

NEW QUESTION 20

You upgraded Oracle Database 10g to Oracle Database 11g. How would this affect the existing users' passwords?

• A. All passwords automatically become case-sensitive.
• B. All passwords remain non-case-sensitive till they are changed.
• C. All passwords remain non-case-sensitive and cannot be changed.
• D. All passwords remain non-case-sensitive until their password attribute in the profile is altered.

Answer: B

NEW QUESTION 21

What is the result of increasing the value of the parameter ASM_POWER_LIMIT during a rebalance operation?

• A. The ASM rebalance operation will likely consume fewer resources and complete in a shorter amount of time.
• B. The ASM rebalance operation will consume fewer resources and complete in a longer amount of time.
• C. The ASM rebalance operation will be parallelized and should complete in a shorter amount of time.
• D. There is no ASM_POWER_LIMIT setting used in ASM.
• E. None of the above

Answer: C

NEW QUESTION 22

Which of the following is not a valid linguistic sort element?

• A. Accent expansion
• B. Canonical equivalence
• C. Reverse secondary sorting
• D. Ignorable characters
• E. Character rearrangement

Answer: A

NEW QUESTION 23

Your system has been upgraded from Oracle Database 10g to Oracle Database 11g. You imported SQL Tuning Sets (STS) from the previous version. After changing the OPTIMIZER_FEATURES_ENABLE parameter to 10.2.0.4 and running the SQL Performance Analyzer, you observed performance regression for a few SQL statements. What would you do with these SQL statements?

• A. Set OPTIMIZER_USE_PLAN_BASELINES to FALSE to prevent the use of regressedplans.
• B. Capture the plans from the previous version using STS and then load them into the stored outline.
• C. Capture the plans from the previous version using STS and then load them into SQL Management Base (SMB).
• D. Set OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to FALSE to prevent the plans from being loaded to the SQL plan baseline.

Answer: C

Explanation:
The SQL management base (SMB) is a part of the data dictionary that resides in the SYSAUX tablespace. It stores statement logs, plan histories, SQL plan baselines, and SQL profiles.
Parameters Relating to Stored Outline Migration:
✑ OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES, Enables or disables the automatic recognition of repeatable SQL statement and the generation of SQL plan baselines for these statements.
✑ OPTIMIZER_USE_SQL_PLAN_BASELINES, Enables or disables the use of SQL
plan baselines stored in SQL Management Base.

NEW QUESTION 24
......