All About Realistic 1Z0-053 Preparation

NEW QUESTION 1

When executing a SQL workload, you choose to generate execution plans only, without collecting execution statistics.
Which two statements describe the implications of this? (Choose two.)

• A. It produces less accurate results of the comparison analysis.
• B. It automatically calls the SQL Tuning Advisor for recommendations.
• C. It shortens the time of execution and reduces the impact on system resources.
• D. Only the changes in the execution plan, and not performance regression, are detected.

Answer: AC

NEW QUESTION 2

If you are going to run a TSPITR recovery, which view will help you to determine which objects will be lost during the TSPITR?

• A. TS_OBJECTS_TO_BE_DROPPED
• B. TS_PTTR_OBJECT_DROPPED
• C. TS_PITR_OBJECTS_TO_BE_DROPPED
• D. TS_OBJECTS_DROPPED
• E. TS_DROPPED_OBJECTS

Answer: C

NEW QUESTION 3

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 4

You perform a backup using the following BACKUP command: RMAN> BACKUP AS COMPRESSED BACKUPSET DATABASE;
Which statement is true of this command?

• A. A different procedure is required to restore a database from compressed backups
• B. The AS COMPRESSED clause of the BACKUP command provided by RMAN is used to create compressed backup sets and image copies.
• C. Using this command to create backups minimizes the bandwidth consumed
• D. Using this command to create backups improves the performance of the backup process

Answer: C

NEW QUESTION 5

Your database is in NOARCHIVELOG mode. You start to do a backup, but your users complain that they don't want you to shut down the database to perform the backup. What options are available to you?

• A. Put the database in hot backup mode and perform an online backup, including backing up the archived redo logs.
• B. Just back up the database datafiles without shutting down the database.
• C. You will have to wait until you can shut down the database to perform the backup.
• D. Mark each datafile as backup in progress, back them up individually, and then mark them as backup not in progres
• E. No archived redo logs will need to be backed up.
• F. Only back up the datafiles that the user will not be touchin
• G. Once the user has finished what they were doing, you can shut down the database and back up the datafiles the user changed during the course of the remaining backup

Answer: C

NEW QUESTION 6

You executed the following command:
RMAN> RECOVER COPY OF DATAFILE '/u01/app/oracle/oradata/orcl/users01.dbf'; Which statement regarding the above command is correct?

• A. The '/u01/app/oracle/oradata/orcl/users01.dbf' data file is recovered from the image copy.
• B. The '/u01/app/oracle/oradata/orcl/users01.dbf' data file is recovered from the last incremental backup.
• C. Image copies of the '/u01/app/oracle/oradata/orcl/users01.dbf' data file are updated with all changes up to incremental backup SCN.
• D. Image copies of the '/u01/app/oracle/oradata/orcl/users01.dbf' data file are recovered using the above command if data file recovery fails.

Answer: C

NEW QUESTION 7

Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)

• A. The ADR base keeps all diagnostic information in binary format
• B. SQL*Plus provides the ADRI script, which can be used to work with ADR
• C. The ADR can be used for problem diagnosis only when the database is open
• D. The ADR can be disabled by settting the DIAGNOSTIC_DEST parameter to null
• E. The ADR can be used for problem diagnosis even when the database instance is down
• F. The ADR base is shared across multiple instances

Answer: EF

NEW QUESTION 8

When an ASM instance receives a SHUTDOWN NORMAL command, what command does it pass on to all database instances that rely on the ASM instances disk groups?

• A. TRANSACTIONAL
• B. IMMEDIATE
• C. ABORT
• D. NORMAL

Answer: A

NEW QUESTION 9

What does the minimize load database parameter mean when backing up a database?

• A. RMAN will attempt to make the backup run as fast as possible without any IO limitations.
• B. RMAN will automatically restrict the number of channels in use to one.
• C. RMAN will spread the backup IO over the total duration stated in the backup command.
• D. RMAN will skip any datafile that currently is involved in an IO operatio
• E. RMAN will retry backing up the datafile later and an error will be raised at the end of the backup if the datafile cannot be backed up.
• F. Datafiles will be backed up; those having the lowest current number of IO operations will be backed up first.

Answer: C

NEW QUESTION 10

You are tuning RMAN to optimize performance. You want tape I/O to be asynchronous when you perform tape backups.
Which action should you take?

