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 3560

What does TIMESTAMP ON UPDATE CURRENT_TIMESTAMP data type do?

1 5227

Explain data type TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP .

Zensar,

2 10194

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

2 5803

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

1 5804

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

2 7420

Explain the difference between FLOAT, DOUBLE and REAL.

Yahoo,

14 74666

Explain the difference between BOOL, TINYINT and BIT?

1 6107

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

4044

Explain MySQL architecture?

1 13519

Explain MySQL locks?

1 5142

Explain multi-version concurrency control in MySQL?

2 9664

What are MySQL transactions?

2 5324

What is ACID?

2 5831

Which storage engines support transactions in MySQL?

2 7546

Un-Answered Questions { Databases }

Is sql server free?

878

What are enums used for in mysql?

960

What is mysql and mysqli?

881

How to change varchar(m) to varchar(n) in sybase?

883

How to make remote connection in database?

967

Is mongodb the same as nosql?

What is oracle update statement with inner join ?

1006

What is confine mode and flex mode?

What are the ddl commands?

959

Mention the differences between trigger and stored procedures

1051

What's the latest version of mysql?

945

What do you mean by durability in dbms?

954

explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?

2438

How does mongodb replica set work?

What are the different schemas objects that can be created using pl/sql?

978

For More Un-Answered { Databases } Questions Click Here