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,

1156

Give syntax for SQL and ORACLE joins.

TCS,

1092

What is Segment Advisor in Oracle?

MCN Solutions,

1104

What is SQL Tuning Advisor in Oracle?

MCN Solutions,

1179

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,

1125

What is flashback in Oracle?

MCN Solutions,

1019

What is the difference between PFILE and SPFILE in Oracle?

MCN Solutions,

1060

How to check database size in Oracle?

MCN Solutions,

1191

What is catalog in Oracle?

MCN Solutions,

1365

What is archive log in Oracle?

MCN Solutions,

1134

Can we connect to ORACLE db using Windows Authentication?

MCN Solutions,

1257

What is memory advisor in Oracle?

MCN Solutions,

1077

Un-Answered Questions { Databases }

What are few of the schema objects that are created using PL/SQL?

1038

Can we perform dml in function?

1067

How to create id with auto_increment on oracle?

990

What is partition, how will you implement it? : sql server analysis services, ssas

1048

Is it possible to update views?

959

What is multi-statement table-value user-defined function?

996

What are the different types of languages that are available in the dbms?

1025

How to call a stored function with parameters?

1045

Can you explain fourth normal form and fifth normal form ?

836

How do I find query history in sql server?

943

How do I install microsoft access 2010?

933

how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba

951

How to create “dependant” parameter “make, model, year”

131

How do I learn what codesets are available in oracle?

1038

Explain database partitioning and its importance.

980

For More Un-Answered { Databases } Questions Click Here