NEW
Font size
WorksheetsDBMS Module 1
Total questions: 12
Worksheet time: 6mins
The data in a database cannot be shared
True
False
The conceptual schema defines the view or views for particular users.
True
False
In a database, the data is stored in such a fashion that they are independent of the programs of people using the data.
True
False
The external schema defines how and where data are organized in physical data storage.
True
False
______________ means that the three levels in the schema (internal, conceptual and external) should be independent of each other so that the changes in the schema at one level should not affect the other levels.
Data Abstraction
Data Independence
Data Dictionary
Database Management System
Which of the following defines the stored data structures in terms of the database model used?
Internal Schema
External Schema
Conceptual Schema
None of the above.
What it the sequence of database operations that represents a logical unit of work and that accesses a database and transforms it from one state to another?
Logical unit of work
Transaction
Record
None of the above
DBMS stands for ________________--
Data Blocking and Management Systems
Database Management Systems
Database Business Management Systems
None of the above
Information processing refers to _________________ and _________________ of information
Acquisition and recording
Organization and Retrieval
Display and Dissemination
All of the above
Which of the following is the critical factor that enables managers and organizations to gain a competitive edge ?
More Manpower
More Capacity
Quality Information
None of the above
What is the name of the system database that contains the descriptions of the data in the database ?
Metadata
Data Dictionary
Table
None of the above
What separates the physical aspects of data storage from the logical aspects of data representation ?
Data
Relationships
Constraints
Schema
