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

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

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

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

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

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

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;

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

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?

&

&

_

_

%

%

$

$

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

null
null
×

Please login to report