Login
Register
Dark Mode
Brightness
Profile
Edit Profile
Messages
My favorites
My Updates
Logout
Webpage for Databases:
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
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 whic...
Sahil_Lather
490
views
Sahil_Lather
asked
Jan 29, 2023
Databases
b-tree
testbook-test-series
databases
+
–
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
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 t...
Sahil_Lather
337
views
Sahil_Lather
asked
Jan 29, 2023
Databases
databases
algorithms
loop
testbook-test-series
+
–
0
votes
0
answers
243
Databases
Please explain option c.
Please explain option c.
Overflow04
235
views
Overflow04
asked
Jan 25, 2023
Databases
databases
test-series
+
–
0
votes
1
answer
244
Will not Exist(cc in T1 is not equal to T2) gives TRUE ? , can anyone explain this
abhinowKatore
443
views
abhinowKatore
asked
Jan 18, 2023
Databases
databases
sql
+
–
1
votes
0
answers
245
SQL | Not Exist
abhinowKatore
275
views
abhinowKatore
asked
Jan 17, 2023
Databases
sql
databases
+
–
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
A relation is in 3NF if every non-prime attribute of R is fully functionally reliant on every key of RTRUEFALSE
Souvik33
506
views
Souvik33
asked
Jan 14, 2023
Databases
made-easy-test-series
databases
true-false
+
–
0
votes
1
answer
247
SQL Query
Write SQL command to find DepartmentID, EmployeeName from Employee table whose average salary is above 20000.
Write SQL command to find DepartmentID, EmployeeName from Employee table whose average salary is above 20000.
rayhanrjt
719
views
rayhanrjt
asked
Jan 6, 2023
Databases
sql
query
databases
+
–
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 ?
With reference to the GATE IT 2007 | Question : 66In the following article from GeeksForGeeks : Lock Compatibility DiagramIt can be clearly seen that if a transaction Ti ...
ParthPratim
292
views
ParthPratim
asked
Jan 6, 2023
Databases
databases
gateit-2007
+
–
Page:
« prev
1
...
4
5
6
7
8
9
10
11
12
13
14
...
97
next »
Email or Username
Show
Hide
Password
I forgot my password
Remember
Log in
Register