Dark Mode

Recent questions tagged databases

0 votes

0 answers

241

TestBook TestSeries question to find max child possible in B+ Tree
In a B+ Tree index having order 6, which is the maximum number of child pointers it can have. Keys are numbered from 1 to 83. What can be the maximum number of nodes which can be used to store all the keys? A. 17 B. 19 C. 59 D. 57

Sahil_Lather asked in Databases Jan 29, 2023

by Sahil_Lather

502 views

0 votes

1 answer

242

TestBook TestSeries Finding number of records under join of 2 tables
Assume a relation R' having 200 records. These records are stored in blocks having block factor as 20. Consider another relation S' having 120 records and all these records are stored in 30 blocks. These two tables have to be joined ... the total number of block access required to join R and S ? A. 2430 B. 6010 C. 6120 D. 1230

Sahil_Lather asked in Databases Jan 29, 2023

by Sahil_Lather

349 views

0 votes

0 answers

243

Databases
Please explain option c.

Overflow04 asked in Databases Jan 25, 2023

241 views

0 votes

1 answer

244

Will not Exist(cc in T1 is not equal to T2) gives TRUE ? , can anyone explain this

abhinowKatore asked in Databases Jan 18, 2023

by abhinowKatore

450 views

1 vote

0 answers

245

SQL | Not Exist

abhinowKatore asked in Databases Jan 17, 2023

by abhinowKatore

284 views

0 votes

2 answers

246

Made Easy Test Series | 3NF | True/False
A relation is in 3NF if every non-prime attribute of R is fully functionally reliant on every key of R TRUE FALSE

Souvik33 asked in Databases Jan 14, 2023

531 views

0 votes

1 answer

247

SQL Query
Write SQL command to find DepartmentID, EmployeeName from Employee table whose average salary is above 20000.

rayhanrjt asked in Databases Jan 6, 2023

753 views

0 votes

1 answer

248

Lock Compatibility in GATE IT 2007 | Question: 66
With reference to the GATE IT 2007 | Question : 66 In the following article from GeeksForGeeks : Lock Compatibility Diagram It can be clearly seen that if a transaction Ti owns a Shared lock on A, then a transaction Tj cannot take an Exclusive lock on ... (A) call in T2 will wait for T1, and T1 will wait for Lock_X(B) from T2, so hence a deadlock ?

ParthPratim asked in Databases Jan 6, 2023

301 views

Page:

« prev
1
...
4
5
6
7
8
9
10
11
12
13
14
...
97
next »

Recent questions tagged databases