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

From where the Transactions per rollback segment is derived ?

1 8775

From where ENQUEUE resources parameter information is derived ?

1 5068

Where does the LGWR process writes information?

1 3831

What is the use of SET TRANSACTION USE ROLLBACK SEGMENT ?

1 6064

Where the Databases overall structure is maintained ?

1 12008

can Constraints cannot be exported through EXPORT command ?

Grasim, Oracle, Suvidha,

2 11373

What is difference between a DIALOG WINDOW and a DOCUMENT WINDOW ?

HCL,

2 14085

What is the difference between a MESSAGEBOX and an ALERT ?

3 18337

Can a DIALOG WINDOW have scroll bar attached to it ?

1 6265

what are the advantages of GUI systems ?

1 9400

What is the difference between a LIST BOX and a COMBO BOX ?

2 4250

Why is it better to use an Integrity Constraint to validate data ?

1 3947

what are the advantages of a client or server model ?

1 4470

What does DLL stands for ?

Nexus Technologies,

2 9033

what is postback trigger?

1 5991

Un-Answered Questions { Databases }

What is mysql data directory?

1013

How can we remove orphan records from a table?

1001

can a stored procedure call itself or recursive stored procedure? : Sql dba

1041

What is the use of triggers?

1050

How do I open an access database?

845

How do I convert a spreadsheet to a database?

961

What are the different oracle database objects?

1109

What the different types of Replication and why are they used?

1089

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

2149

When is the explicit cursor used ?

1045

Why stored procedure is better than query?

962

Where’s database data actually stored? Is there a way to see the files which are stored?

991

Explain about creating a report tool by using the report tool and report wizard?

996

How to define a variable to match a table column data type?

1000

When cursors are useful?

1122

For More Un-Answered { Databases } Questions Click Here