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 database partitioning?

1 3716

What are the two types of data independence?

1220

What are the various types of relationships in database? Define them.

947

What do you understand by index hunting?

1206

Define dbms.

965

explain the term ‘attribute’?

1004

Enlist some commands of dml?

998

What is bcnf?

1080

Define phantom deadlock.

1095

What do you understand by join?

1199

Define join types.

1013

What are the types of database lock?

1123

Explain data dictionary.

968

Explain the term ‘relations’?

942

What do you understand by fragmentation?

969

Un-Answered Questions { Databases }

What is the function of cache fusion in oracle rac?

What are the 'mysql' command line arguments?

1069

what is oltp (online transaction processing)? : Sql dba

1132

What is the difference between a primary key and a composite key?

840

What is the difference between sql and isql*plus?

1166

What is shared_buffers postgresql?

951

Mention how you can inspect the source code of a function?

What is a deadlock and what is a live lock?

1048

How do I insert multiple rows in a table?

952

- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?

1897

What are three advantages to using sql?

1074

how do u place it in required folder

1991

your distribution database is full what will u do

2224

Describe mysql transaction properties.

1074

How do I know if oracle is installed on windows?

996

For More Un-Answered { Databases } Questions Click Here