Database Management System
Questions 31 to 40
31.
|
Data
management is a discipline that focuses on
(a) The management of end users
(b) The proper generation, storage, and
retrieval of data
(c) The help items to be used by end users
(d) The proper generation, storage, and
retrieval of information
(e) The management of data bases.
|
32.
|
The DBMS
allows you to extrapolate information from your data by using
(a) Query language (b)
Table generator
(c) Security system
(d) Access control (e)
Program.
|
33.
|
One of
the advantages of a relational database model is
(a) Structural dependence (b) Conceptual complexity
(c) Complex database design (d) Easier database design
(e) Structural independence.
|
34.
|
A DBMS
performs several important functions that guarantee the integrity and
consistency of the data in the database.
Which of the following is NOT one of those functions?
(a) Data integrity (b) Storage management (c)
Data reports
(d) Security management (e)
Data consistency.
|
35.
|
The most
important advantages of the hierarchical database model are
(a) Conceptual simplicity, security, integrity,
diversity, and security
(b) Security, efficiency, diversity, simplicity,
and integrity
(c) Integrity, efficiency, diversity,
independence, and simplicity
(d) Conceptual simplicity, security, hierarchy
(e) Conceptual simplicity, security,
independence, integrity, and efficiency.
|
36.
|
The most
widely used conceptual model is the ______________.
(a) E-R model (b) Chen model (c) External model
(d) Attribute model (e)
Use-case Model.
|
37.
|
The
_____model represents a global view of the data.
(a) Internal (b) External (c) Physical
(d) Conceptual (e) High-level.
|
38.
|
The ____
model operates at the lowest level of abstraction, describing how the data is
saved on storage devices.
(a) Internal (b) External (c) Physical
(d) Conceptual (e) View level.
|
39.
|
A ____
attribute is an attribute that can be further subdivided to yield additional
attributes.
(a) Composite (b) Simple (c) Single-valued (d) Multivalued (e)
Derived.
|
40.
|
The
entity integrity rule requires that
(a) All primary key entries are not unique
(b) A part of the key may be null
(c) Foreign key values do not reference primary
key values
(d) Duplicate object values are allowed
(e) All primary key entries are unique.
|
Answers
31.
|
Answer : (b)
|
32.
|
Answer : (a)
Reason : Query language is used to interact with
the database
|
33.
|
Answer : (d)
Reason: Relational data base helps us to design the
data base in a easier manner.
|
34.
|
Answer : (c)
Reason : Data reports is not a function of DBMS
|
35.
|
Answer : (e)
Reason : The main important advantage of hierarchical
data base model is conceptual simplicity, security, independence, integrity
and efficiency
|
36.
|
Answer : (a)
Reason: Most widely used conceptual model is the E-R
model.
|
37.
|
Answer : (d)
Reason : Conceptual model represents the global view
of the data
|
38.
|
Answer : (c)
Reason: Physical model operates at the lowest level
of abstraction.
|
39.
|
Answer : (a)
Reason : Composite attribute can be further divided into additional
attributes
|
40.
|
Answer : (e)
Reason: All primary key entries are unique.
|
<< Prev 1... 2... 3... 4... 5... 6... 7... 8... 9... 10... 11... 12... 13... 14... 15... 16... 17... 18... 19... 20... 21... 22... 23... 24... 25... 26... 27... 28... 29... 30... 31... 32... 33... 34... 35... 36... Next >>
Very nice Questions/answers . Tanx for sharing such kind of usefull information. Gbu!
ReplyDeleteThanks for the FANTASTIC post! This information is really good and thanks a ton for sharing it :-) I m looking forward desperately for the next post of yours..garden of life primal defense
ReplyDeleteThanks for offering us such a useful details. Keep up the great work. You can also check out this awarded Vitamin supplement store for nutritional supplements from leading brands. Vitamins and Supplements Canada
ReplyDelete