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

1002

What is the purpose of the master database?

1149

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

1062

Does sql server 2000 full-text search support clustering?

880

What is filtered index?

1116

What is usually the first word in a sql query?

1149

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

1085

What is logshipping and its purpose?

1009

What are the dmvs?

1026

What is xml datatype?

1095

Can sql servers linked to other servers like oracle?

980

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

999

Does a sql server 2005 select statement require a from?

1038

How many databases instances are there in sql server 2000?

1119

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

1073

Un-Answered Questions { Databases }

key flexfield structure

2192

Who is a database user?

563

What is difference between createstatement and preparedstatement?

1132

What are the differences between char and nchar?

1124

How many rows can a database hold?

1054

Define atomicity and aggregation.

1049

What is the difference between procedure and function in mysql?

1031

How to connect with firebird database in delphi using tsqlconnection?

Can journaling features be used to perform safe hot backups?

Is it possible to create trigger on views?

1009

What are the differences between char and varchar data types?

1125

what is extent in informix?

sparse lookup and where its options we find in OCI and db2?

2240

when MSQL8.0 is in market

2098

Is there any advantage of last_name varchar(50) over this last_name varchar(255)?

930

For More Un-Answered { Databases } Questions Click Here