Vivid 1Z0-053 Practice Test 2021

NEW QUESTION 1
Which of the following is not a configurable attribute for an individual disk group?

• A. AU_SIZE
• B. COMPATIBLE.RDBMS
• C. COMPATIBLE.ASM
• D. DISK_REPAIR_TIME
• E. DG_DROP_TIME

Answer: E

Explanation: DG_DROP_TIME is an invalid DG attribute. Disk Group Attributes
The DISK_REPAIR_TIME disk group attribute specifies how long a disk remains offline
before ASM drops the disk.
The COMPATIBLE.ASM attribute determines the minimum software version for an ASM instance that uses the disk group.
The COMPATIBLE.RDBMS attribute determines the minimum COMPATIBLE database initialization parameter setting for any database instance that uses the disk group.
The AU_SIZE attribute determines the allocation unit size of the disk group. The values can be 1, 2, 4, 8, 16, 32, and 64 MB.

NEW QUESTION 2
Which of the following advisors is run in every maintenance window by the auto-task system?

• A. The Memory Advisor
• B. The SQL Tuning Advisor
• C. The Undo Advisor
• D. The SQL Access Advisor

Answer: B

Explanation: About Automated Maintenance Tasks (link)
Oracle Database has three predefined automated maintenance tasks:
✑ Automatic Optimizer Statistics Collection
✑ Automatic Segment Advisor
✑ Automatic SQL Tuning Advisor
By default, all three automated maintenance tasks are configured to run in all maintenance windows.

NEW QUESTION 3
If a backup is expired, which of the following is true?

• A. It can never be used for a restore/recover operation.
• B. Oracle will remove the backup set pieces from the flash recovery area.
• C. The backup has been used at least once to restore and recover the database.
• D. The backup is no longer valid because of a resetlogs operation.
• E. The physical backup set pieces are missing from the media.

Answer: E

NEW QUESTION 4
You have a database with the following tablespaces: SYSTEM, SYSAUX, UNDO, USERS, TEMP. You want to"roll back" the data in the USERS tablespace to the way it looked yesterday.
Which tablespaces do you need to perform a point-in-time restore operation on in order to complete this task? (Choose all that apply.)

• A. SYSTEM
• B. SYSAUX
• C. UNDO
• D. USERS
• E. TEMP
• F. This restore is not possible.

Answer: ABCD

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
Users are connected to a database instance that is using Automatic Storage Management (ASM). The DBA executes the command as follows to shut down the ASM instance:
SQL> SHUTDOWN IMMEDIATE;
What happens to the database instance?

• A. It shuts down long with the ASM instance.
• B. It is aborted and the ASM instance shuts down normally.
• C. It stays open and SHUTDOWN command for the ASM instance fails.
• D. It shuts down only after all pending transactions are completed and the ASM instance waits for this before shutting down.

Answer: C

Explanation: IMMEDIATE or TRANSACTIONAL Clause (link)
Oracle ASM waits for any in-progress SQL to complete before performing an orderly dismount of all of the disk groups and shutting down the Oracle ASM instance. Oracle ASM does not wait for users currently connected to the instance to disconnect. If any database instances are connected to the Oracle ASM instance, then the SHUTDOWN command returns an error and leaves the Oracle ASM instance running. Because the Oracle ASM instance does not contain any transactions, the TRANSACTIONAL mode behaves the same as IMMEDIATE mode.

NEW QUESTION 7
Archived redo logs can be copied to more than one destination by Oracle.

• A. True
• B. False

Answer: A

NEW QUESTION 8
In what view are you likely to see the following output?

• A. V$SESSION_EVENT
• B. V$SESSION
• C. V$WAITS
• D. V$WAITSTAT
• E. V$SYSSTAT

Answer: B

NEW QUESTION 9
A schedule defined entirely within the confines of a Scheduler job object is known as a (n) .

• A. Fixed schedule
• B. Inline schedule
• C. Stored schedule
• D. Hard-coded schedule
• E. None of the above

Answer: B

