Answer Posted / praveen
Denormalization is a technique to move from higher to lower
normal forms of database modeling in order to speed up
database access.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is lock escalation and what is its purpose?
How do you create a data source?
Explain where clause?
What is the use of sql profiler in sql server 2012?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
Explain hostprotectionattribute in sql server 2005?
Tell me what is fill factor?
What is model database? : SQL Server Architecture
What are the dmvs? : sql server database administration
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
Who is the owner of a schema in ms sql server?
What is sql profiler. What are the default templates with it? : sql server database administration
Explain four layers of abstraction microsoft architectured?
What Are the Main Features of SQL Azure?
Explain what role entity and relationship play in an ER diagram.
