The Secret Of Oracle 1Z0-053 Dumps Questions

It is more faster and easier to pass the Oracle 1Z0-053 exam by using 100% Guarantee Oracle Oracle Database 11g: Administration II questuins and answers. Immediate access to the Replace 1Z0-053 Exam and find the same core area 1Z0-053 questions with professionally verified answers, then PASS your exam with a high score now.

Oracle 1Z0-053 Free Dumps Questions Online, Read and Test Now.


How many different calendars does Oracle 11g support?

  • A. 22
  • B. 7
  • C. 6
  • D. 15
  • E. 2

Answer: B


Which commands are used for RMAN database recovery? (Choose all that apply.)

  • A. restore
  • B. repair
  • C. copy
  • D. recover
  • E. replace

Answer: AD


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


You plan to control the sessions performing a huge number of I/O operations. Your requirement is to kill the session when it exceeds a specified number of I/Os. Which statement describes a solution to the above?

  • A. Set a threshold for the default system-defined moving window baseline.
  • B. Add directives to the Automatic Database Diagnostic Monitor (ADDM).
  • C. Modify the profile for the targeted users for which control needs to be imposed.
  • D. Implement the database resource manager to add the SWITCH_IO_REQS and SWITCH_GROUP directives.

Answer: D


Given the following steps, which would be the correct order to create a backup of an Oracle database in ARCHIVELOG mode with control-file autobackups enabled?

  • A. backup archivelog all;
  • B. backup database all;
  • C. backup controlfile;
  • D. backup archivelog, database, controlfile delete input;
  • E. backup database plus archivelog delete input
  • F. e
  • G. a, b, a, c
  • H. d
  • I. b, a, c
  • J. b, a, c, d, e

Answer: A


Which two are the uses of the ASM metadata backup and restore (AMBR) feature? (Choose two.)

  • A. It can be used to back up all data on ASM disks.
  • B. It can be used to recover the damaged ASM disk group along with the data.
  • C. It can be used to gather information about a pre-existing ASM disk group with disk paths, disk name, failure groups, attributes, templates, and alias directory structure.
  • D. It can be used to re-create the ASM disk group with its attributes.

Answer: CD


What is the purpose of the RMAN recovery catalog? (Choose all that apply.)

  • A. Make backups faster
  • B. Store RMAN metadata
  • C. Store RMAN scripts
  • D. Provide the ability to do centralized backup reporting.
  • E. Make recovery faster

Answer: BCD

A recovery catalog is a database schema used by RMAN to store metadata about one or more Oracle databases. Typically, you store the catalog in a dedicated database. A recovery catalog provides the following benefits:
✑ A recovery catalog creates redundancy for the RMAN repository stored in the
control file of each target database. The recovery catalog serves as a secondary metadata repository. If the target control file and all backups are lost, then the RMAN metadata still exists in the recovery catalog.
✑ A recovery catalog centralizes metadata for all your target databases. Storing the
metadata in a single place makes reporting and administration tasks easier to perform.
✑ A recovery catalog can store metadata history much longer than the control file.
This capability is useful if you must do a recovery that goes further back in time than the history in the control file. The added complexity of managing a recovery catalog database can be offset by the convenience of having the extended backup history available.
Some RMAN features function only when you use a recovery catalog. For example, you can store RMAN scripts in a recovery catalog. The chief advantage of a stored script is that it is available to any RMAN client that can connect to the target database and recovery catalog. Command files are only available if the RMAN client has access to the file system on which they are stored.
A recovery catalog is required when you use RMAN in a Data Guard environment. By storing backup metadata for all primary and standby databases, the catalog enables you to offload backup tasks to one standby database while enabling you to restore backups on other databases in the environment.


Which statement is true regarding the retention policy for the incidents accumulated in the Automatic Diagnostic Repository (ADR)?

  • A. The incident metadata is purged when the problem is resolved and the DBA closes the SR.
  • B. The incident files and dumps are not retained in the ADR for the manually created incidents.
  • C. The incident files are retained but the incident metadata is purged when the problem is resolved and the DBA closes the SR
  • D. The default setting is for one year after which the incident metadata is purged from the ADR and the files are retained for one month.

Answer: D

1Z0-053 dumps exhibit


