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

1 3869

What does TIMESTAMP ON UPDATE CURRENT_TIMESTAMP data type do?

1 5412

Explain data type TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP .

Zensar,

2 10386

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

2 6034

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

1 5939

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

2 7610

Explain the difference between FLOAT, DOUBLE and REAL.

Yahoo,

14 75689

Explain the difference between BOOL, TINYINT and BIT?

1 6272

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

4150

Explain MySQL architecture?

1 13665

Explain MySQL locks?

1 5305

Explain multi-version concurrency control in MySQL?

2 9924

What are MySQL transactions?

2 5528

What is ACID?

2 6057

Which storage engines support transactions in MySQL?

2 7753

Un-Answered Questions { Databases }

What is the query and subquery?

1121

Explain stored procedure?

1109

What is relational database with example?

1013

Explain the wait events in statspack report 'db sequential real'?

683

Does sql*plus also have a pl/sql engine?

1131

In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance

2010

What is a initialization parameter file in oracle?

1083

Why should I use postgresql?

1068

What does stand for in sql?

1025

Explain the purpose of %type and %rowtype data types?

976

What is a database lookup?

1137

How do I start mongodb on windows?

What is difference between group by and partition by?

1128

What are open_form,call_form,new_form?

How to sort the query output with order by clauses in ms sql server?

1071

For More Un-Answered { Databases } Questions Click Here