WGU DI 92 - DATA SYSTEMS
ADMINISTRATION EXAM
QUESTIONS AND ANSWERS
GRADED A+ LATEST
UPDATE
To what does a data block correspond physically?: A specific number of
bytes on disk
2. Can a datafile span across more than one tablespace?: No
3. How many data segments are contained in a partitioned table?: One for
each partition
1/32
,4. Which type of tables contains only one data segment?: Nonclustered, non-
index-organized tables
5. What is the minimum number of extents required for a segment?: One
6. Which four components comprise the logical structure of the
database?: -
Tablespaces, segments, extents, and data blocks
7. Can a segment span multiple data files?: Yes
8. Can a segment span more than one tablespace?: No
9. In the logical database structure hierarchy, is an extent above or below
an Oracle block?: Above
10. Which Oracle background process performs cleanup after a failed
user process?: PMON - Process Monitor
1 1 . 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
12. Which component of the Shared Global Area (SGA) contains parsed
SQL statements?: The library cache
13. Which Oracle tool is used to back up, restore, and recover Oracle
databases and datafiles?: RMAN - Recovery Manager
14. After you issue the SHUTDOWN ABORT command, which background
process is activated on the next startup?: SMON - System Monitor
,15. 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
16. What are the physical files that actually store the data that has been
inserted into each table in the database?: Data files
17. An area in SGA that caches the database data, holding blocks from the
2/ 29
data files that have been accessed recently.: Database buffer cache
18. Writes the blocks in the redo log buffer of the SGA to the online redo log
files.: Log writer
19. A circular buffer in the SGA that holds information about the changes
made to the database data.: Redo log buffer
20. 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
3/32
, 21 . 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 of work.: Version Management
22. An element mapping structure is the abstract mapping structure that
describes a storage component within the I/O stack.: Element mapping
structure
23. Which of the following ODI Studio navigators manages and monitors
data integration processes in production?: Operator
24. Question 3 :Which of the following tools enables you to create, manage,
and monitor CDBs and PDBs?: SQL*Plus
25. Which of the following primary structures is known as the abstract
mapping structure?: Elements
26. Which of the following provides an interface to manage, safeguard,
and replicate revisions of units of work?: Version Management
27. Which of the following components is related to the physical storage
structure?: Data File
28. How to display the connection name: From the desktop, double-click the SQL
Plus icon.
In the SQL Plus window, type the following details and press Enter after typing each
detail:
Enter user-name: sys as sysdba
4/ 29
Enter the password.
ADMINISTRATION EXAM
QUESTIONS AND ANSWERS
GRADED A+ LATEST
UPDATE
To what does a data block correspond physically?: A specific number of
bytes on disk
2. Can a datafile span across more than one tablespace?: No
3. How many data segments are contained in a partitioned table?: One for
each partition
1/32
,4. Which type of tables contains only one data segment?: Nonclustered, non-
index-organized tables
5. What is the minimum number of extents required for a segment?: One
6. Which four components comprise the logical structure of the
database?: -
Tablespaces, segments, extents, and data blocks
7. Can a segment span multiple data files?: Yes
8. Can a segment span more than one tablespace?: No
9. In the logical database structure hierarchy, is an extent above or below
an Oracle block?: Above
10. Which Oracle background process performs cleanup after a failed
user process?: PMON - Process Monitor
1 1 . 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
12. Which component of the Shared Global Area (SGA) contains parsed
SQL statements?: The library cache
13. Which Oracle tool is used to back up, restore, and recover Oracle
databases and datafiles?: RMAN - Recovery Manager
14. After you issue the SHUTDOWN ABORT command, which background
process is activated on the next startup?: SMON - System Monitor
,15. 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
16. What are the physical files that actually store the data that has been
inserted into each table in the database?: Data files
17. An area in SGA that caches the database data, holding blocks from the
2/ 29
data files that have been accessed recently.: Database buffer cache
18. Writes the blocks in the redo log buffer of the SGA to the online redo log
files.: Log writer
19. A circular buffer in the SGA that holds information about the changes
made to the database data.: Redo log buffer
20. 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
3/32
, 21 . 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 of work.: Version Management
22. An element mapping structure is the abstract mapping structure that
describes a storage component within the I/O stack.: Element mapping
structure
23. Which of the following ODI Studio navigators manages and monitors
data integration processes in production?: Operator
24. Question 3 :Which of the following tools enables you to create, manage,
and monitor CDBs and PDBs?: SQL*Plus
25. Which of the following primary structures is known as the abstract
mapping structure?: Elements
26. Which of the following provides an interface to manage, safeguard,
and replicate revisions of units of work?: Version Management
27. Which of the following components is related to the physical storage
structure?: Data File
28. How to display the connection name: From the desktop, double-click the SQL
Plus icon.
In the SQL Plus window, type the following details and press Enter after typing each
detail:
Enter user-name: sys as sysdba
4/ 29
Enter the password.
