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

What is backup in Oracle?

MCN Solutions,

1004

What is transaction control statement and how many types of transaction control statement in Oracle?

MCN Solutions,

1155

Give syntax for SQL and ORACLE joins.

TCS,

1092

What is Segment Advisor in Oracle?

MCN Solutions,

1103

What is SQL Tuning Advisor in Oracle?

MCN Solutions,

1178

What is MTTR advisor in Oracle?

MCN Solutions,

1090

How many types of cluster table in Oracle?

MCN Solutions,

1034

How to get the Installed Oracle Version Information ?

MCN Solutions,

1124

What is flashback in Oracle?

MCN Solutions,

1017

What is the difference between PFILE and SPFILE in Oracle?

MCN Solutions,

1060

How to check database size in Oracle?

MCN Solutions,

1189

What is catalog in Oracle?

MCN Solutions,

1364

What is archive log in Oracle?

MCN Solutions,

1134

Can we connect to ORACLE db using Windows Authentication?

MCN Solutions,

1256

What is memory advisor in Oracle?

MCN Solutions,

1077

Un-Answered Questions { Databases }

Explain bcnf (boyce-codd normal form)?

1017

How to filter out duplications in the returning rows in ms sql server?

1141

Does anyone still use microsoft access?

920

What is integrity and what is constraint??Explain with example

2283

Explain materialized views and how they are used.

2441

How to assign values to variables?

1101

Explain SSRS Architecture?

195

What is normalization according to you and explain its different levels?

949

What is open database communication (odbc) in oracle?

1003

Why not phenix, the zelinka/otwinoski libraries, etc?

1121

What are the different types of indexes available in sql server? : sql server DBA

1203

What is linq to sql?

1132

Is it possible to call a stored procedure within a stored procedure?

975

Why stored procedures are faster than query?

1024

How do I create an extended event in sql server?

951

For More Un-Answered { Databases } Questions Click Here