KyaPoocha.com

Related Interview Questions

• What would be the result of the command paste -s dog cat ?  08.11.08

  The paste text filter usually joins two files separating the corresponding lines with a tab. The -s option, however, will cause paste to display the first f...

• When do we go for Dynamic PickList and for Pick Applet?  03.11.08

  We go for Dynamic Picklists When we want to update joins( as normally joins are not updatable). We go for a pick applet when we choose a dynamic picklist. P...

• Difference between Snow flake and Star Schema. What are situations where Snow flake Schema is better than Star Schema to use and when the opposite is true?  18.09.08

  Star schema contains the dimesion tables mapped around one or more fact tables. It is a denormalised model.No need to use complicated joins.Queries results fas...

• When do you use SQL Profiler ?  24.07.08

  SQL Profiler utility allows us to basically track connections to the SQL Server and also determine activities such as which SQL Scripts are running, failed jobs...

• Is there any advantage to denormalizing DB2 tables ?  28.03.08

  Denormalizing DB2 tables reduces the need for processing intensive relational joins and reduces the number of foreign keys....

• What is an inner join, and an outer join ?  20.03.08

  Inner Join: combine information from two or more tables by comparing all values that meet the search criteria in the designated column or columns of one table w...

• What are Implicit and Explicit Joins?  06.12.06

  Implicit Joins is joins created using extension and intersection tables are called as implicit joins,fields populated using implicit joins are editable. Expl...

• What are the fundamental differences between value types and reference types?  24.08.06

  C# divides types into two categories - value types and reference types. Most of the intrinsic types (e.g. int, char) are value types. Structs are also value typ...

• What is a join and explain different types of joins.  06.08.06

  Joins are used in queries to explain how different tables are related. Joins also let you select data from a table depending upon data from another table. Ty...

• What is Reference type and value type ?  14.03.06

  Reference Type: Reference types are allocated on the managed CLR heap, just like object types. A data type that is stored as a reference to the value's location...