Which of the following is true about indexes and index fragmentation?

A. indexes do not have to be updated once they are created
B. records should be stored on the disk contiguously
C. database records stored in order are said to be fragmented
D. external fragmentation occurs due to accumulation of free space between records


Answer: B

Computer Science & Information Technology

You might also like to view...

What is the output of the following segment of code if the value 4 is input by the user?

``` int num; int total = 0; cout << "Enter a number from 1 to 10: "; cin >> num; switch (num) { case 1: case 2: total = 5; case 3: total = 10; case 4: total = total + 3; case 8: total = total + 6; default: total = total + 4; } cout << total << endl; ``` a. 0 b. 3 c. 13 d. 23 e. None of these

Computer Science & Information Technology

A language containing a minimum number of different concepts is said to have ______.

What will be an ideal response?

Computer Science & Information Technology

What is the recommended color for the window in an IrDA device?

A. red B. amber C. green D. violet

Computer Science & Information Technology

Which of the following can be used to protect the confidentiality of information?

a. Encryption b. Auditing c. Backups d. Network server redundancy

Computer Science & Information Technology