Free Access to Oracle.1Z0-083.v2022-09-01.q174 with Valid Practice Test (Page 25)

Choose three. Which three are true about corrupted data blocks and their recovery in an Oracle Database?

A.The ANALYZE TABLE VALIDATE STRUCTURE CASCADE command verifies that each table row has an index entry pointing to it.
B.A media corrupt block is one where the block is not formatted correctly.
C.If a row lock is held by a nonexistent transaction, the block containing the row is media corrupt.
D.DB_LOST_WRITE_PROTECT=TYPICAL causes extra logging overhead on the standby database.
E.DB_BLOCK_CHECKING=TRUE causes a check sum to be added to each data block to help detect physical or media corruption.
F.If a row lock is held by a nonexistent transaction, the block containing the row is logically corrupt.

Which three are performed by Oracle Automatic Storage Management (ASM) instances? (Choose three.)

A.mounting disk groups
B.managing Allocation Units (AUs) for disk group content
C.acting as an I/O server to write data file blocks to ASM disks on behalf of Database Writer processes (DBWn)
D.acting as an I/O server to read data file blocks from ASM disks on behalf of database server processes
E.managing space allocation for Oracle ASM files
F.managing extent allocation for Oracle database segments

Which three are true about the SQL Tuning Advisor? (Choose three.)

A.It checks each query being analyzed for stale statistics.
B.It checks each query being analyzed for missing statistics.
C.It only recommends syntactic changes to SQL statements.
D.It can recommend semantic changes to SQL statements.
E.It considers all SQL statements being analyzed by the advisor task as a group.
F.It builds SQL profiles for each poorly performing SQL statement to prevent regressions.

Which two are true about an RPM-based Oracle Database installation? (Choose two.)

A.It uses a service configuration script to create a single-instance database as part of the installation.
B.It includes the Oracle Preinstallation RPM.
C.From Oracle Database 18c, a single RPM can be used to install only Oracle Database Server for a single instance.
D.It performs a software-only Oracle Database installation.
E.It requires an Unbreakable Linux Network (ULN) subscription.

Which two are true about Oracle Flashback features? (Choose two.)

A.FLASHBACK VERSION QUERY can retrieve REDO records from ONLINE and ARCHIVED REDO LOG files.
B.FLASHBACK TABLE can undrop a column.
C.After a database is restored from flashback logs using the FLASHBACK DATABASE command, it is sometimes rolled forward using redo logs.
D.FLASHBACK QUERY can retrieve REDO records from ONLINE and ARCHIVED REDO LOG files.
E.FLASHBACK DROP can undrop an index when undropping a table.

Download PDF File