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

What are commit, rollback, and savepoint?

1051

Explain the difference in execution of triggers and stored procedures?

1066

Define commit?

1056

Define union, minus, union all, intersect ?

1068

How can we avoid duplicating records in a query?

1040

How many types of relationship are there?

1087

State some properties of relational databases?

1117

Define a temp table?

1082

What are transaction and its controls?

1092

What are actual parameters and formal parameters?

1183

What are expressions?

1064

What is sql server used for?

1103

How is table type constraint applied to a table?

1032

How can we check the sql server version?

1130

What is a unique key constraint?

1093

Un-Answered Questions { Databases }

Explain throw statement in sql server 2008?

1058

Define SQL and state the differences between SQL and other conventional programming Languages?

1267

Do companies use microsoft access?

938

Who owns sybase?

901

Which are the five query types available in oracle?

1003

how to dump a table to a file with 'mysqldump'? : Sql dba

1108

In which language couchdb's early work was started?

What information can be stored in a database?

1160

What is sql*plus?

1122

What is an optimization and performance tuning and how does it really work in practical projects?

958

what is the information that can be stored inside a bit column? : Sql server database administration

1012

Can we use ddl statements in stored procedure sql server?

1066

How to create a stored procedure in oracle?

1157

How to create indexed view?

1112

What is third normal form?

974

For More Un-Answered { Databases } Questions Click Here