InfyTQ Normalization Quiz 1

Question 1

Time: 00:00:00
Which functional dependency types is/are not present in the following dependencies?

Empno -> EName, Salary, Deptno, DName

DeptNo -> DName

EmpNo -> DName

Full functional dependency

Full functional dependency

Partial functional dependency

Partial functional dependency

Transitive functional dependency

Transitive functional dependency

Both B and C

Both B and C

Good Job!

Oops!

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

Please login to submit your explanation

Question 2

Time: 00:00:00
Choose the correct processing technique for the given statements.

Identify the correlation between salary structure and policies sold made by Insurance agents in an organization.

OLTP

OLTP

OLAP

OLAP

OLAM

OLAM

None of the above

None of the above

Good Job!

Oops!

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

Please login to submit your explanation

Question 3

Time: 00:00:00
Consider the schema R(S, T, U, V) and the dependencies S→T, T→U, U→V, V→S. Let R= {R1, R2} such that R1\cap R2=\phi . Then the decomposition is :

not in 2NF

not in 2NF

in 2NF but not in 3NF

in 2NF but not in 3NF

in 3NF but not in 2NF

in 3NF but not in 2NF

in both 2NF and 3NF

in both 2NF and 3NF

Good Job!

Oops!

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

Please login to submit your explanation

Question 4

Time: 00:00:00
The third normal form is inadequate in situations where the relation:

has multiple candidate keys

has multiple candidate keys

has candidate keys that are composite

has candidate keys that are composite

has overlapped candidate keys

has overlapped candidate keys

all of the above

all of the above

Good Job!

Oops!

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

Please login to submit your explanation

Question 5

Time: 00:00:00
5NF is designed to cope with:

Transitive dependency

Transitive dependency

Join dependency

Join dependency

Multivalued dependency

Multivalued dependency

None of these

None of these

Good Job!

Oops!

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

Please login to submit your explanation

Question 6

Time: 00:00:00
The ______ clause allows us to select only those rows in the result relation of the ____ clause that satisfy a specified predicate.

Where, from

Where, from

From, select

From, select

Select, from

Select, from

From, where

From, where

Good Job!

Oops!

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

Please login to submit your explanation

Question 7

Time: 00:00:00
This Query can be replaced by which one of the following?

SELECT name, course_id

FROM instructor, teaches

WHERE instructor_ID= teaches_ID;

Select name,course_id from teaches,instructor where instructor_id=course_id;

Select name,course_id from teaches,instructor where instructor_id=course_id;

Select name, course_id from instructor natural join teaches;

Select name, course_id from instructor natural join teaches;

Select name, course_id from the instructor;

Select name, course_id from the instructor;

Select course_id from instructor join teaches;

Select course_id from instructor join teaches;

Good Job!

Oops!

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

Please login to submit your explanation

Question 8

Time: 00:00:00
SELECT * FROM employee WHERE salary>10000 AND dept_id=101;

Which of the following fields are displayed as output?

Salary, dept_id

Salary, dept_id

Employee

Employee

Salary

Salary

All the field of employee relation

All the field of employee relation

Good Job!

Oops!

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

Please login to submit your explanation

Question 9

Time: 00:00:00
Ready the Query carefully:

SELECT emp_name

FROM department

WHERE dept_name LIKE ' _____ Computer Science';

In the above-given Query, which of the following can be placed in the Query's blank portion to select the "dept_name" that also contains Computer Science as its ending string?

&

&

_

_

%

%

$

$

Good Job!

Oops!

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

Please login to submit your explanation

Question 10

Time: 00:00:00
What do you mean by one-to-many relationships?

One class may have many teachers

One class may have many teachers

One teacher can have many classes

One teacher can have many classes

Many classes may have many teachers

Many classes may have many teachers

Many classes may have many teachers

Many classes may have many teachers

Good Job!

Oops!

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

Please login to submit your explanation

["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

Get over 200+ Courses under One Subscription

Get Prime Course List
mute
Limitless Learning

One Subscription access everything

Job Assistance

Get Access to PrepInsta Prime

Top Faculty

from FAANG/IITs/TOP MNC's

Get Prime

Don’t settle Learn from the Best with PrepInsta Prime Subscription

manish-prepinsta

Manish Agarwal

Ex- Accenture

Trained 3.2L+ students

Rushikesh-prepinsta

Rushikesh Konapure

Data Science & Full Stack Mentor

Trained 35k+ students

atulya-prepinsta

Atulya Kaushik

Ex- Google & Instamojo

Trained 3.2L+ students

Aashay-prepinsta

Aashay Mishra

Ex- Sapient

Trained 83k+ students

Janvi-prepinsta

Janvi Jain

Lead Verbal Mentor

Trained 46k+ students

Learn from Top 1%
Get Prime
prepinsta
prepinsta
prepinsta
prepinsta

One Subscription, For Everything

The new cool way of learning and upskilling -

Limitless Learning

One Subscription access everything

Job Assistance

Get Access to PrepInsta Prime

Top Faculty

from FAANG/IITs/TOP MNC's

Get Prime →

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 Prime Course List
Get Prime Course List

March 26, 2021