InfyTQ Normalization Quiz 3

Question 1

Time: 00:00:00
Tables in second normal form (2NF):

Eliminate all hidden dependencies

Eliminate all hidden dependencies

Eliminate the possibility of insertion anomalies

Eliminate the possibility of insertion anomalies

Have a composite key

Have a composite key

None of the mentioned

None of the mentioned

Good Job!

Oops!

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

Please login to submit your explanation

Start

Question 2

Time: 00:00:00
If a multivalued dependency holds and is not implied by the corresponding functional dependency, it usually arises from one of the following sources.

A many-to-many relationship set

A many-to-many relationship set

A multivalued attribute of an entity set

A multivalued attribute of an entity set

A one-to-many relationship set

A one-to-many relationship set

Both A many-to-many relationship set and A multivalued attribute of an entity set.

Both A many-to-many relationship set and A multivalued attribute of an entity set.

Good Job!

Oops!

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

Please login to submit your explanation

Start

Question 3

Time: 00:00:00
In which of the following, a separate schema is created consisting of that attribute and the primary key of the entity set.

A many-to-many relationship set

A many-to-many relationship set

A multivalued attribute of an entity set

A multivalued attribute of an entity set

A one-to-many relationship set

A one-to-many relationship set

All of the mentioned

All of the mentioned

Good Job!

Oops!

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

Please login to submit your explanation

Start

Question 4

Time: 00:00:00
Suppose the user finds the usage of room number and phone number in a relational schema there is confusion. This is reduced by

Unique-role assumption

Unique-role assumption

Unique-key assignment

Unique-key assignment

Role integral assignment

Role integral assignment

None of the mentioned

None of the mentioned

Good Job!

Oops!

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

Please login to submit your explanation

Start

Question 5

Time: 00:00:00
Designers use which of the following to tune the performance of systems to support time-critical operations?

Redundant optimization

Redundant optimization

Optimization

Optimization

Realization

Realization

Denormalization

Denormalization

Good Job!

Oops!

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

Please login to submit your explanation

Start

Question 6

Time: 00:00:00
In the schema (dept name, size) we have relations total inst 2007, total inst 2008. Which dependency has led to this relation?

Dept name, year->size

Dept name, year->size

Year->size

Year->size

Dept name->size

Dept name->size

Size->year

Size->year

Good Job!

Oops!

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

Please login to submit your explanation

Start

Question 7

Time: 00:00:00
Thus a _______, of course, data gives the values of all attributes, such as title and department, of all courses at a particular point in time.

Instance

Instance

Snapshot

Snapshot

Both Instance and Snapshot

Both Instance and Snapshot

All of the mentioned

All of the mentioned

Good Job!

Oops!

  • PrepInsta Explanation
  • User Explanation
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 has each related entity set has its own schema and there is an additional schema for the relationship set?

A many-to-many relationship set

A many-to-many relationship set

A multivalued attribute of an entity set

A multivalued attribute of an entity set

A one-to-many relationship set

A one-to-many relationship set

None of the mentioned

None of the mentioned

Good Job!

Oops!

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

Please login to submit your explanation

Start

Question 9

Time: 00:00:00
In 2NF

No functional dependencies (FDs) exist

No functional dependencies (FDs) exist

No multivalued dependencies (MVDs) exist

No multivalued dependencies (MVDs) exist

No partial FDs exist

No partial FDs exist

No partial MVDs exist  

No partial MVDs exist  

Good Job!

Oops!

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

Please login to submit your explanation

Start

Question 10

Time: 00:00:00
Information architecture influences:

Answer choice

Answer choice

Site structure

Site structure

Labeling

Labeling

Navigation design

Navigation design

Good Job!

Oops!

  • PrepInsta Explanation
  • User Explanation
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!"]
×

Please login to report

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%

Start Preparing
Detailed performance

Completed

0/0

Accuracy

0%

March 26, 2021