Oracle 1Z0-053 Braindumps 2021

NEW QUESTION 1

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

• A. Building the SQL profile
• B. Recommending optimization of materialized views
• C. Checking query objects for missing and stale statistics
• D. Recommending bitmap, function-based, and B-tree indexes
• E. Recommending restructuring SQL queries that are using bad plans

Answer: ACE

NEW QUESTION 2

While performing the backup of the flash recovery area, you notice that one of the archived redo log files is missing. You have multiple destinations for archived redo log files. What implications does it have on the backup of the flash recovery area?

• A. The backup fails because one of the archived redo log files is missing.
• B. The backup succeeds but it would be without the missing archived log.
• C. During backup, you are prompted for the alternative destination for the missing archived redo log file.
• D. The backup succeeds because it fails over to one of the alternative archived redo log destinations.

Answer: D

NEW QUESTION 3

While tuning a SQL statement, the SQL Tuning Advisor finds an existing SQL profile for the statement that has stale statistics available.
What would the optimizer do in this situation?

• A. It updates the existing SQL profiles with current statistics.
• B. It makes the statistics information available to GATHER_STATS_JOB.
• C. It initiates the statistics collection process by running GATHER_STATS_JOB.
• D. It logs a warning message in the alert log so that the DBA can perform statistics collection manually.

Answer: B

NEW QUESTION 4

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.

• A. 1, 3, 6, 7
• B. 2, 3, 6, 8
• C. 1, 2,3,6,7
• D. 1, 2, 3, 6, 7, 8
• E. 2, 3,6,5,7

Answer: B

NEW QUESTION 5

The database is currently open and the temp03.dbf tempfile belonging to the default temporary tablespace TEMP has been corrupted.
What steps should you take to recover from this tempfile loss in an efficient manner?

• A. Allow the database to continue running, drop the TEMP tablespace, and then re-create it with new tempfiles
• B. Shut down the database, restore and recover the tempfile from backup, and then open the database with RESETLOGS
• C. Allow the database to continue running, take the TEMP tablespace offline, drop the missing tempfile, and then create a new tempfile
• D. Allow the database to continue running, add a new tempfile to TEMP tablespace with a new name, and drop the tempfile that has been corrupted.

Answer: D

NEW QUESTION 6

A user performs an update on a table. Shortly after committing the transaction, they realize
that they had an error in their WHERE clause causing the wrong rows to be updated. Which Flashback option would allow you to undo this transaction and restore the table to its previous state?

• A. Flashback Drop
• B. Flashback Query
• C. Flashback Versions Query
• D. Flashback Transaction Query
• E. Flashback Table

Answer: E

Explanation:
FLASHBACK TABLE
Purpose
Use the FLASHBACK TABLE statement to restore an earlier state of a table in the event of human or application error. The time in the past to which the table can be flashed back is dependent on the amount of undo data in the system. Also, Oracle Database cannot restore a table to an earlier state across any DDL operations that change the structure of the table.

NEW QUESTION 7

You are managing an Oracle Database 11g database. You want to take the backup of
MULT_DATA, a big file tablespace of size 100 TB on tape drive, but you have tapedrives of only 10 GB each.
Which method would accomplish the task quickly and efficiently?

• A. parallel image copy backup
• B. backup with MAXPIECESIZE configured for the channel
• C. parallel backup with MAXPIECESIZE configured for the channel
• D. intrafile parallel backup

Answer: D

