Technical Interview Questions and Answers :: Sapient

10.11K

## Total Qs: 70+

•  Select All
•  SQL
•  Java
•  C++
•  Informatica
•  Operating System
•  Soft. Engineering
•  DBMS
•  C
•  HR Question in TR
•  Data Structure
•  HTML
•  PHP

21 / 70

What is 2NF?
| | To Reading List | Asked In

A relation schema R is in 2NF if it is in 1NF and every non-prime attribute A in R is fully functionally dependent on primary key.

22 / 70

What is 3NF?
| | To Reading List | Asked In

A relation schema R is in 3NF if it is in 2NF and for every FD X -> A either of the following is true
> X is a Super-key of R.
> A is a prime attribute of R.
In other words, if every non prime attribute is non-transitively dependent on primary key.

23 / 70

What is BCNF (Boyce-Codd Normal Form)?
| | To Reading List | Asked In

A relation schema R is in BCNF if it is in 3NF and satisfies an additional constraint that for every FD X -> A, X must be a candidate key.

24 / 70

What is 4NF?
| | To Reading List | Asked In

A relation schema R is said to be in 4NF if for every Multivalued dependency X ->-> Y that holds over R, one of following is true
> X is subset or equal to (or) XY = R.
> X is a super key.

25 / 70

What is 5NF?
| | To Reading List | Asked In

A Relation schema R is said to be 5NF if for every join dependency {R1, R2, ..., Rn} that holds R, one the following is true
> Ri = R for some i.
> The join dependency is implied by the set of FD, over R in which the left side is key of R.

26 / 70

| | To Reading List | Asked In

When there is more than one constructor in a class with different parameters and with different data types we say that the constructor is overloaded.

27 / 70

What is paging & Why paging is used ?
| | To Reading List | Asked In

No Discussion on this question yet!

28 / 70

Define software engineering?
| | To Reading List | Asked In

29 / 70

Define testing?
| | To Reading List | Asked In

No Discussion on this question yet!

| | To Reading List | Asked In