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,

966

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

MCN Solutions,

1103

Give syntax for SQL and ORACLE joins.

TCS,

1069

What is Segment Advisor in Oracle?

MCN Solutions,

1072

What is SQL Tuning Advisor in Oracle?

MCN Solutions,

1127

What is MTTR advisor in Oracle?

MCN Solutions,

1056

How many types of cluster table in Oracle?

MCN Solutions,

1007

How to get the Installed Oracle Version Information ?

MCN Solutions,

1096

What is flashback in Oracle?

MCN Solutions,

988

What is the difference between PFILE and SPFILE in Oracle?

MCN Solutions,

1009

How to check database size in Oracle?

MCN Solutions,

1149

What is catalog in Oracle?

MCN Solutions,

1299

What is archive log in Oracle?

MCN Solutions,

1087

Can we connect to ORACLE db using Windows Authentication?

MCN Solutions,

1201

What is memory advisor in Oracle?

MCN Solutions,

1042

Un-Answered Questions { Databases }

What is the usage of analyze command in oracle?

1053

What is the database url?

1033

Define outer join in sql server joins?

906

What is partitioned view?

870

How to get each name only once from an employee table?

1085

What is a dataset and what are the different types of datasets?

131

How to lock records in a table?

939

How to export data with a field delimiter?

990

can a database be shrunk with users active? : Sql server administration

968

What are the extra roles available in msdb? : sql server security

1099

Who uses access database?

778

How do I create a sql database?

961

How do you remove duplicates without using distinct in sql?

940

What is query processing?

901

Explain transaction server auto commit?

1002

For More Un-Answered { Databases } Questions Click Here