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

How can you find out the version of the installed mysql?

1 1382

Which mysql function is used to concatenate string?

1 1568

What are the advantages and disadvantages of using mysql?

1057

What are the differences between char and varchar data types?

1192

What is a storage engine? What are the differences between innodb and myisam engines?

1117

Explain the different types of mysql joins.

973

What are the differences between innodb and myisam engines?

1046

How can you retrieve a portion of any column value by using a select query?

975

What is the default port number of mysql?

995

Which statement is used in a select query for partial matching?

1232

What is the difference between now() and current_date()?

1026

What is a storage engine?

1018

What is a join? Explain the different types of mysql joins.

1 1465

What is the purpose of using a heap table?

1196

How can you change the password of a mysql user?

1020

Un-Answered Questions { Databases }

What is the meaning of recursive hints in oracle?

1105

What is entity and its types?

980

What is change data capture (cdc) feature?

1124

What do you mean by “trigger” in sql?

1132

What is data types in database?

1038

How to delete node neo4j?

What happens if null values are involved in datetime operations?

1029

How many clustered indexes can you have?

1044

What are the underflow and overflow behaviors on float literals?

1173

Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you

1802

how to write the procedures in odi?

774

What happens if you use a wrong connect identifier?

1144

What is difference between drop truncate and delete?

1161

How do I download postgresql on windows?

893

Explain a database server?

1108

For More Un-Answered { Databases } Questions Click Here