NEW
Font size
S
M
L
XL
WorksheetsLvl 2 Chapter 1 Introduction
Total questions: 30
Worksheet time: 15mins
Name
Class
Date
1.
______ are used for the Unstructured database
a)
RDBMS
b)
SQL
c)
MYSQL
d)
Big Data
2.
________ is specifically called duplication of data
a)
Redundancy
b)
Integrety
c)
Atomicity
d)
Concurrency
3.
Operation completes either 100% or 0% is called _______
a)
Redundancy
b)
Integrety
c)
Atomicity
d)
Concurrency
4.
Multiple users are allowed to access data simaltenously is called ______
a)
Redundancy
b)
Integrety
c)
Atomicity
d)
Concurrency
5.
Role based authorities has been assigned can be called as ________
a)
Data Sharing
b)
Data Security
c)
Intergrety
d)
Data Accessing
6.
Data contained in the database is both correct and consistent
a)
Data Sharing
b)
Data Security
c)
Intergrety
d)
Data Accessing
7.
______ is called Metadata
a)
Facebook data
b)
Data about data
c)
Multiple data
d)
All of above
8.
_______ where relational database management system is not effective
a)
Structured data
b)
Unstructured data
c)
Both of above
d)
None of above
9.
DBMS contains ______ number of tables
a)
One
b)
Two
c)
seventeen
d)
Multiple
10.
_______ type of database have single parants with multiple child
a)
Hierarchical Model
b)
Network Model
c)
Entity Relationship Model
d)
Relational Model
e)
Object-oriented model
11.
______ type of database can have multiple parents
a)
Hierarchical Model
b)
Network Model
c)
Entity Relationship Model
d)
Relational Model
e)
Object-oriented model
12.
______ database model data is organised in two-dimentional tables and further process has been done
a)
Hierarchical Model
b)
Network Model
c)
Entity Relationship Model
d)
Relational Model
e)
Object-oriented model
13.
It consider each object in the world as objects and isolates it from eachother is called ______
a)
Hierarchical Model
b)
Network Model
c)
Object-oriented model
d)
Entity Relationship Model
e)
Relational Model
14.
A __________ architecture buries the application logic within the server database
a)
two-tier DB
b)
three-tier DB
c)
single tier DB
d)
All of above
15.
The _________ architecture does not allow its clients and database to communicate directly- thus making it comparatively more secure in the long run.
a)
two-tier DB
b)
three-tier DB
c)
single tier DB
d)
All of above
16.
It runs and works at a comparatively faster pace.
a)
two-tier DB
b)
three-tier DB
17.
The ________ architecture leads to a performance loss with an increase in the number of users.
a)
two-tier DB
b)
three-tier DB
18.
A _________ DB architecture is comparatively much easier to maintain as well as build.
a)
two-tier DB
b)
three-tier DB
19.
______ manager controls the concurrency and atomicity in database system
a)
Authorization manager
b)
Integrity Manager
c)
Transaction Manager
d)
File manager
e)
Buffer Manager
20.
_______ manages allocation of space on the disk storage
a)
Authorization manager
b)
Integrity Manager
c)
Transaction Manager
d)
File manager
e)
Buffer Manager
21.
_________ fetches the data from disk storage to memory for being used.
a)
Authorization manager
b)
Integrity Manager
c)
Transaction Manager
d)
File manager
e)
Buffer Manager
22.
_______ checks the role of users in during database operation
a)
Authorization manager
b)
Integrity Manager
c)
Transaction Manager
d)
File manager
e)
Buffer Manager
23.
______ checks correctness of the data that coming in the process
a)
Authorization manager
b)
Integrity Manager
c)
Transaction Manager
d)
File manager
e)
Buffer Manager
24.
_______ is part of query processor
a)
Query evaluation engine
b)
Transaction Manager
c)
Naïve User
d)
Indices
e)
Data dictionary
25.
_________ have authority to write in the database system architecture
a)
Naïve User
b)
Application Programmers
c)
Sophesticated Users
d)
Database Administrator
e)
Transaction Manager
26.
_________ mainly deals with the Data definition language
a)
Naïve User
b)
Application Programmers
c)
Sophesticated Users
d)
Database Administrator
e)
File manager
27.
_________ mainly deals with the Data manipulation languaga
a)
Naïve User
b)
Application Programmers
c)
Sophesticated Users
d)
Database Administrator
e)
File manager
28.
Clerk in the bank of baroda of Maninagar brnach can be considered as ________
a)
Naïve User
b)
Application Programmers
c)
Sophesticated Users
d)
Database Administrator
e)
File manager
29.
Which of the following is not a Data Model?
a)
Hierarchical Model
b)
Network Model
c)
Object-oriented model
d)
Entity Relationship Model
e)
aggregated Model
30.
Softwere developer can be considered as _________
a)
Naïve User
b)
Application Programmers
c)
Sophesticated Users
d)
Database Administrator
e)
Transaction Manager
Reset
