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

Oracle (3253)
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 normalization? Explain different forms of normalization?

1235

Explain candidate key, alternate key, and composite key?

1062

Please explain go command in sql server?

1116

Tell me what is log shipping?

1037

Do you know what is lock escalation?

1058

What are the different index configurations a table can have?

1015

Explain difference between cross join and full outer join?

1068

What is the stuff and how does it differ from the replace function?

1229

Explain what is use of dbcc commands?

1145

Explain what is raid and what are different types of raid levels?

1094

Explain the use of keyword with encryption. Create a store procedure with encryption?

1011

Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many

990

Explain what are the basic functions for master, msdb, model, tempdb databases?

1031

Explain what are commit and rollback in sql?

983

please differentiate between delete and truncate?

1041

Un-Answered Questions { Databases }

how do u compile a form i.e .fmb file in Unix or in dos

4621

what are the non-standard sql commands supported by 'mysql'? : Sql dba

1180

What is the date format in mysql?

948

Is mysqli deprecated?

1019

What are the four Oracle system processes that must always be up and running for the database to be useable?

1056

Why we use triggers in mysql?

1045

What is local temp table?

1026

What happens if you lost a data file?

1085

How many triggers you can have on a table?

1035

Is record in oracle pl sql?

1017

Can I use a named pipe to bcp/dump data out or in in sybase?

1067

How much does mongodb cost?

Can we insert data into a view?

1196

Is sql a postgresql?

994

How do databases work?

957

For More Un-Answered { Databases } Questions Click Here