D192 - Data Systems Administration | with full solution 2023/24

D192 - Data Systems Administration | with full solution 2023/24 To what does a data block correspond physically? - A specific number of bytes on disk Can a datafile span across more than one tablespace? - No How many data segments are contained in a partitioned table? - One for each partition Which type of tables contains only one data segment? - Nonclustered, non-index-organized tables What is the minimum number of extents required for a segment? - One Which four components comprise the logical structure of the database? - Tablespaces, segments, extents, and data blocks Can a segment span multiple data files? - Yes Can a segment span more than one tablespace? - No In the logical database structure hierarchy, is an extent above or below an Oracle block? - Above Which Oracle background process performs cleanup after a failed user process? - PMON - Process Monitor Which component of the Shared Global Area (SGA) contains the recently accessed data blocks that have been retrieved from the datafiles by user processes? - The database buffer cache Which component of the Shared Global Area (SGA) contains parsed SQL statements? - The library cache Which Oracle tool is used to back up, restore, and recover Oracle databases and datafiles? - RMAN - Recovery Manager After you issue the SHUTDOWN ABORT command, which background process is activated on the next startup? - SMON - System Monitor What contains the locations of other physical files, database name, database block size, database character set, and recovery information? These files are required to open the database. - Control files What are the physical files that actually store the data that has been inserted into each table in the database? - Data files An area in SGA that caches the database data, holding blocks from the data files that have been accessed recently. - Database buffer cache Writes the blocks in the redo log buffer of the SGA to the online redo log files. - Log writer A circular buffer in the SGA that holds information about the changes made to the database data. - Redo log buffer Consists of Oracle's main memory structure called the system global area (SGA, also known as the shared global area) and several Oracle background processes. - Oracle instance Version management maintains the integrity of your database as well as control schemas. It provides an interface to manage, safeguard, and replicate revisions of units