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 calculate the sum of any column of a table?

1092

What is meant by decimal (5,2)?

1098

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

964

What is the difference between unix timestamp and mysql timestamp?

1108

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

1055

What is the purpose of using ifnull() function?

1055

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

996

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

938

How can you create and drop view in mysql?

980

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

945

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

1171

What is the latest version of php and mysql?

1279

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

1004

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

1042

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

1060

Un-Answered Questions { Databases }

What is bcp? When does it used?

1046

What are the difference between primary keys and foreign keys?

1024

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

4488

How do I manually create a database?

1291

What is pl/sql language case sensitive?

1192

How to use subqueries with the in operator using oracle?

1146

What is having clause in sql?

1021

Where does mysql store data?

946

How to use subqueries with the in operators in ms sql server?

1142

How to declare variable in mysql trigger?

1071

explain different types of constraints? : Sql server database administration

1009

Is it possible to read/write files to-and-from PL/SQL?

1153

How to move database physical files in ms sql server?

1110

What do you understand by oracle forms and why are they required?

1074

How to convert the oracle reports to excel sheet from oracle?

For More Un-Answered { Databases } Questions Click Here