02 September, 2021

All About Real 1Z0-053 Exam Question

Exam Code: 1Z0-053 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: Oracle Database 11g: Administration II
Certification Provider: Oracle
Free Today! Guaranteed Training- Pass 1Z0-053 Exam.

Check 1Z0-053 free dumps before getting the full version:

Page: 1 / 58

Total 698 questions Full Exam Access

Question 1

- (Topic 11)
You executed the following commands in a database session:
1Z0-053 dumps exhibit

Which statement is true about the contents of the recycle bin in this situation?

They remain unaffected.

They are moved to flashback logs.

They are moved to the undo tablespace.

They are moved to a temporary tablespace.

The objects in the recycle bin that are in the default tablespace for the session user are cleaned up.

Question 2

- (Topic 11)
You executed the following command to drop a user: DROP USER scott CASCADE;
Which two statements regarding the above command are correct? (Choose two.)

All the objects of scott are moved to the Recycle Bin.

Any objects in the Recycle Bin belonging to scott are purged.

All the objects owned by scott are permanently dropped from the database.

All the objects of scott in the Recycle Bin must be purged before executing the DROP command.

Any objects in the Recycle Bin belonging to scott will not be affected by the above DROP command.

Question 3

- (Topic 5)
Why would you run the delete obsolete command? (Choose all that apply.)

To remove missing backup set pieces physically from disk

To remove metadata related to backup set pieces in the control file and the recovery catalog

To mark as deleted records in the control file and the recovery catalog associated with obsolete backup sets

To delete backup set pieces associated with backups that are no longer needed due to retention criteria

To remove old versions of RMAN backups

My answer: -

Reference answer: CD

Reference analysis:

Deleting Expired RMAN Backups and Copies
If you run CROSSCHECK, and if RMAN cannot locate the files, then it updates their records in the RMAN repository to EXPIRED status. You can then use the DELETE EXPIRED command to remove records of expired backups and copies from the RMAN repository.
The DELETE EXPIRED command issues warnings if any files marked as EXPIRED actually exist. In rare cases, the repository can mark a file as EXPIRED even though it exists. For example, a directory containing a file is corrupted at the time of the crosscheck, but is later repaired, or the media manager was not configured properly and reported some backups as not existing when they really existed.
To delete expired repository records:
If you have not performed a crosscheck recently, then issue a CROSSCHECK command. For example, issue:
CROSSCHECK BACKUP;
Delete the expired backups. For example, issue: DELETE EXPIRED BACKUP;
Deleting Obsolete RMAN Backups Based on Retention Policies
The RMAN DELETE command supports an OBSOLETE option, which deletes backups that are no longer needed to satisfy specified recoverability requirements. You can delete files that are obsolete according to the configured default retention policy, or another retention policy that you specify as an option to the DELETE OBSOLETE command. As with other forms of the DELETE command, the files deleted are removed from backup media, deleted from the recovery catalog, and marked as DELETED in the control file.
If you specify the DELETE OBSOLETE command with no arguments, then RMAN deletes all obsolete backups defined by the configured retention policy. For example:
DELETE OBSOLETE;

Question 4

- (Topic 16)
To enable resumable space allocation for the instance, which of the following initialization parameters should you set to a nonzero value?

RESUMABLE_SPACE_TIME

RESUMABLE_SPACE

RESUMABLE_TIME

RESUMABLE_TIMEOUT

TIME_RESUMABLE

Question 5

- (Topic 4)
Which view provides information on the backup status of the datafiles in the database?

V$BACKUP

V$BACKUP_STATUS

V$BACKUP_DATAFILE

V$DATAFILE_BACKUP

V$TABLESPCE_BACKUP

Question 6

- (Topic 16)
Which of the following options describes Segment Shrink?

Reclaims space above and below the high-water mark without using additional space

Moves rows to a new physical location, resetting the high-water mark, but uses additional space during the operation

Deallocates space above the high-water mark that is currently not in use

None of the above

Question 7

- (Topic 13)
Which of the following statements is true regarding the initialization parameter DIAGNOSTIC_DEST?

The default value is the value of the environment variable $ORACLE_HOME; if$ORACLE_HOME isn't set, then the default is set to $ORACLE_BASE.

The default value is the value of the environment variable $ORACLE_BASE; if$ORACLE_BASE isn't set, then it is set to $ORACLE_HOME.

DIAGNOSTIC_DEST is always equal to $ORACLE_HOME.

DIAGNOSTIC_DEST is always equal to $ORACLE_BASE.

Question 8

- (Topic 16)
The BOOKINGS table contains online booking information. When a booking is confirmed, the details are transferred to an archival table BOOKINGS_HIST and deleted from the
BOOKINGS table. There is no fixed time interval between each online booking and its confirmation. Because sufficient space is not always available from the delete operations the high-water mark (HWM) is moved up and many rows are inserted below the HWM of the table. The BOOKINGS table has Automatic Segment Space Management (ASSM) and row movement enabled. The table is accessible in 24x7 mode.
What is the most efficient method to reclaim the space released by the delete operations in the BOOKINGS table?

