Updated Oracle Database 11g: Administration II 1Z0-053 Exam Question

Ucertify 1Z0-053 Questions are updated and all 1Z0-053 answers are verified by experts. Once you have completely prepared with our 1Z0-053 exam prep kits you will be ready for the real 1Z0-053 exam without a problem. We have Update Oracle 1Z0-053 dumps study guide. PASSED 1Z0-053 First attempt! Here What I Did.

Free 1Z0-053 Demo Online For Oracle Certifitcation:

Page: 1 / 58
Total 698 questions Full Exam Access
Question 1
- (Topic 17)
You upgraded Oracle Database 10g to Oracle Database 11g. How would this affect the existing users' passwords?
My answer: -
Reference answer: B
Reference analysis:

None

Question 2
- (Topic 14)
Examine the exhibit to view the parameters set in your parameter file. You restart the instance.
To what value will the MEMORY_MAX_TARGET parameter be set by default? Exhibit:
1Z0-053 dumps exhibit
My answer: -
Reference answer: D
Reference analysis:

None

Question 3
- (Topic 6)
What methods are available to recover lost control files? (Choose all that apply.)
My answer: -
Reference answer: AC
Reference analysis:

None

Question 4
- (Topic 7)
When performing a full database disaster recovery with RMAN, in what order would you execute these steps?
My answer: -
Reference answer: E
Reference analysis:

None

Question 5
- (Topic 3)
What is the purpose of the RMAN recovery catalog? (Choose all that apply.)
My answer: -
Reference answer: BCD
Reference analysis:

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.

Question 6
- (Topic 15)
What two statements are true regarding the recommendations received from the SQL Access Advisor? (Choose two.)
My answer: -
Reference answer: BC
Reference analysis:

None

Question 7
- (Topic 6)
Your database has experienced a loss of datafile users_01.dbf, which is associated with a tablespace called USERS. The database is still running.
Which answer properly describes the order of the steps that you would use to recover from this error?
1. Shut down the database.
2. Take the users_01.dbf datafile offline with the alter database command.
3. Restore the users_01.dbf datafile from backup media with the required archived redo logs.
4. Restore all users tablespace-related datafiles from backup media.
5. Issue the recover tablespace users command.
6. Issue the recover datafile users_01.dbf command.
7. Start up the database.
8. Bring the users_01.dbf datafile online with the alter database command.
My answer: -
Reference answer: B
Reference analysis:

None

Question 8
- (Topic 5)
Your database is running in ARCHIVELOG mode, and the database is open. You execute an RMAN backup and specify the KEEP clause.
Which components are backed up when this option is specified?
My answer: -
Reference answer: D
Reference analysis:

None

Question 9
- (Topic 2)
The CONTROL_FILE_RECORD_KEEP_TIME initialization parameter should be set to what value? (Choose all that apply.)
My answer: -
Reference answer: CE
Reference analysis:

CONTROL_FILE_RECORD_KEEP_TIME specifies the minimum number of days before a reusable record in the control file can be reused. In the event a new record needs to be added to a reusable section and the oldest record has not aged enough, the record section expands. If this parameter is set to 0, then reusable sections never expand, and records are reused as needed.
If the number of reusable records in the control file exceeds the circular reuse record limit UB4MAXVAL, then reusable records will be overwritten even if CONTROL_FILE_RECORD_KEEP_TIME has not elapsed.
UB4MAXVAL is defined in the oratypes.h header file, which is found in the public directory. Its value may vary according to the operating system you are using.

Question 10
- (Topic 7)
Which of the following are valid until command options when attempting point-in-time recovery in RMAN? (Choose all that apply.)
My answer: -
Reference answer: ACD
Reference analysis:

None

Question 11
- (Topic 17)
The Database Resource Manager is automatically enabled in the maintenance window that runs the Automated Maintenance Task. What is the reason for this?
My answer: -
Reference answer: D
Reference analysis:

Oracle Database Resource Manager (the Resource Manager) is an infrastructure that provides granular control of database resources allocated to users, applications, and services. The Resource Manager solves many resource allocation problems that an operating system does not manage well, including:
✑ Excessive overhead
✑ Inefficient scheduling
✑ Inappropriate allocation of resources
✑ Inability to manage database-specific resources
The Resource Manager helps overcome these problems by giving the database more control over allocation of hardware resources and enabling you to prioritize work within the database. You can classify sessions into groups based on session attributes, and then allocate resources to these groups to optimize hardware utilization.

