Database Management System
Multiple Choice Questions with Answers:-
1.) Where is metadata stored in
MySQL?
Options are:
A.) In the MySQL database meta
B.) In the MySQL database metasql
C.) In the MySQL database metadata
D.) In the MySQL database mysql
Answer: D
3.) What MySQL property is used to
create a surrogate key in MySQL?
Options are:
A.) IDENTICAL
B.) UNIQUE
C.) AUTO_INCREMENT
D.) SEQUENCE
Answer: C
4.) A relational database consists
of a collection of
Options are:
A.) Keys
B.) Records
C.) Tables
D.) Fields
Answer: C
5.) A Database Management System
(DBMS) is:
Options are:
A.) Collection of data describing
one particular enterprise
B.) Collection of programs to access
data
C.) All Options are correct
D.) Collection of interrelated data
Answer: C
6.) Which of the following is not a
level of data abstraction?
Options are:
A.) View Level
B.) Physical Level
C.) Logical Level
D.) Critical Level
Answer: D
7.) Disadvantages of File systems to
store data is:
Options are:
A.) Data isolation
B.) Data redundancy and
inconsistency
C.) Difficulty in accessing data
D.) All options are correct
Answer: D
8.) In an Entity Relationship
Diagram Rectangles represents
Options are:
A.) Tables
B.) Attributes
C.) Database
D.) Entity Sets
Answer: D
9.) Which of the following is not a
Storage Manager Component?
Options are:
A.) Transaction Manager
B.) Logical Manager
C.) File Manager
D.) Buffer Manager
Answer: B
10.) Data Manipulation Language
enables users to
Options are:
A.) Retrieval of information stored
in database
B.) Insertion of new information
into the database
C.) Deletion of information from the
database
D.) All the options are correct
Answer: D
11.) Which of the following is not
an Schema?
Options are:
A.) Logical Schema
B.) Physical Schema
C.) Database Schema
D.) Critical Schema
Answer: D
12.) Which of the following is
Database Language?
Options are:
A.) Data Definition Language
B.) Data Manipulation Language
C.) Data Query Language
D.) All of the options
Answer: D
13.) Which of the following in not a
function of DBA?
Options are:
A.) Network Maintenance
B.) Schema Definition
C.) Authorization for data access
D.) Routine Maintenance
Answer: A
14.) Which of the following is a
Data Model?
Options are:
A.) Entity Relationship Model
B.) Object Based Data Model
C.) All of the options are correct
D.) Relational Data Model
Answer: C
15.) A Database Management System
(DBMS) is
Options are:
A.) Collection of interrelated data
B.) Collection of data describing
one particular enterprise
C.) All of the options
D.) Collection of programs to access
data
Answer: C
16.) Which of the following is not a
level of data abstraction?
Options are:
A.) Physical Level
B.) View Level
C.) Critical Level
D.) Logical Level
Answer: C
17.) Disadvantages of File systems
to store data is:
Options are:
A.) Data redundancy and
inconsistency
B.) Data isolation
C.) All of the options
D.) Difficulty in accessing data
Answer: C
18.) Which of the following is not a
Storage Manager Component?
Options are:
A.) Transaction Manager
B.) Buffer Manager
C.) File Manager
D.) Logical Manager
Answer: D
19.) Data Manipulation Language
enables users to
Options are:
A.) Retrieval of information stored
in database
B.) Deletion of information from the
database
C.) All of the above
D.) Insertion of new information
into the database
Answer: C
20.) Which of the following is not
an Schema?
Options are:
A.) Logical Schema
B.) Critical Schema
C.) Database Schema
D.) Physical Schema
Answer: B
21.) Which of the following is
Database Language?
Options are:
A.) All of the options
B.) Query Language
C.) Data Definition Language
D.) Data Manipulation Language
Answer: A
22.) Which of the following in not a
function of DBA?
Options are:
A.) Authorization for data access
B.) Network Maintenance
C.) Routine Maintenance
D.) Schema Definition
Answer: B
23.) Which of the following is a
Data Model?
Options are:
A.) Object-Based data model
B.) All of the options
C.) Entity-Relationship model
D.) Relational data model
Answer: B
24.) Column header is refer as
Options are:
A.) Table
B.) Domain
C.) Attributes
D.) Relation
Answer: C
25.) _______ allow us to identify
uniquely a tuple in the relation.
Options are:
A.) Schema
B.) Superkey
C.) Domain
D.) Attribute
Answer: B
26.) Minimal Superkeys are called
Options are:
A.) Schema keys
B.) Attribute keys
C.) Candidate keys
D.) Domain keys
Answer: C
27.) Which of the following is not
Modification of the Database
Options are:
A.) Updating
B.) Sorting
C.) Deletion
D.) Insertion
Answer: B
28.) Which of the following in not
Outer join?
Options are:
A.) Left outer join
B.) Full outer join
C.) All of the options
D.) Right outer join
Answer: C
29.) Set of premitted values of each
attribute is called
Options are:
A.) Tuple
B.) Schema
C.) Domain
D.) Relation
Answer: C
30.) Which of the following is true
regarding Null Value?
Options are:
A.) Null<0
B.) Null=0
C.) Null<>0
D.) Null>0
Answer: C
31.) Logical design of database is
called
Options are:
A.) All of the options
B.) Database Schema
C.) Database Instance
D.) Database Snapshot
Answer: B
32.) Snapshot of the data in the
database at a given instant of time is called
Options are:
A.) Database Instance
B.) All of the options
C.) Database Schema
D.) Database Snapshot
Answer: A
33.) Which of the following is not
Unary operation?
Options are:
A.) Rename
B.) Union
C.) Select
D.) Project
Answer: B
34.) Which of the following is not
binary operation?
Options are:
A.) Union
B.) Set Difference
C.) Cartesian Product
D.) Project
Answer: D
35.) Which of the following is
correct regarding Aggregate functions?
Options are:
A.) It takes a single value and
returns a single value as result
B.) It takes a list of values and
return a single values as result
C.) It takes a list of values and
return a list of values as result
D.) It takes a single value and
returns a list of values as result
Answer: B
36.) The Primary key must be
Options are:
A.) Non Null
B.) Unique
C.) Option A or B
D.) Option A and B
Answer: D
37.) A command to remove a relation
from an SQL database
Options are:
A.) Delete table
B.) Erase table
C.) Alter table
D.) Drop table
Answer: D
38.) which of the following is not
an Aggregate function?
Options are:
A.) Select
B.) Avg
C.) Min
D.) Max
Answer: A
39.) The attribute that can be
divided into other attributes is called
Options are:
A.) Composite Attribute
B.) Derived Attribute
C.) Simple Attribute
D.) Multi-valued Attribute
Answer: A
40.) What is ACID properties of
Transactions?
Options are:
A.) Atomicity, Consistency,
Isolation, Database
B.) Automatically, Concurrency,
Isolation, Durability
C.) Atomicity, Consistency,
Isolation, Durability
D.) Atomicity, Consistency,
Inconsistent, Durability
Answer: C
41.) If every non-key attribute is
functionally dependent on the primary key, the relation will be in
Options are:
A.) Fourth Formal Form
B.) Third Normal Form
C.) First Normal Form
D.) Second Normal Form
Answer: B
42.) Database locking concept is
used to solve the problem of
Options are:
A.) Inconsistent Data
B.) All of the options
C.) Lost Update
D.) Uncommitted Dependency
Answer: B
43.) UML is stands for
Options are:
A.) Universal Modeling Language
B.) United Modeling Language
C.) Uni Modeling Language
D.) Unified Modeling Language
Answer: D
44.) Data Manipulation Language
(DML) is not to
Options are:
A.) Insertion of new information
into the Database
B.) Modification of information in
the Database
C.) Create information table in the
Database
D.) Deletion of information in the
Database
Answer: C
45.) Which of the following in true
regarding Referential Integrity?
Options are:
A.) Every primary-key value must
match a primary-key value in an associated table
B.) Every primary-key value must
match a foreign-key value in an associated table
C.) Every foreign-key value must
match a foreign-key value in an associated table
D.) Every foreign-key value must
match a primary-key value in an associated table
Answer: D
46.) Which of the following option
is use to retrieval of data?
Options are:
A.) Stack
B.) Data Structure
C.) Linked list
D.) Query
Answer: D
47.) ODBC stands for ______
Options are:
A.) None of above
B.) Open database connection
C.) Offline database connection
D.) Oriented database connection
Answer: B
48.) Which of the following is an
unary operation?
Options are:
A.) Selection operation
B.) Primitive operation
C.) Projection operation
D.) Generalized selection
Answer: D
49.) Which SQL Query is use to
remove a table and all its data from the database?
Options are:
A.) None of these
B.) Drop Table
C.) Create Table
D.) Alter Table
Answer: B
50.) In precedence of set operators
the expression is evaluated from:
Options are:
A.) Left to Right
B.) Right to Left
C.) Left to Left
D.) Right to Right
Answer: A
51.) In DBMS, FD stands for _______
Options are:
A.) Facilitate data
B.) Functional data
C.) Facilitate dependency
D.) Functional dependency
Answer: D
52.) How many types of keys in
Database Design?
Options are:
A.) Foreign key
B.) All of the options
C.) Candidate key
D.) Primary key
Answer: B
53.) Which of the following is based
on Multi Valued Dependency?
Options are:
A.) Third
B.) Fourth
C.) First
D.) Second
Answer: B
54.) Which of the following is the
structure of the Database?
Options are:
A.) Table
B.) None of these
C.) Schema
D.) Relation
Answer: C
55.) The minimal set of super key is
called
Options are:
A.) Primary key
B.) Secondary key
C.) Foreign key
D.) Candidate key
Answer: D
56.) ______________ is a classical
approach to database design?
Options are:
A.) Bottom – Up approach
B.) Top – Down approach
C.) Left – Right approach
D.) Right – Left approach
Answer: B
57.) _____________ refers to the
correctness and completeness of the data in a database?
Options are:
A.) Data independence
B.) Data integrity
C.) Data security
D.) Data constraint
Answer: B
58.) A table that displays data
redundancies yields ____________ anomalies
Options are:
A.) Insertion
B.) Deletion
C.) Update
D.) All of the options
Answer: D
59.) A lock that allows concurrent
transactions to access different rows of the same table is known as a
Options are:
A.) Row-level lock
B.) Database-level lock
C.) Field-level lock
D.) Table-level lock
Answer: C
60.) A type of query that is placed
within a WHERE or HAVING clause of another query is called
Options are:
A.) Multi-query
B.) Sub query
C.) Super query
D.) Master query
Answer: B
61.) Which of the following hardware
component is the most important to the operation of database
management system?
Options are:
A.) High resolution video display
B.) Printer
C.) Plotter
D.) High speed, large capacity disk
Answer: D
62.) A form defined
Options are:
A.) None of the options
B.) Where data is placed on the
screen
C.) The width of each field
D.) Both where data is placed on the
screen and the width of each field
Answer: B
63.) If a piece of data is stored in
two places in the database, then
Options are:
A.) In can be more easily accessed
B.) Both Storage space is wasted and
Changing the data in one spot will cause data inconsistency
C.) Storage space is wasted
D.) Changing the data in one spot
will cause data inconsistency
Answer: B
64.) Which of the following is a
problem of file management system?
Options are:
A.) Data redundancy and program
dependence
B.) All of the options
C.) Difficult to update
D.) Lack of data independence
Answer: B
65.) Which of the following is not
an advantage of the database approach
Options are:
A.) Elimination of data redundancy
B.) Ability of associate deleted
data
C.) Increased security and
program/data independence
D.) all of the above
Answer: D
66.) An audit trail
Options are:
A.) None of the options
B.) Is the recorded history of
operations performed on a file
C.) Is used to make backup copies
D.) Can be used to restore lost
information
Answer: B
67.) One approach to standardization
storing of data?
Options are:
A.) CODASYL specification
B.) None of the options
C.) MIS
D.) Structured programming
Answer: A
68.) Which of the following contains
a complete record of all activity that affected the contents of a
database during a certain period of
time?
Options are:
A.) Transaction log
B.) Data manipulation language
C.) Report writer
D.) Query language
Answer: A
69.) Report generators are used to
Options are:
A.) Store data input by a user
B.) Answer queries
C.) Both Retrieve information from
files and Answer queries
D.) Retrieve information from files
Answer: C
70.) Which of the following is true
of a network structure?
Options are:
A.) It will be dominant data base of
the future
B.) It allows a many-to-many
relationship
C.) It is a physical representation
of the data
D.) It is conceptually simple
Answer: B
71.) A record management system
Options are:
A.) Can handle many files of
information at a time
B.) Always uses a list as its model
C.) Both can handle many files of
information at a time and always uses a list as its model
D.) Can be used to extract
information stored in a computer file
Answer: D
72.) One data dictionery software
package is called
Options are:
A.) DB/DC dictionary
B.) Datapac
C.) TOTAL
D.) ACCESS
Answer: A
73.) The function of a database is
...
Options are:
A.) To check all input data
B.) To output data
C.) To collect and organize input
data
D.) To check all spelling
Answer: C
74.) A command that lets you change
one or more fields in a record is
Options are:
A.) None of the options
B.) Modify
C.) Insert
D.) Lookup
Answer: B
75.) What is the language used by
most of the DBMSs for helping their users to access data?
Options are:
A.) High level language
B.) 4GL
C.) Query Language
D.) SQL
Answer: C
76.) Information can be transferred
between the DBMS and a
Options are:
A.) Spreadsheet program
B.) Word processor program
C.) Graphics program
D.) All of the options
Answer: D
77.) The relational database
environment has all of the following components except
Options are:
A.) Users
B.) Database
C.) Query languages
D.) Separate files
Answer: D
78.) The ascending order of a data
hirerchy is:
Options are:
A.)
Bit-byte-file-record-field-database
B.)
Bit-byte-field-record-file-database
C.)
Bit-byte-record-field-file-database
D.)
Byte-bit-field-record-file-database
Answer: B
79.) Primitive operations common to
all record management system include
Options are:
A.) Look-up
B.) All of the options
C.) Print
D.) Sort
Answer: A
80.) Generalized database management
system do not retrieve data to meet routine request
Options are:
A.) False
B.) True
Answer: A
81.) Which of the following is not a
relational database?
Options are:
A.) dBase IV
B.) FoxPro
C.) Reflex
D.) 4th Dimension
Answer: C
82.) A top-to-bottom relationship
among the items in a database is established by a
Options are:
A.) Hierarchical schema
B.) All of the options
C.) Network schema
D.) Relational schema
Answer: A
83.) In order to use a record
management system
Options are:
A.) You need to understand the model
the record management system uses
B.) None of the options
C.) You need to understand the low
level details of how information is stored
D.) Both you need to understand the
model the record management system uses and you need to understand
the low level details of how
information is stored
Answer: A
84.) Choose the RDBMS which supports
full fledged client server application development
Options are:
A.) dBase V
B.) Ingress
C.) Oracle 7.1
D.) FoxPro 2.1
Answer: C
85.) Sort/Report generators
Options are:
A.) Are faster than index/report
generators
B.) Do not need to sort before
generating report
C.) Both require more disk space
than indexed/report generators and are faster than index/report
generators
D.) Require more disk space than
indexed/report generators
Answer: D
86.) The highest level in the hierarchy of data organization
is called
Options are:
A.) Data base
B.) Data record
C.) Data bank
D.) Data file
Answer: A
87.) Which of the following fields
in a student file can be used as a primary key?
Options are:
A.) Class
B.) GPA
C.) Major
Answer: D
88.) The management information
system (MIS) structure with one main computer system is called a
Options are:
A.) Decentralized MIS structure
B.) Centralized MIS structure
C.) Hierarchical MIS structure
D.) Distributed MIS structure
Answer: B
89.) In the DBMS approach,
application programs perform the
Options are:
A.) Storage function
B.) Access control
C.) All of the options
D.) Processing functions
Answer: D
90.) Which of the following is not
true of the traditional approach to information processing
Options are:
A.) It is file oriented
B.) It is inflexible
C.) There is common sharing of data
among the various applications
D.) Programs are dependent on the
file
Answer: C
91.) Batch processing is appropriate
if
Options are:
A.) Only a few transactions are
involved
B.) None of the options
C.) Large computer system is
available
D.) Only a small computer system is
avilbale
Answer: B
92.) Large collection of files are
called
Options are:
A.) Sectors
B.) Database
C.) Fields
D.) Records
Answer: B
93.) A transparent DBMS
Options are:
A.) Both can not hide sensitive
information from users and keeps its logical structure hidden from users
B.) Keeps its physical structure
hidden from users
C.) Can not hide sensitive
information from users
D.) Keeps its logical structure
hidden from users
Answer: B
94.) A file produced by a
spreadsheet
Options are:
A.) None of the options
B.) Is generally stored on disk in
an ASCII text fromat
C.) Can be used as is by the DBMS
D.) Both is generally stored on disk
in an ASCII text fromat and can be used as is by the DBMS
Answer: B
95.) The model for a record
management system might be
Options are:
A.) All of the options
B.) A business form
C.) Handwritten list
D.) A Rolodex card file
Answer: A
96.) Database management systems are
intended to
Options are:
A.) Eliminate data redundancy
B.) Establish relationship among
records in different files
C.) Manage file access and maintain
data integrity
D.) All of the options
Answer: D
97.) The language used application
programs to request data from the DBMS is referred to as the
Options are:
A.) DDL
B.) All of the options
C.) DML
D.) query language
Answer: C
98.) A set of programs that handle a
firm's database responsibilities is called
Options are:
A.) Database management system
(DBMS)
B.) Data management system (DMS)
C.) All of the options
D.) Database processing system
(DBPS)
Answer: C
99.) In a large DBMS
Options are:
A.) Each subschema contains every
field in the logical schema
B.) Each user can access every
subschema
C.) None of the options
D.) Each user can "see"
only a small part of the entire database
Answer: D
100.) In a large DBMS
Options are:
A.) None of the options
B.) Each user can "see"
only a small part of the entire database
C.) Each subschema contains every
field in the logical schema
D.) Each user can access every
subschema
Answer: B
0 Comments