Data Systems Administration - D192
complete questions and reviewed
answers 100% correct
14. D. The LRU mechanism ensures that each user's server process can find free space in the
shared pool and database buffer cache whenever they need it, but it also keeps frequently used
objects cached in those memory areas. - answer ✔✔-The LRU algorithm is used to manage
what part of the Oracle architecture?
18. B. During an incremental database checkpoint, the control file is updated with the
checkpoint position; data files are not updated. Data file headers are updated with checkpoint
information by the DBW n process when dirty buffers are written to the files. During threaded
checkpoint or full database checkpoint, all file headers are updated. This happens during a
normal shutdown as well as during online log switch. - answer ✔✔-18. When an incremental
checkpoint happens in a database, which file(s) are updated with the checkpoint position?
Choose all options that are correct.
shows the full path of the trace directory location. - answer ✔✔-BACKGROUND_DUMP_DEST
11. A. The block size of the database cannot be changed after database creation. The database
name can be changed after the control file is re-created with a new name, and the
CONTROL_FILES parameter can be changed after the control files are copied to the new
location. - answer ✔✔-11. Which initialization parameter cannot be changed after the database
is created?
,When creating a new database or creating a control file, the database should be in the
NOMOUNT state. - answer ✔✔-NOMOUNT
The catalog.sql script creates the data dictionary views, dynamic performance views, and
synonyms. - answer ✔✔-12. Which script creates the database dictionary?
A spfile is another term for a server-side binary file that Oracle reads when a database startup is
performed. This binary file contains all the nondefault initialization parameters used at startup. -
answer ✔✔-SPFILE
Bigfile tablespaces can have only a single data file. The traditional or smallfile tablespace can
have many data files - answer ✔✔-bigfile tablespace
11. A. You can use the ALTER TABLESPACE command to rename a file that belongs to the
tablespace, but all other file-management operations are done through the ALTER DATABASE
command. To enable autoextension, use ALTER DATABASE DATAFILE AUTOEXTEND ON NEXT
MAXSIZE . - answer ✔✔-11. Which command is used to enable the autoextensible feature for a
file if the file is already part of a tablespace?
The data files belonging to the SYSTEM tablespace can be renamed when the database is in the
MOUNT state by using the ALTER DATABASE RENAME FILE statement. - answer ✔✔-SYSTEM
Tablespace
OEM Cloud Control and DBMS_SERVER_ALERT.SET_ THRESHOLD can be used to set the
threshold for tablespaces.
B. Use Oracle Enterprise Manager Cloud Control.
C. Use DBMS_SERVER_ALERT package. - answer ✔✔-The default critical threshold for a
tablespace is set at 97 percent, and you think that is too low. Which two options can you use to
change the threshold value to 90 percent for tablespace APPS_DATA ?
, ROWID includes the data object number, relative file number where the block is stored, the
block number in the file, and the row number. - answer ✔✔-ROWID
Locks are resolved at the user level by either committing or rolling back the transaction holding
the lock. Also, the DBA can kill the session holding the lock as a last resort. - answer ✔✔-Locks
Undo information is required for instance recovery but only to roll back uncommitted
transactions after the online redo logs roll forward. The redo is used for roll forward, and undo
is used to roll back uncommitted transactions.
Undo segments are always owned by SYS . - answer ✔✔-undo
The LREG process notifies the listener after a client connection is established. This is so that the
listener can keep track of the number of connections being serviced by each dispatcher. -
answer ✔✔-What is the process that notifies the listener after a database connection is
established?
Automatic Database Diagnostic Monitor. A tool that generates performance-tuning reports
based on snapshots in the AWR. - answer ✔✔-ADDM
Automatic Diagnostic Repository. Default location for the alert log, trace files, and other
information useful for fault finding.
ADRCI The ADR command-line interface - answer ✔✔-ADR
Background processes that perform extent movement between disks in an Automatic Storage
Management (ASM) disk group. - answer ✔✔-ARBn
Automatic Workload Repository. A set of tables in the SYSAUX tablespace, populated with
tuning data gathered by the MMON process. - answer ✔✔-AWR
complete questions and reviewed
answers 100% correct
14. D. The LRU mechanism ensures that each user's server process can find free space in the
shared pool and database buffer cache whenever they need it, but it also keeps frequently used
objects cached in those memory areas. - answer ✔✔-The LRU algorithm is used to manage
what part of the Oracle architecture?
18. B. During an incremental database checkpoint, the control file is updated with the
checkpoint position; data files are not updated. Data file headers are updated with checkpoint
information by the DBW n process when dirty buffers are written to the files. During threaded
checkpoint or full database checkpoint, all file headers are updated. This happens during a
normal shutdown as well as during online log switch. - answer ✔✔-18. When an incremental
checkpoint happens in a database, which file(s) are updated with the checkpoint position?
Choose all options that are correct.
shows the full path of the trace directory location. - answer ✔✔-BACKGROUND_DUMP_DEST
11. A. The block size of the database cannot be changed after database creation. The database
name can be changed after the control file is re-created with a new name, and the
CONTROL_FILES parameter can be changed after the control files are copied to the new
location. - answer ✔✔-11. Which initialization parameter cannot be changed after the database
is created?
,When creating a new database or creating a control file, the database should be in the
NOMOUNT state. - answer ✔✔-NOMOUNT
The catalog.sql script creates the data dictionary views, dynamic performance views, and
synonyms. - answer ✔✔-12. Which script creates the database dictionary?
A spfile is another term for a server-side binary file that Oracle reads when a database startup is
performed. This binary file contains all the nondefault initialization parameters used at startup. -
answer ✔✔-SPFILE
Bigfile tablespaces can have only a single data file. The traditional or smallfile tablespace can
have many data files - answer ✔✔-bigfile tablespace
11. A. You can use the ALTER TABLESPACE command to rename a file that belongs to the
tablespace, but all other file-management operations are done through the ALTER DATABASE
command. To enable autoextension, use ALTER DATABASE DATAFILE AUTOEXTEND ON NEXT
MAXSIZE . - answer ✔✔-11. Which command is used to enable the autoextensible feature for a
file if the file is already part of a tablespace?
The data files belonging to the SYSTEM tablespace can be renamed when the database is in the
MOUNT state by using the ALTER DATABASE RENAME FILE statement. - answer ✔✔-SYSTEM
Tablespace
OEM Cloud Control and DBMS_SERVER_ALERT.SET_ THRESHOLD can be used to set the
threshold for tablespaces.
B. Use Oracle Enterprise Manager Cloud Control.
C. Use DBMS_SERVER_ALERT package. - answer ✔✔-The default critical threshold for a
tablespace is set at 97 percent, and you think that is too low. Which two options can you use to
change the threshold value to 90 percent for tablespace APPS_DATA ?
, ROWID includes the data object number, relative file number where the block is stored, the
block number in the file, and the row number. - answer ✔✔-ROWID
Locks are resolved at the user level by either committing or rolling back the transaction holding
the lock. Also, the DBA can kill the session holding the lock as a last resort. - answer ✔✔-Locks
Undo information is required for instance recovery but only to roll back uncommitted
transactions after the online redo logs roll forward. The redo is used for roll forward, and undo
is used to roll back uncommitted transactions.
Undo segments are always owned by SYS . - answer ✔✔-undo
The LREG process notifies the listener after a client connection is established. This is so that the
listener can keep track of the number of connections being serviced by each dispatcher. -
answer ✔✔-What is the process that notifies the listener after a database connection is
established?
Automatic Database Diagnostic Monitor. A tool that generates performance-tuning reports
based on snapshots in the AWR. - answer ✔✔-ADDM
Automatic Diagnostic Repository. Default location for the alert log, trace files, and other
information useful for fault finding.
ADRCI The ADR command-line interface - answer ✔✔-ADR
Background processes that perform extent movement between disks in an Automatic Storage
Management (ASM) disk group. - answer ✔✔-ARBn
Automatic Workload Repository. A set of tables in the SYSAUX tablespace, populated with
tuning data gathered by the MMON process. - answer ✔✔-AWR
