Which algorithm is best suited to I/O-bound processes?
FCFS
Round robin
SRN
Multi-level queuing (MLQ)
Difficulty Level: 1
Positive Marks: 1.00
Negative Marks: 0.33
If there are n processes in a system and b is the burst time of each process, what is the maximum and minimum time a process needs to wait for its execution assuming no context delay?
q,0
n,1
nb,0
(n-1)b,0
Difficulty Level: 1
Positive Marks: 1.00
Negative Marks: 0.33
Clock page-replacement algorithm is another implementation of
LRU
FIFO
optimal
second chance
Difficulty Level: 1
Positive Marks: 1.00
Negative Marks: 0.33
_________is the time taken by the disk head to move from one cylinder to another.
Seek time
Transfer time
Rotational latency
None
Difficulty Level: 1
Positive Marks: 1.00
Negative Marks: 0.33
algorithm may be best suitable to batch-processing systems where high throughput and average response time are required.
SCAN
FIFO
LOOK
SSTF
Difficulty Level: 1
Positive Marks: 1.00
Negative Marks: 0.33
RAG is a useful tool to represent a in a system.
deadlock
resource allocation
race condition
none
Difficulty Level: 1
Positive Marks: 1.00
Negative Marks: 0.33
Which algorithm is better when the load on the disk is low and the requests are uniformly distributed?
SCAN
FCFS
LOOK
SSTF
Difficulty Level: 1
Positive Marks: 1.00
Negative Marks: 0.33
An algorithm that satisfies________property does not suffer from the Belady’s anomaly
stack property
queue property
Both
None
Difficulty Level: 1
Positive Marks: 1.00
Negative Marks: 0.33

Consider the following information about the processes :

Calculate the average normalized turn around time using FCFS scheduling algorithm

2.56
2.71
1.84
1.59
Difficulty Level: 1
Positive Marks: 2.00
Negative Marks: 0.66
Consider the following information about the processes :

Calculate the average normalized turn around time using RR (time slice=1) scheduling algorithm

2.56
2.71
1.84
1.59
Difficulty Level: 1
Positive Marks: 2.00
Negative Marks: 0.66
Consider the following information about the processes :

Calculate the average normalized turn around time using RR (time slice=4) scheduling algorithm

2.56
2.71
1.84
1.59
Difficulty Level: 1
Positive Marks: 2.00
Negative Marks: 0.66
How many levels of page tables are required if the page size is 4KB, PTE is 4bytes, and 64 bits virtual addresses if the the last level page table is to fit in one page ?
2
3
4
6
Difficulty Level: 1
Positive Marks: 2.00
Negative Marks: 0.66
Consider a system with main memory access time of 100ns, TLB access time of 10ns, with TLB hit of 85% with page faults of 2 instructions every 100 instructions. The page-fault service time is 2ms. What is the effective memory access time
6124.4 ns
7124.5 ns
8000 ns
7894.7 ns
Difficulty Level: 1
Positive Marks: 2.00
Negative Marks: 0.66
Consider the following synchronization code using binary semaphore between two processes

The value of x and y after execution is

infinite, 1
2,1
1,1
3,1
Difficulty Level: 1
Positive Marks: 2.00
Negative Marks: 0.66

Arrange the given statements into correct order, as followed during a page service after the page fault has occured.

S1 : using the disk map of faulting process, load the faulting page from the disk into

the victim frame

S2 : select a victim page for replacement

S3 : update the page table of faulting process and frame table to reflect the changed

mapping for the victim frame

S4 : using the disk map of the victim process, copy the victim page to the disk (if

dirty)

S5 : look up the frame table to identify the victim process and invalidate the page table

entry of the victim page in the victim page table

S2, S1, S3, S4, S5
S1, S2, S3, S4, S5
S2, S5, S4, S1, S3
S5, S2, S3, S4, S1
Difficulty Level: 1
Positive Marks: 2.00
Negative Marks: 0.66

During the specific time interval, the following page accesses are recorded for the

three processes P1, P2, and P3, respectively.

P1: 0, 10, 1, 0, 1, 2, 10, 2, 1, 1, 0

P2: 0, 100, 101, 102, 103, 0, 101, 102, 104

P3: 0, 1, 2, 3, 4, 5, 0, 1, 2, 3, 4, 5

What is memory required (in frames) to satisfy the need of all the processes in this machine ?

2
4
8
16
Difficulty Level: 1
Positive Marks: 2.00
Negative Marks: 0.66
In B trees deletion causes the height will ___________ [MSQ]
No change
Decreased by 1
Decreased by 2
None of the above
Difficulty Level: 1
Positive Marks: 1.00
Negative Marks: 0.00
Consider the following E-R diagram

