InfyTQ Introduction to DBMS Quiz 1

Question 1

Time: 00:00:00
Database is also known as ?

Collection of Program

Collection of Program

Collection of Data

Collection of Data

Collection of Modules

Collection of Modules

None of the above

None of the above

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 2

Time: 00:00:00
Database management system is a collection of _____________ and set of data programs to access them.

Interrelated Programs

Interrelated Programs

Interrelated Data Structure

Interrelated Data Structure

Databases

Databases

Interrelated Data

Interrelated Data

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 3

Time: 00:00:00
Which among the following is considered as a DBMS ?

ORACLE.

ORACLE.

MYSQL.

MYSQL.

FoxPro.

FoxPro.

All of these.

All of these.

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 4

Time: 00:00:00
Which storage system was used before DBMS came into existence ?

File Management Storage System.

File Management Storage System.

Cloud Storage.

Cloud Storage.

Data System.

Data System.

None of These.

None of These.

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 5

Time: 00:00:00
Full form of DBA is ?

Database Admin

Database Admin

Database Administrator

Database Administrator

Database Application

Database Application

None of the above

None of the above

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 6

Time: 00:00:00
Which among the following is the lowest level of abstraction for a user ?

Conceptual Level

Conceptual Level

View Level

View Level

Physical Level

Physical Level

None of these

None of these

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 7

Time: 00:00:00
Which among the following shows only the user interface to the user not how the data is stored in the system ?

View Level

View Level

Conceptual Level

Conceptual Level

Physical Level

Physical Level

None of these.

None of these.

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 8

Time: 00:00:00
Which of the following acts as an interface between Database Application and Database ?

DBMS

DBMS

Database and User

Database and User

Data

Data

All of the above

All of the above

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 9

Time: 00:00:00
Data Duplication in DBMS is also known as ?

Data Isolation

Data Isolation

Atomicity Problem

Atomicity Problem

Data Redundancy

Data Redundancy

Data Inconsistency

Data Inconsistency

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 10

Time: 00:00:00
If the common fields are not matching in the Database then it is known as ?

Data Isolation

Data Isolation

Data Integrity

Data Integrity

Data Redundancy

Data Redundancy

Data Inconsistency

Data Inconsistency

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

["0","40","60","80","100"]
["Need more practice!","Keep trying!","Not bad!","Good work!","Perfect!"]

Personalized Analytics only Availble for Logged in users

Analytics below shows your performance in various Mocks on PrepInsta

Your average Analytics for this Quiz

Rank

-

Percentile

0%

Completed

0/0

Accuracy

0%

Comments