• A. Set the BACKUP_TAPE_IO_SLAVES parameter to FALSE.
• B. Set the BACKUP_TAPE_IO_SLAVES parameter to TRUE.
• C. Use compression when performing tape backups.
• D. Configure multiple SBT channels.

Answer: B

NEW QUESTION 11

You want to track and store all transactional changes to a table over its lifetime.
To accomplish this task, you enabled Flashback Data Archive with the retention of 5 years. After some time, the business requirement changed and you were asked to change the
retention from 5 years to 3 years.
To accomplish this, you issued the following command:
ALTER FLASHBACK ARCHIVE fla1 MODIFY RETENTION 3 YEAR;
What is the implication of this command?

• A. The command produces an error because the retention time cannot be reduced.
• B. All historical data is retained but the subsequent flashback data archives are maintained for only three years.
• C. All historical data is purged and the new flashback data archives are maintained for three years.
• D. All historical data older than three years is purged from the flashback archive FLA1.

Answer: D

NEW QUESTION 12

Which statement is true for enabling Enterprise Manager Support Workbench in Oracle Database 11g to upload the physical files generated by Incident Packaging Service (IPS) to MetaLink?

• A. The database must be running in ARCHIVELOG mode.
• B. No special setup is required, and the feature is enabled by default.
• C. The path for the Automatic Diagnostic Repository (ADR) must be configured with the DIAGNOSTIC_DEST initialization parameter.
• D. The Enterprise Manager Support Workbench can be enabled only if the background process manageability monitor (MMON) is configured.
• E. Select the Enable option in the Oracle Configuration Manager Registration window during the installation of the Oracle Database 11g software, provide valid MetaLink credentials and select license agreement.

Answer: E

NEW QUESTION 13

What are the recommendations for Oracle Database 11g installation to make it Optimal Flexible Architecture (OFA)-compliant? (Choose all that apply.)

• A. ORACLE_BASE should be set explicitly.
• B. An Oracle base should have only one Oracle home created in it.
• C. Flash recovery area and data file location should be on separate disks.
• D. Flash recovery area and data file location should be created under Oracle base in a non-Automatic Storage Management (ASM) setup.

Answer: ACD

NEW QUESTION 14

What command would you use to set a persistent setting in RMAN so that backups are all written to a tape device?

• A. CONFIGURE DEFAULT DEVICE TYPE TO TAPE MEDIA
• B. CONFIGURE DEFAULT DEVICE TYPE TO TAPE
• C. CONFIGURE DEFAULT DEVICE TYPE TO SBT
• D. CONFIGURE DEFAULT DEVICE TYPE TO SBT_TAPE

Answer: C

Explanation:
SBT_TAPE is incorrect, it should be SBT TAPE, without underline strike.

NEW QUESTION 15

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.

• A. 2 and 3
• B. 1 and 3
• C. 1 and 2
• D. 1, 2 and 3

Answer: B

NEW QUESTION 16

The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. One of the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file:
ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3;
Which action should you perform immediately after using this command?

• A. You should perform a log switch
• B. You should make a backup of the database
• C. You should switch the database to the NOARCHIVELOG mode
• D. You should shut down the database instance and perform a complete database recovery

Answer: B

NEW QUESTION 17

You backed up the database at 8 a.m. today using an online backup. Accounting made a large change to the underlying data between 10 a.m. and noon.
Which of the following actions would ensure that the changes could be recovered using the 8 a.m. backup?

• A. Create a manual incremental online database backup.
• B. Back up all the archived redo logs generated since the 8 a.
• C. backup.
• D. Create a brand-new backup after all the changes have been applied.
• E. There is no way to make the changes recoverable based on the 8 a.
• F. backup.
• G. Perform an online backup of the tablespace(s) that contained changed data.

Answer: B

NEW QUESTION 18

You want to disable resumable space allocation for all sessions. Which value should be assigned to the RESUMABLE_TIMEOUT parameter to disable resumable space allocation for all sessions?

• A. 10
• B. 100
• C. NULL

Answer: A

NEW QUESTION 19

Given a complete loss of your database, in what order would you need to perform the following RMAN operations to restore it?