Explanation:
The MAXPIECESIZE option is to limit the size of backup piece. not to split the big file into pieces.
Configuring the Maximum Size of Backup Pieces
Backup piece size is an issue when it exceeds the maximum file size permitted by the file system or media management software. You can use the MAXPIECESIZE parameter of the CONFIGURE CHANNEL or ALLOCATE CHANNEL command to limit the size of backup pieces.
For example, to limit the backup piece size to 2 gigabytes or less, you can configure the automatic DISK channel as follows and then run BACKUP DATABASE:
CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 2G; BACKUP DATABASE;
We should use the SECTION SIZE option to split the big file into sections to the multiple backup devices. SECTION SIZE sizeSpec Specifies the size of each backup section produced during a data file backup.
By setting this parameter, RMAN can create a multisection backup. In a multisection backup, RMAN creates a backup piece that contains one file section, which is a contiguous range of blocks in a file. All sections of a multisection backup are the same size. You can create a multisection backup for a data file, but not a data file copy.
File sections enable RMAN to create multiple steps for the backup of a single large data file. RMAN channels can process each step independently and in parallel, with each channel producing one section of a multisection backup set.
If you specify a section size that is larger than the size of the file, then RMAN does not use multisection backup for the file. If you specify a small section size that would produce more than 256 sections, then RMAN increases the section size to a value that results in exactly 256 sections.
Depending on where you specify this parameter in the RMAN syntax, you can specify different section sizes for different files in the same backup job.
Note: You cannot use SECTION SIZE with MAXPIECESIZE or with INCREMENTAL LEVEL 1.

NEW QUESTION 8

A database is running in ARCHIVELOG mode and regular backups are performed. A user receives the following
Error message:

Which is the recommended sequence of operations you need to perform for the query successfully?

• A. Drop the affected tablespace, re-create the tablespace, restore the datafiles, and the tablespace.
• B. Take the affected datafile offline (if not already offline), restore the damaged image ofthe datafile, and then bring it online.
• C. Restart the database in MOUNT mode, restore the damaged datafile, recover the datafile and then open the database with resetlogs.
• D. Put the database in RESTRICTED mode, restore all the datafiles in the affected datafile and recover the tablespace, and then put the database in normal operational mode.

Answer: B

NEW QUESTION 9

Immediately after adding a new disk to or removing an existing disk from an ASM instance, you find that the performance of the database goes down initially until the time the addition or removal process is completed, and then gradually becomes normal.
Which two activities would you perform to maintain a consistent performance of the database while adding or removing disks? (Choose two.)

• A. Define the POWER option while adding or removing the disks.
• B. Increase the number of ARB processes by setting up a higher value for ASM_POWER_LIMIT.
• C. Increase the number of DBWR processes by setting up a higher value for DB_WRITER_PROCESSES.
• D. Increase the number of slave database writer processes by setting up a higher value for DBWR_IO_SLAVES.

Answer: AB

Explanation:
ARBn (ASM Rebalance Process): Rebalances data extents within an ASM disk group, possible processes are ARB0-ARB9 and ARBA.
ALTER DISKGROUP..POWER clause, specify a value from 0 to 11, where 0 stops the rebalance operation and 11 permits Oracle ASM to execute the rebalance as fast as possible. The value you specify in the POWER clause defaults to the value of the ASM_POWER_LIMIT initialization parameter. If you omit the POWER clause, then Oracle ASM executes both automatic and specified rebalance operations at the power determined by the value of the ASM_POWER_LIMIT initialization parameter.
Note:
Beginning with Oracle Database 11g Release 2 (11.2.0.2), if the COMPATIBLE.ASM disk group attribute is set to 11.2.0.2 or higher, then you can specify a value from 0 to 1024 in the POWER clause.

NEW QUESTION 10

Given the script
create script db_backup_datafile_script
{backup datafile and 1, and2 plus archivelog delete input;}
What is the result of running this command?
Run {execute script db_backup_datafile_script using 2;}

• A. The script will fail since you instructed RMAN to back up only one datafile rather than two.
• B. The script will successfully back up datafile 3 without error.
• C. The script will fail since it uses a substitution variable which is not supported.
• D. The execute script command will prompt for the value of and2 since it's not included in the command.
• E. The script will fail because you cannot use the plus archivelog command when backing up database datafiles.

Answer: D

NEW QUESTION 11

