InfyTQ Introduction to DBMS Quiz 3

Question 1

Time: 00:00:00
Scattering of data in a traditional file system is also known as ?

Data Isolation

Data Isolation

Data Integrity

Data Integrity

Data Redundancy

Data Redundancy

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
Which of the following are the advantages of DBMS ?

Data Integrity

Data Integrity

Reduction in Data Redundancy

Reduction in Data Redundancy

Reduction in Data Inconsistency

Reduction in Data Inconsistency

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 3

Time: 00:00:00
Database Management System follows which of the following ?

One-Tier Architecture

One-Tier Architecture

Two-Tier Architecture

Two-Tier Architecture

Three-Tier Architecture

Three-Tier Architecture

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 4

Time: 00:00:00
Database Management System provides __________ view to the user.

Complete

Complete

Partial

Partial

Abstract

Abstract

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 5

Time: 00:00:00
Which of the following is used to hide certain details of how data is stored and maintained inside?

Data Isolation.

Data Isolation.

Data Integrity.

Data Integrity.

Data Abstraction

Data Abstraction

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 of the following are the data models in the DBMS ?

Object Based Logical Data Model

Object Based Logical Data Model

Record Based Logical Data Model

Record Based Logical Data Model

Physical Data Model

Physical Data Model

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 7

Time: 00:00:00
Entity Relationship model is an example of ?

Object Based Logical Data Model

Object Based Logical Data Model

Record Based Logical Data Model

Record Based Logical Data Model

Physical Data Model

Physical Data Model

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 8

Time: 00:00:00
Data Model is a tool used for describing ?

Data.

Data.

Consistency Constraints.

Consistency Constraints.

Database Schema.

Database Schema.

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 9

Time: 00:00:00
How many Schema definitions are allowed in DBMS ?

1

1

3

3

5

5

6

6

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

Please login to submit your explanation

Start

Question 10

Time: 00:00:00
Mapping of logics and their relationships is known as ?

Physical Schema

Physical Schema

Conceptual Schema

Conceptual Schema

Logical Schema

Logical Schema

None of these

None of these

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%