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 the different types of collation sensitivity?

1142

List out the differences between global and local temp tables in sql server?

1083

Explain “@@rowcount” and “@@error” in sql server?

1105

What are the different types of join?

1202

Why are sql functions used?

1137

Explain mixed authentication mode of sql server?

1087

How can you insert null values in a column while inserting the data?

1297

Is it possible to update the views? If yes, how, if not, why?

1049

What are the difference between “where” and “having” clause in sql server?

1098

What the different components in replication and what is their use?

971

What are subquery and its properties?

1067

How the authentication mode can be changed?

1151

What is " group by " clause?

897

What are cursors and what are the situations you will use them?

980

What is like operator for and what are wild cards?

917

Un-Answered Questions { Databases }

What is meant by referential integrity?

1027

Name some of the open source software that you can use in alternative to SSR?

168

How can check sql version from command line?

1104

What is difference between sql and excel?

1125

Is sql port 1433 encrypted?

1046

How to store and query spatial data?

1013

How to test subquery results with the exists operator?

1125

How to see the create table statement of an existing table?

1072

What is meant by Active-Passive and Active-Active clustering setup?

1211

Does mysql support nosql?

928

what are the different levels of database schema?

1143

What is %type in pl sql?

981

Explain the difference between physical and logical data independence?

933

How long does it take to learn database administration?

566

What do you mean by a replica set in mongodb?

For More Un-Answered { Databases } Questions Click Here