19 October, 2019

Oracle Database 11g: Administration II 1Z0-053 Free Samples

Testking offers free demo for 1Z0-053 exam. \"Oracle Database 11g: Administration II\", also known as 1Z0-053 exam, is a Oracle Certification. This set of posts, Passing the Oracle 1Z0-053 exam, will help you answer those questions. The 1Z0-053 Questions & Answers covers all the knowledge points of the real exam. 100% real Oracle 1Z0-053 exams and revised by experts!

Page: 1 / 58

Total 698 questions Full Exam Access

Question 1

- (Topic 2)
Which options would you consider while configuring a flash recovery area (fast recovery area in 11g Release 2) for your production database that is running in ARCHIVELOG mode? (Choose all that apply.)

Setting the FAST_START_MTTR_TARGET to set the mean time to recover

Setting the RECOVERY_PARALLELISM parameter to twice the number of CPUs

Using the DB_RECOVERY_FILE_DEST parameter to set the location for flash recovery area

Using the DB_RECOVERY_FILE_DEST_SIZE parameter to define the disk space limit for the recovery files created in the flash recovery area

Question 2

- (Topic 1)
Which background process coordinates the rebalance activity for disk groups?

ORBn

OSMB

RBAL

ASMn

Question 3

- (Topic 19)
Which two statements are true with respect to the maintenance window? (Choose two.)

A DBA can enable or disable an individual task in all maintenance windows.

A DBA cannot change the duration of the maintenance window after it is created.

In case of a long maintenance window, all Automated Maintenance Tasks are restarted every four hours.

A DBA can control the percentage of the resource allocated to the Automated Maintenance Tasks in each window.

Question 4

- (Topic 5)
Compressed backups work with which of the following commands?

copy as backup

backup as copy

backup

copy

Question 5

- (Topic 15)
Which three functions are performed by the SQL Tuning Advisor? (Choose three.)

Building the SQL profile

Recommending optimization of materialized views

Checking query objects for missing and stale statistics

Recommending bitmap, function-based, and B-tree indexes

Recommending restructuring SQL queries that are using bad plans

Question 6

- (Topic 13)
Choose the correct order to package and upload data for an incident to Oracle Support.

Schedule, create new package, view manifest, view contents

Create new package, view manifest, view contents, schedule

Schedule, create new package, view contents, view manifest

Create new package, view contents, view manifest, schedule

None of the above.

Question 7

- (Topic 15)
Which two prerequisites are needed for performing workload capture and replay? (Choose two.)

Close all sessions performing queries using database links.

running the database in shared server mode

The database on which the workload is replayed has to be a restore of the original database to a specific SCN.

setting up the directory to capture the workload

Question 8

- (Topic 13)
In what view are you likely to see the following output?
1Z0-053 dumps exhibit

V$SESSION_EVENT

V$SESSION

V$WAITS

V$WAITSTAT

V$SYSSTAT

Question 9

- (Topic 1)
Examine the following ALTER command;
SQL> ALTER DISKGROUP dgroup1 UNDROP DISKS;
What is the purpose of the command?

It cancels all pending disk drops within the disk group.

It adds previously dropped disks back into the disk group.

It restores disks that are being dropped as the result of a DROP DISKGROUP operation.

It mounts disks in the disk group for which the drop-disk operation has already been completed.

It restores all the dropped disks in the disk group for which the drop-disk operation has already been completed.

Question 10

- (Topic 13)
Which of the following tasks does the tool Incident Packaging Service (IPS) perform?

Cleans up the ADR by deleting files not associated with an incident uploaded to Oracle Support.

Identifies all files associated with a critical error and adds them to a zip file to be sent to Oracle Support.

Automatically opens a Service Request with Oracle Support for each critical error and sends all relevant files.

Displays a high-level view of critical errors on the database home page.

Question 11

- (Topic 4)
Examine the following RMAN command:
RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON; RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
Which prerequisite must be met before accomplishing the backup?

Provide a password for the encryption

Set up an Oracle wallet for the encryption

No setup is required as it is a default encryption method

Both Oracle wallet and password must be set up for the encryption

Question 12

- (Topic 1)
Which type of database file is spread across all disks in a disk group?

All types of files are spread across all disks in the disk group.

Datafiles

Redo log files

Archived redo log files

Control files

Question 13

- (Topic 2)
What does the SCN represent?

The system change number, which is a point in time relative to transactions within a given database.

A number that represents tim

Thus, at 1300 hours, the SCN is the same on all databases.

The security change number, which represents the security code that is needed to access any database structure.

A conversion factor that converts internal database time to external clock time.

UTC time in the database, providing a standardized way of tracking time in Oracle.

Question 14

- (Topic 1)
You are managing an Oracle Database 11g instance and an Oracle Database 10g instance on the same machine. Both instances use the ASM instance as storage. Which statement regarding the ASM disk group compatibility attributes are true in this scenario? (Choose all that apply.)

