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

Differentiate between sql temp table vs table variable?

1 951

Differentiate between mongodb vs. Sql server?

1 1168

When we should use and scope of @@identity?

1 1065

How do indexes help, types?

1 1031

What is store procedure? When do you use?

1 1018

Why use view instead of a table?

1 1015

What are the attributes of cursor?

1 1139

What are set operators?

1 1154

What is blob datatype?

1 1234

What are a cluster and non-cluster index?

1 1095

How do we create privileges in oracle?

1 1133

State and explain about oracle instance?

1 1072

What is the data type of dual table?

1 1095

What is using clause and give example?

1 1124

Explain about achiever in sql?

1 1108

Un-Answered Questions { Databases }

Have you used lexical parameters in reports?

what are all the common sql function? : Sql dba

1127

Why use identity in sql server?

1191

How do I remove duplicates in two columns?

1178

What is the difference between for xml raw and for xml auto?

1112

What is a scheduled job or what is a scheduled task?

1033

Can we use distinct and group by together?

1131

Where can you add custom error messages to sql server?

1203

List out the different types of locks available in sql server?

1045

What is temporary table in sql server? Why we use temp table?

1012

What is an indexed view?

1018

How to remove duplicate rows from table except one?

1081

What are the steps in creating a database?

1005

How do I find the sql server version?

1099

What is clustered index

1083

For More Un-Answered { Databases } Questions Click Here