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
Fifth Normal form is concerned with Join Dependency Domain-key Multivalued dependency Functional dependency
Fifth Normal form is concerned withJoin DependencyDomain-keyMultivalued dependencyFunctional dependency
Ramayya
228
views
Ramayya
asked
Jan 7
Databases
databases
normal-forms
+
–
0
votes
1
answer
62
ISRO 2024
Amongst the ACID properties of a transaction ‘Durability’ property requires that the changes made to the database by a successful transaction persist Except in case of an operating system crash Except in case of a disk crash Except in case of a power failure Always, even if there is a failure of any kind
Amongst the ACID properties of a transaction ‘Durability’ property requires that the changes made to the database by a successful transaction persistExcept in case of...
Ramayya
188
views
Ramayya
asked
Jan 7
Databases
isro-2024
databases
transaction-and-concurrency
+
–
0
votes
2
answers
63
ISRO 2024
Entity Relationship model shows the Static view Functional view Dynamic view All of the above
Entity Relationship model shows theStatic viewFunctional viewDynamic viewAll of the above
Ramayya
341
views
Ramayya
asked
Jan 7
Databases
isro-2024
databases
er-diagram
+
–
0
votes
1
answer
64
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
198
views
Ramayya
asked
Jan 7
Databases
isro-2024
databases
joins
easy
+
–
0
votes
1
answer
65
made-easy
Rohit Chakraborty
116
views
Rohit Chakraborty
asked
Jan 6
Databases
made-easy-test-series
databases
test-series
+
–
0
votes
1
answer
66
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
394
views
Harsh Saini_1
asked
Dec 27, 2023
Databases
transaction-and-concurrency
conflict-serializable
databases
+
–
0
votes
1
answer
67
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
411
views
tishhaagrawal
asked
Dec 16, 2023
Databases
databases
sql
query
gate-preparation
rdbms
doubt
made-easy-test-series
+
–
3
votes
1
answer
68
Can someone please explain how to solve this type of questions?
himanshu55
368
views
himanshu55
asked
Dec 9, 2023
Databases
test-series
gate-preparation
databases
ace-test-series
+
–
1
votes
1
answer
69
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
462
views
suvasish114
asked
Dec 9, 2023
Databases
indexing
databases
file-system
made-easy-test-series
+
–
0
votes
0
answers
70
Made easy DBMS
amitarp818
216
views
amitarp818
asked
Dec 5, 2023
Databases
made-easy-test-series
databases
conflict-serializable
+
–
0
votes
0
answers
71
Made easy DBMS
amitarp818
174
views
amitarp818
asked
Dec 5, 2023
Databases
made-easy-test-series
databases
+
–
0
votes
0
answers
72
#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
119
views
Dknights
asked
Dec 2, 2023
Databases
databases
+
–
0
votes
0
answers
73
madeeasy ots
Sajal Mallick
176
views
Sajal Mallick
asked
Nov 20, 2023
Databases
made-easy-test-series
transaction-and-concurrency
conflict-serializable
databases
+
–
0
votes
0
answers
74
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
178
views
Sajal Mallick
asked
Nov 20, 2023
Databases
made-easy-booklet
databases
transaction-and-concurrency
conflict-serializable
+
–
0
votes
1
answer
75
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
196
views
phaniphani
asked
Nov 16, 2023
Databases
self-doubt
b-tree
databases
+
–
0
votes
0
answers
76
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
206
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