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 2nf in the dbms?

1012

Explain the concept of acid properties in dbms?

1159

What is meant by a database?

1057

How is the pattern matching done in the sql?

1216

Why is the use of dbms recommended?

1327

Explain the concepts of a primary key and foreign key.

947

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

1085

What are the different levels of abstraction in the dbms?

956

Explain by listing some major advantages of dbms.

994

What is the main difference between union and union all?

948

What is the purpose of sql?

998

What is the concept of sub-query in terms of sql?

1022

What are the main differences between primary key and unique key?

1044

What is a join in the sql?

1047

What is dbms used for?

1059

Un-Answered Questions { Databases }

What are five main functions of a database administrator?

914

You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?

1101

Explain the use of consistent option in exp command.

1146

What is database white box testing and black box testing?

1164

What is schemabinding a view?

977

What is dialect in database?

1034

Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.

2369

what is a database transaction? : Sql dba

1258

What are binary string data types in ms sql server?

1396

Explain different types of self contained sub query?

1107

What is the database name in oracle?

1082

What file will give you oracle instance status information? Where is it located?

665

Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?

1126

Explain the various types of normalization.

1128

What stored by the master? : sql server database administration

1189

For More Un-Answered { Databases } Questions Click Here