Computer Fundamentals Multiple choice Questions and Answers on Components of DBMS for Freshers

1. DBMS is a set of __________ to access the data.

a) Codes
b) Programs
c) Information
d) Metadata
Answer: b

Explanation: Database is a set of programs designed to access the data. It contains information about a particular enterprise.
2. DBMS provides a convenient and efficient environment.

a) True
b) False
Answer: a

Explanation: The statement is true. DBMS stands for Database Management System. It provides an efficient and easy to use environment.
3. Which of the following isn’t a level of abstraction?

a) physical
b) logical
c) user
d) view
Answer: c

Explanation: There are three levels of abstraction: physical, logical and the view level. These three levels are involved in DBMS.
4. A level that describes how a record is stored.

a) physical
b) logical
c) user
d) view
Answer: a

Explanation: The answer is physical. The physical level describes how the record gets stored.
e.g. Customer.
5. The ______level helps application programs hide the details of data types.

a) physical
b) logical
c) user
d) view
Answer: d

Explanation: The application programs hide details of datatypes. Views can also hide information for security purposes.
6. A logical structure of the database.

a) Schema
b) Attribute
c) Parameter
d) Instance
Answer: a

Explanation: A schema is the logical structure of the database. e.g A set of customers and accounts and their relationship.
7. The actual content in the database at a particular point.

a) Schema
b) Attribute
c) Parameter
d) Instance
Answer: d

Explanation: The answer is Instance. Instance is the actual content of the database at a particular point of time.
8. Which of the following is not an object-based logical model?

a) ER
b) Network
c) Semantic
d) Functional
Answer: b

Explanation: Network model is a part of record-based logical model and not object-based. Others are object based models. ER stands for Entity-relationship.
9. SQL is _______

a) Relational
b) Network
c) IMS
d) Hierarchical
Answer: a

Explanation: SQL or structured query language is a relational model. It comes under record-based logical models.
10. A level that describes data stored in a database and the relationships among the data.

a) physical
b) logical
c) user
d) view
Answer: b

Explanation: The answer is logical. The logical level describes the relationships between the data. Physical level describes how the data is stored.

Related

CSS Multiple Choice Questions & Answers on Generated Content for Freshers

1. Which of the following selector same as :after; changed under CSS3 to make pseudo-elements obvious? a) ::after b) :after c) #after d) none of the mentioned Answer: a Explanation:...

Java Multiple Choice Questions & Answers on Java.util package BitSet & Date class for Freshers

1. Which of these class object has architecture similar to that of array? a) Bitsetb) Mapc) Hashtabled) All if the mentioned Answer: a Explanation: Bitset class creates a special type of array th...

C Programming Questions and Answers on Structures and Functions for Freshers

1. What is the output of this C code? #include struct student { char *name; }; struct student s; struct student fun(void) { s.name = "new...

Post a Comment

emo-but-icon
:noprob:
:smile:
:shy:
:trope:
:sneered:
:happy:
:escort:
:rapt:
:love:
:heart:
:angry:
:hate:
:sad:
:sigh:
:disappointed:
:cry:
:fear:
:surprise:
:unbelieve:
:shit:
:like:
:dislike:
:clap:
:cuff:
:fist:
:ok:
:file:
:link:
:place:
:contact:

item