Top 1000+ Solved DataBase Management System (DBMS) MCQ Questions Answer
Q. Dynamic Management View is a type of ___________
a. System Defined Views
b. User Defined View
c. Simple View
d. Complex View
Q. Syntax for creating views is __________
a. CREATE VIEW AS SELECT
b. CREATE VIEW AS UPDATE
c. DROP VIEW AS SELECT
d. CREATE VIEW AS UPDATE
Q. You can delete a view with ___________ command.
a. DROP VIEW
b. DELETE VIEW
c. REMOVE VIEW
d. TRUNCATE VIEW
Q. What is SCHEMABINDING a VIEW?
a. Schema binding binds your views to the dependent physical columns of the accessed tables specified in the contents of the view
b. These are stored only in the Master database
c. These types of view are defined by users on a specified schema
d. These are used to show database self describing information
Q. Which of the following is not a SQL Server INFORMATION_SCHEMA view?
a. INFORMATION_SCHEMA.CONSTRAINT_TABLE_USAGE
b. INFORMATION_SCHEMA.DOMAIN_CONSTRAINTS
c. INFORMATION_SCHEMA.KEY_COLUMN_USAGE
d. sys.dm_exec_connections
Q. ___________ is stored only in the Master database.
a. Database-scoped Dynamic Management View
b. Complex View
c. Catalog View
d. None of the mentioned
Q. In the __________ normal form, a composite attribute is converted to individual attributes.
a. First
b. Second
c. Third
d. Fourth
Q. Tables in second normal form (2NF):
a. Eliminate all hidden dependencies
b. Eliminate the possibility of a insertion anomalies
c. Have a composite key
d. Have all non key fields depend on the whole primary key
Q. Which-one ofthe following statements about normal forms is FALSE?
a. BCNF is stricter than 3 NF
b. Lossless, dependency -preserving decomposition into 3 NF is always possible
c. Loss less, dependency – preserving decomposition into BCNF is always possible
d. Any relation with two attributes is BCNF
Q. Functional Dependencies are the types of constraints that are based on______
a. Key
b. Key revisited
c. Superset key
d. None of the mentioned
Q. Which is a bottom-up approach to database design that design by examining the relationshipbetween attributes:
a. Functional dependency
b. Database modeling
c. Normalization
d. Decomposition
Q. Which forms simplifies and ensures that there are minimal data aggregates and repetitivegroups:
a. 1NF
b. 2NF
c. 3NF
d. All of the mentioned
Q. Which forms has a relation that possesses data about an individual entity:
a. 2NF
b. 3NF
c. 4NF
d. 5NF
Q. Empdt1(empcode, name, street, city, state, pincode).For any pincode, there is only one city and state. Also, for given street, city and state, there is just one pincode. In normalization terms, empdt1 is a relation in
a. 1 NF only
b. 2 NF and hence also in 1 NF
c. 3NF and hence also in 2NF and 1NF
d. BCNF and hence also in 3NF, 2NF and 1NF