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 sub procedure/function be called recursively?

1002

What happens if recursive calls get out of control?

1082

How to get a list of all background sessions in the database?

993

How to get execution statistics reports on query statements?

1091

How to shutdown your 10g xe server from command line?

1085

How to export your connection information to a file?

1129

How to shutdown your 10g xe server?

1148

How a tablespace is related to data files?

1109

Where is the export dump file located?

1156

What are the original export and import utilities?

1169

What is a connect identifier?

1039

How to view all columns in an existing table?

936

What is an anonymous block?

1242

How many anonymous blocks can be defined?

1184

How to load data through external tables?

1135

Un-Answered Questions { Databases }

What is delimiter in mysql?

874

Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?

883

How do I enable sql encryption?

1031

Explain difference between cross join and full outer join?

1005

Why do we use sql constraints? Which constraints we can use while creating database in sql?

1042

What is a dba?

585

What does the on update no action do?

1028

Explain primary key and composite key.

972

Explain the main features of couchdb?

Why mysql is so popular?

961

Why I can not enter 0.001 second in date and time literals in ms sql server?

1065

Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?

950

What are the limitations in ssrs on sql server express edition?

186

How to link tables in sql server?

933

What are the advantages of using Query Strings?

1067

For More Un-Answered { Databases } Questions Click Here