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?

1006

What happens if recursive calls get out of control?

1083

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

993

How to get execution statistics reports on query statements?

1095

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

1088

How to export your connection information to a file?

1133

How to shutdown your 10g xe server?

1149

How a tablespace is related to data files?

1109

Where is the export dump file located?

1159

What are the original export and import utilities?

1175

What is a connect identifier?

1042

How to view all columns in an existing table?

936

What is an anonymous block?

1255

How many anonymous blocks can be defined?

1187

How to load data through external tables?

1140

Un-Answered Questions { Databases }

What is a transact-sql statement batch in ms sql server?

1025

Why indexing is used in database?

936

Relational calculus is what type of language?

1039

what are all the common sql function? : Sql dba

1061

Explain the term entity in dbms?

895

What is a recovery catalog?

what are the differences between require and include, include_once and require_once? : Sql dba

1027

How many indexes does mongodb create by default for a new collection?

What are the steps you will take to improve performance of a poor performing query?

2850

Is primary key indexed by default in postgres?

811

How many types of dimensions in oracle?

580

How many types of primary keys are there?

1040

How to load data from file to file and what are the KM's required for this requirement?

610

Is it possible to remove old files in the movechunk directory?

What is difference between order by and group by?

1009

For More Un-Answered { Databases } Questions Click Here