Which of the following statements is true regarding implementing a Flashback Table recovery?

• A. An SCN is never used to perform a Flashback Table recovery.
• B. If a significant number of changes have been made to the table, row movement must be enabled.
• C. The tablespace must be offline before performing a Flashback Table recovery.
• D. Flashback Table recovery is completely dependent on the availability of undo data in theundo tablespace.

Answer: D

NEW QUESTION 12

View the Exhibit to examine the error while executing the REPAIR FAILURE command in an RMAN session.
What is the reason for this error? Exhibit:

• A. Another repair session is running concurrently.
• B. The failure ID has not been mentioned in the command for data file 5.
• C. There are new failures recorded in the Automatic Diagnostic Repository (ADR).
• D. The ADVISE FAILURE command has not been issued before the REPAIR FAILURE command.

Answer: A

NEW QUESTION 13

Which command would you use to determine what database backups are currently available for restore?

• A. list database backup;
• B. report database backup;
• C. list backup of database;
• D. list summary backup;
• E. report backup of database;

Answer: C

NEW QUESTION 14

You are using Recovery Manager (RMAN) to perform backups. In which three situations would you perform a compressed backup? (Choose three.)

• A. You are backing up to tape and your tape device performs its own compression.
• B. You are making image copies, and you have not enabled tablespace compression.
• C. You are using disk-based backups and disk space in your Flash Recovery Area, or other disk-based backup destinations are limited.
• D. You are performing your backups to some device over a network where reduced network bandwidth is more important than CPU usage.
• E. You are using some archival backup media, such as CD or DVD, where reducing backup sizes saves media costs and archival storage.

Answer: CDE

NEW QUESTION 15

View the following SQL statements: Transaction T1
SQL> INSERT INTO hr.regions 2 VALUES (5,'Pole');
3 COMMIT;
Transaction T2
SQL> UPDATE hr.regions 2 SET region_name='Poles'
3 WHERE region_id = 5;
4 COMMIT;
Transaction T3
SQL> UPDATE hr.regions
2 SET region_name='North and South Poles'
3 WHERE region_id = 5;
You want to back out transaction T2. Which option would you use?

• A. It is possible, but transaction T3 also backs out.
• B. It is possible with the NOCASCADE_FORCE option.
• C. It is possible with the NONCONFLICT_ONLY option.
• D. It is not possible because it has conflicts with transaction T3.

Answer: B

Explanation:
Table 12-2 Flashback TRANSACTION_BACKOUT Options
CASCADE
Backs out specified transactions and all dependent transactions in a post-order fashion (that is, children are backed out before parents are backed out).
Without CASCADE, if any dependent transaction is not specified, an error occurs.
NOCASCADE
Default. Backs out specified transactions, which are expected to have no dependent transactions. First dependent transactions causes an error and appears in
*_FLASHBACK_TXN_REPORT.
NOCASCADE_FORCE
Backs out specified transactions, ignoring dependent transactions. Server runs undo SQL statements for specified transactions in reverse order of commit times. If no constraints break and you are satisfied with the result, you can commit the changes; otherwise, you can roll them back.
NONCONFLICT_ONLY
Backs out changes to nonconflicting rows of the specified transactions. Database remains consistent, but transaction atomicity is lost.

NEW QUESTION 16

Which three statements are true about persistent configuration? (Choose three.)

• A. A user cannot set privileges on the persistent lightweight jobs
• B. Persistent lightweight jobs generate a large amount of metadata
• C. It is possible to create fully self-contained persistent lightweight jobs
• D. The use of a template is mandatory to create persistent lightweight jobs
• E. Persistent lightweight jobs are useful when users need to create a large number of jobs in a short time

Answer: ADE

NEW QUESTION 17

While deploying a new application module, the software vendor ships the application software along with appropriate SQL plan baselines for the new SQLs being introduced. Which two statements describe the consequences? (Choose two.)

