Top 1000+ Solved DataBase Management System (DBMS) MCQ Questions Answer
Q. The main task carried out in the __________ is to remove repeating attributes toseparate tables.
a. First Normal Form
b. Second Normal Form
c. Third Normal Form
d. Fourth Normal Form
Q. Which forms has a relation that possesses data about an individual entity?
a. 2NF
b. 3NF
c. 4NF
d. 5NF
Q. Which of the following has each related entity set has its own schema and there is anadditional schema for the relationship set?
a. A many-to-many relationship set
b. A multivalued attribute of an entity set
c. A one-to-many relationship set
d. None of the mentioned
Q. Fifth Normal form is concerned with
a. Functional dependency
b. Multivalued dependency
c. Join dependency
d. Domain-key
Q. n which of the following, a separate schema is created consisting of that attribute andthe primary key of the entity set.
a. A many-to-many relationship set
b. A multivalued attribute of an entity set
c. A one-to-many relationship set
d. None of the mentioned
Q. In 2NF
a. No functional dependencies (FDs) exist
b. No multivalued dependencies (MVDs) exist
c. No partial FDs exist
d. No partial MVDs exist
Q. Which of the following is related to information?
a. Data
b. Communication
c. Knowledge
d. All of these
Q. Which of the following is element of the database?
a. Data
b. Constraints and schema
c. Relationships
d. All of these.
Q. What represent a correspondence between the various data elements?
a. Data
b. Constraints
c. Relationships
d. Schema
Q. Which of the following is an advantage of using database system?
a. Security enforcement
b. Avoidance of redundancy
c. Reduced inconsistency
d. All of these.
Q. Which of the following is characteristic of the data in a database?
a. Independent
b. Secure
c. Shared
d. All of these.
Q. Relationships could be of the following type:
a. One-to-one relationship
b. One-to-many relationships
c. Many-to-many relationships
d. All of these.
Q. In a file-oriented system there is:
a. Data inconsistency
b. Duplication of data
c. Data independence
d. Al of these.
Q. In a database system there is:
a. Increased productivity
b. Improved security
c. Economy of scale
d. All of these.