Physical reads typically perform faster than logical reads True False QUESTION2
ID: 3920435 • Letter: P
Question
Physical reads typically perform faster than logical reads True False QUESTION2 When a regular entity type contains a multivalued attribute, one must: create a single table with multiple lines for each instance of the multivalued attribute. create two new tables, one containing the multivalued attribute. create two new tables, both containing the multivalued attribute None of these. QUESTION3 One major disadvantage of the outer join is that information is easily lost. True False QUESTION 4 Raid level 2 & 3 are usually set up for: A. Synchronous access to all disks (all disks particpate in all reads / writes) B. Independent access to all disks (each disk operates independent of the others) C. Use by applications that have many concurrent users. D.A &C;Explanation / Answer
1.) Since no IO is performed, logical IO is faster than physical reads. Hence, False.
2.) For multi-valued attribute, we need to create a separate table for multi valued atrribute along with the primary key. Hence option b is the correct option.
3.) This is not correct. False
4.) Sorry. I am not sure about this one,
5.) In LRU, page which is used last will be replaced. Therefore, page B will be replaced.
6.) Random replacement strategy has the least overhead.