=======================================
Review Questions
1. You need to start up the iSQL*Plus server. Which of the following
commands do you use?
A. isqlplus startup
B. isqlplusctl startup
C. isqlplusctl start
D. sqlplus start
--
Ans: C.
To use the iSQL*Plus tool, you need to start the iSQL*Plus server.
Connect to the location
where the server is going to be started, get to a command prompt, and
type isqlplusctl start. In
a Windows environment, you can start the associated service to perform
the same task.
2. You need to find the directory where the Oracle alert log is being
written. Which initialization
parameter contains this information?
A. ALERT_LOG_DEST
B. BACKGROUND_DUMP_DEST
C. LOG_DESTINATION
D. INIT_LOG_DUMP_DEST
---
Ans: B.
BACKGROUND_DUMP_DEST is the initialization parameter that determines
where the Oracle
alert log is written. This is a directory path designation.
3. An Oracle application server is an example of what component in the
Oracle Enterprise Management
Framework?
A. Managed targets
B. Application Entity
C. Destination
D. Background Object
E. None of the above
---
Ans: A.
In the Oracle Enterprise Management Framework, managed targets can be
administered
using the Enterprise Manager. Application servers are one example of a
managed target. Other
examples include databases, web servers, applications, and Oracle
agents.
4. You need to start up the Enterprise Manager Grid Control facility.
Which command should
you use?
A. agctl start agent
B. emctl startup agent
C. agctl enable agent
D. emctl startup framework
E. emctl start agent
---
Ans: E.
To use the Grid Control facility, you must start the associated agent
process.
This process can be started from a command-line prompt using the emctl
start agent command.
In a Windows environment, you can start the agent by starting the
appropriate service.
5. All the following are functional areas within the Oracle Enterprise
Management Framework
except which?
A. Repository Agent
B. Management Services
C. Database Control
D. Oracle Management Repository
E. Managed targets
--
Ans: A.
Management Services, Database Control, Oracle Management Repository, and
managed targets
are functional areas of the Oracle Enterprise Management Framework.
6. You want to view the EMP table structure from within the iSQL*Plus
interface. Which command
produces the desired output?
A. DEFINE EMP
B. SHOW EMP
C. DESCRIBE EMP
D. DISPLAY EMP
---
Ans: C.
You can use the DESCRIBE command within SQL*Plus and iSQL*Plus to
display the structure
of a table or a view. This information includes the column name, column
width, datatype,
and whether the column allows null values.
7. All the following are database management options within the Database
Configuration Assistant
except which?
A. Change Database Initialization Parameters
B. Create A Database
C. Manage Templates
D. Delete A Database
---
ANs: A. The Database Configuration Assistant lets you create databases,
manage templates, add
database options, and delete databases. Although you can change
initialization parameters
when you are defining a database, this is not one of the management
options available.
8. Which of the following is another term for the fully qualified name
of a database?
A. ORACLE SID
B. Global Database Name
C. Global identifier
D. Oracle global name
E. ORACLE ID
---
Ans: B.
The Global Database Name is another term for the fully qualified name of
a database. The
global database name is composed of the database name and database
domain.
9. Which of the following Oracle accounts is not automatically
configured by the DBCA?
A. SYS
B. SYSTEM
C. SYSMAN
D. DBSNMP
E. All the above accounts are configured automatically by DBCA.
---
Ans: E.
The DBCA creates the SYS, SYSTEM, SYSMAN, and DBSNMP accounts by
default. You can lock
the accounts and set the initial password.
10. 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?
A. File system storage
B. Oracle managed storage
C. Raw devices
D. Defined storage
E. None of the above
---
Ans: C.
Raw devices are disk partitions set up as special devices and managed by
Oracle. The underlying
operating system does not control the reading or writing of information
to these special
areas of disk.
11. Which new Oracle 10g feature provides a centralized location to
maintain and manage all the
files related to database backups?
A. Archive logging
B. Automated Storage Management
C. Flash Recovery
D. Data Guard
---
Ans: C.
The Flash Recovery feature is designed to ease configuration and
administration of all aspects
of Oracle backup and recovery. It predefines a location of disk to
centrally store files that Oracle
will use in case database recovery is needed.
12. Which of the following best describes seed templates?
A. DBCA template definitions that contain database definition
information and the actual
datafiles and redo log files
B. DBCA template definitions that contain database definition
information only
C. DBCA template definitions that contain database definition
information and the actual
datafiles
D. DBCA template definitions that contain database definition
information redo log file and
control file definitions
E. None of the above
---
ANS. A.
Seed templates are template definitions that contain database definition
information and the
actual datafiles and redo log files. Nonseed templates contain the
database definition but don't
contain the actual datafiles and redo log files.
13. You find a file on disk that has a .DJF extension. What type of
information would you expect
to be stored in the file?
A. The associated predefined redo logs and datafiles for nonseed
templates
B. The associated predefined redo logs and datafiles for seed templates
C. The associated predefined redo logs and control files for seed
templates
D. The associated predefined redo logs and control files for nonseed
templates
--
ANS: B.
Files that have a .DJF extension contain the predefined redo logs and
datafiles for seed templates.
14. Which of the following is not a valid Create A Database Template
option in the DBCA?
A. From An Existing Template
B. From An Existing Database And Don't Copy The Data
C. From An Existing Database And Copy The Structure And Data
D. From An Existing Template And Copy The Structure And Data
----
Ans: D. From the Template Management screen of the DBCA, you can create
a new template from an
existing template, create a new template from an existing database and
copy the structure only,
and create a new template from an existing database, copying the
structure and the data. You cannot
create a new template from an existing template and copy structure and
data.
15. Which of the following startup options does not perform a database
recovery?
A. STARTUP
B. STARTUP FORCE RESTRICT
C. STARTUP NOMOUNT
D. STARTUP OPEN
E. STARTUP RESTRICT
----
Ans: C.
Recovery of a database occurs when the database moves from the MOUNT
mode to the OPEN
mode. All these options attempt to start up and open the database except
for option C, which
only puts the database in NOMOUNT mode.
16. Which of the following shutdown statements does not perform a clean
shutdown?
A. SHUTDOWN ABORT
B. SHUTDOWN TRANSACTIONAL
C. SHUTDOWN
D. SHUTDOWN IMMEDIATE
E. All the above are considered clean shutdowns.
----
Ans: A.
Any time you perform a SHUTDOWN ABORT, Oracle does not perform a clean
shutdown. All
other types of shutdowns are considered clean shutdowns because Oracle
will not have to perform
recovery on a subsequent database startup.
17. 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?
A. STARTUP NOMOUNT RESTRICT
B. STARTUP RESTRICT
C. STARTUP MOUNT RESTRICT
D. STARTUP MOUNT FORCE RESTRICT
Ans: B.
The STARTUP RESTRICT choice opens the database and allows only users
with RESTRICTED
database access to connect and use it.
18. You want to start up the database using a binary initialization
file. What is another name for
this file?
A. CONFIGFILE
B. PFILE
C. SPFILE
D. init_pfile.ora
Ans: C.
The 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.
19. Under normal circumstances, which of the following actions or events
is not found in the Oracle
alert log?
A. Database startup and shutdown information
B. Nondefault initialization parameters
C. ORA-00600 errors
D. New columns added to a user table
---
Ans: The Oracle alert log contains a chronological history of
administrative events and actions
and certain types of database errors that occur within the database.
Adding a column to a user
table is not an administrative action and is not recorded in the alert
log.
20. 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?
A. $ORACLE_HOME/bin/portlist.ini
B. $ORACLE_HOME/rdbms/admin/portlist.ini
C. $ORACLE_HOME/install/portlist.ini
D. $ORACLE_HOME/bin/portlist.ini
---
Ans
C. The $ORACLE_HOME/install/portlist.ini file contains information about
what ports are
being used by the various Oracle tools.
No comments:
Post a Comment