Home › Quizzes › Oracle Database Architecture and Administration

Oracle Database Architecture and Administration

Test your knowledge of Oracle database memory structures, files, instance management, installation options, and administrative commands

25 Questions Published
Play Quiz Practise this topic out loud

Questions

Question 1 Multiple Choice (Single Answer)

Which of the following SGAs is the circular buffer that stores all changes made in database?

  1. Redo log buffer
  2. Database buffer cache
  3. Shared pool
  4. Streams pool
Question 2 Multiple Choice (Single Answer)

__________ is responsible for storing and reusing frequently used SQL statements, their execution plans and stored procedures.

  1. Library cache
  2. Data dictionary cache
  3. Background process
  4. None of these
Question 3 Multiple Choice (Single Answer)

Which of following files contain a record of all the changes made in database?

  1. Data files
  2. Control files
  3. Redo log files
  4. Password files
Question 4 Multiple Choice (Single Answer)

Which of the following will help you determine the memory size of Java pool initialization parameter?

  1. DB_BLOCK_SIZE
  2. SHARED_POOL_SIZE
  3. JAVA_POOL_SIZE
  4. LARGE_POOL_SIZE
Question 5 Multiple Choice (Single Answer)

____________ is used to hold the names of privileged users who have been granted SYSDBA and SYSOPER roles.

  1. Parameter file
  2. Password file
  3. Redo log file
  4. None of these
Question 6 Multiple Choice (Single Answer)

Which one of the following is used for handling large I/O requests of server processes?

  1. Shared pool
  2. Large pool
  3. Java pool
  4. Stream pool
Question 7 Multiple Choice (Single Answer)

Which of the following files contains data dictionary and user created data?

  1. Data file
  2. Redo log file
  3. Parameter file
  4. Control file
Question 8 Multiple Choice (Single Answer)

In which of the following stages can database administrator perform certain maintenance or administrative tasks?

  1. Instance creation
  2. Mounting the database
  3. Opening the database
  4. None of these
Question 9 Multiple Choice (Single Answer)

__________ STARTUP syntax option may be used for certain operations such as creating a database manually.

  1. MOUNT
  2. NOMOUNT
  3. READ ONLY
  4. None of these
Question 10 Multiple Choice (Single Answer)

Which Oracle9i database edition installer installs a pre-configured seed database, networking services and Oracle utilities?

  1. Enterprise edition
  2. Standard edition
  3. Personal edition
  4. None of these
Question 11 Multiple Choice (Single Answer)

__________ Oracle universal installer installs Real application clusters, but supports only a single user development and deployment environment.

  1. Custom
  2. Standard edition
  3. Personal edition
  4. None of these
Question 12 Multiple Choice (Single Answer)

Which of the following is the collection of memory structures and Oracle background processes that operate aganist an Oracle database?

  1. Database
  2. Instance
  3. Tablespace
  4. None of these
Question 13 Multiple Choice (Single Answer)

Which Oracle9i client installer installs networking services and support files?

  1. Administration
  2. Runtime
  3. Custom
  4. Standard
Question 14 Multiple Choice (Single Answer)

__________ is a logical grouping of database objects, usually to facilitate security, performance, or the availability of database objects such as tables and indexes.

  1. Segment
  2. Tablespace
  3. Extent
  4. Schema
Question 15 Multiple Choice (Single Answer)

Which of the following database files facilitate the Oracle mechanism to recover from an instance failure or a media failure?

  1. Data files
  2. Redo log files
  3. Control files
  4. None of these
Question 16 Multiple Choice (Single Answer)

Which of the following is the group of objects associated with a particular user account, such as tables, indexes, functions and so forth?

  1. Database block
  2. Schema
  3. Segment
  4. None of these
Question 17 Multiple Choice (Single Answer)

Which of the following database files contain(s) all the information of the database save or retreive using SELECT and other DML statements?

  1. Data files
  2. Data dictionary
  3. Database blocks
  4. Control files
Question 18 Multiple Choice (Single Answer)

____________ in Oracle tells that the subtype methods will override the subtype's methods.

  1. OVERRIDING
  2. FINAL
  3. NOT INSTANTIABLE
  4. None of these
Question 19 Multiple Choice (Single Answer)

In Oracle, which of the following maintains a set of tables and views that are used as a read only reference about the database?

  1. Tablespace
  2. Physical structure
  3. Data dictionary
  4. None of these
Question 20 Multiple Choice (Single Answer)

____________________ tells Oracle that this method is not available in the subtype.

  1. OVERRIDING
  2. FINAL
  3. NOT INSTANTIABLE
  4. None of these
Question 21 Multiple Choice (Single Answer)

Calling programs may invoke _________ on objects that have been instantiated.

  1. member method
  2. static method
  3. constructor method
  4. none of these
Question 22 Multiple Choice (Single Answer)

If no method is declared, which of the following methods is defaultly declared and allows calling program to create new object types?

  1. Member methods
  2. Constructor method
  3. Comparison methods
  4. None of these
Question 23 Multiple Choice (Single Answer)

When the database is shutdown in ____________ mode, the Oracle server automatically rolls back all currently active transactions.

  1. transactional
  2. immediate
  3. abort
  4. none of these
Question 24 Multiple Choice (Single Answer)

If the database is shutdown, in which of the following Shutdown modes does an instance recovery need not be done during the subsequent startup?

  1. NORMAL
  2. IMMEDIATE
  3. TRANSACTIONAL
  4. ABORT
Question 25 Multiple Choice (Single Answer)

For which one of the following can STARTUP command option be used if you wish to perform some kind of maintainance on the database such as export and import?

  1. FORCE
  2. MOUNT
  3. RESTRICTED SESSION
  4. RECOVER
← Back to Quizzes