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,

1858

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

Ernst Young,

1071

Difference between rowid and rownum in SQL?

Virtusa,

1 1784

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

Tavant Technologies, Virtusa,

1 2636

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

Amazon,

889

What is the Difference Primary key and Unique Key

HCL,

974

How many types of km's?

Infosys, Tech Mahindra,

554

Un-Answered Questions { Databases }

what is checksum in sql server.........???

1646

WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?

1982

What is history table in sql server?

912

How do I partition a table in sql server?

1000

What is database bounce?

998

Why is a trigger used?

905

Point out the difference between user tables and data dictionary?

946

Is microsoft access cloud based?

815

as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration

870

Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?

928

How many types of literals are available in pl sql?

1069

What is msdb database? : SQL Server Architecture

1084

how to increment dates by 1 in mysql? : Sql dba

946

What are the numeric comparison operations?

1072

What are the types of records?

967

For More Un-Answered { Databases } Questions Click Here