WorksheetsLvl 1 Introduction DBMS (QB)
Total questions: 39
Worksheet time: 28mins
Name
Class
Date
1.
Which is the false statement ?
a)
A Database is ordered collection of
data.
b)
A Database is systematic compilation of records in a computer
c)
DBMS manages the database
d)
Data helps in making
decisions.
2.
In traditional file system ,Two files may be combined into a third file if
a)
They have a row in common
b)
They have a field in common
c)
They have no records with the same value in the common field
d)
Both (b) and (c)
3.
Data is said to be ________ if same data is copied at many places.
a)
Redundant
b)
Concurrent
c)
Inconsistent
d)
Controlled
4.
What do you mean by Concurrent access?
a)
Copies of same data does not match with each other
b)
Same data is copied at many places
c)
The access of same data by multiple users at same time
d)
Both A & B
5.
Data Model is collection of conceptual tools for describing -
a)
Data
b)
Data schema
c)
Consistency
d)
All of these
6.
Data________ refers to describing the data description, representing data semantics, and describing the consistency constraints that apply to the data.
a)
Adding
b)
Modifying
c)
Modeling
d)
Refining
7.
Which of the following is not a Data Model?
a)
Aggregate Model
b)
Relational Model
c)
ER Model
d)
Hierarchical Model
8.
Which of the following is not an example of DBMS?
a)
MySQL
b)
Microsoft Acess
c)
IBM DB2
d)
Google
9.
Data such as table name, column name, data type, authorized user and user access privileges for any table is called ______for that table.
a)
Data Isolation
b)
Data Independence
c)
Data Integrity
d)
Meta data
10.
Which of the following is a feature of DBMS?
a)
Minimum Duplication and Redundancy of Data
b)
High Level of Security
c)
Mulitple-user Access
d)
All of these
11.
Which of the following is not a function of the database?
a)
Managing stored data
b)
Manipulating data
c)
Security for stored data
d)
Analysing code
12.
What is information about data called?
a)
Hyper data
b)
Tera data
c)
Meta data
d)
Relations
13.
What is a database?
a)
Organized collection of information that cannot be accessed, updated, and managed
b)
Collection of data or information without organizing
c)
Organized collection of data or information that can be accessed, updated, and managed
d)
Organized collection of data that cannot be updated
14.
The same information may be duplicated in several places (files). For example, if a student has a double major (say, music and mathematics) the address and telephone number of that student may appear in a file that consists of student records of students in the Music department and in a file that consists of student records of students in the Mathematics department. This redundancy leads to higher storage and access cost. In addition, it may lead to data
inconsistency.
a)
TRUE
b)
FALSE
15.
Implementation of the simple structures at the logical level may involve complex physical-level structures, the user of the logical level does not need to be aware of this complexity. This is referred
to as .
a)
physical data independence.
b)
Logical Data Independence
c)
Local Data Independence
d)
None of these
16.
Which is the type of Data Independence?
a)
Physical Data Independence
b)
Logical Data Independence
c)
Both A & B
d)
None of these
17.
__________is the ability to modify the conceptual schema without requiring any change in application programs.
a)
physical data
independence.
b)
Logical Data
Independence
c)
Local Data
Independence
d)
None of these
18.
_______ which is responsible for fetching data from disk storage into main memory, and deciding what data to cache in main memory.
a)
Buffer manager
b)
Authorization and integrity manager
c)
Transaction manager
d)
None of these
19.
Authorization and integrity manager tests the satisfaction of integrity constraints and checks the authority of users to access data.
a)
TRUE
b)
FALSE
20.
____ means to hide certain details of how data is stored and maintain.
a)
Data Isolation
b)
Data Integrity
c)
Data Abstraction
d)
None of these
21.
____ of abstraction explains how data is actually stored and describes the Data Structure and Access methods used by database.
a)
Conceptual Level
b)
Physical Level
c)
View Level
d)
None of these
22.
Which component manages the allocation of space on disk storage and the data structures used to represent information stored on disk?
a)
Buffer manager
b)
File manager
c)
Transaction manager
d)
Authorization manager
23.
_________________ is the skeleton structure that represents the logical view of the entire database.
a)
Data Independence
b)
Storage structure
c)
DB Schema
d)
Mapping
24.
Translates DML statements into low level instructions that the query evaluation engine understands.
a)
Query Evaluation Engine
b)
Integrity Manager
c)
DML Compiler
d)
DDL Interpreter
25.
Which of the following is a component of the DBMS?
a)
Buffer manager
b)
File manager
c)
Transaction
manager
d)
All of these
26.
Procedural DMLs require a user to specify what data are needed and how to get those data.
a)
TRUE
b)
FALSE
27.
Declarative DMLs (also referred to as nonprocedural DMLs) require a user to specify what data are needed without specifying how to get those data.
a)
TRUE
b)
FALSE
28.
Data Manipulation Languages are used for -
a)
Insert Information into Database
b)
update Information
c)
Delete Information
d)
All of these
29.
The Statement that requests a retrieval of information from database is called as .
a)
Control Statement
b)
Query
c)
Manipulation Statement
d)
None of these
30.
Database Administrator is responsible for which of the following function?
a)
Defining Security Constraints
b)
Defining Integrity Constraints
c)
Granting the Data Access
d)
All of these
31.
The Users who use " easy to use menu" are called
a)
Sophisticated end user
b)
Naïve user
c)
Stand alone users
d)
Casual end users
32.
Schema Definition is written by________
a)
Database Administrator
b)
Application Programmer
c)
Naïve user
d)
Casual end users
33.
User who interacts with the system using database query language is called as .
a)
Sophisticated end user
b)
Naïve user
c)
Stand alone users
d)
Casual end users
34.
Farmer goes to ATM Center to withdraw an amount of Rs.300/-.Which type of user farmer is ?
a)
Sophisticated end user
b)
Unophisticated end user
c)
Application Programmer
d)
Specialized User
35.
Which of the following is/are functions of the database administrator?
a)
Schema definition
b)
Access method definition
c)
Backup and Recovery
d)
All of these
36.
You have understood first chapter(Instruction) of DBMS by _____ %
a)
100%
b)
75%-100%
c)
50%
d)
Below 50%
37.
How do you feel today
a)
Relaxed
b)
Missing College
c)
Just woke up
d)
In "Do not Disturb" mode
38.
Will you appear in a similar kind of Online Quiz?
a)
Ofcourse Yes
b)
May be
c)
No
d)
Definitely Not !!!
39.
I like _____ subject most
a)
DBMS
b)
DS
c)
Maths II
d)
FEE
e)
JAVA II
100 %
