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

Can you tell the difference between mysql_fetch_object and mysql_fetch_array?

993

If you wish to encrypt the username and password using php, how will you do that?

1022

Consider you have the following three tables which have to be linked together.

898

What is the difference between b-tree and hash indexes?

1004

State the differences between mongodb and mysql.

1185

What is normalization and list the different types of normalization?

953

Suppose you have to collect the first name, middle name and the last name of students from the below table. But, you observe that there few missing values either in the first name, middle name and the last name columns. How will you return the first non-null values?

964

If you are assigned a task, to find the information of procedures. What are the basic commands that you will use to do so?

960

What is the command used to create a database using php and mysql?

1152

Consider a scenario where you have to send an email to a client from the sql database. How do you think you can achieve this task?

981

How can you handle the –secure-file-priv in mysql?

949

Can you tell the difference between ereg_replace() and eregi_replace()?

1041

Can you tell the reasons for selecting lamp(linux, apache, mysql, php) instead of any other combination of software programs, servers, and operating system?

900

Consider you have a composite index of three columns. Now, you have to provide the value of two columns in the where clause of a select query. Do you think index can be used for the operation?

1025

What are the ways in which you can retrieve data in the result set of mysql using php?

995

Un-Answered Questions { Databases }

What is constant in pl sql?

1030

What is a trigger? Why we need it?

1003

What is microsoft access used for in real life?

847

Tell me what is de-normalization and what are some of the examples of it?

1056

What is the difference between mongodb and mysql?

Explain the disadvantages of cursors?

1147

What is an oracle data file?

1106

How is clustered index different from non-clustered index?

how to present a past time in hours, minutes and seconds? : Sql dba

1015

How many tables can be joined in SQL Server?

1069

Which commands you use to lock the database in mongodb?

What is pl/sql table? Why it is used?

1041

What are the 7 disadvantages to a manual system?

988

What are the approximate numeric data types?

946

How to use user defined functions in expressions?

1095

For More Un-Answered { Databases } Questions Click Here