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 3696

What does TIMESTAMP ON UPDATE CURRENT_TIMESTAMP data type do?

1 5318

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 75194

Explain the difference between BOOL, TINYINT and BIT?

1 6192

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

4097

Explain MySQL architecture?

1 13598

Explain MySQL locks?

1 5235

Explain multi-version concurrency control in MySQL?

2 9805

What are MySQL transactions?

2 5436

What is ACID?

2 5931

Which storage engines support transactions in MySQL?

2 7656

Un-Answered Questions { Databases }

What is the maximum length of an alert name?

1001

What is master database? : SQL Server Architecture

1019

What is pl sql package?

1031

How do I shrink an ldf file?

980

What is procedure in mysql?

935

How to rename a tablespace in oracle?

1085

What are indexes? Mention the differences between the clustered and non-clustered index?

963

How do clustered indexes store data?

1106

How to perform key word search in tables?

961

How does limit work in mysql?

908

What is a system tablespace and why do we need it?

How do I view a table in sql?

1006

Which is super key?

805

how do you login to mysql using unix shell? : Sql dba

1079

Are semicolons required at the end of sql statements in sql server 2005?

995

For More Un-Answered { Databases } Questions Click Here