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

How can you determine what protocol is being used for interconnect traffic?

1 66

What is oracle real application clusters?

1 76

When system tablespace is created?

1 1118

What are the database administrators utilities available?

1 1120

What is system tablespace?

1 1172

What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?

1 1138

How does one get the view definition of fixed views/tables?

1 1093

What is a snapshot log?

1 1073

Can objects of the same schema reside in different tablespace?

1 1127

How index is implemented in oracle database?

1 1068

How are extents allocated to a segment?

1 1202

How does one create a new database?

1 668

What database block size should I use?

1 792

How does one coalesce free space?

1 618

Introduction of rollup clause using sum and group by clause?

1 1046

Un-Answered Questions { Databases }

What is the best sql course?

1046

Is there some bulk load or other way to import a lot of data fast?

931

What is sql server query analyzer?

1123

What is standby servers? Explain types of standby servers.

1075

What are the types of database explain each of them briefly?

1053

Does view occupy space?

1006

what is the command syntax for inserting a document?

please send me oracle pl/sql exp resume. and also faqs...

2566

Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in

2100

How to define array in mongoose schema?

what is spatial nonclustered index

1054

1. Tell me about your self? 2. Latest Project Introduction? 3. Difference between server jobs and parallel jobs? 4. Seq-Seq Explain its behavior and execution mode and which parallelism technique is used? 5. What is padding characters? 6. Seq-Seq, Seq-Copy-Seq which one is the best and efficient? 7. How many reject links do we have to a transformer? 8. How many reject links to join stage? 9. Difference between join and lookup? 10. How to design PX routine? 11. How can we call job in another job? 12. Difference between batch and sequencer? 13. Which Database is used? 14. What is change capture? Give briefing of that? 15. What is change Code? Explain? 16. How you call UNIX in Ds? 17. How do you call JCL in UNIX? 18. How do you pass the job status of one job to another job? Have designed any job sequencer? 19. How do you find a file in existed directory? 20. How can you call parallel jobs in transformer? 21. Execution of jobs in command line? 22. Tuning of sql queries? 23. What is orchestrating metadata? 24. What are junk dimension? 25. What are the third party tools you are used? 26. What are the system variables you have used? IBM 1. What is virtual dataset? 2. How do you handle reject link to a peek stage? 3. What is transaction table? 4. Which one is the efficient from the following? a. ODBC enterprise b. Oracle enterprise 5. How can you extract data from excel sheet? Do you know how to parameterize, this option? 6. Six pages of complex query I have, how do you simplify this query? 7. Difference between dataset and lookup file set?

1982

What are the different subsets of sql?

1646

What kind of problems occurs if we do not implement proper locking strategy?

1493

Explain “row_number()” in sql server with an example?

1073

For More Un-Answered { Databases } Questions Click Here