1.What is the deferece between DBMS & RDBMS?
2.How can you trouble shoot? If u will get error while
installing sql server?
3.How can u trouble shoot slow running query?
4.how can u trouble log shipping errors?
5.why do we use merge replication instead of T.log
replication?
Answer Posted / subhash kumar
yes
no
yes
yes
no
Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Do you know the policy based administration feature of sql server 2008?
Explain about system stored procedure?
Why I am getting this error when renaming a database in ms sql server?
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
What is data compression? : sql server database administration
What is the difference between functions and stored procedures?
What are the characteristics of modern DBMS?
how to use DTS package in 2000,2005,2008 in sql server
What do you understand by mirroring and mention the advantages of the mirroring?
Does windows server 2016 come with sql server?
Why do we use non clustered index?
What is difference between unique and primary key?
Describe how to use the linked server?
Explain few examples of RDBMS?
What are the types of database schema? : sql server analysis services, ssas