Font size
WorksheetsDBMS_UNIT1
Total questions: 25
Worksheet time: 14mins
__________databases involves maps & satellite images.
Numeric
Text
Geographic
Multimedia
DB + (a) = Database System
(answer only in capital letter)
A DBMS catalog stores the description of the database. The description is called as
meta data
mini data
maxi data
mean data
Identify the properties of DBMS
defining
constructing
manipulating
sharing
Database Users basically divided into how many categories.
1
2
3
4
____________ users frequently query/update the database using standard canned transactions
Casual end users
Naive/Parametric end users
Sophisticated end users
Stand-alone users
____________ users implement their own applications to meet their complex needs.
Casual end users
Naive/Parametric end users
Sophisticated end users
Stand-alone users
_________________ leads to wasted storage space, duplication of effort ,when multiple copies of a datum need to be updated.
Data Controlling
Data independence
Data redundancy
Data effort
A set of concepts to describe the structure of a database, the operations for manipulating these structures, and certain constraints that the database should obey is termed as ____________
Data Model
Data Interpretation
Data Inconsistency
Data error
tick the all the appropriate answers
identify all the levels of data model
Conceptual Model
Physical Model
Implementational Model
Functional Model
Real world object or concept is defined as _______
Attributes
Entity
Relationship
E_R diagram
______________ data model was proposed in 1970 by E.F. Codd @ IBM
Relational Model
Network Model
Hierarchical Model
Object Oriented Model
Overall design of the database is called as ____________
Instance
Schema
initial database state
valid database state
Collection of information stored in the database at a particular moment is called
Instance
Schema
initial database state
valid database state
Instance is otherwise called as Snapshot
False
True
Schema is called as (a)
The image is an example for
Initial Data State
Instance
Valid Data State
Schema
_________________ Schema describes the various user views.
Internal Schema
Conceptual Schema
External Schema
_________________ Schema describes physical storage structures and access paths
Internal Schema
Conceptual Schema
External Schema
Ability to modify a schema definition in one level without affecting a schema definition in the next higher level is called
Data model
Data independence
Data flow
Data diagram
Ability to modify the conceptual schema
without causing application programs to be rewritten is called as
Physical independence
Logical independence
Identify the odd man out in data base languages
DDL
DML
DCL
DIL
Graphical User Interfaces is a combination_______
Form only
Menu only
Form & Menu only
Form, Menu & Web only
______ combines everything into single system including- DBMS software, hardware, application programs and user interface processing software.
Centralized DBMS
Distributed DBMS
Classification of DBMS depends on different category. Identify all,(click all the possible answers correct)
Data model
Number of Users
Number of Sites
Data Independence