The database-compatibility version settings for each instance must be greater than or equal to the RDBMS compatibility of all ASM disk groups used by that database instances.

RDBMS compatibility and the database version determines whether a database instance can mount the ASM disk group.

The RDBMS compatibility settings for a disk group control the format of data structures for ASM metadata on the disk.

ASM compatibility controls which features for the ASM will be enabled.

Question 15

- (Topic 16)
When shrinking a table segment, you choose to shrink all the indexes for that table using the SHRINK SPACE command. Which clause should you use?

INCLUDING DEPENDENCIES

INCLUDING DEPENDENCIES CASCADE

COMPACT

CASCADE

None of the above

Question 16

- (Topic 11)
Which method would you use to undo the changes made by a particular transaction without affecting the changes made by other transactions?

Point-in-time recovery

Execute the ROLLBACK command with transaction number

Flashback the database to before the transaction was committed

Determine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and use them for recovery

Question 17

- (Topic 3)
How would you grant the RVPC user access to specific RMAN database records in the
RMAN virtual private catalog?

Issue the grant command from the SYS user (or equivalent) of the target database.

Issue the grant command from the SYS user (or equivalent) of the recovery-catalog database.

Issue the grant command from the recovery catalog-owning schema user account in the recovery catalog.

Issue the grant command from RMAN when connected to the recovery catalog-owning schema.

Issue the grant command from RMAN when connected to the target database.

Question 18

- (Topic 11)
Which of the following statements are true regarding the Recycle Bin? (Choose all that apply.)

The Recycle Bin is a physical storage area for dropped objects.

The Recycle Bin is a logical container for dropped objects.

The Recycle Bin stores the results of a Flashback Drop operation.

The objects in the Recycle Bin are stored in the tablespace in which they were created.

Question 19

- (Topic 13)
Which statements are true regarding the creation of an incident package file by using the EM Workbench Support? (Choose all that apply.)

You can add or remove the trace files to the package.

You can create the incremental incident package ZIP file for new or modified diagnostic information for the incident package already created.

You can add SQL test cases to the incident package.

You cannot create an incremental incident package when the physical files are purged from the ADR.

My answer: -

Reference answer: ABC

Reference analysis:

Refer to here
About Quick Packaging and Custom Packaging
The Enterprise Manager Support Workbench provides two methods for creating and uploading an incident package: the quick packaging method and the custom packaging method.
Quick Packaging—This is the more automated method with a minimum of steps, organized in a guided workflow (a wizard). You select a single problem, provide a package name and description, and then schedule upload of the package contents, either immediately or at a specified date and time. The Support Workbench automatically places diagnostic data related to the problem into the package, finalizes the package, creates the zip file, and then uploads the file. With this method, you do not have the opportunity to add, edit, or remove package files or add other diagnostic data such as SQL test cases. However, it is the simplest and quickest way to get first-failure diagnostic data to Oracle Support. Quick packaging is the method used in the workflow described in "Investigating, Reporting, and Resolving a Problem".
Note that when quick packaging is complete, the package that was created by the wizard remains. You can then modify the package with custom packaging operations at a later time and manually reupload.
Custom Packaging—This is the more manual method, with more steps. It is intended for expert Support Workbench users who want more control over the packaging process. With custom packaging, you can create a new package with one or more problems, or you can add one or more problems to an existing package. You can then perform a variety of operations on the new or updated package, including:
✑ Adding or removing problems or incidents
✑ Adding, editing, or removing trace files in the package
✑ Adding or removing external files of any type
✑ Adding other diagnostic data such as SQL test cases
✑ Manually finalizing the package and then viewing package contents to determine if you must edit or remove sensitive data or remove files to reduce package size.
You might conduct these operations over a number of days, before deciding that you have enough diagnostic information to send to Oracle Support.
With custom packaging, you create the zip file and request upload to Oracle Support as two separate steps. Each of these steps can be performed immediately or scheduled for a future date and time.
Select the Full or Incremental option to generate a full package zip file or an incremental package zip file.
For a full package zip file, all the contents of the package (original contents and all correlated data) are always added to the zip file.
For an incremental package zip file, only the diagnostic information that is new or modified since the last time that you created a zip file for the same package is added to the zip file. For example, if trace information was appended to a trace file since that file was last included in the generated physical file for a package, the trace file is added to the
incremental package zip file. Conversely, if no changes were made to a trace file since it was last uploaded for a package, that trace file is not included in the incremental package zip file.

Question 20

- (Topic 15)
Which two client requests are captured during database replay Capture? (Choose two)

Flashback queries

Shared server requests

Direct path load of data from external files by using utilities such as SQL *loader

Data definition language (DDL) and data manipulation language (DML) operations

My answer: -

Reference answer: CE

Reference analysis:

