Answer Posted / ricky
relational database is composed of related data. so method
to combine these table together is known as normalisation.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is database replication? What are the different types of replication you can set up in sql server?
Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.
How would you go about developing a ssrs report?
You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?
Do you know what are the ways available in sql server to execute sql statements?
If you want to send some data from access database to sql server database. What are different component of ssis will you use?
When is the use of update_statistics command?
What does it mean to normalize a database and why would you do it?
How does clustered and non clustered index work?
Explain filtered indexes benefits?
What is proper subset of candidate key?
Give main differences between "Truncate" and "Delete".
How to create function with parameter in sql server?
How will you make an attribute not process? : sql server analysis services, ssas
Explain the flow of creating a cube? : sql server analysis services, ssas