Question 1 Overflow is an example of a. Media Failure

b. System Failure

c. Inconsistency

d. Local Failure

Question 2 Which of the following is not correct

a. The data in Data warehouse is not generated fast

b. Locks are used to solve failure

c. Having many disks in one machine is called RAID

d. All are correct

Question 3 Assume that you used a bitmap index on two fields in a table. The number of bits used to represent each value in the two fields would equal

a. We can not know

b. The number of values in the field

c. The number of records in the table

Question 4 Which of the following is not correct

a. XQuery is used with Semi-structured data

b. Transactions completed before save point are not undone neither redone at failure

c. Hash index can find the record faster than the sequential file

d. All are correct

Question 5 SELECT * FROM emp WHERE Name = Zeyad. Which index is best used for this

a. Hash

b. Sequential

c. Bitmap

d. Grid

Question 6 Decreasing isolation would increase consistency

a. True

b. False

Question 7 In lost update problem, which update is lost

a. We can not know

b. The first update

c. The second update

Question 8 Which of the following is not correct

a. Data mining looks for finding new knowledge

b. Log file is used only with system failures

c. It is easier to load a sequential file index into memory than loading a hash index.

d. All are correct