Home › Quizzes › Oracle Database Administration

Oracle Database Administration

Oracle Database architecture and administration concepts including memory structures (SGA, PGA), processes, tablespaces, redo logs, data dictionary, and Oracle Database editions

15 Questions Published
Play Quiz Practise this topic out loud

Questions

Question 1 Multiple Choice (Single Answer)

Which file contains user and system data?

  1. Control file
  2. Data file
  3. Online redo file
  4. Offline redo file
  5. Doc file
Question 2 Multiple Choice (Single Answer)

Which process is responsible for updating file headers in the database data files?

  1. The Log Writer Process
  2. The Database Writer Process
  3. The Checkpoint Process
  4. The Process Monitor Process
  5. The System Monitor Process
Question 3 Multiple Choice (Single Answer)

The dynamic performance view V$LOG contains information about

  1. all current redo logs
  2. redo log switches
  3. locations of redo log files
  1. Only 1
  2. Only 2
  3. Only 3
  4. 1 and 2
  5. 2 and 3
Question 4 Multiple Choice (Single Answer)

Which of the following contain(s) the information about all user objects in the database?

  1. Data dictionary
  2. Indexes
  3. Clusters
  4. System Global Area
  5. Library Cache
Question 5 Multiple Choice (Single Answer)

Which SGA database buffer is used to store different block sizes?

  1. Database buffer cache
  2. KEEP buffer pool
  3. RECYCLE buffer pool
  4. nK buffer cache
  5. Shared pool
Question 6 Multiple Choice (Single Answer)

Find the false statement about Oracle Database Grid Computing.

  1. It has high performance and scalability.
  2. It uses dynamic resources.
  3. It has continuous availability of data and applications.
  4. It has single administrator which cannot manage hundreds of servers.
  5. It has advanced integration features that allow applications and data to run anywhere in the network.
Question 7 Multiple Choice (Single Answer)

In order to parse SQL statements, the Oracle instance frequently accesses

  1. SGA
  2. PGA
  3. data dictionary
  4. views
  5. disk files
Question 8 Multiple Choice (Single Answer)

Among the following procedures, which one can be used for a locally managed system tablespace?

  1. TABLESPACE_MIGRATE_FROM_LOCAL
  2. TABLESPACE_MIGRATE_TO_LOCAL
  3. TABLESPACE_RELOCATE_BITMAPS
  4. TABLESPACE_FIX_BITMAPS
  5. TABLESPACE_REBUILD_BITMAPS
Question 9 Multiple Choice (Single Answer)

The PGA memory area of Oracle instance which holds the information about runtime-buffers is

  1. stack-space
  2. session-information
  3. private SQL-area
  4. sorting area
  5. strain area
Question 10 Multiple Choice (Single Answer)

In process architectures, which process gathers and stores Automatic Workload Repository data?

  1. MMAN
  2. MMON
  3. MMNL
  4. MMON Slaves
  5. PSWN
Question 11 Multiple Choice (Single Answer)

Which of the following files hold the transactional history of the Oracle database?

  1. Data and index files
  2. Online redo log files
  3. Temp files
  4. Archive log files
  5. Offline redo log files
Question 12 Multiple Choice (Single Answer)

Which schema(s) has/have the features of a privileged account?

  1. SYS schema
  2. SYSTEM schema
  3. OUTLN schema
  4. HR and OE schemas
  5. SCOTT schema
Question 13 Multiple Choice (Single Answer)

The Oracle RDBMS stores data logically in the form of

  1. data files
  2. tablespaces
  3. data segments
  4. extents
  5. data blocks
Question 14 Multiple Choice (Single Answer)

In version–numbering syntax of the Oracle Database release, what does the third number tell?

  1. Platform Specific Release Number
  2. Component Specific Release Number
  3. Major Database Release Number
  4. Database Maintenance Release Number
  5. Application Server Release Number
Question 15 Multiple Choice (Single Answer)

___________ is the Oracle edition which is specially designed and priced for small business purposes.

  1. Oracle Enterprise Edition
  2. Oracle Standard Edition
  3. Oracle Standard Edition One
  4. Oracle Express
  5. Java
← Back to Quizzes