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

What are commit, rollback, and savepoint?

1009

Explain the difference in execution of triggers and stored procedures?

1030

Define commit?

1012

Define union, minus, union all, intersect ?

1022

How can we avoid duplicating records in a query?

997

How many types of relationship are there?

1048

State some properties of relational databases?

1069

Define a temp table?

1034

What are transaction and its controls?

1056

What are actual parameters and formal parameters?

1119

What are expressions?

1022

What is sql server used for?

1067

How is table type constraint applied to a table?

989

How can we check the sql server version?

1086

What is a unique key constraint?

1045

Un-Answered Questions { Databases }

Explain different forms of normalization?

958

How do I connect to postgresql remotely?

883

what are knowledge modules?

651

What are the levels of architecture?

832

What is the difference between mysql_fetch_assoc and mysql_fetch_array?

1086

Can you edit long shell operations with an external text editor?

what are all types of user defined functions? : Sql dba

1055

Explain the types of record group.

What is ndb in mysql?

980

What is the use of <> sql?

992

what tools available for managing mysql server? : Sql dba

1095

What things to be taken in consideration for lookup fields?

914

What is difference between getdate and sysdatetime in sql server 2008?

1060

Is it good to store images in database?

1015

What is a form used for in a database?

929

For More Un-Answered { Databases } Questions Click Here