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

Explain what is an Exception ?

1 3688

Explain about User_Defined Exceptions?

1 3590

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

CTS,

1 9847

Is it possible to use Transactional control statements in Database ?

2 5222

Is it possible to Enable or Disable a Database trigger ?

1 4113

PL/SQL supports which datatypes?

2 5177

what is "TABLE" datatype ?

2 4750

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

HP, Manthan Solutions,

1 19792

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

3 15783

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

Citrix, SAP Labs,

3 19535

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

HCL, IBM, Wipro,

1 15581

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

2 17454

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

1 3593

Explain different types of Views ?

HCL, Inbound Solutions,

5 36579

what is Data Definiton Language ?

2101

Un-Answered Questions { Databases }

What are stuff and replace function?

1143

What do data architects do?

854

What do you know about mongodb?

What are different partitioning techniques in database?

949

How do you install statspack?

720

Explain the components of rdbms?

1019

What is procedure explain with example?

1009

What is db stored procedure?

945

Explain subquery and state its properties?

1094

How do I enable postgis on pgadmin?

1039

What is a livelock?

1024

what is a stored procedure? : Sql dba

1192

How to drop a stored function?

1185

What is dynamic schema in mongodb?

Which tcp/ip port does sql server run?

1070

For More Un-Answered { Databases } Questions Click Here