Home › Quizzes › Oracle Database

Oracle Database

Oracle Database architecture covering memory components (SGA/PGA), logical storage structures, and database files.

15 Questions Published
Play Quiz Practise this topic out loud

Questions

Question 1 Multiple Choice (Single Answer)

Which of the following memory components of the SGA stores all the changes made in the database?

  1. Streams pool
  2. SQL work area
  3. Redo log buffer
  4. Instance creation
  5. Read only
Question 2 Multiple Choice (Single Answer)

Which of the following contents of the program global area contains bind information and runtime memory structures?

  1. Private SQL area
  2. SQL work area
  3. Stream pool
  4. Extent
  5. Mounting the database
Question 3 Multiple Choice (Single Answer)

Which of the following is a centralized container where the data is stored?

  1. Oracle instance
  2. Extent
  3. Instance creation
  4. Oracle database
  5. Read only
Question 4 Multiple Choice (Single Answer)

The contents of which of the following memory components of the system global area are shared by multiple users?

  1. Stream pool
  2. Shared pool
  3. Instance creation
  4. SQL work area
  5. Force
Question 5 Multiple Choice (Single Answer)

Which of the following logical storage structures is usually to facilitate security, performance or the availability of database objects such as tables and indexes?

  1. Extent
  2. Oracle instance
  3. Tablespace
  4. Mounting the database
  5. Archive files
Question 6 Multiple Choice (Single Answer)

Which of the following memory components of the system global area holds all the blocks read in from disk for query or modification?

  1. Stream pool
  2. SQL work area
  3. Archive file
  4. Mounting the database
  5. Database buffer cache
Question 7 Multiple Choice (Single Answer)

Which of the following is made up of an Oracle instance and Oracle database?

  1. Oracle instance
  2. Oracle server
  3. Archives files
  4. Stream pool
  5. pfile
Question 8 Multiple Choice (Single Answer)

Which of the following memory components of the system global area is used for handling large input/output requests of server processes?

  1. SQL work area
  2. Instance creation
  3. Read only
  4. Large pool
  5. Stream pool
Question 9 Multiple Choice (Single Answer)

Which of the following files maintains the timestamp of database creation?

  1. Archive file
  2. Parameter file
  3. Control file
  4. Instance creation
  5. Read only
Question 10 Multiple Choice (Single Answer)

Which of the following memory components of the program global area holds a session's variables and session-related information?

  1. Session memory
  2. SQL work area
  3. Stream pool
  4. Instance creation
  5. ABORT
Question 11 Multiple Choice (Single Answer)

Which of the following is a good way to group objects in the database for purpose of security and access control?

  1. Schema
  2. Extent
  3. Oracle instance
  4. Parameter file
  5. Force
Question 12 Multiple Choice (Single Answer)

Which of the following logical storage structures is a collection of extents allocated for a single type of object such as a table?

  1. Extent
  2. Oracle instance
  3. Archive file
  4. Registration
  5. Segment
Question 13 Multiple Choice (Single Answer)

Which of the following memory components of the system global area is responsible for storing and reusing frequently used SQL statements, their execution plans and stored procedures?

  1. Stream pool
  2. Library cache
  3. SQL work area
  4. Instance creation
  5. pfile
Question 14 Multiple Choice (Single Answer)

Which of the following logical storage structures is the lowest unit of allocation in an oracle database?

  1. Data files
  2. Database block
  3. Extent
  4. Instance creation
  5. Stream pool
Question 15 Multiple Choice (Single Answer)

Which of the following memory components of the system global area is used by all session-specific java code and data within the JVM?

  1. Java applet
  2. Java pool
  3. Stream pool
  4. SQL work area
  5. Mounting the database
← Back to Quizzes