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

Can you tell the difference between mysql_fetch_object and mysql_fetch_array?

1055

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

1077

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

951

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

1063

State the differences between mongodb and mysql.

1253

What is normalization and list the different types of normalization?

999

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?

1009

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

1009

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

1211

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?

1030

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

995

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

1089

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

942

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?

1089

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

1054

Un-Answered Questions { Databases }

How do I select a database in mysql?

1135

What is the use of stored procedures?

1121

How to see the create table statement of an existing table?

1108

Are there any alternatives to isql in sybase?

1008

Design an ETL process( batch job/script)from source to starting that u will not be dependent on the source in the near future?please elobarate details on what are things to consider.if you'd like to do a diagram that will be great.please answer it

2484

What is %type in pl sql?

1016

How to convert a unicode strings to non-unicode strings?

1168

what is denormalization? : Sql server database administration

983

What can be the maximum size of an access database?

877

What is text in mysql?

966

What is the innodb in mysql?

1100

What is the difference between the 2 operating modes of database mirroring? : sql server DBA

1044

How check triggers in sql server?

1063

How to escape special characters in sql statements?

1017

What is pl sql collection?

1017

For More Un-Answered { Databases } Questions Click Here