Database Management System (DBMS)

381. Which formal method that locates and analyses relation schemas on the basis of their primary, candidate keys, and the FD’s that are present among the attributes of these schemas:

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

Correct answer: (C)
Normalization

382. In decomposition technique of splitting a relation into ___________ relation:

  1. ONE or MORE
  2. TWO or MORE
  3. THREE or MORE
  4. FOUR or MORE

Correct answer: (B)
TWO or MORE

383. Codd suggested how many forms in normalization process:

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

Correct answer: (C)
3

384. Consequently R.Boyce-Codd jointly launched powerful definition for the thired normal form called ___________:

  1. Boyce-Codd normal form
  2. First normal form
  3. Second normal form
  4. All of these

Correct answer: (A)
Boyce-Codd normal form

385. BCNF stands for:

  1. Basic -Codd normal form
  2. Build -Codd normal form
  3. Boyce-Codd normal form
  4. None of these

Correct answer: (C)
Boyce-Codd normal form

386. Which forms simplifies and ensures that there is minimal data aggregates and repetitive groups:

  1. 1NF
  2. 2NF
  3. 3NF
  4. All of these

Correct answer: (A)
1NF

387. Which forms every non-prime attribute is fully dependent functionally on the candidate key of a relational schema:

  1. 1NF
  2. 2NF
  3. 3NF
  4. 5NF

Correct answer: (B)
2NF

388. Which forms is required when although NF is present more normalization is required:

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

Correct answer: (C)
3NF

389. Which forms has a relation that possesses data about an individual entity:

  1. 2NF
  2. 3NF
  3. 4NF
  4. 5NF

Correct answer: (C)
4NF

390. PJNF stands form:

  1. Practically –join normal form
  2. Project –join normal form
  3. Pages –join normal form
  4. programming –join normal form

Correct answer: (B)
Project –join normal form

Previous
Page 39 of 45
Next
Copyright © EngineeringMCQ.com