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

Why should we go for stored procedures? Why not direct queries?

1100

What number sorts of privileges are accessible in sql?

1037

What are the difference between primary keys and foreign keys?

966

Define normalisation?

1118

How can you control the amount of free space in your index pages?

1057

What is sql sandbox in sql server?

1226

What is dbcc?

1139

How to delete exactly duplicate records from a table?

1063

What is the contrast amongst drop and truncate?

1034

What are data files?

1042

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

991

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

1043

On a windows server 2003 active – passive failover cluster, how do you find the node which is active?

1206

What is the use of nvl work?

1004

How to optimize stored procedures in sql server?

1185

Un-Answered Questions { Databases }

What is natural key?

991

How can an index be declared in mysql?

948

what are the acid properties in dbms?

1020

What is sql*plus?

1082

Why do I need netlib?

1014

How do you kill a long running query in mysql?

900

How to find tables without indexes?

1090

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

2270

How do I know if oracle client is installed on windows?

1024

what are the types of subquery? : Sql dba

1105

HI Friends I m new dev(forms & report). can anyone tell me how we upload a document on form 11g.??

1452

What is external database?

863

How do you prevent oracle from giving you informational messages during and after a sql statement execution?

582

What is the osql utility?

975

What is the innodb in mysql?

1044

For More Un-Answered { Databases } Questions Click Here