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?

952

What happens if recursive calls get out of control?

1011

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

952

How to get execution statistics reports on query statements?

1017

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

1024

How to export your connection information to a file?

1082

How to shutdown your 10g xe server?

1094

How a tablespace is related to data files?

1067

Where is the export dump file located?

1088

What are the original export and import utilities?

1072

What is a connect identifier?

990

How to view all columns in an existing table?

880

What is an anonymous block?

1172

How many anonymous blocks can be defined?

1115

How to load data through external tables?

1082

Un-Answered Questions { Databases }

When to use Inner join & when to use subquery?

1097

What does pragma mean?

988

Is sql different from sql server?

1012

Can sql server 2016 run on windows 7?

869

How do I connect to postgresql access?

951

What is sharding in sql?

928

There are 100 datafiles, numbered from 1 to 100. File number 10 is deleted and it has 500 MB of data. The database is working in archive log mode. How can be the database recovered ? While doing recovery the archive logs applied are from nos 1 to 100, but 50 gets corrupted. What do we do? Can we proceed further? If so how?

2077

Describe concurrency control.

986

Explain how you can configure a running aggregate in SSRS?

157

What do you mean by erd and its main elements?

738

Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

1223

What happens if variable names collide with table/column names?

1117

Does postgres use sql?

791

What are the purposes and advantages stored procedure?

899

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

2796

For More Un-Answered { Databases } Questions Click Here