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,

1951

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

Ernst Young,

1170

Difference between rowid and rownum in SQL?

Virtusa,

1 1958

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

Tavant Technologies, Virtusa,

1 2792

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

Amazon,

997

What is the Difference Primary key and Unique Key

HCL,

1049

How many types of km's?

Infosys, Tech Mahindra,

628

Un-Answered Questions { Databases }

What are the differences between char and varchar2 in oracle?

1249

Is postgresql scalable?

881

Which is better Oracle or MS SQL? Why?

6495

Explain the field term used in database.

1014

How can we create the complete backup of data in the oracle.

2206

What is normalization and its types?

1080

What is an example of a schema?

855

What are the conditions kept in mind while connecting the oracle rac with the network?

Explain what is a view?

1119

Is mongodb normalized?

How would you import data from another ms access database?

926

I want to start and stop mysql on windows? How do I do that?

1116

What is dbms and its functions?

1056

What is artificial key?

939

What are enums used for in mysql?

1052

For More Un-Answered { Databases } Questions Click Here