|
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
 Related Questions Latest Answer : Rollup summarises the group of data records based on key eg you want the income of a particular city from a set of records , you can use the rollup component.example dml is customer ,city name and amount (here the key ... What is the difference between clustered and non-clustered indices? ...and why do you use a clustered index? Latest Answer : while creating table you can implement tat by addingforeign key references p.tab_name(p.Col_name)heree p refers primary table andd this statement to be written beside col you want make as refrential integrity for the table..................... ... Latest Answer : SQL stands for Structured Query Language. ... Latest Answer : Stored procedure is a pre-compiled execution block,so they do not want to wait as the time for compilation.It is call from the server.It reduce the execution time ... Latest Answer : Using "show users" command yuo can see all the users currently logged on into SQL server ... Latest Answer : explain plan can be reviewed to check the execution plan of the query. This would guide if the expected indexes are used or not. ... Describe where you would use each of the following index types in relation to query type and/or data Describe where you would use each of the following index types in relation to query type and/or data set: Hashed, Sorted, Bitmapped (Ranked), Clustered In a process which reads 15,000 rows from one table and either updates or inserts them into another table and given the scenario where the process may abnormally terminate, describe how you track progress within the data to ensure the process could be restarted without repeating any processing.
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
