Database Management System (DBMS)

261. ASM stands for:

  1. Automatic storage management

Correct answer: (A)
Automatic storage management

262. Oracle database 11g was released in ___________:

  1. 2001
  2. 2002
  3. 2006
  4. 2007

Correct answer: (D)
2007

263. The server process contains memory for a private session which is its own and is called ___________:

  1. SGA
  2. PGA
  3. Both
  4. None

Correct answer: (B)
PGA

264. Tables and indexes that are data of logical database structure that are stored physically in the form of ___________:

  1. Data files
  2. Control files
  3. Online redo log files
  4. All of these

Correct answer: (A)
Data files

265. Which files has metadata that specifies database structure that includes database name along with database files names and locations:

  1. Data files
  2. Control files
  3. Online redo log files
  4. All of these

Correct answer: (B)
Control files

266. Which is also known as redo records, recording whatever changes are made to data:

  1. Data files
  2. Control files
  3. Online redo log files
  4. All of these

Correct answer: (C)
Online redo log files

267. The data in oracle database is stored in blocks known as ___________:

  1. Data blocks
  2. Extents
  3. Segments
  4. Tablespaces

Correct answer: (A)
Data blocks

268. Which contains many extents:

  1. Data blocks
  2. Extents
  3. Segments
  4. Tablespaces

Correct answer: (C)
Segments

269. ___________ shows a specified number of data blocks that are logically contiguous and keeps a particular type of information in its storage:

  1. Data blocks
  2. Extents
  3. Segments
  4. Tablespaces

Correct answer: (B)
Extents

270. Which are logical storage units contained in a database and a logical container for some segment:

  1. Data blocks
  2. Extents
  3. Segments
  4. Tablespaces

Correct answer: (D)
Tablespaces

Previous
Page 27 of 45
Next
Copyright © EngineeringMCQ.com