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

1049

What happens if recursive calls get out of control?

1139

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

1040

How to get execution statistics reports on query statements?

1153

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

1151

How to export your connection information to a file?

1176

How to shutdown your 10g xe server?

1205

How a tablespace is related to data files?

1164

Where is the export dump file located?

1224

What are the original export and import utilities?

1258

What is a connect identifier?

1084

How to view all columns in an existing table?

981

What is an anonymous block?

1324

How many anonymous blocks can be defined?

1252

How to load data through external tables?

1188

Un-Answered Questions { Databases }

Define "correlated subqueries".

993

Can sub report data source be different from that of the parent report?

149

What is update_statistics command?

1121

How to recreate an existing index in ms sql server?

1117

What are the advantages of sql stored procedure?

1121

State the difference between union and union all?

985

Is ms access better than excel?

813

What is toast in postgres?

975

Explain about the various features present in MS Access?

882

What is oracle open database communication (odbc)?

1082

Can you insert NULL in unique column?

1210

Who is end user in database?

906

Write SQL queries on Self Join and Inner Join.

1215

What are the skills required for oracle dba?

695

How to change a login name in ms sql server?

1134

For More Un-Answered { Databases } Questions Click Here