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 usage of save points in oracle database?

1 1047

What is the relationship among database, tablespace and data file?

1 1070

What is the difference between hot backup and cold backup in oracle?

1 1100

What is a system tablespace and when it is created?

1 1046

What are the different types of database objects?

1 1159

What is logical backup in oracle?

1 1112

What are the extensions used by oracle reports?

1 1122

What is the meaning of recursive hints in oracle?

1 1128

What is bulk copy or bcp in oracle?

1 1218

What is the usage of control file in oracle?

1 1179

What is the usage of synonyms?

1 1264

What types of joins are used in writing subqueries?

1 1078

What is the difference between post-database commit and post-form commit?

1 1339

What is blob data type in oracle?

1 1243

What is the usage of analyze command in oracle?

1 1172

Un-Answered Questions { Databases }

What is the current version of postgresql?

1174

If a cursor is open, how can we find in a pl/sql block?

1235

You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

1210

What is temporary table in sql server? Why we use temp table?

1017

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

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2706

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

1113

What is the difference between upgrade and migration in sql server?

1180

define sql insert statement ? : Sql dba

1096

What are the steps in creating a database?

1009

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 can you append an identity column to a temporary table?

1068

How can we solve concurrency problems?

1120

what are all the common sql function? : Sql dba

1130

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

1077

For More Un-Answered { Databases } Questions Click Here