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 the basic functions for master, msdb, model, tempdb and resource databases?

1 1066

What is the purpose of the master database?

1 1235

Does server sql treat char as a variable-length or fixed-length column?

1 1122

Does sql server 2000 full-text search support clustering?

1 935

What is filtered index?

1 1156

What is usually the first word in a sql query?

1 1208

How do I install only the client tools of sql server 2000?

1 1152

What is logshipping and its purpose?

1 1102

What are the dmvs?

1 1100

What is xml datatype?

1 1144

Can sql servers linked to other servers like oracle?

1 1045

When a primary key constraint is included in a table, what other constraints does this imply?

1 1063

Does a sql server 2005 select statement require a from?

1 1106

How many databases instances are there in sql server 2000?

1 1193

What are four major operators that can be used to combine conditions on a where clause?

1 1113

Un-Answered Questions { Databases }

Is it possible to have clustered index on separate drive from original table location?

1036

Is microsoft getting rid of access?

885

What kind of problems occurs if we do not implement proper locking strategy?

1495

What are the different subsets of sql?

1648

How to put more than 1000 values into an oracle in clause?

1112

Suppose database is running slow, what will you do?

2590

What are the different SQL Server Versions you have worked on?

1077

what is the age limit for groups1 examination

2339

what is spatial nonclustered index

1055

How can you append an identity column to a temporary table?

1068

What is a concurrency problem in dbms?

1051

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1295

How can I check that whether automatic statistic update is enabled or not?

1110

Were you involved in any data conversion, which one?

What are the different types of subquery?

1233

For More Un-Answered { Databases } Questions Click Here