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 the use of indexing table?

2 6477

what is the difference between MyIsam and InnoDb engine?

2 6761

Hi all, I am going to write oracle certification. Can anyone send me the dumps available if any for OCA exam? Its really very urgent, prompt response will help me alot..

8 9579

What are the steps need to be take improve the speed of a SQLDATA Server?

IBM,

2 5359

What is sqlcode -923 ?

1 10501

candidate key is subset of super key but not vice-verse explain

2121

can u give guidance abt packages of plsql

Mphasis,

2249

what is the disadvantage of SQL Loder?

TCS,

1 7035

Write a stored procedure for emplpoyee and department table to get DeptName which having no employee. Table Structure- Emp-Emp_Id,Emp_Name,Dept_id Dept-Dept_Id,Dept_Name

TCS,

7 12365

"primary key=unique+null" is equal,reson?not,reason?

5 7521

How to define a cusotmer as a supplier in ORACLE R12

Intelligroup,

2320

WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

Intelligroup,

2265

what is difference between Enterprise Manager and Query Analyer

CTS,

6 9811

what is shared memory?

IBM,

1 4397

what is semphore explian it?

IBM,

2900

Un-Answered Questions { Databases }

Explain the wait events in statspack report 'enqueue'?

627

What conditions he must fullfil before being accepted as a publisher?

1087

What is mongodb named after?

What is asqueryable?

1044

Explain the different normalization forms?

1167

Explain oracle 12c new features for developers?

1129

Give the constructs of a package, function or a procedure.

1103

How to set the current database in ms sql server?

1154

How do I find my oracle client driver version?

1108

What happens if the constraint name is left out of a constraint clause?

588

What does innodb stand for?

1033

What is sql sandbox in sql server?

1306

What is the boxing and unboxing concept in .net?

988

What are the advantages of using stored procedures in sql server?

1062

What are the various type of relations between different data?

805

For More Un-Answered { Databases } Questions Click Here