Question 12
- (Topic 6)
Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which contains one redo member.
When you attempt to start the database, you receive the following errors: ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: 'D:REDO01.LOG'
You discover that the online redo log file of the current redo group is corrupted. Which statement should you use to resolve this issue?
My answer: -
Reference answer: C
Reference analysis:

None

Question 13
- (Topic 5)
Which of the following statements are true about the BACKUP command? (Choose all that apply.)
My answer: -
Reference answer: BC
Reference analysis:

None

Question 14
- (Topic 4)
What feature comes into play to help ensure the completion of the backup should one of three backup devices fail during a backup that is using three different channels?
My answer: -
Reference answer: A
Reference analysis:

None

Question 15
- (Topic 5)
Using the LIST command in Recovery Manager (RMAN), which two pieces of information in the RMAN repository can be listed? (Choose two.)
My answer: -
Reference answer: AD
Reference analysis:

About the LIST command
The primary purpose of the LIST command is to list backup and copies. For example, you can list:
✑ Backups and proxy copies of a database, tablespace, data file, archived redo log, or control file
✑ Backups that have expired
✑ Backups restricted by time, path name, device type, tag, or recoverability
✑ Archived redo log files and disk copies
Besides backups and copies, RMAN can list other types of data. For example, you can list:
✑ Backup sets and proxy copies
✑ Image copies
✑ Archived redo log files
✑ Database incarnations
✑ Databases in a Data Guard environment
✑ Backups and copies for a primary or standby database in a Data Guard environment
✑ Restore points
✑ Names of stored scripts
✑ Failures for use with Data Recovery Advisor

Question 16
- (Topic 17)
You plan to control idle sessions that are blocking other sessions from performing transactions. Your requirement is to automatically terminate these blocking sessions when they remain idle for a specified amount of time.
How would you accomplish this task?
My answer: -
Reference answer: B
Reference analysis:

None

Question 17
- (Topic 13)
Which of the following initialization parameters have been deprecated in Oracle 11g because of the introduction of the Automatic Workload Repository? (Choose all that apply.)
My answer: -
Reference answer: ACD
Reference analysis:

None

Question 18
- (Topic 9)
True or false: tablespace point-in-time recovery is possible only with RMAN.
My answer: -
Reference answer: B
Reference analysis:

None

Question 19
- (Topic 15)
Your company wants to upgrade the production database to a Real Application Clusters (RAC) environment.
You set up the best RAC database and want to replay a recorded workload captured from the production database on the test machine.
The following steps may be used to replay the database workload:
1) Preprocess the captured workload
2) Restart the database in RESTRICTED mode.
3) Set up Replay Clients.
4) Restore the test database to the point when the capture started.
5) Remap connections.
Which is the correct sequence of the required steps?
My answer: -
Reference answer: B
Reference analysis:

11.1 Steps for Replaying a Database Workload
Proper planning of the workload replay and preparation of the replay system ensures that the replay will be accurate. Before replaying a database workload, review and complete the
following steps as appropriate:
✑ Setting Up the Replay Directory
✑ Restoring the Database
✑ Resolving References to External Systems
✑ Remapping Connections
✑ User Remapping
✑ Specifying Replay Options
✑ Using Filters with Workload Replay
✑ Setting Up Replay Clients

Question 20
- (Topic 15)
You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process, you execute the following script:
SQL> @utlu111i.sql
Which statement about the execution of this script is true?
My answer: -
Reference answer: C
Reference analysis:

Script Name: utlu111i.SQL
Used to: Pre-Upgrade Information
Analyzes the database to be upgraded, detailing requirements and issues for the upgrade to Oracle Database 11g Release 1 (11.1)

Question 21
- (Topic 20)
Which of the following is not a valid linguistic sort element?
My answer: -
Reference answer: A
Reference analysis:

None

Question 22
- (Topic 11)
You executed the following commands in a database session:
1Z0-053 dumps exhibit
What could have caused the recycle bin to clean up?
My answer: -
Reference answer: A
Reference analysis:

None

Question 23
- (Topic 20)
Given two different character sets (A and B), which of the following must be true for A to be considered a strict superset of B? (Choose all that apply.)
My answer: -
Reference answer: AC
Reference analysis:

None

Question 24
- (Topic 12)
You need to maintain a record of all transactions on some tables for at least three years. Automatic undo management is enabled for the database.
What must you do accomplish this task?
My answer: -
Reference answer: D
Reference analysis:

None

Question 25
- (Topic 6)
Another DBA issues a shutdown abort command on a database on which you were running an online backup.
What will happen when you try to restart the database?
My answer: -
Reference answer: C
Reference analysis:

None

Page: 1 / 58
Total 698 questions Full Exam Access