Explain the basic concepts of SQL server architecture?
Answer Posted / bhushan
SQL server Architechture is basically a partition of
Logical and Physical data database.
| Is This Answer Correct ? | 17 Yes | 11 No |
Post New Answer View All Answers
What command do we use to rename a db, a table and a column?
What is the difference between cube operator and rollup operator? : SQL Server Architecture
What is log shipping?
What is sql server schema compare? How we can compare two database schemas?
What is star, snowflake and star flake schema? : sql server analysis services, ssas
When would you prefer to have a minimum number of indexes?
What is trigger in salesforce?
what protocol both networks use? : Sql server database administration
What is meant by dirty read?
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
What is updatable resultset?
What do you understand by replication in sql server? Mention the different types of replication in sql server.
Define union, union all, minus, intersect?
What is query optimization process?
Is foreign key a primary key?