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

Can store procedure call by user define function in SQL server?

HCL,

10 19155

hi sql gurus, here is my question 4 u. i wanna use triggers for sending reminder mail to all users who are registered to the site. if any one knws the code plz send me ans here : chayabs3@gmail.com thnx advance

1 5565

How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?

EDS,

1 2175

We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.

1 5396

How i call Reports from Forms10g.

4 16958

What are the Features of Forms 6i over 4.5? What are the Features of Forms 10g? What are the Features of Reports 6i? What are the Features of Reports 10g ?

1 4703

A table contains list of customers and his city with other details. Each customer has a unique number and the table consists millions of data. Query is: I want to retrieve 10 customers from each city, no script, only from single query?

Infosys,

8 13108

How can I know what query is executing by by a particural user? (using sp id or any othe way.)

2 5402

what is the main difference between after trigger and instead trigger.

2 19946

I have to display ten columns values from diffrent ten tables. how many joins are require?

CarrizalSoft Technologies, HCL,

10 14877

what is difference between paging and fragmentation?

Cognizant, IOS,

1 7826

what is difference between clustering and mirroring?

Religare,

2 12200

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

2566

What is the difference between compression level 0 1nd 9

2 7764

what is directio?

2 7134

Un-Answered Questions { Databases }

what are the advantages of sql ? : Sql dba

1136

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

1235

How can you append an identity column to a temporary table?

1065

What is your daily office routine?

2340

Do we need to rebuild index after truncate?

1128

How to convert character strings into numeric values?

1186

How do I find the sql server version?

1099

What are the different types of subquery?

1228

How to define array in mongoose schema?

how to start mysql server? : Sql dba

1258

what is the age limit for groups1 examination

2335

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?

1905

What are the advantages of database?

1009

Have you created fact table and dimension tables?

703

How do I find query history in sql server?

1018

For More Un-Answered { Databases } Questions Click Here