D192 - Data Systems Administration Questions and Answers Solved 100% Correct

To what does a data block correspond physically? - ANSWER-A specific number of bytes on disk Can a datafile span across more than one tablespace? - ANSWER-No How many data segments are contained in a partitioned table? - ANSWER-One for each partition Which type of tables contains only one data segment? - ANSWER-Nonclustered, non-index-organized tables What is the minimum number of extents required for a segment? - ANSWER-One Which four components comprise the logical structure of the database? - ANSWER-Tablespaces, segments, extents, and data blocks Can a segment span multiple data files? - ANSWER-Yes Can a segment span more than one tablespace? - ANSWER-No In the logical database structure hierarchy, is an extent above or below an Oracle block? - ANSWER-Above Which Oracle background process performs cleanup after a failed user process? - ANSWER-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? - ANSWER-The database buffer cache Which component of the Shared Global Area (SGA) contains parsed SQL statements? - ANSWER-The library cache Which Oracle tool is used to back up, restore, and recover Oracle databases and datafiles? - ANSWER-RMAN - Recovery Manager After you issue the SHUTDOWN ABORT command, which background process is activated on the next startup? - ANSWER-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. - ANSWER-Control files