Oracle 1Z0-053 Practice Test 2021

NEW QUESTION 1
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 2
Automatic data conversion will occur if which of the following happens?

• A. The client and server have different NLS_LANGUAGE settings.
• B. The client and server character sets are not the same, and the database character set is not a strict superset of the client character set.
• C. The client and server are in different time zones.
• D. The client requests automatic data conversion.
• E. The AUTO_CONVERT initialization parameter is set to TRUE.

Answer: B

NEW QUESTION 3
Which three statements must be true before transporting a tablespace from a database on one platform to a database on another platform? (Choose three.)

• A. Both source and target database must be the same character set
• B. Both source and target database must have the same endian format
• C. The COMPATIBLE parameter must be the same in the source and target databases.
• D. The minimum compatibility level for both the source and target database must be 10.0.0.
• E. All read-only and offline data files that belong to the tablespace to be transported must be platform aware.

Answer: ABD

NEW QUESTION 4
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?

• A. INCLUDING DEPENDENCIES
• B. INCLUDING DEPENDENCIES CASCADE
• C. COMPACT
• D. CASCADE
• E. None of the above

Answer: D

NEW QUESTION 5
What happens when you run the SQL Tuning Advisor with limited scope?

• A. Access path analysis is not performed for SQL statements.
• B. SQL structure analysis is not performed for SQL statements.
• C. SQL Profile recommendations are not generated for SQL statements.
• D. Staleness and absence of statistics are not checked for the objects in the SQL Tuning Advisor.

Answer: B

Explanation: Topic 16, Space Management

NEW QUESTION 6
The writes the Flashback Database logs in the flash recovery area.

• A. FLSH
• B. FLDB
• C. RVWR
• D. RVRW
• E. FBDA

Answer: C

Explanation: RVWR (Recovery Writer Process), Writes flashback data to the flashback logs in the fast recovery area RVWR writes flashback data from the flashback buffer in the SGA to the flashback logs. RVWR also creates flashback logs and performs some tasks for flashback log automatic management. Existed in Database instance, Flashback Database
FBDA (Flashback Data Archiver Process), Archives historical rows for tracked tables into flashback data archives and manages archive space, organization, and retention
When a transaction that modifies a tracked table commits, FBDA stores the pre-image of the rows in the archive. FDBA maintains metadata on the current rows and tracks how much data has been archived.
FBDA is also responsible for automatically managing the flashback data archive for space, organization (partitioning tablespaces), and retention. FBDA also keeps track of how far the archiving of tracked transactions has progressed.
See Also: Oracle Database Advanced Application Developer's Guide Existed in Database and ASM instances

NEW QUESTION 7
You notice that a long-running transaction is suspended due to a space constraint, and there is no AFTER SUSPEND triggered event addressing the issue. You also note that the critical transaction is just about to reach the RESUMABLE_TIMEOUT value.
Which of these actions is appropriate?

• A. Abort the session, fix the space problem, then resubmit the transaction.
• B. Use the DBMS_RESUMABLE.SET_SESSION_TIMEOUT procedure to extend the time- out for the session while you fix the problem.
• C. Do nothing, let the transaction fail, then fix the problem.
• D. Use Segment Shrink to clean up the table.
• E. Use the DBMS_RESUMABLE.SET_TIMEOUT procedure to extend the time-out for the session while you fix the problem.

Answer: B

Explanation: Topic 17, Managing Resources

NEW QUESTION 8
Which of the following are true concerning block media recovery? (Choose all that apply.)

• A. Any gap in archive logs ends the recovery.
• B. If a gap in archive logs is encountered, RMAN will search forward for newer versions of the blocks that are not corrupt.
• C. Uncorrupted blocks from the flashback logs may be used to speed recovery.
• D. The database can be in NOARCHIVELOG mode.
• E. None of the above.

Answer: BC

Explanation: Overview of Block Media Recovery (link) Basic Concepts of Block Media Recovery
Whenever block corruption has been automatically detected, you can perform block media recovery manually with the RECOVER ... BLOCK command. By default, RMAN first searches for good blocks in the real-time query physical standby database, then flashback logs and then blocks in full or level 0 incremental backups.
Prerequisites for Block Media Recovery (link)
The following prerequisites apply to the RECOVER ... BLOCK command:
✑ The target database must run in ARCHIVELOG mode and be open or mounted with a current control file.
✑ If the target database is a standby database, then it must be in a consistent state,
recovery cannot be in session, and the backup must be older than the corrupted file.
✑ The backups of the data files containing the corrupt blocks must be full or level 0
backups and not proxy copies.
If only proxy copy backups exist, then you can restore them to a nondefault location on disk, in which case RMAN considers them data file copies and searches them for blocks during block media recovery.
✑ RMAN can use only archived redo logs for the recovery.
RMAN cannot use level 1 incremental backups. Block media recovery cannot survive a missing or inaccessible archived redo log, although it can sometimes survive missing redo records.
✑ Flashback Database must be enabled on the target database for RMAN to search
the flashback logs for good copies of corrupt blocks.
If flashback logging is enabled and contains older, uncorrupted versions of the corrupt blocks, then RMAN can use these blocks, possibly speeding up the recovery.
✑ The target database must be associated with a real-time query physical standby
database for RMAN to search the database for good copies of corrupt blocks.
Restore Failover (link)
RMAN automatically uses restore failover to skip corrupted or inaccessible backups and look for usable backups. When a backup is not found, or contains corrupt data, RMAN automatically looks for another backup from which to restore the desired files.

