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 TIMESTAMP DEFAULT ?2006:09:02 17:38:44′ ON UPDATE CURRENT_TIMESTAMP.

1 3700

What does TIMESTAMP ON UPDATE CURRENT_TIMESTAMP data type do?

1 5322

Explain data type TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP .

Zensar,

2 10297

what if you really want to store the timestamp data, such as the publication date of the article?

2 5912

What happens if a table has one column defined as TIMESTAMP?

1 5885

If you specify the data type as DECIMAL (5,2), what?s the range of values that can go in this table?

2 7518

Explain the difference between FLOAT, DOUBLE and REAL.

Yahoo,

14 75201

Explain the difference between BOOL, TINYINT and BIT?

1 6193

How to enable or disable a row of a table using MySQL in struts?

4099

Explain MySQL architecture?

1 13599

Explain MySQL locks?

1 5238

Explain multi-version concurrency control in MySQL?

2 9807

What are MySQL transactions?

2 5439

What is ACID?

2 5937

Which storage engines support transactions in MySQL?

2 7659

Un-Answered Questions { Databases }

Explain what are triggers and rules?

909

What do we mean by record group in oracle forms?

1076

How to check status of stored procedure in sql server?

988

All questions related to Control m monitoring tool

2545

How do I truncate a sql log file?

1074

What does dba stand for in technology?

548

What is a temporal table?

930

Explain the hardware architecture used in oracle rac?

Can you tell how many values can set the function of mysql to consider?

988

Which are the most powerful features in mongodb?

How do I install sql server?

890

Differentiate between ‘delete’, ‘truncate’ and ‘drop’ commands.

1155

Can I remove old files in the move chunk directory in mongodb?

What are dml commands?

1020

Explain features and concepts of analysis services?

978

For More Un-Answered { Databases } Questions Click Here