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 is set nocount on and what is set nocount off?

950

Explain intellisense for query editing

1041

Explain primary key and foreign key constraints?

1046

Explain following error properties?

1033

Explain system scalar functions?

1017

How to find index size for each index on table?

1015

What is database mirroring?

1134

What are dml triggers and types of dml triggers?

1003

What is difference between line feed ( ) and carriage return ( )?

919

What languages bi uses to achieve the goal?

1014

What is checkpoint process in the sql server?

1044

What is raiseerror? What is raiseerror?

1155

What is the difference between varchar and varchar(max) datatypes?

1097

What is the difference between seek predicate and predicate?

1071

What is the correct order of the logical query processing phases?

956

Un-Answered Questions { Databases }

What are foreign keys in database?

981

What is serializable?

1051

What is consistency?

1145

What is pdo in php mysql?

957

What you need to do is issue an ase kill command on the connection then un-suspend the db?

952

in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

1708

can u combine pipeline parallelism and partition parallalism? how and whan?

2357

What are the disadvantages of mongodb?

What is constraints and its types?

966

How does select query work?

955

Name the sql joins that are available in informix.

What platforms are supported in couchdb?

What is design view in ms access?

865

What is a good example of a transaction in sybase?

1054

What does subquery mean in sql?

1073

For More Un-Answered { Databases } Questions Click Here