On the development database rac0, there are six raw devices: /dev/raw/raw1 through
/dev/raw/raw6. /dev/raw/raw1 and /dev/raw/raw2 are 8GB each, and the rest are 6GB each.
An existing disk group +DATA1, of NORMAL REDUNDANCY, uses /dev/raw/raw1 and
Which series of the following commands will drop one of the failure groups for +DATA1, create a new disk group +DATA2 using two of the remaining four raw devices, and then cancel the drop operation from +DATA1?
1Z0-053 dumps exhibit

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

Answer: A


Which of the following statements is true regarding the VERSIONS BETWEEN clause?

  • A. The VERSIONS BETWEEN clause may be used in DML statements.
  • B. The VERSIONS BETWEEN clause may be used in DDL statements.
  • C. The VERSIONS BETWEEN clause may not be used to query past DDL changes to tables.
  • D. The VERSIONS BETWEEN clause may not be used to query past DML statements to tables.

Answer: C


What command would you issue to enable automated backups of control files?

  • A. alter database controlfile autobackup on
  • B. alter system controlfile autobackup on
  • C. configure controlfile autobackup on
  • D. enable controlfile autobackup

Answer: C


Which command would you use to determine what database backups are currently available for restore?

  • A. list database backup;
  • B. report database backup;
  • C. list backup of database;
  • D. list summary backup;
  • E. report backup of database;

Answer: C


Which two statements are true about a duplicate database that is created by using the DUPLICATE command in RMAN? (Choose two.)

  • A. It is a copy or a subset of the target database.
  • B. It is opened in RESTRICT mode after a duplicating operation.
  • C. It is created by using backups and archived redo log files from the target database.
  • D. It is created with the same database identifier (DBID) as that of target database.

Answer: AC

Duplicating a Database
Overview of RMAN Database Duplication
Database duplication is the use of the DUPLICATE command to copy all or a subset of the data in a source database. The duplicate database (the copied database) functions entirely independently from the source database (the database being copied).
Purpose of Database Duplication
If you copy a database with operating system utilities instead of the DUPLICATE command, then the DBID of the copied database remains the same as the original database. To register the copy database in the same recovery catalog with the original, you must change the DBID with the DBNEWID utility (see Oracle Database Utilities). In contrast, the DUPLICATE command automatically assigns the duplicate database a different DBID so that it can be registered in the same recovery catalog as the source database.
Backup-Based Duplication
In backup-based duplication, RMAN creates the duplicate database by using pre-existing RMAN backups and copies. This technique of duplication uses one of the following mutually exclusive subtechniques: Duplication without a target database connection, RMAN obtains metadata about backups from a recovery catalog.
Duplication without a target database connection and without a recovery catalog. RMAN obtains metadata about where backups and copies reside from BACKUP LOCATION. Duplication with a target database connection. RMAN obtains metadata about backups
from the target database control file or from the recovery catalog. How RMAN Duplicates a Database
For backup-based duplication, the principal work of the duplication is performed by the auxiliary channels. These channels correspond to a server session on the auxiliary instance on the destination host. For active database duplication the primary work is performed by target channels. RMAN must perform database point-in-time recovery, even when no explicit point in time is provided for duplication. Point-in-time recovery is required because the online redo log files in the source database are not backed up and cannot be applied to the duplicate database. The farthest point of recovery of the duplicate database is the most recent redo log file archived by the source database.
As part of the duplicating operation, RMAN automates the following steps:
1. Creates a default server parameter file for the auxiliary instance if the following conditions are true:
✑ Duplication does not involve a standby database.
✑ Server parameter files are not being duplicated.
✑ The auxiliary instance was not started with a server parameter file.
2. Restores from backup or copies from active database the latest control file that satisfies the UNTIL clause requirements.
3. Mounts the restored or copied backup control file from the active database.
4. Uses the RMAN repository to select the backups for restoring the data files to the auxiliary instance. This step applies to backup-based duplication.
5. Restores and copies the duplicate data files and recovers them with incremental backups and archived redo log files to a noncurrent point in time.
6. Shuts down and restarts the database instance in NOMOUNT mode.
7. Creates a new control file, which then creates and stores the new DBID in the data files.
8. Opens the duplicate database with the RESETLOGS option and creates the online redo log for the new database.


