Login
Register
Dark Mode
Brightness
Profile
Edit Profile
Messages
My favorites
My Updates
Logout
Webpage for Databases:
Recent questions tagged databases
0
votes
1
answer
61
ISRO 2024
In SQL the statement $\text{select * from R, S}$ is equivalent to $\text{select * from R natural join S}$ $\text{select * from R cross join S}$ $\text{select * from R outer join S}$ $\text{select * from R inner join S}$
In SQL the statement $\text{select * from R, S}$ is equivalent to$\text{select * from R natural join S}$$\text{select * from R cross join S}$$\text{select * from R outer ...
Ramayya
180
views
Ramayya
asked
Jan 7
Databases
isro-2024
databases
joins
easy
+
–
0
votes
1
answer
62
made-easy
Rohit Chakraborty
101
views
Rohit Chakraborty
asked
Jan 6
Databases
made-easy-test-series
databases
test-series
+
–
0
votes
1
answer
63
Number of Conflict Serializable Schedules
How many total $Conflict$ $Serializable$ $Schedules$ are possible that can be formed by $T1$ and $T2?$ $T1:$ $r_1(A)$ $r_1(B)$ $w_1(B)$ $T2:$ $r_2(B)$ $r_2(A)$ $w_2(B)$
How many total $Conflict$ $Serializable$ $Schedules$ are possible that can be formed by $T1$ and $T2?$$T1:$ $r_1(A)$ $r_1(B)$ $w_1(B)$$T2:$ $r_2(B)$ $r_2(A)$ $w_2(B)$
Harsh Saini_1
334
views
Harsh Saini_1
asked
Dec 27, 2023
Databases
transaction-and-concurrency
conflict-serializable
databases
+
–
0
votes
1
answer
64
MadeEasy Test Series: How many tuples will be present in the output of the following SQL query.
My doubt here is, if NOT EXISTS gets an empty set as the input then every tuple of the table in the outer query must satisfy the condition. Am I right? For example, in the above question - The ... the same below) Can anyone please explain whether I am approaching this right, or if I am missing something?
My doubt here is, if NOT EXISTS gets an empty set as the input then every tuple of the table in the outer query must satisfy the condition. Am I right?For example, in the...
tishhaagrawal
343
views
tishhaagrawal
asked
Dec 16, 2023
Databases
databases
sql
query
gate-preparation
rdbms
doubt
made-easy-test-series
+
–
3
votes
1
answer
65
Can someone please explain how to solve this type of questions?
himanshu55
341
views
himanshu55
asked
Dec 9, 2023
Databases
test-series
gate-preparation
databases
ace-test-series
+
–
1
votes
1
answer
66
Made Easy
Amy and Bob are working on a project vehicle rental system, they have a file consisting of 10000 records, having block size 1024 bytes, record size 100 bytes. Search key size 9 bytes, pointer 7 bytes. They want to implement single level indexing. ... dense index, however Amy suggested to implement sparse index. How many blocks are saved by Amy considering only 1st level index ________?
Amy and Bob are working on a project vehicle rental system, they have a file consisting of 10000 records, having block size 1024 bytes, record size 100 bytes. Search key ...
suvasish114
424
views
suvasish114
asked
Dec 9, 2023
Databases
indexing
databases
file-system
made-easy-test-series
+
–
0
votes
0
answers
67
Made easy DBMS
amitarp818
202
views
amitarp818
asked
Dec 5, 2023
Databases
made-easy-test-series
databases
conflict-serializable
+
–
0
votes
0
answers
68
Made easy DBMS
amitarp818
152
views
amitarp818
asked
Dec 5, 2023
Databases
made-easy-test-series
databases
+
–
0
votes
0
answers
69
#foreign key#normalization
If in a relationship an entity totally participates, and if it contains a foreign key then the foreign key can not be null in relation table format?
If in a relationship an entity totally participates, and if it contains a foreign key then the foreign key can not be null in relation table format?
Dknights
114
views
Dknights
asked
Dec 2, 2023
Databases
databases
+
–
0
votes
0
answers
70
madeeasy ots
Sajal Mallick
164
views
Sajal Mallick
asked
Nov 20, 2023
Databases
made-easy-test-series
transaction-and-concurrency
conflict-serializable
databases
+
–
0
votes
0
answers
71
madeeasy workbook
According to me answer is 2.Is it right? Suggestion is needed how to approach this if it is given in more complexity.
According to me answer is 2.Is it right? Suggestion is needed how to approach this if it is given in more complexity.
Sajal Mallick
168
views
Sajal Mallick
asked
Nov 20, 2023
Databases
made-easy-booklet
databases
transaction-and-concurrency
conflict-serializable
+
–
0
votes
1
answer
72
Database system concepts by abraham silberschatz #14th chapter
is it allowed in a B+ tree, while deletion to leave behind a key in internal nodes while deleting it from the leaf ?
is it allowed in a B+ tree, while deletion to leave behind a key in internal nodes while deleting it from the leaf ?
phaniphani
176
views
phaniphani
asked
Nov 16, 2023
Databases
self-doubt
b-tree
databases
+
–
0
votes
0
answers
73
https://www.javatpoint.com/dbms-reduction-of-er-diagram-into-table
How can I represent the ER model in tabular form? , in java point, the tabular form doesn't seem to be correct. Ref. https://www.javatpoint.com/dbms-reduction-of-er-diagram-into-table
How can I represent the ER model in tabular form? , in java point, the tabular form doesn't seem to be correct.Ref. https://www.javatpoint.com/dbms-reduction-of-er-diagra...
Shrenik Pradhan
179
views
Shrenik Pradhan
asked
Nov 16, 2023
Databases
databases
+
–
Page:
« prev
1
2
3
4
5
6
7
8
...
97
next »
Email or Username
Show
Hide
Password
I forgot my password
Remember
Log in
Register