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

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

1 1179

What number sorts of privileges are accessible in sql?

1 1115

What are the difference between primary keys and foreign keys?

1 1038

Define normalisation?

1 1180

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

1 1126

What is sql sandbox in sql server?

1 1329

What is dbcc?

1 1200

How to delete exactly duplicate records from a table?

1 1135

What is the contrast amongst drop and truncate?

1 1100

What are data files?

1 1117

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

1 1071

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

1 1100

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

1 1265

What is the use of nvl work?

1 1065

How to optimize stored procedures in sql server?

1 1266

Un-Answered Questions { Databases }

Are you familiar with user exits in reports?

how to use regular expression in pattern match conditions? : Sql dba

1105

Can we rollback truncate?

1072

What are the different subsets of sql?

1646

What is a concurrency problem in dbms?

1049

What is standby servers? Explain types of standby servers.

1070

Were you involved in any data conversion, which one?

Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

2175

Design database draw er diagram for a certain scenario ?

4645

How to start an oracle instance?

1096

Disadvantages of the indexes?

1218

What is the current version of postgresql?

1164

in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

2207

what is dbms? : Sql dba

1060

What is your daily office routine?

2340

For More Un-Answered { Databases } Questions Click Here