You have enabled backup optimization in RMAN. You issue the following RMAN command to configure a redundancy-based retention policy:
Which statement is true?

  • A. The command fails because you cannot configure a redundancy-based retention policy when backup optimization is enabled
  • B. Backup optimization is performed, but RMAN considers the redundancy-based retention policy when it determines which datafiles should be backed up
  • C. Backup optimization is permanently disabled
  • D. Backup optimization is temporarily disabled because a redundancy-based retention policy is specified

Answer: B


Which are the prerequisites for performing flashback transactions on your database? (Choose all that apply.)

  • A. Undo retention guarantee for the database must be configured.
  • B. Supplemental log must be enabled for the primary key.
  • C. Supplemental log must be enabled.
  • D. Execute permission on the DBMS_FLASHBACK package must be granted to the user.

Answer: BCD


To control the execution of a server process when it is receiving bad packets from a potentially malicious client, you set the SEC_PROTOCOL_ERROR_FURTHER_ACTION initialization parameter as follows:
What is the significance of this setting?

  • A. It terminates the client connection after 10 bad packets and the client cannot reconnect to the same instance.
  • B. It terminates the client connection after 10 bad packets but the client can still reconnect, and attempt the same operation again.
  • C. It terminates the client connection 10 seconds after receiving a bad packet and the client cannot reconnect to the same instance.
  • D. It terminates the client connection after receiving a bad packet and the client can reconnect to the same instance after 10 minutes.

Answer: B


A user named Arren is executing this query:
select table_name, operation, undo_sql from
flashback_transaction_query t, (select versions_xid as xid
from employees versions between scn minvalue and maxvalue
where employee_id = 123) e where t.xid = e.xid;
When the query runs, he receives an ORA-01031: insufficient privileges error. Since the user owns the employees table, you know that it is not the problem.
Which of the following SQL statements will correct this problem?


Answer: A


View the Exhibit and examine the disk groups created at the time of migrating the database storage to Automatic Storage Management (ASM).
1Z0-053 dumps exhibit
Why does the FRA disk group initially have more free space even though both DATA and FRA disk groups are provided with the same size?

  • A. Because the FRA disk group will not support dynamic rebalancing
  • B. Because the FRA disk group is not configured to support mirroring
  • C. Because disks in the FRA disk group are not formatted at this stage
  • D. Because the FRA disk group will support only a single size of allocation unit

Answer: B


Which dynamic view displays the status of block-change tracking?


Answer: B

V$BLOCK_CHANGE_TRACKING displays the status of block change tracking for the database.


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


When you are performing a tablespace point-in-time recovery, which tablespaces will always be restored to the auxiliary instance? (Choose all that apply.)

  • A. The SYSTEM tablespace.
  • B. The UNDO tablespace.
  • C. All tablespaces with tables.
  • D. All tablespaces with indexes.
  • E. No tablespaces are automatically restored.

Answer: AB


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


You are an Oracle DBA responsible for an ASM instance. The disk controller on your system fails. You suspect that the disk itself is okay. You know it will take 24 hours to replace the controller and you don't want to have to rebuild the disks from scratch.
What do you do?

  • A. Take the whole disk group offline and wait for the controller card to be installe
  • B. Once it's installed, bring the disk group online again.
  • C. Change the ASM parameter ASM_PREFERRED_READ_FAILURE_GROUPS to indicate that you want to read from the non-failed dis
  • D. Once the disk controller is replaced, reset the parameter to its original value.
  • E. You have no choice but to rebuild the dis
  • F. Drop the disk from the disk group and wait for the controller to be replace
  • G. Once the controller is replaced, add the disk back into the disk group and allow ASM to rebuild it.
  • H. If you are using any setting other than REDUNDANCY EXTERNAL for your disk group, you will have to recover any data on that disk from a backu
  • I. The database will be unavailable until you can correct the problem and perform recovery.
  • J. Change the attribute DISK_REPAIR_TIME on the disk group to a time greater than 24 hours.

Answer: E


P.S. Easily pass 1Z0-053 Exam with 698 Q&As Certshared Dumps & pdf Version, Welcome to Download the Newest Certshared 1Z0-053 Dumps: (698 New Questions)