NEW
Font size
WorksheetsDIM CT
Total questions: 25
Worksheet time: 13mins
Database is a collection of:
Modules
Programs
Data
None of the above
_ is collection of interrelated data and set of program to access
Database
Data Structure
Programming Languge
DBMS
DBMS should provide following feature(s)
Authorized access
Safety of the information stored
Protect the data from system crash
All of the above
Which of the following is considered as DBMS ?
Access
Foxpro
Oracle
All of these
Before use of DBMS information was stored using __________.
Cloud Storage
None of these
Data System
File Management System
The DBMS acts as an interface between what two components of an database system ?
Database and SQL
Database Application and Database
Data and Database
Database and User
Long form of DBA is ______________.
Database Administrator
Database Application
None of these
Database Admin
A database is a complex type of ______.
Manager
None of these
Data Structure
Application
Duplication of data at several places is called as _______________.
Data Inconsistency
Data Redundancy
Atomicity Problem
Data Isolation
If in redundant file common fields are not matching then it results in _____________.
Data Isolation
Data Integrity Problem
Data Inconsistency
Data Redundancy
Data Isolation caused due to ________ in traditional file system.
Complex Data
Duplicate Data
Atomic Data
Scattering of Data
If DBA modify the structure of the data record then this modification do not affect other application is called as _____________.
Data Integrity
Data Independence
Data Security
Data Isolation
A main purpose of DBMS is to provide ____________ view of data to user.
None of these
Partial
Complete
Abstract
Which of the following is not a level of data abstraction?
Physical Level
Critical Level
Logical level
External Level
In database management system, term which is used to represent real world concept or object is classified as
entity
attribute
relationship
Abstraction
Which of the following are the properties of entities?
Groups
Table
Attributes
Switchboards
Association among several entities is called as _____________.
Extraction
Relationship
Combination
Association
______________ express the number of entities to which another entity can be associated via a relationship set.
None of these
Messaging Cardinality
Logical Cardinality
Mapping Cardinality
Considering binary relationships, possible cardinality ratios are
one : one
1 : N
M : N
all of above
Attributes that can be arranged into hierarchy are called
composite attributes
atomic attributes
derived attributes
simple attributes
Set of all entities having same attributes is classified as
entity type
attribute type
function type
hierarchy type
Set of values which specifies which values are to be assigned to individual entities is considered as
domain of values
composition of values
attribution of values
derivation of values
Attributes which have only one value for a specific entity are called
multi-valued attributes
single valued attributes
atomic attributes
diatomic attributes
In ER diagrams, rectangles are used to denote
entity types
attribute types
key types
structure types
The data model which does not entertain many to many relationships is
Network Model
Hierarchy Model
OODM
RDBMS
