Basics Database Management System Multiple Choice Questions and Answers

Data can be used to make decisions only if:

It is in huge volume

It can be processed into information 

It is electronically generated

It contains numbers


Which of the following is data:

Web page

Image shot from phone

Fingerprint

All of the above


Anything which stores only unstructured data can be called a database.

True

False 


Which of the following is not true:

Database and Database management system (DBMS) are the same 

Database stores data.

Database management system is a software.

All of the above.


Which of the following is the purpose of DBMS:

Creation of database

Manipulation of data

Retrieving data from database

All of the above 


File based systems faces data integrity issues because:

Files contains textual information

Large data is stored in files

Duplicate files may have different values 

Files are changed frequently


What does same data being saved in multiple locations called

Inconsistency

Redundancy 

Integrity

Security


In File based systems it is easy to maintain concurrency control when multiple users are updating the same file.

True

False


File System in which each teacher of a college is maintaining their separate files concerning the same subjects taught in the course would lead to :

High data integrity

High data redundancy 

High data security

High efficiency to access data

If your laptop has the application like MS Access which is fetching data from some other system then it is an example of which type of architecture

1 tier
2 tier 
3 tier
None of the above.


In a software architecture which of the following is responsible for computing the result and returning it:

Client

Server 


What do you mean by data sharing in DBMS:

Same information is visible to everyone 

Different information is visible to everyone

Different versions of information is visible to everyone

Anyone can access data


What is/are the drawback of using DBMS:

Requires training

Complex to use

It is costly

All of the above 




Post a Comment

0 Comments