Oracle 1Z0-053 Exam Questions 2021

NEW QUESTION 1
What are the different logging modes available in Oracle Database 11g? (Choose two.)

• A. NOLOG mode
• B. NOARCHIVELOG mode
• C. LOGGING mode
• D. HOTDATABASE mode
• E. ARCHIVELOG mode

Answer: BE

NEW QUESTION 2
Which type of backup contains only the blocks that have changed since the last level 0 incremental backup?

• A. a cumulative level 1 backup
• B. a differential level 1 backup
• C. a full backup
• D. a whole backup

Answer: A

NEW QUESTION 3
Which type of database file is spread across all disks in a disk group?

• A. All types of files are spread across all disks in the disk group.
• B. Datafiles
• C. Redo log files
• D. Archived redo log files
• E. Control files

Answer: A

NEW QUESTION 4
What command would you use to set a persistent setting in RMAN so that backups are all written to a tape device?

• A. CONFIGURE DEFAULT DEVICE TYPE TO TAPE MEDIA
• B. CONFIGURE DEFAULT DEVICE TYPE TO TAPE
• C. CONFIGURE DEFAULT DEVICE TYPE TO SBT
• D. CONFIGURE DEFAULT DEVICE TYPE TO SBT_TAPE

Answer: C

Explanation: SBT_TAPE is incorrect, it should be SBT TAPE, without underline strike.

NEW QUESTION 5
Which statements are true regarding system-partitioned tables? (Choose all that apply.)

• A. Only a single partitioning key column can be specified.
• B. All DML statements must use partition-extended syntax.
• C. The same physical attributes must be specified for each partition.
• D. Unique local indexes cannot be created on a system-partitioned table.
• E. Traditional partition pruning and partitionwise joins are not supported on these tables.

Answer: DE

NEW QUESTION 6
View the Exhibit and examine the Data Pump architecture. Identify the numbered components.
Exhibit:

• A. 1 - Oracle Loader, 2 - Oracle Data Pump, 3 - Direct Path API
• B. 1 - Oracle Data Pump, 2 - Direct Path API, 3 - Oracle Loader
• C. 1 - Direct Path API, 2 - Oracle Loader, 3 - Oracle Data Pump
• D. 1 - Oracle Loader, 2 - Direct Path API, 3 - Oracle Data Pump

Answer: A

NEW QUESTION 7
The database users regularly complain about the difficulty in performing transactions. On investigation, you find that some users perform long-running transactions that consume huge amounts of space in the undo tablespace, which caused the problem. You want to control the usage of the undo tablespace only for these user sessions and you do not want these sessions to perform long-running operations.
How would you achieve this?

• A. Implement a profile for the users.
• B. Implement external roles for the users.
• C. Set the threshold for the undo tablespace.
• D. Implement a Database Resource Manager plan.

Answer: B

NEW QUESTION 8
Which statement describes the information returned by the DBMS_SPACE.SPACE_USAGE procedure for LOB space usage?

• A. It returns space usage of only BasicFile LOB chunks.
• B. It returns space usage of only SecureFile LOB chunks.
• C. It returns both BasicFile and SecureFile LOB space usage for only nonpartitioned tables.
• D. It returns both BasicFile and SecureFile LOB space usage for both partitioned and nonpartitioned tables.

Answer: B

Explanation: SPACE_USAGE Procedures
The first form of the procedure shows the space usage of data blocks under the segment High Water Mark. You can calculate usage for LOBs, LOB PARTITIONS and LOB SUBPARTITIONS. This procedure can only be used on tablespaces that are created with auto segment space management. The bitmap blocks, segment header, and extent map blocks are not accounted for by this procedure. Note that this overload cannot be used on SECUREFILE LOBs.

C:UsersalboDesktop1-1.jpg
The second form of the procedure returns information about SECUREFILE LOB space usage. It will return the amount of space in blocks being used by all the SECUREFILE LOBs in the LOB segment. The procedure displays the space actively used by the LOB column, freed space that has retention expired, and freed space that has retention unexpired. Note that this overload can be used only on SECUREFILE LOBs.

C:UsersalboDesktop1-1.jpg

NEW QUESTION 9
You need to maintain a record of all transactions on some tables for at least three years. Automatic undo management is enabled for the database.
What must you do accomplish this task?

• A. Enable supplemental logging for the database.
• B. Specify undo retention guarantee for the database
• C. Create Flashback Data Archive in the tablespace where the tables are stored.
• D. Create Flashback Data Archive and enable Flashback Data Archive for specific tables

Answer: D

NEW QUESTION 10
Your database is running in ARCHIVELOG mode, and the database is open. You execute an RMAN backup and specify the KEEP clause.
Which components are backed up when this option is specified?

• A. only the control file, the current SPFILE, and data files
• B. only the current SPFILE and data files if autobackup is disabled
• C. only the data files and the archived redo logs
• D. the control file, current SPFILE file, data files, and archived redo logs

Answer: D

NEW QUESTION 11
A database has three online redo log groups with one member each. A redo log member with the status ACTIVE is damages while the database is running.
What is the first step you should take to solve this problem?

