Database Management System (DBMS)

301. How many types of changeover methods:

  1. 1
  2. 2
  3. 3
  4. 4

Correct answer: (D)
4

302. Which the types of changeover methods:

  1. Direct
  2. Parallel
  3. Pilot
  4. Staged or phased
  5. All of these

Correct answer: (E)
All of these

303. How many types of maintenance:

  1. 1
  2. 2
  3. 3
  4. 4

Correct answer: (B)
2

304. Which are the not a type of maintenance:

  1. Corrective
  2. Adaptive
  3. Perfective
  4. None of these

Correct answer: (D)
None of these

305. Which is conducted for assessing the quality of the system produced by developer for customer:

  1. Maintenance
  2. Analysis of starting
  3. Implementation
  4. Testing

Correct answer: (D)
Testing

306. Which is one of the major important components of the relational database:

  1. Query execution
  2. Query process
  3. Query optimizer
  4. Query transaction

Correct answer: (B)
Query process

307. Which is refers to the process of restoring the data that has been stored in a compter:

  1. Retrieve
  2. Backup
  3. Recovery
  4. Deadlock

Correct answer: (A)
Retrieve

308. How many major stages of query processing:

  1. 1
  2. 2
  3. 3
  4. 4

Correct answer: (B)
2

309. Which are the major stages of query processing:

  1. Query execution
  2. Query optimizer
  3. Both
  4. None

Correct answer: (C)
Both

310. In query processor which ordering is related to hash joins by SQL server 7.0:

  1. Interesting ordering
  2. Index intersection
  3. Index joins
  4. Parallel queries

Correct answer: (A)
Interesting ordering

Previous
Page 31 of 45
Next
Copyright © EngineeringMCQ.com