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 joins..how many types of joins are there?

CSC, TCS, Amdocs,

29 61300

what are Triggers?

TCS,

5 8241

what are stored procedures?

TCS,

6 6632

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

TCS, Green Info Solutions,

7 11579

what are views?

TCS,

7 13122

what is web server?

Satyam,

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?

CTS,

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?

CA,

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?

3942


What are joins, explain all types of joins?

871


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?

682


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

710


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

1519






what is isolation level at dead lock?

1009


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

627


What is an Oracle index?

394


what is the difference difference between procedure and packages

5778


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

4619


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

778


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.technology, 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, gc_technology.technology asc

2052


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.

913


What is your daily office routine?

1074


Tell about MOM Tool(Microsoft Operator Manager)?

681