If A has 1000 entities, b has 100 entities and C has 50 entities. What is the maximum no. of tuples of entities that could be in a relationship set for R?

1000
1,00,000
10,00,0000
100
Difficulty Level: 1
Positive Marks: 1.00
Negative Marks: 0.33
Find a set of FDs for the relation schema R(w, x, y, z) with primary key wx under which R is in 2NF but not in 3NF.
Difficulty Level: 1
Positive Marks: 1.00
Negative Marks: 0.33
Assume R (A, B) and S (C, D) relation have the following instances:

(Select B from R)

MINUS

(Select distinct C from S)

Total number of tuples returned by the above query is ______________.

0
Difficulty Level: 1
Positive Marks: 1.00
Negative Marks: 0.00
The transactions T1 and T2 are specific executions of the programs that refer to the specific flights whose number of seats are stored in data items X and Y in the database. Then what type problem(s) may encounter with these two transactions if they run concurrently? [MSQ]
Lost update problem
Dirty read problem
Incorrect summary problem
Redundancy problem
Difficulty Level: 1
Positive Marks: 1.00
Negative Marks: 0.00
‘_ _ _%’ matches any string of
At least three characters
At most three characters
Exactly three characters
Exactly three characters ends with %
Difficulty Level: 1
Positive Marks: 1.00
Negative Marks: 0.33
Consider the relation R(ABCD) with AB as a candidate key, choose the FD so that R should be in 2NF but not in 3NF.
D->C
AB->C
AB->D
A->B
Difficulty Level: 1
Positive Marks: 1.00
Negative Marks: 0.33
Assume transaction T1 holds a shared lock on relation R. If transaction T2 also requests for a shared lock on R. Then,
It will result in a deadlock situation.
It will immediately be rejected.
It will immediately be granted.
It will be granted as soon as it is released by T1
Difficulty Level: 1
Positive Marks: 1.00
Negative Marks: 0.33
Difficulty Level: 1
Positive Marks: 2.00
Negative Marks: 0.66
Consider a disk with block size 512 Bytes. A block pointer 6 bytes and record pointer is 9 bytes. The file has 10000 Employee records. Every record is a fixed length of 120 Bytes. Its key is SSN which is of 4 Bytes. The file is not ordered by the key field and want to construct a secondary Index on SSN. Find out no. of blocks required in the second level Index.
8
7
6
4
Difficulty Level: 1
Positive Marks: 2.00
Negative Marks: 0.66
Consider two Relations R1,R2 with X1 and X2 rows where X2>X1>0. What are the max and min rows for Relation Algebra Expression R2/R1?
X1/X2, 0
X2/X1, 0
X1/X2, X1
0, X2/X1
Difficulty Level: 1
Positive Marks: 2.00
Negative Marks: 0.66
Use the following tables for the below queries wherever table 1 and table 2 are used:

How many number of rows will be there in output?

0
2
1
3
Difficulty Level: 1
Positive Marks: 2.00
Negative Marks: 0.66
Many to one relationship between X and Y entities in E-R diagram is converted as
Modify Y side to include foreign key of Y side as primary key.
Modify Y side to include primary key of X side as foreign key.
Modify Y side to include foreign key of Y side as primary key.
Modify X side to include primary key of Y side as foreign key.
Difficulty Level: 1
Positive Marks: 2.00
Negative Marks: 0.66
Consider the following description.

To construct the B+ tree use the following values. Consider database block size as 512B, Block pointer as 8B, Record pointer as 10B, Key value as 12B.

(1) What is the order of the B+ tree of Internal nodes?

24
25
26
27
Difficulty Level: 1
Positive Marks: 2.00
Negative Marks: 0.66
Consider the following description.

To construct the B+ tree use the following values. Consider database block size as 512B, Block pointer as 8B, Record pointer as 10B, Key value as 12B.

What will be the number of Index records that can be stored into a B+ Tree of 3 levels for the above question. Assume that the fill factor of the node is 90%

231172
231173
231174
231175
Difficulty Level: 1
Positive Marks: 2.00
Negative Marks: 0.66

Which of the following is/are correct about the relation R? [MSQ]

Prime attributes of R = {A, B, C, D}
ABD is a candidate key of R
The relation R is in 1NF but not in 2NF
The relation R is in BCNF
Difficulty Level: 1
Positive Marks: 2.00
Negative Marks: 0.66

[MSQ]

Difficulty Level: 1
Positive Marks: 2.00
Negative Marks: 0.66