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

What is backup in Oracle?

MCN Solutions,

1089

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

MCN Solutions,

1251

Give syntax for SQL and ORACLE joins.

TCS,

1149

What is Segment Advisor in Oracle?

MCN Solutions,

1152

What is SQL Tuning Advisor in Oracle?

MCN Solutions,

1271

What is MTTR advisor in Oracle?

MCN Solutions,

1145

How many types of cluster table in Oracle?

MCN Solutions,

1087

How to get the Installed Oracle Version Information ?

MCN Solutions,

1196

What is flashback in Oracle?

MCN Solutions,

1070

What is the difference between PFILE and SPFILE in Oracle?

MCN Solutions,

1118

How to check database size in Oracle?

MCN Solutions,

1268

What is catalog in Oracle?

MCN Solutions,

1452

What is archive log in Oracle?

MCN Solutions,

1197

Can we connect to ORACLE db using Windows Authentication?

MCN Solutions,

1325

What is memory advisor in Oracle?

MCN Solutions,

1138

Un-Answered Questions { Databases }

Which are new data types introduced in sql server 2008?

1114

How to display Row Number with Records in Oracle SQL Plus?

1107

What is DML (Data Manipulation Language)?

918

How do I find duplicates in sql?

994

How to convert comma separated string to array in pl/sql?

1247

How does mongodb replication work?

I have a few records all are same structures data, I want to store data in multiple targets how

2716

What are different sql data types?

1140

What do you understand by “performance tuning of db” & what are the different areas where we can perform tuning?

Differentiate between ltm and repagent?

1048

What are some indications that you need to increase the shared_pool_size parameter?

620

What do you know about couchdbkit?

Which are the storage engines used by mongodb?

What is sql query optimization?

1207

What is acid db?

939

For More Un-Answered { Databases } Questions Click Here