Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...



Databases Interview Questions
Questions Answers Views Company eMail

write a query to delete similar records in different tables with same structure

4 9675

write a query to delete similar records in particular fields(columns) in different tables

TCS,

6 14267

Is it possible to run 32 bit sql server 2000 on64bit windows platform.if how much memory is available to sql server?

1 4256

What is index? How many types of indexes?

HCL,

2 12285

what are the optimization techniques for Query optimization performance issues and faster execution of queries

Infosys, Sierra Atlantica,

2 12995

what is difference between view and Dip.

IBM, L&T,

1 2474

what is curser.

9 14083

what is Data Transformation Services (DTS) ?can u explain me in detail?

TCS,

5 14837

wht is normalization?can u explain me in detail?

TCS,

9 18743

what are the main differences between MyISAM and InnoDB table storage structures ? what are the advantages and disadvantages in usage of these ?

E2 Solutions, Tesco,

10 44691

what are the new features of sql server 2005?

HP, Keane India Ltd,

8 13621

Suppose in a situation if two list boxes are there and if you select multiple options based on that the options related to those selected items should display in second list box. Again if we select multiple items in second listbox then the related to those selected items should display . In this scenario how will you design database,tables?

HP,

1 5424

what is the bond code in materialized view?

1 3086

what is the boundary line in varrays?

HCL,

1 8574

what is explain plan?

4 21604


Un-Answered Questions { Databases }

Suppose database is running slow, what will you do?

2590


what is the difference between openrowset and openquery?

1187


How to enter binary string literals in ms sql server?

1235


What is sql server query analyzer?

1123


What is the difference between for xml raw and for xml auto?

1112


You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

1207


How to define array in mongoose schema?

60


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

2309


How to convert character strings into numeric values?

1186


What is in place upgrade in sql server?

1123


What is a view in sql?

1035


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


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

1060


What is a concurrency problem in dbms?

1049


If any stored procedure is encrypted, then can we see its definition in activity monitor?

1064