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 1064

What is the purpose of the master database?

1 1235

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

1 1120

Does sql server 2000 full-text search support clustering?

1 932

What is filtered index?

1 1156

What is usually the first word in a sql query?

1 1207

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

1 1150

What is logshipping and its purpose?

1 1102

What are the dmvs?

1 1100

What is xml datatype?

1 1141

Can sql servers linked to other servers like oracle?

1 1042

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

1 1062

Does a sql server 2005 select statement require a from?

1 1103

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 }

What are wait types?

1244

What is a concurrency problem in dbms?

1050

what is schema? : Sql dba

1138

define sql insert statement ? : Sql dba

1095

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2702

Can one drop a column from a table?

1082

What are different types of constraints?

996

Explain system functions or built-in functions? What are different types of system functions?

1060

Can we shrink data file in sql server?

1123

What is oracle latest version?

1171

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

1041

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

1112

What is the current mysql version?

1096

What is the current version of sql?

1091

What is the difference between upgrade and migration in sql server?

1179

For More Un-Answered { Databases } Questions Click Here