Database Management System (DBMS)

371. What is a super key:

  1. Key
  2. Key revisited
  3. Superset key
  4. None of these

Correct answer: (C)
Superset key

372. Which s essential a business problem not a data problem:

  1. Data
  2. Database
  3. Database design
  4. All of these

Correct answer: (C)
Database design

373. Which is primarily the result of a thorough understanding of information about an enterprise:

  1. Data
  2. Database
  3. Database design
  4. Data modeling

Correct answer: (D)
Data modeling

374. McFadden has defined normalization in his which book:

  1. Database modern management
  2. Management database of modern
  3. Modern database management
  4. Database management

Correct answer: (C)
Modern database management

375. The database design prevents some data from being represented due to ___________:

  1. Deletion anomalies
  2. Insertion anomalies
  3. Update anomaly
  4. None of these

Correct answer: (B)
Insertion anomalies

376. How many types of insertion anomalies:

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

Correct answer: (B)
2

377. Who developed the normalization process:

  1. E.F. codd
  2. F.F. codd
  3. E.E. codd
  4. None of these

Correct answer: (A)
E.F. codd

378. E.F.Codd developed the normalization process in the which early:

  1. 1969
  2. 1970
  3. 1971
  4. 1972

Correct answer: (B)
1970

379. Which is a bottom-up approach to database design that design by examining the relationship between attributes:

  1. Functional dependency
  2. Database modeling
  3. Normalization
  4. Decomposition

Correct answer: (C)
Normalization

380. Which is the process of breaking a relation into multiple relations:

  1. Functional dependency
  2. Database modeling
  3. Normalization
  4. Decomposition

Correct answer: (D)
Decomposition

Previous
Page 38 of 45
Next
Copyright © EngineeringMCQ.com