NEW QUESTION 9
Which of the following commands will perform an active database duplication of the ORCL database to the ORCL2 database?

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

Answer: E

NEW QUESTION 10
To manually configure the SGA components using Oracle Enterprise Manager Memory Advisor, you can set values for which of the following initialization parameters? (Choose all that apply.)

• A. DB_CACHE_SIZE
• B. SHARED_POOL_SIZE
• C. LARGE_POOL_SIZE
• D. JAVA_POOL_SIZE
• E. SGA_MAX_SIZE
• F. SORT_AREA_SIZE

Answer: ABCD

NEW QUESTION 11
Using Oracle Enterprise Manager to set SGA pool values manually, for which of the following pools does Oracle EM offer advice to set the value appropriately? (Choose all that apply.)

• A. DB_CACHE_SIZE
• B. SHARED_POOL_SIZE
• C. LARGE_POOL_SIZE
• D. JAVA_POOL_SIZE
• E. SGA_MAX_SIZE
• F. SORT_AREA_SIZE

Answer: AB

NEW QUESTION 12
You want to set the following initialization parameters for your database instance:
LOG_ARCHIVE_DEST_1 = 'LOCATION=/disk1/arch' LOG_ARCHIVE_DEST_2 = 'LOCATION=/disk2/arch' LOG_ARCHIVE_DEST_3 = 'LOACTION=/disk3/arch' LOG_ARCHIVE_DEST_4 = 'LOCATION=/disk4/arch MANDATORY'
Identify the statement that correctly describes this setting.

• A. The MANDATORY location must be a flash recovery area.
• B. The optional destinations may not use the flash recovery area.
• C. This setting is not allowed because the first destination is not set as MANDATORY.
• D. The online redo log file is not allowed to be overwritten if the archived log cannot be created in the fourth destination.

Answer: D

Explanation: MANDATORY
Specifies that filled online log files must be successfully archived to the destination before they can be reused.
If MANDATORY is not specified, then, by default, the destination is considered to be optional.
At least one destination must succeed, even if all destinations are optional. If archiving to an optional destination fails, the online redo log file is still available for reuse and may be overwritten eventually. However, if the archival operation of a mandatory destination fails, online redo log files cannot be overwritten.

NEW QUESTION 13
Note the following parameter settings: Which setting is NOT allowed?

• A. ALTER SYSTEM SET DB_CACHE_SIZE=50M;
• B. ALTER SYSTEM SET DB_8K_CACHE_SIZE=10M;
• C. ALTER SYSTEM SET DB_4K_CACHE_SIZE=10M;
• D. ALTER SYSTEM SET DB_16K_CACHE_SIZE=10M;

Answer: B

NEW QUESTION 14
What does the DB_FLASHBACK_RETENTION_TARGET parameter configure?

• A. An upper limit on how far you can flash back the database, depending on the information in the redo logs
• B. An upper limit on how far you can flash back the database, depending on theinformation in the undo tablespace
• C. The amount of time for which the flashback data is to be kept in the flash recovery area, provided that there is enough space
• D. The amount of time for which the flashback data is guaranteed to be kept in the undo tablespace, provided that there is enough space

Answer: C

NEW QUESTION 15
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?

• A. PLSQL_BLOCK
• B. JAVA_STORED_PROCEDURE
• C. STORED_PROCEDURE
• D. EXECUTABLE
• E. None of the above are invalid settings.

Answer: B

Explanation: job_type
Job action type ('PLSQL_BLOCK', 'STORED_PROCEDURE', 'EXECUTABLE', or 'CHAIN')

NEW QUESTION 16
To control the execution of a server process when it is receiving bad packets from a potentially malicious client, you set the SEC_PROTOCOL_ERROR_FURTHER_ACTION initialization parameter as follows:
SQL> ALTER SYSTEM SET SEC_PROTOCOL_ERROR_FURTHER_ACTION = Drop,10;
What is the significance of this setting?

• A. It terminates the client connection after 10 bad packets and the client cannot reconnect to the same instance.
• B. It terminates the client connection after 10 bad packets but the client can still reconnect, and attempt the same operation again.
• C. It terminates the client connection 10 seconds after receiving a bad packet and the client cannot reconnect to the same instance.
• D. It terminates the client connection after receiving a bad packet and the client can reconnect to the same instance after 10 minutes.

Answer: B

NEW QUESTION 17
A developer calls and reports that he accidentally dropped an important lookup table from a production database. He needs the table to be recovered. What action would you take?

• A. Initiate an incomplete recovery operation using RMAN.
• B. Copy the table from a development database.
• C. Advise the user to rekey the data.
• D. Perform a Flashback Drop operation.
• E. Perform a Flashback Recovery operation.

Answer: D

NEW QUESTION 18
What is the correct order of steps to perform an online database backup?
a: alter database begin backup; b: alter database end backup;
c: Back up the database datafiles. d: Back up the archive log files.
e: alter system switch logfile;

• A. a, b, c, d, e
• B. e, d, a, b, c
• C. a, c, b, d, e
• D. d, b, c, a, e
• E. a, c, b, e, d

Answer: E

Explanation: (link)
To back up online read/write tablespaces in an open database:
1. Use the DBA_DATA_FILES data dictionary view to identify all of the data files in the tablespace.
2. ALTER TABLESPACE users BEGIN BACKUP;
3. Back up the online data files of the online tablespace with operating system commands.
4. ALTER TABLESPACE users END BACKUP;
5. ALTER SYSTEM ARCHIVE LOG CURRENT; Archive the unarchived redo logs so that the redo required to recover the tablespace backup is archived.