MyQuestionIcon

1

You visited us 1 times! Enjoying our articles? Unlock Full Access!

Consider data...

Question

Consider database has 3 files, each file has 100 pages and each page has 10 records. Mention the sequence of locking in multiple granularity locking to read records P30 to P70 of file 1.

A

IS on data base, S on file 1

Right on! Give the BNAT exam to get a 100% scholarship for BYJUS courses

B

IS on data base, S on file 2

No worries! We‘ve got your back. Try BYJU‘S free classes today!

C

IS on data base, X on file 1

No worries! We‘ve got your back. Try BYJU‘S free classes today!

D

X on data base S on file 1

No worries! We‘ve got your back. Try BYJU‘S free classes today!

Open in App

Solution

The correct option is A IS on data base, S on file 1
All ancestor nodes be locked in intention shared modes and the node be locked in shared mode.

Suggest Corrections

thumbs-up

0

Similar questions

Q. A student wishes to create symbolic links in a computer system running Unix. Three text files named "file 1", "file 2" and "file 3" exist in her current working directory, and the student has read and write permissions for all three files. Assume that file 1 contains information about her hobbies, files 1 contains information about her friends and file3 contains information about her courses. The student executes the following sequence of commands from her current working directory

In -s file1 file2
In -s file2 file3

Which of the following types information would be lost from her file system?
I. Hobbies II. Friends
III. Courses

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

Join BYJU'S Learning Program

similar_icon

Related Videos

lock

Muscular Tissue

Watch in App

Join BYJU'S Learning Program

CrossIcon