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,

1110

Difference between rowid and rownum in SQL?

Virtusa,

1 1860

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,

1001

How many types of km's?

Infosys, Tech Mahindra,

584

Un-Answered Questions { Databases }

What are the two types of data independence?

1130

How to select all records from the table?

1136

What is ms access and its components?

838

Explain database link?

1123

Define RDBMS.

1170

What is mongodb compass?

Which profile required to access ODI Console?

601

Explain four layers of abstraction microsoft architectured?

147

Is mysql still relevant?

909

What is ole db used for?

1014

How to stop database server in postgresql?

957

3. Steps in UAT?

2432

What is limit in dbms?

1048

What is data model in dbms?

912

What is system catalog or catalog relation?

1082

For More Un-Answered { Databases } Questions Click Here