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


Please Help Members By Posting Answers For Below Questions

Explain powershell included in sql server 2008?

615


How do you implement session management in SQL Server mode?

558


What is the significance of master, tempdb and model databases?

528


What is the difference between sdf and mdf?

679


How do I delete a sql server database?

549






What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

574


Does a full backup include transaction log?

485


Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture

544


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.

2034


What structure can you implement for the database to speed up table reads?

711


What are advantages of ssrs or why we should use ssrs?

104


Define Unique Key?

594


Define full outer join in sql server joins?

499


How to filter records of table in SQL SERVER?

601


Explain the various types of concurrency problem?

703