Sawaal
  • Home/
  • Searching for re-build

 Searching for "re-build"

Q:

How can you rebuild an index?

Answer

ALTER INDEX <index_name> REBUILD;

Report Error

View answer Workspace Report Error Discuss

Subject: Database Administration

Q:

How to rebuild Master Database?

Answer

Master database is system database and it contains information about running server's configuration. When SQL Server 2005 is installed it usually creates master, model, msdb, tempdb resource and distribution system database by default. Only Master database is th one which is absolutely must have database. Without Master database SQL Server cannot be started. This is the reason it is extremely important to backup Master database.


To rebuild the Master database, Run Setup.exe, verify, and repair a SQL Server instance, and rebuild the system databases. This procedure is most often used to rebuild the master database for a corrupted installation of SQL Server.

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

Q:

You are working with a previously saved document and you have deleted a logical operator. Which two methods can you use to recover the logical operator?

A. Click the Undo button in the Query panel.

B. Rebuild the filters.

C. Close the Query panel without executing and then open the query

D. From the Tools menu, select Recover Operator.

Answer

Answer : B , C

Report Error

View answer Workspace Report Error Discuss

Subject: SAP BW