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

How can you calculate the sum of any column of a table?

1057

What is meant by decimal (5,2)?

1044

What is a trigger? How you can create a trigger in mysql?

916

What is the difference between unix timestamp and mysql timestamp?

1064

How can you change the name of any existing table by using the sql statement?

1008

What is the purpose of using ifnull() function?

1004

How can you add and remove any column of a table?

956

How can you export the table as an xml file in mysql?

894

How can you create and drop view in mysql?

943

What is an index? How can an index be declared in mysql?

902

What are the differences between a primary key and foreign key?

1113

What is the latest version of php and mysql?

1228

Explain the difference between mysql_fetch_array(), mysql_fetch_object()?

958

How to get last inserted id after insert data from a table in mysql?

994

What is the role of a limit in a mysql query?

1021

Un-Answered Questions { Databases }

How does mysql store binary data?

976

What are primary key and foreign key and how they work?

989

How can you select unique records from a table?

1099

What is a database in layman terms?

958

Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

2076

How to install oracle odbc drivers?

1107

What is postgresql server?

1017

How do you run a trace?

918

What is cypher neo4j?

How to set the current database in ms sql server?

1098

Explain something about security and SQL Azure?

134

Why is theta join required?

1155

How to update a root password.

963

Why mongodb is faster?

What is default constraint?

1013

For More Un-Answered { Databases } Questions Click Here