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?

1103

What is the user of Primary key?

985

How does index makes search faster?

QuestPond,

979

How can we delete Duplicate row in table?

Wipro,

1066

How would you use user_constraints table in DB?

Wipro,

1008

Why do we backup Active Directory ?

1042

What is normalization? Describe its different types.

Wipro,

1103

What is the difference between DATETIME2 and DATETIME?

Infosys,

1079

What do you mean by the term 'normalization'?

Tech Mahindra,

1209

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

NA,

1028

What is the difference between TRUNCATE and DROP?

1140

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

1008

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

BirlaSoft, Verifone,

1112

Explain DBCC?

QuestPond,

960

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

1071

Un-Answered Questions { Databases }

What are the different column comparison operators in mysql?

941

what is oracle database ? : Sql dba

1026

can a stored procedure call itself or recursive stored procedure? : Sql dba

1028

How many types of data are there?

1002

Is there a way to detect whether fbclient.dll or fbembed.dll is loaded?

915

What is dml command?

966

What is primary key, unique key, and foreign key?

976

What is 3nf normalization form?

1111

Do provide an explanation for pgadmin?

825

What do you understand by query optimization?

1024

How do I show users in mysql?

1061

Mention what are the key characteristics of rac or why to use rac?

Explain can you move old files in the movechunk directory?

Explain data independence?

1027

Why is mongodb called mongodb?

For More Un-Answered { Databases } Questions Click Here