|
Question |
Rating |
View Answer |
|
What is Task? |
|
View Answer |
|
What is job? |
|
View Answer |
|
How do we upgrade SQL Server 7.0 to 2000? |
|
View Answer |
|
Explain features of SQL Server like Scalability , Availability, Integration with Internet. |
|
View Answer |
|
What is de-normalization? When do you do it and how? |
|
View Answer |
|
Explain differences between Server.Transfer and server.execute method? |
|
View Answer |
|
What is indexing? |
|
View Answer |
|
What is referential integrity and how can we achieve it? |
|
View Answer |
|
How do you use DBCC statements to monitor various ASPects of a SQL Server installation? |
|
View Answer |
|
What is the purpose of UPDATE STATISTICS? |
|
View Answer |
|
What are cursors? Name four type of cursors and when each one would be applied? |
|
View Answer |
|
What is the difference between a Local temporary table and a Global temporary table? How is each one used? |
|
View Answer |
|
What does it mean to have quoted_identifier on? What are the implications of having it off? |
|
View Answer |
|
What is the STUFF function and how does it differ from the REPLACE function? |
|
View Answer |
|
What is an execution plan? When would you use it? How would you view the execution plan? |
|
View Answer |
|
What is an execution plan? When would you use it? How would you view the execution plan? |
|
View Answer |
|
What is one of the first things you would do to increase performance of a query? For example, a boss tells you that “a query that ran yesterday took 30 seconds, but today it takes 6 minutes”? |
|
View Answer |
|
What is the purpose of using COLLATE in a query? |
|
View Answer |
|
Using query analyzer, name 3 ways you can get an accurate count of the number of records in a table. |
|
View Answer |
|
What are the types of cookies are there? |
|
View Answer |