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 is the difference between a local and a global temporary table?

1 1201

What is difference between delete & truncate commands?

1 1177

What stored by the msdb?

1 1071

Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

1 1147

What command must you use to include the not null constraint after a table has already been created?

1 1289

Can I run multiple instances of sql server 2000 at the same time on one computer?

1 1138

What are the different types of replication are there in sql server 2000?

1 1113

What are system databases into sql server (2005/2008)?

1 1079

How many database files are there in sql server 2000?what are they?

1 1145

What are sparse columns?

1 1101

How can we rewrite sub-queries into simple select statements or with joins?

1 1064

What does the on delete cascade option do?

1 1085

How are the unique and primary key constraints different?

1 1158

What are the advantages of using cte?

1 1093

When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?

1 1186

Un-Answered Questions { Databases }

What is the current mysql version?

1096

Can one drop a column from a table?

1082

What is the best sql course?

1046

Equi join and non equi join is possible with sql server?

1130

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

1179

Does view occupy space?

1007

Can we do dml on views?

1032

What is an indexed view?

1019

Plz send me Oracle Pl/Sql [1z0-147] dumps to this mail? sivakumarr1987@gmail.com

1897

What is self contained sub query?

1138

How raid can influence database performance?

1114

What are the source of constraints?

1006

List the ways in which dynamic sql can be executed?

1083

Suppose database is running slow, what will you do?

2590

Is inner join faster than left join?

1273

For More Un-Answered { Databases } Questions Click Here