[Updated] Goldman Sachs Aptitude Test Questions and Answers
Practice List of TCS Digital Coding Questions !!!
Take 50+ FREE!! Online Data Interpretation Mock test to crack any Exams.

# Technical Interview Questions and Answers :: Virtusa

206.19K

## Total Qs: 221+

•  Select All
•  SQL
•  C++
•  .NET
•  Oracle PLSQL
•  Informatica
•  WebMethod
•  DBMS
•  Soft. Engineering
•  Data Structure
•  Networking
•  C
•  Operating System
•  HR Question in TR
•  Java

11 / 221

Can you briefly introduce yourself?

No Discussion on this question yet!

12 / 221

What is self join?

USED TO CONVERT HIERACHICAL STRUCTURE TO THE FLAT STRUCTURE. IT IS USED TO JOIN A TABLE ITSELF AS LIKE IF THAT IS THE SECOND TABLE

13 / 221

What is Lossless join property?

It guarantees that the spurious tuple generation does not occur with respect to relation schemas after decomposition.

14 / 221

What is 1 NF (Normal Form)?

The domain of an attribute must include only atomic (simple, indivisible) values.

15 / 221

What is Fully Functional dependency?

It is based on the concept of full functional dependency. A functional dependency X -> Y is full functional dependency if removal of any attribute A from X means that the dependency does not hold any more.

16 / 221

What is 2NF?

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.

17 / 221

What is 3NF?

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.

18 / 221

What is BCNF (Boyce-Codd Normal Form)?

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.

19 / 221

What is 4NF?

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.

20 / 221

What is 5NF?