DBMS MCQ Question and Answer
DBMS MCQ Question and Answer
101. Which of the following is an automated or manual tool for storing and organizing
information about the data maintained in a database?
- JAD
- electronic journal
- data dictionary
- hypermedia database
103. In a relational database, the operation that creates a subset of data consisting of
columns in a table, permitting the user to create new tables that contain only the
information required is the
- join operation
- project operation
- section operation
- select operation
104. In the relational database, the operation that combines relational tables to
provide the user with more information than is available in individual tables is the
- join operation
- merge operation
- select operation
- grow operation
105. The logical database model that presents data to users in a treelike structure is
the
- object-oriented DBMS
- network DBMS
- relational DBMS
- hierarchical DBMS
106. The hierarchical DBMS organizes data elements into
- segments
- data compartments
- data units
- objects
107. An abstract model of the database from a business perspective best defines
- physical design
- object design
- organizational view
- conceptual design
108. The process of creating small, stable data structures from complex groups of data when
designing a relational database defines
- data decomposition
- data structuring
- data transcribing
- normalization
109. Which of the following best describes a special organizational function for managing
the organization
- database administration
- information management
- data analysis
- data administration
110. Data administration
- establishes specific policies and procedures through which data can be managed as an organizational resource
- establishes access rules and procedures
- defines and organizes database structure and content
- maintains the database