Perform EXPORT, DROP, and IMPORT operations on the BOOKINGS table sequentially

Shrink the BOOKINGS table by using the ALTER TABLE... SHRINK SPACE command

Move the BOOKINGS table to a different location by using the ALTER TABLE... MOVE command

Deallocate the space in the BOOKINGS table by using the ALTER TABLE ... DEALLOCATE UNUSED command

Question 9

- (Topic 14)
For Oracle 11g, Oracle strongly recommends that you configure your database to use which of the following memory management features?

Automatic PGA Memory Management

Automatic SGA Memory Management

Automatic Shared Memory Management

Automatic Memory Management

Manual SGA Memory Management

None of the above

Question 10

- (Topic 3)
Which option is best practice for creating a recovery catalog owner in the catalog database?

Granting UNLIMITED QUOTA on the SYSTEM tablespace to the owner

Allocating the SYSTEM tablespace as the default tablespace and granting the SYSDBA privilege to the user

Creating a new tablespace, allocating this as the default, and granting UNLIMITED QUOTA on this tablespace to the user

Allocating the SYSAUX tablespace as the default tablespace and granting UNLIMITED QUOTA on this tablespace to the user

Question 11

- (Topic 18)
Which of the following is not a valid setting for the PROGRAM_TYPE parameter in a program object or the JOB_TYPE parameter in a job object?

PLSQL_BLOCK

JAVA_STORED_PROCEDURE

STORED_PROCEDURE

EXECUTABLE

None of the above are invalid settings.

Question 13

- (Topic 5)
Which of the following files cannot be backed up by RMAN? (Choose all that apply.)

Database datafiles

Control files

Online redo logs

Database pfiles

Archived redo logs

Question 14

- (Topic 10)
You perform a backup using the following BACKUP command: RMAN> BACKUP AS COMPRESSED BACKUPSET DATABASE;
Which statement is true of this command?

A different procedure is required to restore a database from compressed backups

The AS COMPRESSED clause of the BACKUP command provided by RMAN is used to create compressed backup sets and image copies.

Using this command to create backups minimizes the bandwidth consumed

Using this command to create backups improves the performance of the backup process

Question 15

- (Topic 15)
Which of the following advisors within the Oracle advisory framework will analyze a single SQL statement and make recommendations for performance improvement?

SQL Repair Advisor

SQL Optimizer

SQL Access Advisor

SQL Tuning Advisor

Question 16

- (Topic 14)
View the Exhibit to examine the parameter values. You are planning to set the value for the
MEMORY_TARGET parameter of your database instance. What value would you assign?
Exhibit:
1Z0-053 dumps exhibit

1440 MB

90 MB

362 MB

272 MB

Question 17

- (Topic 15)
Identify the activities performed as part of the Automatic SQL Tuning process in the maintenance window? (Choose all that apply.)

generating the SQL profile

testing and accepting the SQL profile

generating a list of candidate SQLs for tuning

adding tuned SQL plans into the SQL plan baseline

tuning each SQL statement in the order of importance

generating baselines that include candidate SQLs for tuning

My answer: -

Reference answer: ABCE

Reference analysis:

17.2.1 How Automatic SQL Tuning Works (link)
Oracle Database automatically runs SQL Tuning Advisor on selected high-load SQL statements from the Automatic Workload Repository (AWR) that qualify as tuning candidates. This task, called Automatic SQL Tuning, runs in the default maintenance windows on a nightly basis. By default, automatic SQL tuning runs for at most one hour. You can customize attributes of the maintenance windows, including start and end time, frequency, and days of the week.
After automatic SQL tuning begins, the database performs the following steps:
1. Identifies SQL candidates in the AWR for tuning
Oracle Database analyzes statistics in AWR and generates a list of potential SQL statements that are eligible for tuning. These statements include repeating high-load statements that have a significant impact on the database.
The database tunes only SQL statements that have an execution plan with a high potential for improvement. The database ignores recursive SQL and statements that have been tuned recently (in the last month), parallel queries, DML, DDL, and SQL statements with performance problems caused by concurrency issues.The database orders the SQL statements that are selected as candidates based on their performance impact. The database calculates the impact by summing the CPU time and the I/O times in AWR for the selected statement in the past week.
2. Tunes each SQL statement individually by calling SQL Tuning Advisor
During the tuning process, the database considers and reports all recommendation types, but it can implement only SQL profiles automatically.
3. Tests SQL profiles by executing the SQL statement
If a SQL profile is recommended, the database tests the new profile by executing the SQL statement both with and without the profile. If the performance improvement improves at least threefold, then the database accepts the SQL profile, but only if the ACCEPT_SQL_PROFILES task parameter is set to TRUE. Otherwise, the automatic SQL tuning reports merely report the recommendation to create a SQL profile.
4. Optionally, implements the SQL profiles provided they meet the criteria of threefold
performance improvement The database considers other factors when deciding whether to implement the SQL profile. For example, the database does not implement a profile when the objects referenced in the statement have stale optimizer statistics. SQL profiles that have been implemented automatically show type is AUTO in the DBA_SQL_PROFILES view.
If the database uses SQL plan management, and if a SQL plan baseline exists for the SQL statement, then the database adds a new plan baseline when creating the SQL profile. As a result, the optimizer uses the new plan immediately after profile creation. See Chapter 15, "Using SQL Plan Management". At any time during or after the automatic SQL tuning process, you can view the results using the automatic SQL tuning report. This report describes in detail all the SQL statements that were analyzed, the recommendations generated, and the SQL profiles that were automatically implemented.
1Z0-053 dumps exhibit
C:\Users\albo\Desktop\1-1.jpg

