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

Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)

Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)

DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)

Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)

Database Management (1411)
Databases AllOther (288)

Databases Interview Questions

Questions Answers Views Company eMail

Explain datetimeoffset data type in sal server 2008?

866

What is buffer cash in sql server?

1114

Define master database?

1007

Explain transaction server auto commit?

1000

What are the essential components of sql server service broker?

979

Why do we use non clustered index?

1027

How to use the inserted and deleted pseudo tables?

925

Define full outer join?

903

Explain concepts of analysis services?

902

Explain where clause?

941

What are the advantages of sql stored procedure?

1032

Explain syntax for disabling triggers?

988

Define left outer join?

936

How dts is used to extract, transform and consolidate data?

1035

How to implement service broker?

942

Un-Answered Questions { Databases }

Explain the dbcc pintable command when would you use it?

878

What is the life of an sql statement?

982

What is the phantom problem?

964

Can we commit inside a function in oracle?

933

What to do if dba lost the system password?

1109

How do I edit a stored procedure?

960

Who developed mongodb?

How to specify transaction or query timeout?

994

How can we find duplicate records in a table?

906

How would concatenate strings in mysql?

976

How do I setup a mysql database?

936

Define ddl and dml.

1001

What are extended events in sql server?

919

What is the difference between varchar and varchar types?

1017

How do I delete a table in postgresql?

810

For More Un-Answered { Databases } Questions Click Here