10 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:

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?

All passwords automatically become case-sensitive.

All passwords remain non-case-sensitive till they are changed.

All passwords remain non-case-sensitive and cannot be changed.

All passwords remain non-case-sensitive until their password attribute in the profile is altered.

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

120M

320M

440M

600M

Question 3

- (Topic 6)
What methods are available to recover lost control files? (Choose all that apply.)

Backup control file.

Emergency control file.

The create controlfile command.

The restore controlfile SQL*Plus command.

No backup is require

The database will re-create the control file when it is discovered to be lost.

Question 5

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

Make backups faster

Store RMAN metadata

Store RMAN scripts

Provide the ability to do centralized backup reporting.

Make recovery faster

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.)

It cannot generate recommendations that support multiple workload queries.

It can recommend partitioning on tables provided that the workloads have some predicates and joins on the columns of the NUMBER or DATE type.

It can recommend partitioning only on tables that have at least 10,000 rows.

It can recommend only B-tree indexes and not bitmap or function-based indexes.

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.

1, 3, 6, 7

2, 3, 6, 8

1, 2,3,6,7

1, 2, 3, 6, 7, 8

2, 3,6,5,7

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?

only the control file, the current SPFILE, and data files

only the current SPFILE and data files if autobackup is disabled

only the data files and the archived redo logs

the control file, current SPFILE file, data files, and archived redo logs

Question 9

- (Topic 2)
The CONTROL_FILE_RECORD_KEEP_TIME initialization parameter should be set to what value? (Choose all that apply.)

The initialization parameter should be set to 0 when the RMAN repository is being used.

The initialization parameter should be set to greater than 0 with the RMAN repository utilizing the recovery catalog only.

The initialization parameter should be set to greater than 0 with the RMAN repository utilizing the control file or the recovery catalog.

The initialization parameter should be set to 0 with the RMAN repository utilizing the control file or the recovery catalog.

The initialization parameter should never be set to 0 if you are using RMAN.

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.)

until time

until change

until sequence

until SCN

until commit

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?

to prevent the creation of an excessive number of scheduler job classes

to allow the Automated Maintenance Tasks to use system resources without any restriction

to allow resource sharing only among the Automated Maintenance Tasks in the maintenance window

to prevent the Automated Maintenance Tasks from consuming excessive amounts of system resources

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?

ALTER DATABASE DROP LOGFILE GROUP 1;

ALTER DATABASE CLEAR LOGFILE GROUP 1;

ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;

ALTER DATABASE DROP LOGFILE MEMBER 'D:\REDO01.LOG';

Question 13

- (Topic 5)
Which of the following statements are true about the BACKUP command? (Choose all that apply.)

The BACKUP command can not be used to make image copies of a datafile.

The BACKUP command can improve performance by multiplexing backup files.

The BACKUP can take advantage of the block-change tracking capability.

The BACKUP command cannot store data in incremental backups.

The BACKUP command can store data in cumulative incremental backups only.

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?

Channel failover

Restartable backups

Rescheduable backups

Automatic backup recovery

Channel recovery

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.)

stored scripts in the recovery catalog

backups that can be deleted from disk

backup sets and image copies are obsolete

backups that do not have the AVAILABLE status in the RMAN repository

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?

Set metric threshold

Implement Database Resource Manager

Enable resumable timeout for user sessions

Add directives to Automatic Database Diagnostic Monitor (ADDM)

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.)

BACKGROUND_DUMP_DEST

FOREGROUND_DUMP_DEST

CORE_DUMP_DEST

USER_DUMP_DEST

DIAGNOSTIC_DEST

All of the above

Question 18

- (Topic 9)
True or false: tablespace point-in-time recovery is possible only with RMAN.

True

False

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?

1, 4, 3, 5

1, 4, 5, 3

2, 1, 5, 3, 4

1, 2, 4, 5, 3

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?

It must be executed from the Oracle Database 11g environment.

It must be executed only after the SYSAUX tablespace has been created.

It must be executed from the environment of the database that is being upgraded.

It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.

It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.

Question 21

- (Topic 20)
Which of the following is not a valid linguistic sort element?

Accent expansion

Canonical equivalence

Reverse secondary sorting

Ignorable characters

Character rearrangement

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?

There is demand for space from the new table

The undo tablespace does not have sufficient free space

The new table name is the same as the table name in the recycle bin

The temporary tablespace that is assigned to you does not have sufficient free space

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.)

A must contain all of the characters defined in B.

A must be Unicode.

The encoded values in A must match the encoded values in B for all characters defined in B.

A must be a multi-byte character set.

The encoded values in A must match the encoded values in B for all numeric and alphabetic characters in B.

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?

Enable supplemental logging for the database.

Specify undo retention guarantee for the database

Create Flashback Data Archive in the tablespace where the tables are stored.

Create Flashback Data Archive and enable Flashback Data Archive for specific tables

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?

Oracle will automatically take the datafile out of hot backup mode, generate a warning message, and then open the database.

Oracle will automatically take the datafile out of hot backup mode and then open the database.

Oracle will generate an error when trying to open the database, indicating that a datafile is in hot backup mod

You will need to correct this error before you can open the database.

The database will open with the file in hot backup mod

You can restart the backup at any time.

The datafile in hot backup mode will be corrupted and you will have to recover it.

Page: 1 / 58

Total 698 questions Full Exam Access