Please login

Prime

Prepinsta Prime

Video courses for company/skill based Preparation

(Check all courses)
Get Prime Video
Prime

Prepinsta Prime

Purchase mock tests for company/skill building

(Check all mocks)
Get Prime mock

InfyTQ Introduction to DBMS Quiz 4

Question 1

Time: 00:00:00
Choose the correct order of the available database schemas ?

1→ Logical Schema 2→ Physical Schema 3→ Conceptual Schema

2 1 3

2 1 3

3 2 1

3 2 1

3 1 2

3 1 2

1 2 3

1 2 3

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 environment is also known as ?

Database Schema

Database Schema

Database design

Database design

Database Instance.

Database Instance.

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 3

Time: 00:00:00
The Process of modifying the database schema in lower level without affecting the schema in higher level is called as _________ ?

Data Abstraction

Data Abstraction

Data Integrity

Data Integrity

Data Independence

Data Independence

Data Redundancy

Data Redundancy

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

Please login to submit your explanation

Start

Question 4

Time: 00:00:00
How many different levels of Data Independence are there ?

1

1

2

2

3

3

4

4

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 level of independence has the ability to modify the logical schema without affecting the application program to rewrite the whole thing again ?

Logical Data Independence.

Logical Data Independence.

Physical Data Independence

Physical Data Independence

Both (a) and (b)

Both (a) and (b)

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 6

Time: 00:00:00
What is the meaning of the word ‘Tuple’ in reference to databases ?

An attribute attached to a record.

An attribute attached to a record.

Another name for the key linking different tables in a database

Another name for the key linking different tables in a database

A row or record in a database table.

A row or record in a database table.

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 part of the database holds only similar types of information ?

Report

Report

Field

Field

Record

Record

File

File

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

Please login to submit your explanation

Start

Question 8

Time: 00:00:00
What is the meaning of the word “relation” in a database ?

Tuple

Tuple

Table

Table

Attribute

Attribute

Field

Field

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

Please login to submit your explanation

Start

Question 9

Time: 00:00:00
Collection of data and the relationship between them is known as ?

Entity Relationship Model

Entity Relationship Model

Object based data Model

Object based data Model

Relational Model

Relational Model

Semi-structured data model

Semi-structured data model

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

Please login to submit your explanation

Start

Question 10

Time: 00:00:00
Which of the following terms is not related to the database ?

User data

User data

Meta data

Meta data

Reports

Reports

Indexes

Indexes

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!"]

Completed

0/0

Accuracy

0%

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%