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

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

1096

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

1225

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

1067

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

1041

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

1137

Explain left outer join and right outer join?

1054

What is the bookmark lookup and rid lookup?

1010

What is local temp table?

989

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

1065

Explain insert into select statement?

970

What are policy management terms?

999

What is data compression?

1029

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

1058

what is unique and xaml nonclustered index

1060

Is it possible to create trigger on views?

1007

Un-Answered Questions { Databases }

What is snapshot is too old? Give and example for better understand.

1625

What is access good for?

827

Define synonym?

1185

what is an extent in informix?

Where is mysql password stored?

946

What is using in sql?

1110

What is self-join and what is the requirement of self-join?

1171

Explain the storage engines in mysql?

1016

How do I truncate all tables in mysql?

998

How can we delete a table in sql server?

990

What are the parts of ms access?

885

How network traffic be reduced by using the stored procedure?

1138

What is difference between index and primary key?

1110

How to verify a user name with sqlcmd tool?

1094

What is clause?

1166

For More Un-Answered { Databases } Questions Click Here