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

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.

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

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

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

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

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

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

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  

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

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/10

Accuracy

0%

Get Prepinsta Prime

Get all 200+ courses offered by Prepinsta

Never Miss an OffCampus Update

Get OffCampus Updates on Social Media from PrepInsta

Follow us on our Media Handles, we post out OffCampus drives on our Instagram, Telegram, Discord, Whatsdapp etc.

Get Hiring Updates
Amazon,Google,Delottie & 30+companies are hiring ! Get hiring Updates right in your inbox from PrepInsta

Get over 200+ course One Subscription

Courses like AI/ML, Cloud Computing, Ethical Hacking, C, C++, Java, Python, DSA (All Languages), Competitive Coding (All Languages), TCS, Infosys, Wipro, Amazon, DBMS, SQL and others.

Get over 200+ course One Subscription

Courses like AI/ML, Cloud Computing, Ethical Hacking, C, C++, Java, Python, DSA (All Languages), Competitive Coding (All Languages), TCS, Infosys, Wipro, Amazon, DBMS, SQL and others.

Get PrepInsta Prime Subscription

Get access to all the courses that PrepInsta offers, check the out below -

Companies

TCS, Cognizant, Delloite, Infosys, Wipro, CoCubes, KPMG, Amazone, ZS Associates, Accenture, Congnizant & other 50+ companies

Programming

Data Structures, Top 500 Codes, C, C++, Java Python & other 10+ subjects

Skills

Full Stack Web Development, Data Science, Machine Learning, AWS Cloud, & other 10+ skills and 20+ projects