You need to find the directory where the Oracle alert log is being written. Which initialization parameter contains this information?
ALERT_LOG_DEST
BACKGROUND_DUMP_DEST
LOG_DESTINATION
INIT_LOG_DUMP_DEST
An Oracle application server is an example of what component in the Oracle Enterprise Management Framework?
Managed targets
Application Entity
Destination
Background Object
None of the above
You need to start up the Enterprise Manager Grid Control facility. Which command should you use?
agctl start agent
emctl startup agent
agctl enable agent
emctl startup framework
emctl start agent
All the following are functional areas within the Oracle Enterprise Management Framework except which?
Repository Agent
Management Services
Database Control
Oracle Management Repository
Managed targets
You want to view the EMP table structure from within the iSQL*Plus interface. Which command produces the desired output?
DEFINE EMP
SHOW EMP
DESCRIBE EMP
DISPLAY EMP
All the following are database management options within the Database Configuration Assistant except which?
Change Database Initialization Parameters
Create A Database
Manage Templates
Delete A Database
Which of the following is another term for the fully qualified name of a database?
ORACLE SID
Global Database Name
Global identifier
Oracle global name
ORACLE ID
Which of the following Oracle accounts is not automatically configured by the DBCA?
SYS
SYSTEM
SYSMAN
DBSNMP
All the above accounts are configured automatically by DBCA.
You have worked with your systems administrator to set up predefined disk partitions dedicated to and controlled by Oracle for meeting your database storage requirements. What is another name for this type of storage?
File system storage
Oracle managed storage
Raw devices
Defined storage
None of the above
Which new Oracle 10g feature provides a centralized location to maintain and manage all the files related to database backups?
Archive logging
Automated Storage Management
Flash Recovery
Data Guard
Which of the following best describes seed templates?
DBCA template definitions that contain database definition information and the actual datafiles and redo log files
DBCA template definitions that contain database definition information only
DBCA template definitions that contain database definition information and the actual datafiles
DBCA template definitions that contain database definition information redo log file and control file definitions
None of the above
You find a file on disk that has a .DJF extension. What type of information would you expect to be stored in the file?
The associated predefined redo logs and datafiles for nonseed templates
The associated predefined redo logs and datafiles for seed templates
The associated predefined redo logs and control files for seed templates
The associated predefined redo logs and control files for nonseed templates
Which of the following is not a valid Create A Database Template option in the DBCA?
From An Existing Template
From An Existing Database And Don't Copy The Data
From An Existing Database And Copy The Structure And Data
From An Existing Template And Copy The Structure And Data
Which of the following startup options does not perform a database recovery?
STARTUP
STARTUP FORCE RESTRICT
STARTUP NOMOUNT
STARTUP OPEN
STARTUP RESTRICT
Which of the following shutdown statements does not perform a clean shutdown?
SHUTDOWN ABORT
SHUTDOWN TRANSACTIONAL
SHUTDOWN
SHUTDOWN IMMEDIATE
All the above are considered clean shutdowns.
You would like to export the system and limit access to only the DBA staff during the export process. Which of the following startup options should you use?
STARTUP NOMOUNT RESTRICT
STARTUP RESTRICT
STARTUP MOUNT RESTRICT
STARTUP MOUNT FORCE RESTRICT
You want to start up the database using a binary initialization file. What is another name for this file?
CONFIGFILE
PFILE
SPFILE
init_pfile.ora
Under normal circumstances, which of the following actions or events is not found in the Oracle alert log?
Database startup and shutdown information
Nondefault initialization parameters
ORA-00600 errors
New columns added to a user table
On your Unix database server, you have installed and configured a database using the DBCA. You need to find out what ports are being used for the various Oracle tools. Where would you find this information?
$ORACLE_HOME/bin/portlist.ini
$ORACLE_HOME/rdbms/admin/portlist.ini
$ORACLE_HOME/install/portlist.ini
$ORACLE_HOME/bin/portlist.ini