• A. The plan baselines can be evolved over time to produce better performance.
• B. The newly generated plans are directly placed into the SQL plan baseline without being verified.
• C. The new SQL statements initially run with the plans that are known to produce good performance under standard test configuration.
• D. The optimizer does not generate new plans for the SQL statements for which the SQL plan baseline has been imported.

Answer: AC

Explanation:
Purpose of SQL Plan Baselines
Common scenarios where SQL plan management can improve or preserve SQL performance include:
A database upgrade that installs a new optimizer version usually results in plan changes for a small percentage of SQL statements. Most of these plan changes result in either no performance change or improvement. However, some plan changes may cause performance regressions. SQL plan baselines significantly minimize potential regressions resulting from an upgrade.
Ongoing system and data changes can impact plans for some SQL statements, potentially causing performance regressions. SQL plan baselines help minimize performance regressions and stabilize SQL performance.
Deployment of new application modules means introducing new SQL statements into the database. The application software may use appropriate SQL execution plans developed in a standard test configuration for the new statements. If the system configuration is significantly different from the test configuration, then the database can evolve SQL plan baselines over time to produce better performance.

NEW QUESTION 18

Which two statements are true regarding an Automatic Storage Management (ASM) instance? (Choose two.)

• A. An ASM instance mounts an ASM control file
• B. An ASM instance uses the ASMB process for rebalancing of disks within a disk group
• C. Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameter is not set explicitly
• D. An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started

Answer: CD

NEW QUESTION 19

Note the following parameters settings in your database:

You issued the following command to increase the value of DB_8K_CACHE_SIZE: SQL> ALTER SYSTEM SET DB_8K_CACHE_SIZE=140M;
What would happen?

• A. It will fail because DB_8K_CACHE_SIZE parameter cannot be changed dynamically
• B. It will be successful only if the memory is available from the auto tuned components
• C. It will fail because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGET
• D. It will fail because an increase in the DB_8K_CACHE_SIZE cannot be accommodated withinSGA_MAX_SIZE

Answer: D

Explanation:
This is an actually mathematic question.

NEW QUESTION 20

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

• A. The initialization parameter should be set to 0 when the RMAN repository is being used.
• B. The initialization parameter should be set to greater than 0 with the RMAN repository utilizing the recovery catalog only.
• C. The initialization parameter should be set to greater than 0 with the RMAN repository utilizing the control file or the recovery catalog.
• D. The initialization parameter should be set to 0 with the RMAN repository utilizing the control file or the recovery catalog.
• E. The initialization parameter should never be set to 0 if you are using RMAN.

Answer: CE

Explanation:
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.

NEW QUESTION 21

How long will this backup be allowed to run?
Backup as compressed backupset duration 2:00 minimize load database;

• A. 2 minutes
• B. 2 hours
• C. 2 days
• D. The command will generate an error.
• E. This backup is not constrained by any time limitation.

Answer: B

NEW QUESTION 22

Automatic PGA Memory Management eliminates the need to manually configure which of the following initialization parameters? (Choose all that apply.)

• A. SORT_AREA_SIZE
• B. HASH_AREA_SIZE
• C. BITMAP_MERGE_AREA_SIZE
• D. CREATE_BITMAP_AREA_SIZE
• E. PGA_AGGREGATE_TARGET

Answer: ABCD

NEW QUESTION 23

View the Exhibit to examine the output for the V$DIAG_INFO view. Which statements are true regarding the location of diagnostic traces? (Choose all that apply.)
Exhibit:

• A. The path to the location of the background as well as the foreground process trace files is /u01/oracle/diag/ rdbms/orclbi/orclbi/trace.
• B. The location of the text alert log file is /u01/oracle/diag/rdbms/orclbi/orclbi/alert.
• C. The location of the trace file for the current session is/u01/oracle/diag/rdbms/orclbi/orclbi/trace.
• D. The location of the XML-formatted version of the alert log is/u01/oracle/diag/rdbms/orclbi/orclbi/alert.