9.3 Workload Capture Restrictions
Certain types of user sessions and client requests may sometimes be captured in a workload, but they are not supported by Database Replay. Capturing these session and request types in a workload may result in errors during workload replay.
The following types of user sessions and client requests are not supported by Database Replay:
✑ Direct path load of data from external files using utilities such as SQL*Loader
✑ Non-PL/SQL based Advanced Queuing (AQ)
✑ Flashback queries
✑ Oracle Call Interface (OCI) based object navigations
✑ Non SQL-based object access
✑ Distributed transactions, Any distributed transactions that are captured will be replayed as local transactions.
✑ XA transactions, XA transactions are not captured or replayed. All local transactions are captured.
✑ JAVA_XA transactions, If the workload uses the JAVA_XA package, JAVA_XA function and procedure calls are captured as normal PL/SQL workload. To avoid problems during workload replay, consider dropping the JAVA_XA package on the
replay system to enable the replay to complete successfully.
✑ Database Resident Connection Pooling (DRCP)
✑ Workloads using OUT binds
✑ Multi-threaded Server (MTS) and shared server sessions with synchronization mode set to
OBJECT_ID
✑ Migrated sessions, The workload is captured for migrated sessions. However, user logins or session migration operations are not captured. Without a valid user login or session migration, the replay may cause errors because the workload may be replayed by a wrong user.
Typically, Database Replay refrains from capturing these types of non-supported user sessions and client requests. Even when they are captured, Database Replay will not replay them. Therefore, it is usually not necessary to manually filter out non-supported user sessions and client requests. In cases where they are captured and found to cause errors during replay, consider using workload capture filters to exclude them from the workload.

Question 21

- (Topic 17)
Which statements describe the capabilities of the DBMS_NETWORK_ACL_ADMIN package? (Choose all that apply.)

It can be used to allow the access privilege settings for users but not roles.

It can be used to allow the access privilege settings for users as well as roles.

It can be used to control the time interval for which the access privilege is available to a user.

It can be used to selectively restrict the access for each user in a database to different host computers.

It can be used to selectively restrict a user\'s access to different applications in a specific host computer.

Question 22

- (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 23

- (Topic 15)
View the Exhibit to examine the Automatic SQL Tuning result details. Which action would you suggest for the selected SQL statement in the Exhibit?
1Z0-053 dumps exhibit

Accept the recommended SQL profile.

Collect statistics for the related objects.

Run the Access Advisor for the SQL statement.

Run the Segment Advisor for recommendations.

Question 24

- (Topic 14)
In Oracle 11g, by default which one of the following conditions implicitly enables Automatic PGA Memory Management?

Setting a nonzero value for SGA_TARGET

Configuring Automatic Shared Memory Management

Configuring Automatic Memory Management

Setting a nonzero value for SGA_MAX_SIZE and PGA_AGGREGATE_TARGET

None of the above

Question 25

- (Topic 6)
What is the correct order of the following commands if you wanted to restore datafile 4, which was accidentally removed from the file system?
a: sql 'alter database datafile 4 online'; b: restore datafile 4;
c: recover datafile 4;
d: sql 'alter database datafile 4 offline';
e: startup
f: shutdown

a, c, b, d

d, b, c, a

f, d, b, c, a, e

c, a, b, d, f

a, b, d, e

Question 26

- (Topic 8)
How many database instances are used during a database-duplication process?

One

Two

Three

Four

Five

Question 27

- (Topic 6)
You realize that the control file is damaged in your production database. After restoring the control file from autobackup, what is the next step that you must do to proceed with the database recovery?

Mount the database

Open the database in NORMAL mode

Open the database in RESTRICTED mode

Open the database with the RESETLOGS option

Question 28

- (Topic 10)
You want to take the backup of the USERS tablespace. It has a single data file of 900 MB. You have tape drives of 300 MB each. The SBT channel is configured for the RMAN. To accomplish the backup, you issued the following RMAN command:
RMAN> BACKUP SECTION SIZE 300M TABLESPACE users;
Which two statements are true regarding the execution of the above command? (Choose two.)

The RMAN parallelizes the backup although the parallelism is not set for a channel.

The backup piece size will be limited to 300 MB.

The operation is accomplished using the default channel available.

Three channels for the tape drive must be configured by setting the parallelism to three.

Question 29

- (Topic 13)
Identify the three predefined server-generated alerts. (Choose three.)

Drop User

Tablespace Space Usage

Resumable Session Suspended

Recovery Area Low On Free Space

SYSTEM Tablespace Size Increment

Question 30

- (Topic 7)
When running the tablespace point-in-time command
recover tablespace users
until time '10/06/2008:22:42:00'
auxiliary destination 'c:\oracle\auxiliary'; You receive the following error:
1Z0-053 dumps exhibit

What is the likely cause of the error?

The database is in ARCHIVELOG mode.

There is not a current backup of the database available.

The USERS tablespace has dependent objects in other tablespaces and can not be a part of a TSPITR alone.

The USERS tablespace is not eligible for TSPITR because it has invalid objects.

The recover tablespace command is incorrect and generates the error.

Page: 1 / 58

Total 698 questions Full Exam Access