Oracle Admin Quiz

 



Oracle Admin Quiz contain set of 10 MCQ questions for Oracle Admin MCQ which will help you to clear beginner level quiz.



1.      Which of the following background processes is used for coalescing free extents, in case dictionary managed tablespaces are used?

• 1. Process Monitor
  2. Checkpoint
  3. Log Writer
  4. System Monitor

 
2.      Which of the following is a middle tier component of the Oracle Enterprise Manager (OEM) that is the core of the OEM framework?

• 1. Console
  2. Oracle Management Server (OMS)
  3. Intelligent Agent
  4. Database Server

 
3.      Which of the following initialization parameters sets the Alert file and Background Trace file locations?

• 1. DB_CREATE_FILE_DEST
  2. DB_BACKGROUND_DUMP_DEST
  3. USER_DUMP_DEST
  4. BACKGROUND_DUMP_DEST

 
4.      Which two parameters can be set to tell the Oracle to use OMF (Oracle Managed Files)?

• 1. DB_CREATE_FILE_DEST
  2. BACKGROUND_DUMP_DUST
  3. USER_DUMP_DEST
  4. LOG_ARCHIVE_DEST

 
5.      Which of the following functions does the catalog.sql script perform? (Choose two)

• 1. It creates data dictionary views and synonyms.
  2. It creates the base tables.
  3. It creates PL/SQL packages to extend database functionality.
  4. It starts other scripts that create objects for export/import.

 
 
6.      The size of the Control File does not depend upon which of the following parameters?

• 1. MAXINSTANCES
  2. MAXLOGFILES
  3. MAXLOGMEMBERS
  4. MAXLOGHISTORY

 
7.      Which of the following commands is used to reinitialize online redo log groups?

• 1. ALTER DATABASE CLEAR LOGFILE
  2. ALTER DATABASE DROP LOGFILE
  3. ALTER DATABASE RESET LOGFILE
  4. ALTER DATABASE ADD LOGFILE

 
8.      Which of the following clauses may use a Temporary Tablespace? (Choose two)

• 1. UNION ALL clause
  2. SELECT DISTINCT Clause
  3. INNER JOIN
  4. D.GROUP BY clause

 
9.      Increasing the value of which of the following parameters can control row migration in blocks?

• 1. PCTUSED
  2. PCTFREE
  3. INITRANS
  4. MAXTRANS

 
10.  Which of the following is the correct syntax for creating an UNDO tablespace?

• 1. CREATE TABLESPACE undotbs DATAFILE ‘/disk1/undo.dbf’ SIZE 100 M
  2. CREATE TABLESPACE undotbs DATAFILE ‘/disk1/undo.dbf’ SIZE 100 M UNDO
  3. CREATE UNDO TABLESPACE undotbs DATAFILE ‘/disk1/undo.dbf’ SIZE 100 M
  4. CREATE UNDOTABLESPACE undotbs DATAFILE ‘/disk1/undo.dbf’ SIZE 100 M