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 3733

What does TIMESTAMP ON UPDATE CURRENT_TIMESTAMP data type do?

1 5345

Explain data type TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP .

Zensar,

2 10328

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

2 5939

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

1 5904

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

2 7540

Explain the difference between FLOAT, DOUBLE and REAL.

Yahoo,

14 75339

Explain the difference between BOOL, TINYINT and BIT?

1 6219

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

4109

Explain MySQL architecture?

1 13618

Explain MySQL locks?

1 5255

Explain multi-version concurrency control in MySQL?

2 9832

What are MySQL transactions?

2 5457

What is ACID?

2 5965

Which storage engines support transactions in MySQL?

2 7686

Un-Answered Questions { Databases }

Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

892

What do you understand by functional dependency?

925

Is crud a cuss word?

1043

Can you please explain the difference between function and stored procedure?

1022

How can you perform pattern matching in sql?

1009

When should you consider denormalization?

988

can a stored procedure call itself or recursive stored procedure? : Sql dba

1041

How can we delete a table in sql server?

989

What do you understand by the analysis services in sql server?

958

How to list all objects in a given schema?

1070

How to Change a users password from unix shell.

1134

Have you created sequence? When will you use?

569

Explain what are the restrictions that views have to follow? : SQL Server Architecture

1067

What is plan freezing?

979

Tell me what are the essential components of sql server service broker?

962

For More Un-Answered { Databases } Questions Click Here