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

1 1326

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

1 1101

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

1 1219

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

1 1073

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

1 1271

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

1 1242

What is dcl? : sql server DBA

1 1358

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

1 1175

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

1 1082

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

1 1239

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

1 1298

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

1 1298

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

1 1124

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

1 1198

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

1 1162

Un-Answered Questions { Databases }

What is a concurrency problem in dbms?

1052

in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

2211

Have you created fact table and dimension tables?

710

Can we do dml on views?

1033

What is sql or structured query language?

1222

what are aggregate and scalar functions? : Sql dba

1125

How do I start sql server 2017?

1014

What is acid mean in sql server?

1242

in oracle BPM composer in part BA model on design model in enterprise model i cannot connection with value chain model work not links in part properties do you can me help me?

1605

Any work done in oracle workflow builder. Did you customize or build a new workflow?

what is the command syntax for inserting a document?

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

1131

What are the properties of the transaction?

1069

What are wait types?

1247

How to convert character strings into numeric values?

1187

For More Un-Answered { Databases } Questions Click Here