Answer: ACD

NEW QUESTION 24

You have configured flash recovery area in your database and you set the following Initialization parameters for your database instance:
LOG_ARCHIVE_DEST 1 = 'LOCATION=/disk1/arch MANDATORY' LOG _ARCHIEVE_DEST 2 = 'LOCATION=/disk2/arch' LOG_ARCHIVK_DEST_3 = 'LOCATION=/diSk3/arch LOG_ARCH1VK_DEST_4 = 'LOCATION=/disk4/arch' LOG_ARCHIVE_MIN-SUCCEED_DEST = 2
While the database instance is functional, you realized that the destination set by the LOG_ARCHIVE_DEST_I parameter Is not available for the archived redo log file to be created in. All redo log groups have been used.
What happens in an event of log switch?

• A. The online redo log file is not allowed to be overwritten.
• B. The archived redo log files are written to the flash recovery area until the MANDATORY destination is made available.
• C. The database instance will crash because the archived redo log file cannot be created in a destination set as MANDATORY.
• D. The destination set by the LOG_ARCHIVE_DEST_1 parameter is ignored and the archived redo log files are created in the next two available locations to guarantee archive log success.

Answer: D

NEW QUESTION 25

The BACKUP_TAPE_IO_SLAVES parameter is set to FALSE for the database instance. Which statement is true while performing a tape backup in an RMAN session?

• A. The tape I/O performed is asynchronous
• B. The tape buffer is allocated from the System Global Area (SGA)
• C. The tape buffer is allocated from the Program Global Area (PGA)
• D. Oracle I/O uses an interrupt mechanism to determine when each I/O completes

Answer: C

Explanation:
Tape I/O Slaves
RMAN allocates the tape buffers in the System Global Area (SGA) or the Program Global Area (PGA), depending on whether I/O slaves are used. If you set the initialization parameter
BACKUP_TAPE_IO_SLAVES=true, then RMAN allocates tape buffers from the SGA. Tape devices can only be accessed by one process at a time, so RMAN starts as many slaves as necessary for the number of tape devices. If the LARGE_POOL_SIZE initialization parameter is also set, then RMAN allocates buffers from the large pool. If you set BACKUP_TAPE_IO_SLAVES=false, then RMAN allocates the buffers from the PGA.
If you use I/O slaves, then set the LARGE_POOL_SIZE initialization parameter to dedicate SGA memory to holding these large memory allocations. This parameter prevents RMAN I/O buffers from competing with the library cache for SGA memory. If I/O slaves for tape I/O were requested but there is not enough space in the SGA for them, slaves are not used, and a message appears in the alert log.
The parameter BACKUP_TAPE_IO_SLAVES specifies whether RMAN uses slave processes rather than the number of slave processes. Tape devices can only be accessed by one process at a time, and RMAN uses the number of slaves necessary for the number of tape devices.

NEW QUESTION 26

A PL/SQL procedure queries only those columns of a redefined table that were unchanged by the online table redefinition.
What happens to the PL/SQL procedure after the online table redefinition?

• A. It remains valid.
• B. It becomes invalid for all options of online table redefinition but automatically gets revalidated the next time it is used.
• C. It becomes invalid for all options of online table redefinition and is automatically recompiled during online redefinition of the table.
• D. It becomes invalid only if the storage parameters have been modified and it automatically gets revalidated the next time it is used.

Answer: A

NEW QUESTION 27

The following query will provide what information about transportable tablespaces for the current database? (Choose all that apply.)

• A. The list of target platforms having the same endian format as the source database
• B. The list of target platforms requiring endian conversion
• C. The list of target platforms that will not require endian conversion
• D. The list of all target platforms that can receive transportable tablespaces from the source database
• E. None of the above

Answer: AC

NEW QUESTION 28
......