Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Two tables emp(empid,name,deptid,sal) and dept(deptid,deptname) are there.write a query which displays empname,corresponding deptname also display those employee names who donot belong to any dept.

Amazon,

1895

What is the difference between primary key, foreign key and candidate key?

Ernst Young,

1109

Difference between rowid and rownum in SQL?

Virtusa,

1 1858

How can you swap values between two rows in a table using single- SQL statement?

Tavant Technologies, Virtusa,

1 2703

Write an sql query to sort a table according to the amounts in a row and find the second largest amount.

Amazon,

923

What is the Difference Primary key and Unique Key

HCL,

1000

How many types of km's?

Infosys, Tech Mahindra,

584

Un-Answered Questions { Databases }

If the valueset if of type –TABLE then how many tables can we attach in the valueset ?

2327

How do I save a stored procedure?

1008

How to use rank function in mysql?

989

how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....

2061

What is best institute to Learn DotNET And SQL in chennai?

2161

How many row comparison operators are used while working with a subquery?

1030

how files are stored in Neo4j?

How to enable tcp/ip protocol on a sql server?

1161

What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?

1141

Why we use mongodb instead of mysql?

968

What is the use of graph database?

1040

What is difference between drop and delete?

935

How would you change old and new values in an insert, delete and update triggers?

1020

What is the basic structure of an sql?

1098

What are the differences between char and varchar in ms sql server?

1063

For More Un-Answered { Databases } Questions Click Here