2.7. Review Questions

  1. You need to start up the iSQL*Plus server. Which of the following commands do you use?

    1. isqlplus startup

    2. isqlplusctl startup

    3. isqlplusctl start

    4. sqlplus start

  2. You need to find the directory where the Oracle alert log is being written. Which initialization parameter contains this information?

    1. ALERT_LOG_DEST

    2. BACKGROUND_DUMP_DEST

    3. LOG_DESTINATION

    4. INIT_LOG_DUMP_DEST

  3. An Oracle application server is an example of what component in the Oracle Enterprise Management Framework?

    1. Managed targets

    2. Application Entity

    3. Destination

    4. Background Object

    5. None of the above

  4. You need to start up the Enterprise Manager Grid Control facility. Which command should you use?

    1. agctl start agent

    2. emctl startup agent

    3. agctl enable agent

    4. emctl startup framework

    5. emctl start agent

  5. All the following are functional areas within the Oracle Enterprise Management Framework except which?

    1. Repository Agent

    2. Management Services

    3. Database Control

    4. Oracle Management Repository

    5. Managed targets

  6. You want to view the EMP table structure from within the iSQL*Plus interface. Which command produces the desired output?

    1. DEFINE EMP

    2. SHOW EMP

    3. DESCRIBE EMP

    4. DISPLAY EMP

  7. All the following are database management options within the Database Configuration Assistant except which?

    1. Change Database Initialization Parameters

    2. Create A Database

    3. Manage Templates

    4. Delete A Database

  8. Which of the following is another term for the fully qualified name of a database?

    1. ORACLE SID

    2. Global Database Name

    3. Global identifier

    4. Oracle global name

    5. ORACLE ID

  9. Which of the following Oracle accounts is not automatically configured by the DBCA?

    1. SYS

    2. SYSTEM

    3. SYSMAN

    4. DBSNMP

    5. All the above accounts are configured automatically by DBCA.

  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?

    1. File system storage

    2. Oracle managed storage

    3. Raw devices

    4. Defined storage

    5. None of the above

  11. Which new Oracle 10g feature provides a centralized location to maintain and manage all the files related to database backups?

    1. Archive logging

    2. Automated Storage Management

    3. Flash Recovery

    4. Data Guard

  12. Which of the following best describes seed templates?

    1. DBCA template definitions that contain database definition information and the actual datafiles and redo log files

    2. DBCA template definitions that contain database definition information only

    3. DBCA template definitions that contain database definition information and the actual datafiles

    4. DBCA template definitions that contain database definition information redo log file and control file definitions

    5. None of the above

  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?

    1. The associated predefined redo logs and datafiles for nonseed templates

    2. The associated predefined redo logs and datafiles for seed templates

    3. The associated predefined redo logs and control files for seed templates

    4. The associated predefined redo logs and control files for nonseed templates

  14. Which of the following is not a valid Create A Database Template option in the DBCA?

    1. From An Existing Template

    2. From An Existing Database And Don't Copy The Data

    3. From An Existing Database And Copy The Structure And Data

    4. From An Existing Template And Copy The Structure And Data

  15. Which of the following startup options does not perform a database recovery?

    1. STARTUP

    2. STARTUP FORCE RESTRICT

    3. STARTUP NOMOUNT

    4. STARTUP OPEN

    5. STARTUP RESTRICT

  16. Which of the following shutdown statements does not perform a clean shutdown?

    1. SHUTDOWN ABORT

    2. SHUTDOWN TRANSACTIONAL

    3. SHUTDOWN

    4. SHUTDOWN IMMEDIATE

    5. All the above are considered clean shutdowns.

  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?

    1. STARTUP NOMOUNT RESTRICT

    2. STARTUP RESTRICT

    3. STARTUP MOUNT RESTRICT

    4. STARTUP MOUNT FORCE RESTRICT

  18. You want to start up the database using a binary initialization file. What is another name for this file?

    1. CONFIGFILE

    2. PFILE

    3. SPFILE

    4. init_pfile.ora

  19. Under normal circumstances, which of the following actions or events is not found in the Oracle alert log?

    1. Database startup and shutdown information

    2. Nondefault initialization parameters

    3. ORA-00600 errors

    4. New columns added to a user table

  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?

    1. $ORACLE_HOME/bin/portlist.ini

    2. $ORACLE_HOME/rdbms/admin/portlist.ini

    3. $ORACLE_HOME/install/portlist.ini

    4. $ORACLE_HOME/bin/portlist.ini

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset