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

Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?

1 1147

How to find the list of fixed hard drive and free space on server?

1 1325

What is difference in performance between insert top (n) into table and using top with insert?

1 1141

What is change data capture (cdc) in sql server 2008?

1 1087

Where are sql server usernames and passwords stored in the sql server?

1 1191

Explain left outer join and right outer join?

1 1112

What is the bookmark lookup and rid lookup?

1 1050

What is local temp table?

1 1051

What is difference between getdate and sysdatetime in sql server 2008?

1 1127

Explain insert into select statement?

1 1033

What are policy management terms?

1 1064

What is data compression?

1 1083

How to copy the tables, schema and views from one sql server to another?

1 1127

what is unique and xaml nonclustered index

1 1116

Is it possible to create trigger on views?

1 1061

Un-Answered Questions { Databases }

What is a scheduled job or what is a scheduled task?

1031

What is an indexed view?

1018

How to export data from database and import into another?

989

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1186

what is dbms? : Sql dba

1058

Why use identity in sql server?

1189

What are the two main functions of queries in databases?

1522

How do I find query history in sql server?

1018

How to convert character strings into numeric values?

1186

What is the difference between case version and decode version?

1102

How to select all columns of all rows from a table in oracle?

1120

what are the advantages of sql ? : Sql dba

1136

Does group by remove duplicates?

1108

What is acid mean in sql server?

1232

how to start mysql server? : Sql dba

1258

For More Un-Answered { Databases } Questions Click Here