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 do you the system monitoring?

1 7238

what is the Enterprise manager(2000) and management studio (2005)?

2 4915

How the data stores in a page?

1 5589

what are the problems in logshipping?

3 22287

How to tune a stored procedure?

6 17258

what is index seek and index scan?

2 12302

What is the difference between IN and EXISTS operators in SQL Server?

ASD Lab, CSC, Intelligroup,

9 67779

What about UPDATESTATISTICS ?

HCL, Intelligroup,

2 6988

how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?

HSBC,

1 3483

Hi can anyone tell me where are the dumps found of OCA certification.. Also the materials to be studied for the preparation.

2 6319

what is indexing, searching and user interface?

HCL,

1 5550

How to display n-1 columns from n number of columns, from a single table in MS SQL server 2005?

2 5980

can you any body tell me the difference between candidate key and primary key

4 8460

pl help me, i want oracle HRMS training institute address,in chennai

8 13349

i made a table in sql server 2000 and in a column i want to add image path of a picture present in my hardisk... so using insert statement how will i insert the path of the image in the table??

WebTech,

1 6533

Un-Answered Questions { Databases }

1. What is Container? 2. Tell me about your project? 3. Which container you are used in your project? 4. What is Surrogate key? 5. How you are implemented it? 6. Difference between Server job and Parallel job? 7. What is your Target Database? 8. What is Source System? 9. Difference between Join and Lookup? 10. Are you maintaining historical data? What is the logic used to maintained to historical data? 11. Do you have documents for mapping?

1845

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

2703

How do I remove duplicates in two columns?

1179

What is sql or structured query language?

1220

How to put more than 1000 values into an oracle in clause?

1110

Can we do dml on views?

1032

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

2177

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1193

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?

1908

Can delete statement be rollbacked?

1051

Can we use distinct and group by together?

1133

What versions of clipper does netlib support?

1088

What are the steps in creating a database?

1008

Explain system functions or built-in functions? What are different types of system functions?

1060

Re: Where can i get informatica certification Exam dumps and details? please forward it to emailid:

2311

For More Un-Answered { Databases } Questions Click Here