• A. Attempt to Issue a checkpoint.
• B. Restart the database using the RESETLOGS option.
• C. Drop the redo log number and create it in a different location.
• D. Perform and incomplete recovery up to the most recent available redo log.

Answer: A

Explanation: Recovering After Losing All Members of an Online Redo Log Group
If a media failure damages all members of an online redo log group, then different scenarios can occur depending on the type of online redo log group affected by the failure and the archiving mode of the database. If the damaged online redo log group is current and active, then it is needed for crash recovery; otherwise, it is not.
Recovering After the Loss of an Online Redo Log Group Inactive
It is not needed for crash recovery Clear the archived or unarchived group. Active
It is needed for crash recovery Attempt to issue a checkpoint and clear the log; if impossible, then you must either use Flashback Database or restore a backup and perform incomplete recovery up to the most recent available redo log.
Current
It is the redo log that the database is currently writing to Attempt to clear the log; if impossible, then you must either use Flashback Database or restore a backup and perform incomplete recovery up to the most recent available redo log.

NEW QUESTION 12
Which tasks can be accomplished using the DBMS_LOB.SETOPTIONS procedure?

• A. only encryption and compression settings for all SecureFile LOBs
• B. only encryption and deduplication settings for only SecureFile CLOBs
• C. deduplication, encryption, and compression settings for all SecureFile LOBs
• D. deduplication, encryption, and compression settings only for SecureFile CLOBs

Answer: C

Explanation: Refer to here.
DBMS_LOB.SETOPTIONS()
This procedure sets compression, deduplication and encryption features. It enables the features to be set on a per-LOB basis, overriding the default LOB settings. This call incurs a round trip to the server to make the changes persistent.

NEW QUESTION 13
Which statement is true regarding the VALIDATE DATABASE command?

• A. It checks the database for intrablock corruptions only.
• B. It checks for block corruption in the valid backups of the database.
• C. It checks the database for both intrablock and interblock corruptions.
• D. It checks for only those corrupted blocks that are associated with data files.

Answer: A

Explanation: interblock corruption
A type of block corruption in which the corruption occurs between blocks rather than within the block itself. This type of corruption can only be logical corruption.
intrablock corruption A type of block corruption in which the corruption occurs within the block itself. this type of corruption can be either a physical corruption or logical corruption.

NEW QUESTION 14
Which operation requires that you create an auxiliary instance manually before executing the operation? (Choose all that apply.)

• A. Backup-based database duplication.
• B. Active database duplication.
• C. Tablespace point-in-time recovery.
• D. No operation requires the creation of an auxiliary instance.

Answer: AB

NEW QUESTION 15
You need to perform a block media recovery on the tools01.dbf data file in the SALES database by using Recovery Manager (RMAN).
Which two are the prerequisites to perform this operation? (Choose two)

• A. You must configure block change tracking file
• B. You must have first level 1 backups for RMAN to restore blocks
• C. You must ensure that the SALES database is mounted or open
• D. You must have full or level 0 backups for RMAN to restore blocks
• E. You must take the tools01.dbf data file offline before you start a block media recovery

Answer: CD

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

NEW QUESTION 16
View Exhibit1 to examine the CRS11G disk group when all the disks are online. View Exhibit2 to examine the CRS11G disk group when one disk is offline.
Why is the rebalancing not performed and the content of the disk group not empty in Exhibit2?
ASM-disk-group-1 (exhibit):

ASM-disk-group-2 (exhibit):

• A. Because the disk group is created with NORMAL redundancy
• B. Because the disk repair time attribute is set to a nonzero value
• C. Because the mirrored extents cannot be rebalanced across the other three disks
• D. Because the other three disks have 60% free space, the disk rebalancing is delayed

Answer: B

Explanation: Key points:
1. The COMPATIBILITY.ASM>=11.1 and COMPATIBILITY.RDBMS>=11.1
2. The DISK_REPAIR_TIME is set to non-zero. by default it is 3.6hr. Refer to here.
Note: To use this feature, the disk group compatibility attributes must be set to 11.1 or higher. For more information, refer to "Disk Group Compatibility".
Oracle ASM fast resync keeps track of pending changes to extents on an OFFLINE disk during an outage. The extents are resynced when the disk is brought back online.
By default, Oracle ASM drops a disk in 3.6 hours after it is taken offline. You can set the DISK_REPAIR_TIME disk group attribute to delay the drop operation by specifying a time interval to repair the disk and bring it back online.

NEW QUESTION 17
Which three statements are true regarding persistent lightweight jobs? (Choose three.)

• A. Persistent lightweight jobs modify several tables in the data dictionary to generate a lot of redo.
• B. The user cannot set privileges on persistent lightweight jobs.
• C. Persistent lightweight jobs are useful when users need to create a large number of jobs in a short time.
• D. Persistent lightweight jobs are useful when users need to create a small number of jobs that run infrequently.
• E. The use of a template is mandatory to create persistent lightweight jobs.

Answer: BCE