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 new features in SQL Server 2005 when compared to SQL Server 2000?

1 1228

What are the High-Availability solutions in SQL Server and differentiate them briefly?

1 1201

How do you troubleshoot errors in a SQL Server Agent Job?

1 1118

What is the default Port No on which SQL Server listens?

1 1187

what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?

1 1119

What is DCL?

1 1109

What are the commands used in DCL?

1 1093

What is the default fill factor value?

1 1143

Where do you find the default Index fill factor and how to change it?

1 1129

What is a system database and what is a user database?

1 1155

What are the recovery models for a database?

1 1160

What is the importance of a recovery model?

1 1104

What is Replication?

1 1117

What the different types of Replication and why are they used?

1 1148

What the different components of Replication and what is their use?

1 1134

Un-Answered Questions { Databases }

what is the last version,the release date of that version and fix pack of ibm db2 udb?

2035

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

1095

How do I find the sql server version?

1096

Why should you use or avoid select * statements?

1094

How to export data from database and import into another?

978

how to escape special characters in sql statements? : Sql dba

1097

How to convert numeric expression data types using the cast() function?

1133

If any stored procedure is encrypted, then can we see its definition in activity monitor?

1055

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

1095

Is inner join faster than left join?

1265

What is the primary use of the model database?

1141

What is the best sql course?

1031

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

1277

How can we solve concurrency problems?

1110

Can we rollback truncate?

1058

For More Un-Answered { Databases } Questions Click Here