Time Left - 20:00 mins

GATE 2023 Database Evaluation Quiz 5

Attempt now to get your rank among 60 students!

Question 1

A file is organized so that the ordering of data records is the same as or close to the ordering of data entries in some index, then that index is called?

Question 2

Which record allows part of a record to be in one block and the rest of it to be on the next block?

Question 3

Lock Point of a transaction occurs, when?

Question 4

Which of the following scenarios may lead to an irrecoverable error in a database system?

Question 5

Consider an ordered file with 1,00,000 records stored on a disk using an un-spanned file organization. The Block size is 2048 bytes and records length is 256 bytes. If primary indexing is used over a field of size 10 bytes and block pointer size is 6 bytes. Then the number of block access is required to search for a record?

Question 6

Which of the following statements is correct one?

Question 7

Which of the following is true?

Question 8

Given a block can hold either 3 records or 10 key pointers. If a database contains n records, then how many blocks do we need to hold the data file and the dense index?
  • 60 attempts
  • 1 upvote