Database Management System - DBMS Objective Question and Answer
Database Management System - DBMS MCQ Multiple Choice Questions - Page 2 for Practice
31. BCNF stands for:
Correct Answer is: Boyce-Codd normal form
32. Which of the following is not a Storage Manager Component?
Correct Answer is: Logical Manager
33. ……………… is a combination of two of more attributes used as a primary key
Correct Answer is: Composite Key
34. A Database Management System (DBMS) is
Correct Answer is: All of the above
35. Which is the transformation of requests and results between different levels of abstraction:
Correct Answer is: Mapping
36. Drop Table cannot be used to drop a table referenced by a …………… constraint.
Correct Answer is: Foreign Key
37. Drop Table cannot be used to drop a table referenced by a …………… constraint.
Correct Answer is: Foreign Key
38. In the relational model, relationships between relations or tables are created by using:
Correct Answer is: Foreign keys
39. All transactions are controlled and executed by the DBMS (subject to some limitations to guarantee database ………………
Correct Answer is: integrity
40. A ………………database state is one in which all data integrity constraints are satisfied
Correct Answer is: consistent
41. One solution to the multivalued dependency constraint problem is to:
Correct Answer is: split the relation into two relations, each with a single theme
42. The SQL command to creating a table is:
Correct Answer is: Create table
43. The following are functions of a DBMS except………………
Correct Answer is: creating and processing forms
44. Which of the following is not a Schema?
Correct Answer is: Critical Schema
45. DCL stands for
Correct Answer is: Data Control Language
46. One aspect that has to be dealt with by the integrity subsystem is to ensure that only valid values can be assigned to each data items. This is referred to as
Correct Answer is: Domain Integrity
47. DFD stands for
Correct Answer is: Data Flow Diagram
48. DML is a language by which user accesses or manipulates the………………
Correct Answer is: Data model
49. Minimal data redundancy means improved………………
Correct Answer is: Data consistency
50. The provision of …………….. is a major objective for database system:
Correct Answer is: Data independence
51. The overall description of a database is called………………
Correct Answer is: Database schema
52. Disadvantages of File systems to store data is:
Correct Answer is: All of the above
53. Which is the central component of the DBMS software that can also be termed as the database control system?
Correct Answer is: Data manager
54. Data are stored in………………as database:
Correct Answer is: Data files
55. Transaction is an action used to perform some manipulation on data stored in the………………
Correct Answer is: Database
56. Which is stored information about description of data in the database:
Correct Answer is: Data dictionary
57. In an Entity-Relationship Diagram Rectangles represents
Correct Answer is: Entity sets
58. DBA stands for:
Correct Answer is: Database administrator
59. Which is the person responsible for overall control f the database system:
Correct Answer is: DBA
60. ………... is a translates into low-level instruction that a query processor understands:
