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 1324

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 1100

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 1270

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

1 1242

What is dcl? : sql server DBA

1 1357

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 1297

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

1 1297

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 1197

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

1 1162

Un-Answered Questions { Databases }

List out the different types of locks available in sql server?

1046

When should you use an instead of trigger?

1048

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

1131

8. Sort, Lookup What kind of technique (partition) is used? 9. How can you handle exceptions in job sequencer? 10. How do you apply custom conditions an exceptions (How do you trigger exceptions in job sequence?) 11. I have a job with 3 possibilities? Finish with ok…..Abort…….Warning} How do you handle these in Job sequencer 12. How do you connect both OK and Warning can we? 13. How to find which process is running currently? 14. How do you find the disk usage in UNIX? 15. How do you combine 2 sequential files having same metadata of same file names? 16. How do you implement SCD in Ds? 17. Explain the situation where you have applied? 18. How do you apply new changes to? 19. Difference between change capture and Change apply? 20. Explain Compare Stage? 21. What is Surrogate key? 22. How to solve the problem of null values?

1903

how to use regular expression in pattern match conditions? : Sql dba

1108

What are the advantages of database?

1011

What are the source of constraints?

1006

What is a view in sql?

1037

what is spatial nonclustered index

1055

Which statement is used in a select query for partial matching?

1240

i have all the Oracle Certification material from 1z0-001 to 1Z0-643, if required just drop me a mail to: summi4you@yahoo.co.in

1856

How to convert character strings into numeric values?

1187

What are the kinds of subquery?

1103

What are the properties of the transaction?

1069

Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

2178

For More Un-Answered { Databases } Questions Click Here