• A. restore controlfile
• B. restore database
• C. restore spfile
• D. recover database
• E. alter database open
• F. alter database open resetlogs
• G. b, a, c, d, e
• H. a, c, b, d, f
• I. c, a, b, d, e
• J. c, a, b, d, f
• K. e, a, b, d, c

Answer: D

NEW QUESTION 20

Which statement is true about a running session that belongs to the online transaction processing (OLTP) group?

• A. It permanently switches to the low_group consumer group if the session exceeds 10,000 I/O requests or 2,500 MB of data transfer.
• B. It performs the first 10000 I/O requests or 2,500 MB of data transfer in the LOW-GROUP consumer group, and then switches to the original group.
• C. It switches to the LOW_GROUP consumer group if the session exceeds 10000 I/O requests or 2500 MB of data transfer and returns to the original group after the operation.
• D. It switches to the LOW_GROUP consumer group if the session exceeds 10000 I/O requests or 2500 MB of data transfer for queries, but not for data manipulation language (DML) operations.

Answer: C

Explanation:
Refer to here.
Example 2
The following PL/SQL block creates a resource plan directive for the OLTP group that temporarily switches any session in that group to the LOW_GROUP consumer group if the session exceeds 10,000 I/O requests or exceeds 2,500 Megabytes of data transferred. The session is returned to its original group after the offending top call is complete.

C:\Users\albo\Desktop\1-1.jpg

NEW QUESTION 21

Which is not a valid locale definition file type?

• A. Language
• B. Linguistic sort
• C. Calendar
• D. Territory
• E. Character set

Answer: C

NEW QUESTION 22

Immediately after adding a new disk to or removing an existing disk from an ASM instance, you find that the performance of the database goes down initially until the time the addition or removal process is completed, and then gradually becomes normal.
Which two activities would you perform to maintain a consistent performance of the database while adding or removing disks? (Choose two.)

• A. Define the POWER option while adding or removing the disks.
• B. Increase the number of ARB processes by setting up a higher value for ASM_POWER_LIMIT.
• C. Increase the number of DBWR processes by setting up a higher value for DB_WRITER_PROCESSES.
• D. Increase the number of slave database writer processes by setting up a higher value for DBWR_IO_SLAVES.

Answer: AB

Explanation:
ARBn (ASM Rebalance Process): Rebalances data extents within an ASM disk group, possible processes are ARB0-ARB9 and ARBA.
ALTER DISKGROUP..POWER clause, specify a value from 0 to 11, where 0 stops the rebalance operation and 11 permits Oracle ASM to execute the rebalance as fast as possible. The value you specify in the POWER clause defaults to the value of the ASM_POWER_LIMIT initialization parameter. If you omit the POWER clause, then Oracle ASM executes both automatic and specified rebalance operations at the power determined by the value of the ASM_POWER_LIMIT initialization parameter.
Note:
Beginning with Oracle Database 11g Release 2 (11.2.0.2), if the COMPATIBLE.ASM disk group attribute is set to 11.2.0.2 or higher, then you can specify a value from 0 to 1024 in the POWER clause.

NEW QUESTION 23

You issued the following command to mount the DATA disk group in restricted mode: ALTER DISKGROUP data MOUNT RESTRICT;
What is the implication of this command?

• A. The client RDBMS instance can access the file as a read-only file.
• B. A new disk cannot be added to a disk group.
• C. A disk in a disk group can be taken offline.
• D. The client RDBMS instance cannot access the files in the disk group.

Answer: D

Explanation:
MOUNT (link)
Specify MOUNT to mount the disk groups in the local Oracle ASM instance. Specify ALL MOUNT to mount all disk groups specified in the ASM_DISKGROUPS initialization parameter. File operations can only be performed when a disk group is mounted. If Oracle ASM is running in a cluster or a standalone server managed by Oracle Restart, then the MOUNT clause automatically brings the corresponding resource online.
RESTRICTED | NORMAL Use these clauses to determine the manner in which the disk groups are mounted.
In the RESTRICTED mode, the disk group is mounted in single-instance exclusive mode. No other Oracle ASM instance in the same cluster can mount that disk group. In this mode the disk group is not usable by any Oracle ASM client.
In the NORMAL mode, the disk group is mounted in shared mode, so that other Oracle ASM instances and clients can access the disk group. This is the default.

NEW QUESTION 24
......