Prepare
- All Platforms
- Programming
- Aptitude
- Syllabus
- Interview Preparation
- Interview Exp.
- Off Campus
- Prime Video
- Prime Mock
PrepInsta Prime
OffCampus
The Job Company
Placement Stats

Prime Video
Prime Mock

⁰

Notifications Mark All Read

7 Day TCS NQT Crash Course is available at just 1999. Click here to Purchase
Login
Get Prime

InfyTQ Menu

What is InfyTQ ?
Placement Papers
Registration Process
Certification Round
- Certification Round Details
- Certification Round Practice Questions
Java
- Java Round
- Java MCQ Practice Questions
Python
- Python Round
- Python MCQ Practice Questions
DBMS
- DBMS Round
- DBMS MCQ Practice Questions
Coding Questions
Advantage Round
Syllabus
Recruitment Process
How to Prepare
InfyTQ Results
Interview Experiences

Get Hiring Updates
Contact us

PrepInsta MockMock
Prime VideoVideo

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

Partial functional dependency

Transitive functional dependency

Both B and C

Good Job!

Oops!

Report the answer

How to use PrepInsta Quiz

PrepInsta Explanation
User Explanation

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

Partial functional dependency is not present in given following functional dependency.

You can find more details about functional dependency here

Please login to submit your explanation

You can check your performance of this question after Login/SignupLogin

Start

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

OLAP

OLAM

None of the above

Good Job!

Oops!

Report the answer

How to use PrepInsta Quiz

PrepInsta Explanation
User Explanation

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

Explanation: OLTP the correct processing technique for the given statements.

Please login to submit your explanation

You can check your performance of this question after Login/SignupLogin

Start

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

in 2NF but not in 3NF

in 3NF but not in 2NF

in both 2NF and 3NF

Good Job!

Oops!

Report the answer

How to use PrepInsta Quiz

PrepInsta Explanation
User Explanation

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

R1∩R2 ≠ Ø means there is common attribute in R1 and R2.

Now if we choose a decomposition positively then we can choose something like R1(S, T, U) and R2(U, V) then we can say that decomposition is lossless because common attribute is U and LHS of every FDs are candidate key, therefore it is in 2NF as well as 3NF.

Please login to submit your explanation

You can check your performance of this question after Login/SignupLogin

Start

Question 4

Time: 00:00:00

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

has multiple candidate keys

has candidate keys that are composite

has overlapped candidate keys

all of the above

Good Job!

Oops!

Report the answer

How to use PrepInsta Quiz

PrepInsta Explanation
User Explanation

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

Third normal form is considered adequate for relational database design, it is inadequate in all situations with the relation having multiple, composes or overlapped candidate keys.

Please login to submit your explanation

You can check your performance of this question after Login/SignupLogin

Start

Question 5

Time: 00:00:00

5NF is designed to cope with:

Transitive dependency

Join dependency

Multivalued dependency

None of these

Good Job!

Oops!

Report the answer

How to use PrepInsta Quiz

PrepInsta Explanation
User Explanation

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

Ans: B

Explanation: 5NF is designed to cope with Join dependency.

Please login to submit your explanation

You can check your performance of this question after Login/SignupLogin

Start

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

From, select

Select, from

From, where

Good Job!

Oops!

Report the answer

How to use PrepInsta Quiz

PrepInsta Explanation
User Explanation

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

Answer: Option (A)

Explanation: Where selects the rows on a particular condition. From gives the relation which involves the operation.

Please login to submit your explanation

You can check your performance of this question after Login/SignupLogin

Start

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 instructor natural join teaches;

Select name, course_id from the instructor;

Select course_id from instructor join teaches;

Good Job!

Oops!

Report the answer

How to use PrepInsta Quiz

PrepInsta Explanation
User Explanation

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

Answer: Option (B)

Explanation: Join clause joins two tables by matching the common column.

Please login to submit your explanation

You can check your performance of this question after Login/SignupLogin

Start

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

Employee

Salary

All the field of employee relation

Good Job!

Oops!

Report the answer

How to use PrepInsta Quiz

PrepInsta Explanation
User Explanation

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

Answer: Option (D)

Explanation: Here * is used to select all the fields of the relation.

Please login to submit your explanation

You can check your performance of this question after Login/SignupLogin

Start

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!

Report the answer

How to use PrepInsta Quiz

PrepInsta Explanation
User Explanation

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

In the above-given Query, the "%" (like) operator will be used, which is generally used while searching for a certain pattern in the strings. It represents the single and multiple characters. In this case, it is used with the "Where" clause to select the "dept_name" that contains the Computer Since as its ending string. To understand it more clearly, consider the following syntax:

Syntax

SELECT column1, column2, ...

FROM table_name

WHERE columnN LIKE pattern;

Please login to submit your explanation

You can check your performance of this question after Login/SignupLogin

Start

Question 10

Time: 00:00:00

What do you mean by one-to-many relationships?

One class may have many teachers

One teacher can have many classes

Many classes may have many teachers

Good Job!

Oops!

Report the answer

How to use PrepInsta Quiz

PrepInsta Explanation
User Explanation

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

Answer: Option (B)
Explanation: We can understand the "one to many" relationship as a teacher who may have more than one class to attend.

Please login to submit your explanation

You can check your performance of this question after Login/SignupLogin

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

Start Preparing

Detailed performance

Completed

0/10

Accuracy

Related Banners

Prepinsta Prime

Get Prepinsta Prime

Get all 200+ courses offered by Prepinsta

Explore Prime or check Course List

Check out our instagram

Never Miss an OffCampus Update

Get OffCampus Updates on Social Media from PrepInsta

Instagram

Get Hiring Updates

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

PrepInsta 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

PrepInsta 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