Oracle 1Z0-053 Braindumps 2021

NEW QUESTION 1
Which type of backup must be performed first with an incremental backup?

• A. Level 1
• B. Level 0
• C. Level 2
• D. Level 3

Answer: B

NEW QUESTION 2
You are managing the APPPROD database as a DBA which is not using the Oracle- managed files. You plan to duplicate this database in the same system with the name DUPDB.You want to create the same directory structure for duplicate database files as of the target database.
You executed the following RMAN commands:
RMAN> CONNECT TARGET sys/sys@APPPROD RMAN> CONNECT AUXILIARY sys/sys@DUPDB RMAN> DUPLICATE TARGET DATABASE
TO dupdb
FROM ACTIVE DATABASE PASSWORD FILE
SPILE NOFILENAMECHECK;
What are the implications of this command?

• A. It creates database files for the duplicate database under the Oracle base with a different directory for the duplicate database.
• B. It overwrites data files of the target database because a different location for data files is not mentioned for the duplicate database.
• C. It creates database files for the duplicate database under the same Oracle home as that of the target database with the same directory structure.
• D. It creates database files for the duplicate database under the same Oracle home as that of the target but with a different directory for the duplicate database.

Answer: B

Explanation: Topic 9, Performing Tablespace Point-in-Time Recovery (TSPITR)

NEW QUESTION 3
Which of the following statements is true regarding the VERSIONS BETWEEN clause?

• A. The VERSIONS BETWEEN clause may be used in DML statements.
• B. The VERSIONS BETWEEN clause may be used in DDL statements.
• C. The VERSIONS BETWEEN clause may not be used to query past DDL changes to tables.
• D. The VERSIONS BETWEEN clause may not be used to query past DML statements to tables.

Answer: C

NEW QUESTION 4
The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. One of the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file:
ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3;
Which action should you perform immediately after using this command?

• A. You should perform a log switch
• B. You should make a backup of the database
• C. You should switch the database to the NOARCHIVELOG mode
• D. You should shut down the database instance and perform a complete database recovery

Answer: B

NEW QUESTION 5
Examine the following set of RMAN commands:
RMAN> CONFIGURE CHANNEL dc1 DEVICE TYPE DISK FORMAT '/u02/backup/%U'; RMAN> RUN (
ALLOCATE CHANNEL Chi DEVICE TYPE DISK;
EXECUTE SCRIPT full_backup;
)
Which statement is true when the RMAN RUN block is executed?

• A. The execution of the script fails because multiple channels cannot coexist.
• B. The script is executed and both the channels are used for the script execution.
• C. The new channel 'CHI' is Ignored because a channel has been configured already.
• D. configuration parameter dc1 is overridden because a new channel is allocated in RMAN RUN block.

Answer: D

NEW QUESTION 6
While working on a data problem, Curt, Bill, Ben, Mike, and Matt introduced a vast amount of corrupted data into the database. Pablo has discovered this problem and he needs you to recover the database to the point in time prior to the introduction of the corruption. The logical corruption was introduced at 6:30 p.m. on September 6, 2008.
Which of the following would be the correct commands to use to restore the database to a point in time before the corruption?

• A. Option A
• B. Option B
• C. Option C
• D. Option D
• E. Option E

Answer: C

NEW QUESTION 7
True or false: you can perform an active database duplication when the database is in NOARCHIVELOG mode.

• A. True
• B. False

Answer: B

NEW QUESTION 8
Which commands are used for RMAN database recovery? (Choose all that apply.)

• A. restore
• B. repair
• C. copy
• D. recover
• E. replace

Answer: AD

NEW QUESTION 9
You want to disable resumable space allocation for all sessions. Which value should be assigned to the RESUMABLE_TIMEOUT parameter to disable resumable space allocation for all sessions?

• A. 10
• B. 100
• C. NULL

Answer: A

NEW QUESTION 10
View the Exhibit that sets the threshold for the Current Open Cursors Count metric. Why is the Significance Level threshold type not available in the threshold setting?
Exhibit:

• A. because AWR baseline is not enabled
• B. because Current Open Cursors Count is not a basic metric
• C. because the STATISTICS_LEVEL parameter is set to BASIC
• D. because the AWR baseline is a system-defined moving window baseline

Answer: B

Explanation:
C:UsersalboDesktop1-1.jpg

NEW QUESTION 11
Which two statements are true about the duplexing of the backups taken by RMAN? (Choose two.)

• A. It's only supported for the backups performed on the tape
• B. It is not supported for backup operations that produce image copies
• C. Duplex backups need a parallelism for the device to be equal to number of copies
• D. Duplex backups can be performed to either disk or tape, but cannot be performed on tape and disk simultaneously

Answer: BD

NEW QUESTION 12
Which of the following advisors within the Oracle advisory framework will analyze a single SQL statement and make recommendations for performance improvement?

• A. SQL Repair Advisor
• B. SQL Optimizer
• C. SQL Access Advisor
• D. SQL Tuning Advisor

Answer: D

NEW QUESTION 13
You backed up the database at 8 a.m. today using an online backup. Accounting made a large change to the underlying data between 10 a.m. and noon.
Which of the following actions would ensure that the changes could be recovered using the 8 a.m. backup?

• A. Create a manual incremental online database backup.
• B. Back up all the archived redo logs generated since the 8 a.
• C. backup.
• D. Create a brand-new backup after all the changes have been applied.
• E. There is no way to make the changes recoverable based on the 8 a.
• F. backup.
• G. Perform an online backup of the tablespace(s) that contained changed data.

Answer: B

NEW QUESTION 14
You plan to have a larger moving window size for the default system-defined moving window baseline because you want to use the adaptive threshold.
Which statement factors in this consideration while increasing the size of the moving window?

• A. The collection level for the AWR should be set to BASIC.
• B. The moving window size must be less than Undo Retention.
• C. The moving window size should be greater than the Automatic Workload Repository (AWR) retention period.
• D. The moving window size should be equal to or less than the Automatic Workload Repository (AWR) retention period.

Answer: D

Explanation: Moving Window Baseline (link)
A moving window baseline corresponds to all AWR data that exists within the AWR retention period. This is useful when using adaptive thresholds because the database can use AWR data in the entire AWR retention period to compute metric threshold values. Oracle Database automatically maintains a system-defined moving window baseline. The default window size for the system-defined moving window baseline is the current AWR retention period, which by default is 8 days.
If you are planning to use adaptive thresholds, consider using a larger moving window—such as 30 days—to accurately compute threshold values. You can resize the moving window baseline by changing the number of days in the moving window to a value that is equal to or less than the number of days in the AWR retention period. Therefore, to increase the size of a moving window, you must first increase the AWR retention period accordingly.

NEW QUESTION 15
You plan to control the sessions performing a huge number of I/O operations. Your requirement is to kill the session when it exceeds a specified number of I/Os. Which statement describes a solution to the above?

• A. Set a threshold for the default system-defined moving window baseline.
• B. Add directives to the Automatic Database Diagnostic Monitor (ADDM).
• C. Modify the profile for the targeted users for which control needs to be imposed.
• D. Implement the database resource manager to add the SWITCH_IO_REQS and SWITCH_GROUP directives.

Answer: D

NEW QUESTION 16
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 17
Over the course of a day, a department performed multiple DML statements (inserts, updates, deletes) on multiple rows of data in multiple tables. The manager would like a report showing the time, table name, and DML type for all changes that were made. Which Flashback technology would be the best choice to produce the list?

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

Answer: C