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 75197

Explain the difference between BOOL, TINYINT and BIT?

1 6193

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

4097

Explain MySQL architecture?

1 13598

Explain MySQL locks?

1 5238

Explain multi-version concurrency control in MySQL?

2 9807

What are MySQL transactions?

2 5437

What is ACID?

2 5937

Which storage engines support transactions in MySQL?

2 7659

Un-Answered Questions { Databases }

Differentiate between a primary key and a unique key.

1070

List some popular graph databases?

What are the different tools that are provided by oracle to assist performance monitoring?

What is synonyms?

1057

what are the advantages of sql ? : Sql dba

1060

What is the current version of mysql?

970

What is a deterministic function?

1066

What is a database schema in oracle?

1110

How to add the custom code in Report?

126

Do you know sql server 2008 backup compression?

966

Tell me what is the significance of null value and why should we avoid permitting null values?

985

What is mutating error in pl sql?

1015

Where is database stored?

876

What is extension and intension?

905

Is it possible to declare or create a cursor for update of table? If no tell me why?

1051

For More Un-Answered { Databases } Questions Click Here