11 September, 2021
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:
Question 1
- (Topic 17)
You upgraded Oracle Database 10g to Oracle Database 11g. How would this affect the existing users' passwords?
You upgraded Oracle Database 10g to Oracle Database 11g. How would this affect the existing users' passwords?
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:
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:
Question 3
- (Topic 6)
What methods are available to recover lost control files? (Choose all that apply.)
What methods are available to recover lost control files? (Choose all that apply.)
Question 4
- (Topic 7)
When performing a full database disaster recovery with RMAN, in what order would you execute these steps?
When performing a full database disaster recovery with RMAN, in what order would you execute these steps?
Question 5
- (Topic 3)
What is the purpose of the RMAN recovery catalog? (Choose all that apply.)
What is the purpose of the RMAN recovery catalog? (Choose all that apply.)
Question 6
- (Topic 15)
What two statements are true regarding the recommendations received from the SQL Access Advisor? (Choose two.)
What two statements are true regarding the recommendations received from the SQL Access Advisor? (Choose two.)
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.
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.
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?
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?
Question 9
- (Topic 2)
The CONTROL_FILE_RECORD_KEEP_TIME initialization parameter should be set to what value? (Choose all that apply.)
The CONTROL_FILE_RECORD_KEEP_TIME initialization parameter should be set to what value? (Choose all that apply.)
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.)
Which of the following are valid until command options when attempting point-in-time recovery in RMAN? (Choose all that apply.)
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?
The Database Resource Manager is automatically enabled in the maintenance window that runs the Automated Maintenance Task. What is the reason for this?
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?
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?
Question 13
- (Topic 5)
Which of the following statements are true about the BACKUP command? (Choose all that apply.)
Which of the following statements are true about the BACKUP command? (Choose all that apply.)
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?
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?
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.)
Using the LIST command in Recovery Manager (RMAN), which two pieces of information in the RMAN repository can be listed? (Choose two.)
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?
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?
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.)
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.)
Question 18
- (Topic 9)
True or false: tablespace point-in-time recovery is possible only with RMAN.
True or false: tablespace point-in-time recovery is possible only with RMAN.
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?
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?
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?
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?
Question 21
- (Topic 20)
Which of the following is not a valid linguistic sort element?
Which of the following is not a valid linguistic sort element?
Question 22
- (Topic 11)
You executed the following commands in a database session:
What could have caused the recycle bin to clean up?
You executed the following commands in a database session:
What could have caused the recycle bin to clean up?
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.)
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.)
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?
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?
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?
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?