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

Explain what is an Exception ?

1 3627

Explain about User_Defined Exceptions?

1 3517

Is it possible to open a cursor which is in a Package in another database?

CTS,

1 9764

Is it possible to use Transactional control statements in Database ?

2 5110

Is it possible to Enable or Disable a Database trigger ?

1 4047

PL/SQL supports which datatypes?

2 5040

what is "TABLE" datatype ?

2 4665

What is the Result of the following 'VIK'||NULL||'RAM' ?

HP, Manthan Solutions,

1 19709

Does the Database trigger will fire when the table is TRUNCATED ?

3 15649

what the SUBSTR(SQUARE ANS ALWAYS WORK HARD,14,6) will return ?

Citrix, SAP Labs,

3 19385

what the REPLACE('JACK AND JUE','J','BL') will return ?

HCL, IBM, Wipro,

1 15465

What the TRANSLATE('333SQD234','0123456789ABCDPQRST','0123456789') will return ?

2 17335

Is it possible to modify a Datatype of a column when column contains values?

1 3522

Explain different types of Views ?

HCL, Inbound Solutions,

5 36380

what is Data Definiton Language ?

2051

Un-Answered Questions { Databases }

How to connect to sybase database from linux?

990

In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??

1661

What is sql injection vulnerability?

944

Can you convert a bit-mapped report to ASCII (character-mode) Report ? How ?

2287

What are the common oracle dba tasks?

1147

What are the built in functions in sql server?

985

What is rs.exe utility?

156

your distribution database is full what will u do

2172

How to connect a sql*plus session to an oracle server?

1128

Tell me what are cursors and when they are useful?

956

Does mysql support nosql?

912

Difference between lexical and bind varible.

How to select unique records from a table?

1059

Types of Authentications in Sql Server? How user gets authenticated through windows authentication?

1052

Are resultset updatable?

953

For More Un-Answered { Databases } Questions Click Here