Databases Interview Questions
Questions Answers Views Company eMail

How to create DSN..Explain?

Infosys, BeBo Technologies,

2 16058

What is the difference between SQL, DDL, and DML?

Wipro, BeBo Technologies,

7 61060

What are inner join and outer join?

3 8241

What are many types of joins are there?

CSC, TCS, Amdocs,

29 61300

what are Triggers?


5 8241

what are stored procedures?


6 6632

what are many types of index's are there and what are they?

TCS, Green Info Solutions,

7 11579

what are views?


7 13122

what is web server?


3 7585

What are functions

3 5934

What are the different table present in MYsql?

3 8219

What is the difference between mysql_fetch_array and mysql_fetch_object?


4 7906

what is the difference between oracle 81,91,11i

Oracle, i2,

2 14666

How client makes connection with server in client/server architecture?


1 2428

Is Oracle 7.3 is a single user or multi user..Is it possible to use this as a backend for web applications?

2 3011

Un-Answered Questions { Databases }

Which is better Oracle or MS SQL? Why?


What are joins, explain all types of joins?


1. How many nodes you are using project? 2. What is configuration file? 3. What is modules partition? How it is work in project? 4. What is Environment Variable? How it is use? 5. What is sequence? 6. How do you execute parallel jobs in projects? 7. If you run a job in job sequencer individually without any comments? 8. How many jobs did in your project? 9. How to schedule the job in Data stage 7.5 X2? 10. If you have 10 jobs in PX2, shall you run all jobs at a time? 11. I have 5 jobs (1-5), I connect with each other, but I want to run from 3-5 only how? 12. What is same partition? 13. If you have 40GB hard disk in I have 30GB data how I configure the nodes for partition? 14. Did you write any code for Data stage project? 15. Did you write any code for parallel job execution in your project? 16. Will you schedule all jobs at a time?


sql database suspect We have a sql database that is showing as suspect. How can we recover?


Is the After report trigger fired if the report execution fails ?


what is isolation level at dead lock?


Teradata: How can we know the indexed column in a table?


What is an Oracle index?


what is the difference difference between procedure and packages


Give two methods you could use to determine what DDL changes have been made.


Hi Can any one tell me what are the API's used in requisition import.


how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area,, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, asc


hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.


What is your daily office routine?


Tell about MOM Tool(Microsoft Operator Manager)?