Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle (3239)
SQL Server (4518)
MS Access (429)
MySQL (1402)

Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)

DB Development (113)
SQL PLSQL (3312)
MongoDB (502)
IBM Informix (50)

Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)

Database Management (1391)
Databases AllOther (288)

Databases Interview Questions

Questions Answers Views Company eMail

What is the use of indexing table?

2 5363

what is the difference between MyIsam and InnoDb engine?

2 5520

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 7042

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

IBM,

2 4261

What is sqlcode -923 ?

1 9672

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

1577

can u give guidance abt packages of plsql

Mphasis,

1644

what is the disadvantage of SQL Loder?

TCS,

1 6085

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 9924

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

5 5440

How to define a cusotmer as a supplier in ORACLE R12

Intelligroup,

1726

WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

Intelligroup,

1701

what is difference between Enterprise Manager and Query Analyer

CTS,

6 7713

what is shared memory?

IBM,

1 3466

what is semphore explian it?

IBM,

2244

Un-Answered Questions { Databases }

what are the informix isolation levels and can you explain each one ?

What is importing utility?

546

What is an oracle wallet?

508

Mention the different authentication modes in sql server.

533

What is pivot table in sql?

522

How you can change the database name in SQL SERVER?

670

How to sort output in descending order in oracle?

572

Why dbms is used?

516

List the types of recovery model available in sql server?

501

Do foreign keys speed up queries?

426

What is max connection in mysql?

497

What is database implementation?

487

how do u setup a replication site?

1494

How to define a record variable to store a table row?

575

What does ss stand for sexually?

582

For More Un-Answered { Databases } Questions Click Here