Explanation: “A schedule defined within a job object is know as an inline schedule, where as an independent schedule object is referred to as a stored schedule. Inline schedules cannot be reference by any other objects. ” http://www.datadisk.co.uk/html_docs/oracle/scheduler.htm

NEW QUESTION 10
Which three statements correctly describe the features of the I/O calibration process? (Choose three.)

• A. Only one I/O calibration process can run at a time.
• B. It automates the resource allocation for the Automated Maintenance Tasks.
• C. It improves the performance of the performance-critical sessions while running.
• D. It can be used to estimate the maximum number of I/Os and maximum latency time for the system.
• E. The latency time is computed only when the TIMED_STATISTICS initialization parameter is set to TRUE.

Answer: ADE

NEW QUESTION 11
What will be the result of the following configuration?
Log_archive_dest_1 = 'location=c:oraclearchmydb' Log_archive_dest_2 = 'location=z:oraclearchmydb'

• A. An error will occur during database startup because the second parameter is not valid.
• B. An error will occur during database startup since you are trying to create archived redo logs in two different locations.
• C. Archived redo logs will be created in two different locations by the ARCH process.
• D. Archived redo logs will be created in two different locations by the LGWR process.
• E. Neither parameter setting is valid, so the database will not start up.

Answer: C

NEW QUESTION 12
Performance divergence indicated in the Workload Replay report is most likely due to what?

• A. DML and SQL statement results that do not match between the capture and replay systems
• B. When errors that occur in the capture system don't occur in the replay system
• C. Top SQL statements
• D. Infrastructure or system-configuration differences
• E. Time-of-day differences between capture and replay systems

Answer: D

NEW QUESTION 13
Which of the following are included in a transportable tablespace set? (Choose all that apply.)

• A. The datafiles that make up a self-contained group of tablespaces required for copy
• B. The system tablespace
• C. An export of the tablespace metadata
• D. The spfile
• E. All of the above

Answer: AC

NEW QUESTION 14
Which view shows all valid values for the NLS_LANGUAGE, NLS_SORT, NLS_TERRITORY, and NLS_CHARACTERSET parameters?

• A. V$VALID_NLS_VALUES
• B. NLS_VALID_VALUES
• C. NLS_VALUE_OPTIONS
• D. V$NLS_VALUE_OPTIONS
• E. V$NLS_VALID_VALUES

Answer: E

NEW QUESTION 15
You want to create the Recovery Manager (RMAN) Virtual Private Catalog (VPC) to maintain a separation of responsibilities along with a consolidation of RMAN repository.
Which condition must be met before you create the VPC?

• A. A base catalog exists
• B. The recovery catalog is empty
• C. The base recovery catalog must be dropped
• D. A target database is registered in the recovery catalog

Answer: A

NEW QUESTION 16
Which two statements are true about encrypting RMAN backup? (Choose two.)

• A. The transparent encryption of backups uses the encryption wallet
• B. The database uses the same encryption key for every encrypted backup
• C. The password encryption of backups only uses the password while creating and restoring backup

Answer: AC

NEW QUESTION 17
What will be the end result of this set of RMAN commands?
shutdown abort startup mount
restore datafile 4 until time '09/30/2008:15:00:00'; recover datafile 4 until time '09/29/2008:15:00:00'; alter database open resetlogs;

• A. Datafile 4 will be recovered until 9/30/2008 at 15:00 and the database will open.
• B. The restore command will fail.
• C. The recover command will fail.
• D. The alter database open resetlogs command will fail.
• E. All these commands will fail because they must be in the confines of a run block.

Answer: D

Explanation: Pay attention on the difference between two timestamps.

NEW QUESTION 18
Before a Flashback Table operation, you execute the following command: ALTER TABLE employees ENABLE ROW MOVEMENT;
Why would you need this to be executed?

• A. Because row IDs may change during the flashback operation
• B. Because the object number changes after the flashback operation
• C. Because the rows are retrieved from the recycle bin during the flashback operation
• D. Because the table is moved forward and back to a temporary during the flashback opertion

Answer: A