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

2 6364

what is the difference between MyIsam and InnoDb engine?

2 6619

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 9271

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

IBM,

2 5226

What is sqlcode -923 ?

1 10423

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

2068

can u give guidance abt packages of plsql

Mphasis,

2174

what is the disadvantage of SQL Loder?

TCS,

1 6937

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 12118

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

5 7279

How to define a cusotmer as a supplier in ORACLE R12

Intelligroup,

2230

WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

Intelligroup,

2209

what is difference between Enterprise Manager and Query Analyer

CTS,

6 9591

what is shared memory?

IBM,

1 4299

what is semphore explian it?

IBM,

2815

Un-Answered Questions { Databases }

What is bulk collect in pl sql?

1088

What is progress actional?

992

What is bookmark link in ssrs?

244

What is execution plan in sql?

1046

What is the meaning of projections in mongoDB?

Is microsoft access available in office 365?

893

What are the main characteristics of database approach?

1032

How can you tell if an index on particular table is used or not used in 9i?

564

How to set the current database in ms sql server?

1081

Mention what is the difference between single instance environment and rac environment?

Who are mongodb competitors?

What are different types of sql commands?

1117

Define right outer join in sql server joins?

1046

What is the partitioning method?

1018

How does clustering in improving the performance?

850

For More Un-Answered { Databases } Questions Click Here