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 dropping a database and taking a database offline? : sql server DBA

1 1137

How do you troubleshoot errors in a sql server agent job? : sql server DBA

1 1196

What are the commands used in dcl? : sql server DBA

1 1174

What are the operating modes in which database mirroring runs? : sql server DBA

1 1273

What is a system database and what is a user database? : sql server DBA

1 1373

How do you open a cluster administrator? : sql server DBA

1 1175

Which autogrowth database setting is good? : sql server DBA

1 1292

List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

1 1433

Where do you find the default index fill factor and how to change it? : sql server DBA

1 1150

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

1 1282

What are the different types of indexes available in sql server? : sql server DBA

1 1321

What is left outer join in sql server joins?

1 1145

Can you please explain the difference between primary keys and foreign keys?

1 1201

What is 3nf normalization form?

1 1209

Explain index in sql server?

1 1090

Un-Answered Questions { Databases }

What are the source of constraints?

1006

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

1897

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?

1043

what is the difference between openrowset and openquery?

1189

what ASIS BUSINESS PROCESS IN ORACLE FINANCE

2354

What is oracle latest version?

1171

what is the command syntax for inserting a document?

What are the kinds of subquery?

1103

What is normalization and what are the advantages of it?

1054

How to export data from database and import into another?

995

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

2050

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

1077

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

1110

What are the properties of the transaction?

1069

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

1037

For More Un-Answered { Databases } Questions Click Here