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 6470

what is the difference between MyIsam and InnoDb engine?

2 6747

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 9542

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

IBM,

2 5348

What is sqlcode -923 ?

1 10493

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

2115

can u give guidance abt packages of plsql

Mphasis,

2244

what is the disadvantage of SQL Loder?

TCS,

1 7021

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 12337

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

5 7487

How to define a cusotmer as a supplier in ORACLE R12

Intelligroup,

2309

WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

Intelligroup,

2256

what is difference between Enterprise Manager and Query Analyer

CTS,

6 9787

what is shared memory?

IBM,

1 4386

what is semphore explian it?

IBM,

2884

Un-Answered Questions { Databases }

define data blocks ? : Sql dba

1049

Define database lock and its types.

1052

What is the server name in sql server?

1075

Why is %isopen always false for an implicit cursor?

1154

What is database development process?

939

what is the difference between LENGTH AND SIZE?

2538

What is difference between cursor and trigger?

1131

How do I run a sql query?

1088

What is a sub query and what are the different types of subqueries?

1179

Explain how one can iterate through items and records in a specified block?

1229

What is Virtual Private Database in Oracle?

1152

What sql does mysql use?

1000

What is extension and intension?

971

What is candidate key with example?

1036

Define cursor.

1113

For More Un-Answered { Databases } Questions Click Here