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

Explain integrity constraints?

1 1186

What do you mean by a deadlock?

1 1145

Will you be able to store pictures in the database?explain.

1 1065

Explain the function of optimizer in oracle?

1 1248

What are the uses of synonyms?

1 1219

Explain the use of record option in exp command.

1 1097

Explain the use of analyse option in exp command.

1 1249

List the types of joins used in writing subqueries?

1 1069

What is meant by recursive hints in oracle?

1 1161

List out the components of logical database structure of oracle database.

1 1123

Explain the use of file option in exp command.

1 1213

What is the difference between conversions and interfaces? : oracle accounts receivable

1 1349

Can you explain how to adjust the amount of advance already received against an invoice? : oracle accounts receivable

1 1357

Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable

1 1372

Difference between transaction type and transaction sources. : oracle accounts receivable

1 1102

Un-Answered Questions { Databases }

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

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

1897

what is collation? : Sql dba

1229

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?

1212

Is primary key clustered index?

1018

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

2708

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?

1907

How do I create a trace in sql server?

1118

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1132

How to write a left outer join with the where clause in oracle?

1151

What is acid mean in sql server?

1244

How do I start sql server 2017?

1015

Can you index views?

953

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

1077

what is the difference between openrowset and openquery?

1191

For More Un-Answered { Databases } Questions Click Here