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 purpose does the model database server? : sql server DBA

1214

If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA

1036

What are the recovery models for a database? : sql server DBA

1150

What is the difference between the 2 operating modes of database mirroring? : sql server DBA

1011

What the different types of replication and why are they used? : sql server DBA

1190

What are the different ways you can create databases in sql server? : sql server DBA

1153

What is dcl? : sql server DBA

1287

What is the difference between clustered and non-clustered index? : sql server DBA

1103

What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA

1028

What is the default fill factor value? : sql server DBA

1149

What authentication modes does sql server support? : sql server DBA

1231

What are the different types of upgrades that can be performed in sql server? : sql server DBA

1225

What the different components in replication and what is their use? : sql server DBA

1063

Explain about your sql server dba experience? : sql server DBA

1107

Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

1097

Un-Answered Questions { Databases }

What is data sparsity and how it effect on aggregation?

967

Does google have something like access?

844

Is sql database free?

996

How to read/write files from pl/sql?

1056

How to save query output to a local file?

1051

What is domain in dbms?

969

What is stored procedure in database?

959

Which was the neo4j first version and when was it released?

List some advantages and disadvantages of stored procedure?

1029

What are the main differences between primary key and unique key?

1008

What are the functions of administration?

578

What is difference between index seek vs. Index scan?

1171

Where’s database data actually stored? Is there a way to see the files which are stored?

994

Under which circumstance should you create an index on a table?

1187

How to test values returned by a subquery with the in operator?

1211

For More Un-Answered { Databases } Questions Click Here