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 3710

Explain about User_Defined Exceptions?

1 3615

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

CTS,

1 9874

Is it possible to use Transactional control statements in Database ?

2 5260

Is it possible to Enable or Disable a Database trigger ?

1 4141

PL/SQL supports which datatypes?

2 5225

what is "TABLE" datatype ?

2 4781

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

HP, Manthan Solutions,

1 19840

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

3 15842

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

Citrix, SAP Labs,

3 19632

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

HCL, IBM, Wipro,

1 15612

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

2 17498

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

1 3647

Explain different types of Views ?

HCL, Inbound Solutions,

5 36658

what is Data Definiton Language ?

2107

Un-Answered Questions { Databases }

1. What is Container? 2. Tell me about your project? 3. Which container you are used in your project? 4. What is Surrogate key? 5. How you are implemented it? 6. Difference between Server job and Parallel job? 7. What is your Target Database? 8. What is Source System? 9. Difference between Join and Lookup? 10. Are you maintaining historical data? What is the logic used to maintained to historical data? 11. Do you have documents for mapping?

1841

What is the difference between upgrade and migration in sql server?

1173

what is the command syntax for inserting a document?

What is sql or structured query language?

1217

What are the properties of the transaction?

1069

What is normalization and what are the advantages of it?

1050

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1287

Why use identity in sql server?

1189

How to convert numeric expression data types using the cast() function?

1142

Explain “row_number()” in sql server with an example?

1069

Why we use the openxml clause?

1065

What kind of problems occurs if we do not implement proper locking strategy?

1493

Were you involved in any data conversion, which one?

You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

1207

How to use values from other tables in update statements using oracle?

1147

For More Un-Answered { Databases } Questions Click Here