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 6362

what is the difference between MyIsam and InnoDb engine?

2 6618

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 9267

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

IBM,

2 5226

What is sqlcode -923 ?

1 10421

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 12115

"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 9585

what is shared memory?

IBM,

1 4297

what is semphore explian it?

IBM,

2815

Un-Answered Questions { Databases }

How do I stop a mysql command?

990

You look at your fragmentation report and see that smon has not coalesced any of you tablespaces, even though you know several have large chunks of contiguous free extents. What is the problem?

609

How do I setup a database connection?

1007

How to use old values to define new values in update statements in ms sql server?

1266

What is the difference between syntax error and runtime error?

1140

What are the Types of repositories in ODI?

584

How to connect to the server with user account: sys?

1017

What does mysql flush privileges do?

931

How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?

1038

what is sql in mysql? : Sql dba

1191

What is the difference between 'dump tran database to physical name' 'dump tran database with truncate_only' and dump tran database with no_log'and in real time when we go to truncate the log?

892

How to sort the rows in sql.

1075

what are the difference between clustered and a non-clustered index? : Sql dba

1032

How do I start mysql in linux?

906

How many types of normalization? What is the use of it?

1136

For More Un-Answered { Databases } Questions Click Here