Home › Quizzes › Oracle

Oracle

Introduction to Oracle Database architecture, startup/shutdown procedures, database files, and logical structures

15 Questions Published
Play Quiz Practise this topic out loud

Questions

Question 1 Multiple Choice (Single Answer)

Which of the following consists of all the files, structures, processes that form oracle database 9i?

  1. Oracle instance
  2. Redo log buffer
  3. Oracle server
  4. Stream pool
  5. Mounting the database
Question 2 Multiple Choice (Single Answer)

In which of the following options of STARTUP command are DML statements not allowed in the database?

  1. RECOVER
  2. PFILE
  3. ABORT
  4. Mounting the database
  5. READ ONLY
Question 3 Multiple Choice (Single Answer)

In which of the following options of SHUTDOWN command is a checkpoint performed on all the databases and the files are closed?

  1. ABORT
  2. IMMEDIATE
  3. FORCE
  4. NORMAL
  5. Password file
Question 4 Multiple Choice (Single Answer)

Which of the following files holds attributes and their values, however any change to a attribute's values requires you to bounce or restart the database?

  1. Parameter file
  2. Password file
  3. Instance creation
  4. Redo log buffer
  5. Stream pool
Question 5 Multiple Choice (Single Answer)

Which of the following holds control information necessary to keep the database functioning?

  1. Password file
  2. Control file
  3. Instance creation
  4. PFILE
  5. Stream pool
Question 6 Multiple Choice (Single Answer)

Which of the following files contain(s) the data dictionary and user created data?

  1. Password files
  2. Data files
  3. Instance creation
  4. Redo log buffer
  5. SQL work area
Question 7 Multiple Choice (Single Answer)

Which of the following has a physical structure that is visible to the operating system made up of operating system made up of operating system files and a logical structure that is recognized only the oracle server?

  1. Oracle database
  2. Oracle instance
  3. Redo log buffer
  4. SQL work area
  5. Mounting the database
Question 8 Multiple Choice (Single Answer)

Which of the following options of STARTUP can be used if you wish to perform some kind of maintenance on the database such as an export and import?

  1. RECOVER
  2. FORCE
  3. RESTRICTED SESSION
  4. ABORT
  5. Java pool
Question 9 Multiple Choice (Single Answer)

In which of the following options of SHUTDOWN command, when a user's transaction completes, the user is automatically disconnected?

  1. IMMEDIATE
  2. ABORT
  3. FORCE
  4. TRANSACTIONAL
  5. Mounted the database
Question 10 Multiple Choice (Single Answer)

Which of the following is the highest level of logical objects in the database?

  1. Database block
  2. Extent
  3. Tablespace
  4. SQL work area
  5. Instance creation
Question 11 Multiple Choice (Single Answer)

Which of the following files can be created by a process known as archiving?

  1. Password file
  2. Instance creation
  3. PFILE
  4. Redo log buffer
  5. Archive files
Question 12 Multiple Choice (Single Answer)

Any change made in the database is first recorded in the which of the files before it is actually implemented?

  1. Instance creation
  2. Password file
  3. PFILE
  4. Online redo log files
  5. Stream pool
Question 13 Multiple Choice (Single Answer)

Which of the following is another logical structure that can classify or group database objects?

  1. Extent
  2. Database block
  3. Instance creation
  4. Mounting the database
  5. Schema
Question 14 Multiple Choice (Single Answer)

In which of the following options of STARTUP command will the instance be created and the database mounted?

  1. RESTRICT
  2. MOUNT
  3. RECOVER
  4. ABORT
  5. Opening the database
Question 15 Multiple Choice (Single Answer)

Which of the following is a type of object that a user typically sees such as a table?

  1. Database block
  2. Database segment
  3. Extent
  4. Instance creation
  5. Private SQL area
← Back to Quizzes