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.  Privileges are assigned to users through ________________

1. DBA
2. Role
3. Table
4. Dictionary

2.  When a user process fails, what background process cleans up after it?

1. PCLEAN
2. PFAIL
3. PMON
4. Both a and c

 
3.   PFILE is simply a text based file

1. False
2. True

 
4.   In which of the files below are database parameters stored?

1. PFILE
2. SPFILE
3. PARFILE
4. Both a and b

 
5.   Each tablespace in an Oracle database consists of one or more files called

1. Files
2. name space
3. datafiles
4. PFILE

 
6.   The ______________ records all changes made to data

1. Redo log
2. Archive log
3. Both a and b
4. Data file

 
 
7.   When a transaction modifies the database, Oracle copies the original data before modifying it. The original copy of the modified data is called

1. Undone Data
2. Archive data
3. Redo data
4. Undo data

 
8.   What is the purpose of SMON background process?

1. Performs crash recovery when a failed instance starts up again
2. Performs recovery when a user process fails
3. Both a and b
4. Writes redo log entries to disk

 
9.  When an Oracle database is created, which user is automatically created and granted the DBA role

1. SYS
2. SYSTEM
3. SGA
4. Both a and b

 
10.  Which schema object instructs Oracle to connect to a remotely access an object of a database?

1. Sequence
2. Remote link
3. Database link
4. Data link

11.  To create a ____________________ backup, the database must have been shut down normally

1. Consistent
2. Inconsistent
3. Hot
4. Soft