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

What is a Join and explain its types?

1064

What is the user of Primary key?

941

How does index makes search faster?

QuestPond,

936

How can we delete Duplicate row in table?

Wipro,

1019

How would you use user_constraints table in DB?

Wipro,

966

Why do we backup Active Directory ?

1012

What is normalization? Describe its different types.

Wipro,

1056

What is the difference between DATETIME2 and DATETIME?

Infosys,

1039

What do you mean by the term 'normalization'?

Tech Mahindra,

1150

What is the difference between clustered and a non-clustered index?

NA,

998

What is the difference between TRUNCATE and DROP?

1085

What are the disadvantages of using querystrings to send data from one page to another?

959

What is the difference between ddl,dml and dcl commands?

BirlaSoft, Verifone,

1079

Explain DBCC?

QuestPond,

925

Explain what role entity and relationship play in an ER diagram.

1041

Un-Answered Questions { Databases }

How to get last row id?

956

How do you maintain a database?

900

What is Record-at-a-time?

807

What is a sql trace file?

999

How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?

996

Can you have more than one key in a database?

905

Can we rollback truncate?

966

What is indexing in sql and its types?

1025

how to include character strings in sql statements? : Sql dba

1022

State some uses of redo log files?

965

How to convert the oracle reports to excel sheet from oracle?

What is the exist operator?

What are aggregate functions in sql?

1116

Which sql statement is used to delete data from a database?

920

Explain what are commit and rollback in sql?

883

For More Un-Answered { Databases } Questions Click Here