DBMS MCQ Question and Answer
DBMS MCQ Question and Answer
152. A logical view is:
- the process of creating small stable data structures from complex groups of data when designing a relational database
- a methodology for documenting databases illustrating the relationship between various entities in the database
- an approach to data management that stores both data and the procedures acting on the data as objects that can be automatically retrieved and shared.
- a representation of data as they would appear to an application programmer or user.
153. The language associated with a database management system that is employed by end users and programmers to manipulate data in the database is the:
- data definition language
- data presentation language
- data manipulation language
- data translation language
155. 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
157. 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
158. 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
159. The logical database model that presents data to users in a treelike structure is the:
- object-oriented DBMS
- network DBMS
- relational DBMS
- hierarchical DBMS
160. The hierarchical DBMS organizes data elements into:
- segments
- data compartments.
- data units.
- objects.