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?

1050

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

1074

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

946

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

1063

State the differences between mongodb and mysql.

1248

What is normalization and list the different types of normalization?

997

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?

1005

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

1005

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

1209

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?

1026

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?

939

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?

1084

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

1048

Un-Answered Questions { Databases }

Can I learn sql in a week?

1125

What is the DIF format and when we will use in teradata

2543

How to check the server version in oracle?

1145

What is an access?

870

What are its two major subsystems of r?

1232

Is truncate ddl or dml?

1040

What is structure of dbms?

972

What are the two parts of design view?

1071

What happen when an index does not fit into ram?

How to update operations immediately sync to disk in mongodb?

What is the point of foreign keys?

826

What is the instance of a relation?

1093

How would you improve throughput in sybase?

1037

What are the data types in postgresql?

961

What is Virtual Private Database in Oracle?

1152

For More Un-Answered { Databases } Questions Click Here