While considering Costs and Benefits of Coalescing or Rebuilding Index – McqOptions

MCQOPTIONS

1.	While considering Costs and Benefits of Coalescing or Rebuilding Indexes which has lower costs and does not require more disk space?
A.	Coalesce Index
B.	Rebuild Index
C.	Both A & B
D.	None of the above
Answer» B. Rebuild Index

Discussion

No Comment Found

Related MCQs

Which of the following statements is true after execution of the program?  int a[10],I,*p;  a[0]=1; a[1]=2; p=a; (*p)++;
using' in C++ is for.
Analyse the following code snippet: ClassTemp  {  private:  charm_acEmpName[25];  public:  char*GetFirstChar()  {  strcpy(m_acEmpName,"Hello");  returnthis->m_acEmpName;  }  };  intmain(intargc,char**argv)v {  Temp oTempObject; cout< } .
 Choose the proper statement
NULL is
Which of the following data structures are used in RDBMS.
When a transaction is committed, what does the LGWR do?
To ensure that a transaction does not hang if it cannot obtain a lock, which of the following statements below should be executed?
When does a statement run in a resumable mode?
What do we call transactions in which commit was interrupted by any type of system or network failure?