WGU D192 DATA SYSTEMS ADMINISTRATION 2024 UPDATE
COMPLETE QUESTIONS AND DETAILED ANSWERS (100%
CORRECT)
Which clause of the CREATE DATABASE statement will create a default permanent
table space for the database? - (correct answer) The DEFAULT TABLESPACE
clause
What does the SET DEFAULT TABLESPACE clause of the CREATE DATABASE
statement specify? - (correct answer) The default type of table space that will be
created with a CREATE TABLESPACE statement if neither SMALLFILE nor BIGFILE is
specified
Which clause in the CREATE TABLESPACE statement specifies that all the extents in a
locally managed tablespace must be of the same size? - (correct answer) The
UNIFORM SIZE clause
To what does a data block correspond physically? - (correct answer) A specific
number of bytes on disk
Can a datafile span across more than one tablespace? - (correct answer) No
How many data segments are contained in a partitioned table? - (correct answer)
One for each partition
Which type of tables contains only one data segment? - (correct answer)
Nonclustered, non-index-organized tables
What is the minimum number of extents required for a segment? - (correct answer)
One
Which four components comprise the logical structure of the database? - (correct
answer) Tablespaces, segments, extents, and data blocks
Can a segment span multiple data files? - (correct answer) Yes
Can a segment span more than one tablespace? - (correct answer) No
In the logical database structure hierarchy, is an extent above or below an Oracle
block? - (correct answer) Above
Which Oracle background process performs cleanup after a failed user process? -
(correct 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? - (correct
answer) The database buffer cache
Which component of the Shared Global Area (SGA) contains parsed SQL statements? -
(correct answer) The library cache
Which Oracle tool is used to back up, restore, and recover Oracle databases and
datafiles? - (correct answer) RMAN - Recovery Manager
After you issue the SHUTDOWN ABORT command, which background process is
activated on the next startup? - (correct 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. - (correct answer) Control files
What are the physical files that actually store the data that has been inserted into each
table in the database? - (correct answer) Data files
An area in SGA that caches the database data, holding blocks from the data files that
have been accessed recently. - (correct answer) Database buffer cache
Writes the blocks in the redo log buffer of the SGA to the online redo log files. -
(correct answer) Log writer
A circular buffer in the SGA that holds information about the changes made to the
database data. - (correct answer) 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. -
(correct answer) 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
of work. - (correct answer) Version Management
An element mapping structure is the abstract mapping structure that describes a
storage component within the I/O stack. - (correct answer) Element mapping
structure
Which of the following ODI Studio navigators manages and monitors data integration
processes in production? - (correct answer) Operator
Question 3 :Which of the following tools enables you to create, manage, and monitor
CDBs and PDBs? - (correct answer) SQL*Plus
, Which of the following primary structures is known as the abstract mapping structure? -
(correct answer) Elements
Which of the following provides an interface to manage, safeguard, and replicate
revisions of units of work? - (correct answer) Version Management
Which of the following components is related to the physical storage structure? -
(correct answer) Data File
How to display the connection name - (correct answer) 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
Enter the password.
In the SQL Plus window, execute the following command to display the current
container's name:
Copy show con_name;
In the SQL Plus window, execute the following command to display the name of the
pluggable database and id of the container to which the data pertains:
Copy select name, con_id from v$pdbs;
Important: In the SQL Plus window, execute the following command to close the
window: Copy exit
Displaying Information About the Active Services in the Database - (correct answer)
From the desktop, open SQL Plus.
Connect to the database by entering the following details:
user-name: sys as sysdba
Enter the password.
In the SQL Plus window, use the select statement to display the name of the active
service of the container having the id 3 from v$active_services.
Statement: select name from v$active_services where con_id=3;
Execute the exit statement after running the query.
What is the format for the default name of the text alert log file in a database? -
(correct answer) alert_sid.log
Which text file will contain information about the last checkpoint that occurred in a
database? - (correct answer) The alert log file
What will be the consequences on the database buffers and redo log buffers when you
issue the SHUTDOWN ABORT command? - (correct answer) The database buffers
and redo log buffers are not written to the disk.
COMPLETE QUESTIONS AND DETAILED ANSWERS (100%
CORRECT)
Which clause of the CREATE DATABASE statement will create a default permanent
table space for the database? - (correct answer) The DEFAULT TABLESPACE
clause
What does the SET DEFAULT TABLESPACE clause of the CREATE DATABASE
statement specify? - (correct answer) The default type of table space that will be
created with a CREATE TABLESPACE statement if neither SMALLFILE nor BIGFILE is
specified
Which clause in the CREATE TABLESPACE statement specifies that all the extents in a
locally managed tablespace must be of the same size? - (correct answer) The
UNIFORM SIZE clause
To what does a data block correspond physically? - (correct answer) A specific
number of bytes on disk
Can a datafile span across more than one tablespace? - (correct answer) No
How many data segments are contained in a partitioned table? - (correct answer)
One for each partition
Which type of tables contains only one data segment? - (correct answer)
Nonclustered, non-index-organized tables
What is the minimum number of extents required for a segment? - (correct answer)
One
Which four components comprise the logical structure of the database? - (correct
answer) Tablespaces, segments, extents, and data blocks
Can a segment span multiple data files? - (correct answer) Yes
Can a segment span more than one tablespace? - (correct answer) No
In the logical database structure hierarchy, is an extent above or below an Oracle
block? - (correct answer) Above
Which Oracle background process performs cleanup after a failed user process? -
(correct 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? - (correct
answer) The database buffer cache
Which component of the Shared Global Area (SGA) contains parsed SQL statements? -
(correct answer) The library cache
Which Oracle tool is used to back up, restore, and recover Oracle databases and
datafiles? - (correct answer) RMAN - Recovery Manager
After you issue the SHUTDOWN ABORT command, which background process is
activated on the next startup? - (correct 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. - (correct answer) Control files
What are the physical files that actually store the data that has been inserted into each
table in the database? - (correct answer) Data files
An area in SGA that caches the database data, holding blocks from the data files that
have been accessed recently. - (correct answer) Database buffer cache
Writes the blocks in the redo log buffer of the SGA to the online redo log files. -
(correct answer) Log writer
A circular buffer in the SGA that holds information about the changes made to the
database data. - (correct answer) 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. -
(correct answer) 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
of work. - (correct answer) Version Management
An element mapping structure is the abstract mapping structure that describes a
storage component within the I/O stack. - (correct answer) Element mapping
structure
Which of the following ODI Studio navigators manages and monitors data integration
processes in production? - (correct answer) Operator
Question 3 :Which of the following tools enables you to create, manage, and monitor
CDBs and PDBs? - (correct answer) SQL*Plus
, Which of the following primary structures is known as the abstract mapping structure? -
(correct answer) Elements
Which of the following provides an interface to manage, safeguard, and replicate
revisions of units of work? - (correct answer) Version Management
Which of the following components is related to the physical storage structure? -
(correct answer) Data File
How to display the connection name - (correct answer) 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
Enter the password.
In the SQL Plus window, execute the following command to display the current
container's name:
Copy show con_name;
In the SQL Plus window, execute the following command to display the name of the
pluggable database and id of the container to which the data pertains:
Copy select name, con_id from v$pdbs;
Important: In the SQL Plus window, execute the following command to close the
window: Copy exit
Displaying Information About the Active Services in the Database - (correct answer)
From the desktop, open SQL Plus.
Connect to the database by entering the following details:
user-name: sys as sysdba
Enter the password.
In the SQL Plus window, use the select statement to display the name of the active
service of the container having the id 3 from v$active_services.
Statement: select name from v$active_services where con_id=3;
Execute the exit statement after running the query.
What is the format for the default name of the text alert log file in a database? -
(correct answer) alert_sid.log
Which text file will contain information about the last checkpoint that occurred in a
database? - (correct answer) The alert log file
What will be the consequences on the database buffers and redo log buffers when you
issue the SHUTDOWN ABORT command? - (correct answer) The database buffers
and redo log buffers are not written to the disk.