Question 18

- (Topic 16)
You have enabled resumable space allocation in your database by setting the RESUMABLE_TIMEOUT parameter set to a nonzero value.
Which three statements about resumable space allocation are true? (Choose three.)

Even with resumable space allocation enabled for your database, you can disable resumable space allocation for a single session.

A resumable statement is suspended only if an out of space error occurs.

When a resumable statement is suspended, the transaction that contains the statement is also suspended.

A resumable statement can only be suspended and resumed once during the execution of the statement.

You can query the V$SESSION_WAIT dynamic performance view to identify the statements that are suspended for a session.

Question 19

- (Topic 16)
Which statements are true regarding table compression? (Choose all that apply.)

It saves disk space and reduces memory usage.

It saves disk space but has no effect on memory usage.

It incurs extra CPU overhead during DML as well as direct loading operations.

It incurs extra CPU overhead during DML but not direct loading operations.

It requires uncompress operation during I/O.

Question 20

- (Topic 12)
View the Exhibit and examine the output.
You executed the following command to enable Flashback Data Archive on the EXCHANGE_RATE table:
ALTER TABLE exchange_rate FLASHBACK ARCHIVE; What is the outcome of this command?
Exhibit:
1Z0-053 dumps exhibit

The Flashback Archive is created on the same tablespace where the tables are stored.

The Flashback Archive is created on the SYSAUX tablespace.

The command generates an error because no Flashback Archive name is specified and there is no default Flashback Archive.

The table uses the default Flashback Archive.

Question 21

- (Topic 7)
View the Exhibit to examine the error during the database startup. You open an RMAN session for the database instance. To repair the failure, you executed the following as the first command in the RMAN session:
RMAN> REPAIR FAILURE;
Which statement describes the consequence of the command? Exhibit:
1Z0-053 dumps exhibit

The command performs the recovery and closes the failures.

The command only displays the advice and the RMAN script required for repair.

The command produces an error because the ADVISE FAILURE command has not been executed before the REPAIR FAILURE command.

The command executes the RMAN script to repair the failure and removes the entry from the Automatic Diagnostic Repository (ADR).

Question 22

- (Topic 8)
You are managing the APPPROD database as a DBA. You plan to duplicate this database in the same system with the name DUPDB. You issued the following RMAN commands to create a duplicate database:
1Z0-053 dumps exhibit

Which three are the prerequisites for the successful execution of the above command? (Choose three.)

The source database should be open.

The target database should be in ARCHIVELOG mode if it is open.

RMAN should be connected to both the instances as SYSDBA.

The target database backups should be copied to the source database backup directories.

The password file must exist for the source database and have the same SYS user password as the target.

Question 23

- (Topic 11)
User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, which commands must you execute to enable SCOTT to flash back the transactions? (Choose four.)

ALTER DATABASE FLASHBACK ON;

GRANT SELECT ANY TRANSACTION TO scott;

GRANT EXECUTE ON dbms_flashback TO scott;

ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;

ALTER TABLESPACE undots1 RETENTION GUARANTEE;

ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;

Question 24

- (Topic 15)
Which client requests to the database can be captured as a part of the workload capture? (Choose all that apply.)

flashback query

distributed transactions

logging in and logging out of sessions

all DDL statements having bind variables

direct path load of data from external files

Question 25

- (Topic 1)
You are managing an Oracle Database 11g instance with ASM storage. The ASM instance is down. To know the details of the disks in the DATA disk group , you issued the following ASMCMD command:
ASMCMD> lsdsk -I -d DATA
Which statement is true regarding the outcome of this command?

The command succeeds but it retrieves only the disk names.

The command produces an error because the ASM instance is down.

The command succeeds but it shows only the status of the ASM instance.

The command succeeds and retrieves information by scanning the disk headers based on anASM_DISKSTRING value.

Page: 1 / 58

Total 698 questions Full Exam Access