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
1651
#doubt algo
What is the disadvantage of avl tree over b tree ??
What is the disadvantage of avl tree over b tree ??
air1ankit
188
views
air1ankit
asked
Oct 28, 2017
Algorithms
algorithms
databases
+
–
3
votes
1
answer
1652
indexing
Arnabi
733
views
Arnabi
asked
Oct 28, 2017
Databases
indexing
databases
+
–
0
votes
0
answers
1653
Database #1NF
R(ABCDE) { A,BC,CD} are candidate key of relation R after 1 NF design which one is possible multi valued attributes before 1 NF design ???
R(ABCDE) { A,BC,CD} are candidate key of relation R after 1 NF design which one is possible multi valued attributes before 1 NF design ???
air1ankit
463
views
air1ankit
asked
Oct 27, 2017
Databases
databases
data-dependency
rdbms
+
–
2
votes
1
answer
1654
Doubt Database
How to remove extraneous attributes ?? Que - find the minimal cover of the functional dependency set A->BCDEF BC->ADEF B->F D->E explain whlole procedure please
How to remove extraneous attributes ??Que - find the minimal cover of the functional dependency setA->BCDEF BC->ADEF B->F D->E explain whlole procedure please
air1ankit
943
views
air1ankit
asked
Oct 27, 2017
Databases
databases
database-normalization
+
–
1
votes
0
answers
1655
Database: B+ Tree Insertion
Question: the below figure shows a B+ tree where only key values are indicated in the records. Each block can hold upto three records. A record with a key value 34 is inserted into the B+-tree. Obtain the modified B-tree after insertion. My Solution Please validate the solution,
Question: the below figure shows a B+ tree where only key values are indicated in the records. Each block can hold upto three records. A record with a key value 34 is ins...
Manu Thakur
896
views
Manu Thakur
asked
Oct 27, 2017
Databases
databases
bplustrees
indexing
+
–
23
votes
1
answer
1656
B+tree with sparse/Dense indexing
Database file consists of $10,000$ records with record size of $100$ bytes, block size $512$ bytes. If sparse B+ tree index is built over given database file with search key size $22$ bytes and both block pointer and record pointer of size $12$ bytes each.Find out a)minimum index block required b)maximum index block required my answers a)$143$ b)$325$.
Database file consists of $10,000$ records with record size of $100$ bytes, block size $512$ bytes. If sparse B+ tree index is built over given database file with search ...
reena_kandari
5.7k
views
reena_kandari
asked
Oct 26, 2017
Databases
databases
indexing
bplustrees
+
–
2
votes
2
answers
1657
Dbms #self doubt
1. How many super key is possible if (a,bc,cd) is candidate key and R(ABCDEF) #DOUBT When we use veen digram why we are taking only intersections part only ??? Need help please explain ..
1. How many super key is possible if (a,bc,cd) is candidate key and R(ABCDEF)#DOUBTWhen we use veen digram why we are taking only intersections part only ??? Need help pl...
air1ankit
534
views
air1ankit
asked
Oct 26, 2017
Databases
databases
relational-algebra
database-normalization
transaction-and-concurrency
+
–
2
votes
0
answers
1658
Database: Multilevel Indexing
In the following question, How to know that at first level (base level) index entries will be recorded for a block or for each record?https://gateoverflow.in/2311/gate1993_14 See the highlighted part below, what if we have multilevel secondary inedxing?
In the following question, How to know that at first level (base level) index entries will be recorded for a block or for each record?https://gateoverflow.in/2311/gate199...
Manu Thakur
1.9k
views
Manu Thakur
asked
Oct 26, 2017
Databases
databases
indexing
multilevel
+
–
1
votes
1
answer
1659
no of superkeys
Arnabi
852
views
Arnabi
asked
Oct 26, 2017
Databases
databases
+
–
2
votes
2
answers
1660
indexing doubt
Arnabi
639
views
Arnabi
asked
Oct 25, 2017
Databases
indexing
databases
bplustrees
+
–
4
votes
1
answer
1661
Database: Does each multivalued attribute requires a separate table in 1NF?
Following question and answer from GateForum test series: Now see the following text i coped from Korth, we will create an new for each value of multivalued attribute: Hence answer should be 1 for this question.
Following question and answer from GateForum test series:Now see the following text i coped from Korth, we will create an new for each value of multivalued attribute:Henc...
Manu Thakur
3.9k
views
Manu Thakur
asked
Oct 24, 2017
Databases
databases
er-to-relational
+
–
3
votes
1
answer
1662
Database: equijoin v/s natural join
Which one is the more suitable answer for the following question, equijoin or natural join?
Which one is the more suitable answer for the following question, equijoin or natural join?
Manu Thakur
1.1k
views
Manu Thakur
asked
Oct 24, 2017
Databases
databases
natural-join
+
–
1
votes
2
answers
1663
B+ tree
Database file consists 1250 records.Block can hold either 3 record or (10 key,11 pointer ) The max number of level of index required for dense B+ tree index for daatabase file are _____________________
Database file consists 1250 records.Block can hold either 3 record or (10 key,11 pointer ) The max number of level of index required for dense B+ tree index for daatabase...
set2018
2.9k
views
set2018
asked
Oct 24, 2017
Databases
databases
+
–
0
votes
1
answer
1664
database
What is the correct interpretion of this query
What is the correct interpretion of this query
set2018
407
views
set2018
asked
Oct 24, 2017
Databases
databases
+
–
2
votes
1
answer
1665
transaction control
In basic time stamp ordering W-time stamp (Q) denotes the largest time stamp of any transaction that has executed write-(Q) successfully.Suppose that we define W-time stamp(Q) as the most recent transaction to execute Write(Q) successfully.Which is ... give same result in few cases 3)both with give different result in all cases 4)both with give different result insome cases
In basic time stamp ordering W-time stamp (Q) denotes the largest time stamp of any transaction that has executed write-(Q) successfully.Suppose that we define W-time sta...
set2018
2.7k
views
set2018
asked
Oct 24, 2017
Databases
transaction-and-concurrency
databases
+
–
0
votes
2
answers
1666
relational table
Assume COFFEE is the relation,find number of tuple 1) 6 2) 4 3) 5 4) 3
Assume COFFEE is the relation,find number of tuple1) 62) 43) 54) 3
set2018
505
views
set2018
asked
Oct 24, 2017
Databases
databases
+
–
4
votes
1
answer
1667
Doubt Database
What is difference between attributes set of cross product and attributes set of joine ???
What is difference between attributes set of cross product and attributes set of joine ???
air1ankit
566
views
air1ankit
asked
Oct 22, 2017
Databases
databases
database-normalization
rdbms
relational-algebra
+
–
1
votes
1
answer
1668
Transactions Serializable schedule and Unserializable Schedule
Some where I have read, that WR, RW, WW problem occurs only in un-serializable schedule, and Irrecoverable problem, cascade less rollback problem and lost update problems occur in serializable schedule. Is the above statement true or false?
Some where I have read, that WR, RW, WW problem occurs only in un-serializable schedule, and Irrecoverable problem, cascade less rollback problem and lost update problems...
Shubhanshu
400
views
Shubhanshu
asked
Oct 22, 2017
Databases
databases
transaction-and-concurrency
concurrency
+
–
2
votes
0
answers
1669
indexing-testbook
set2018
315
views
set2018
asked
Oct 21, 2017
Databases
databases
testbook-test-series
indexing
+
–
2
votes
0
answers
1670
indexing-Testbook
set2018
186
views
set2018
asked
Oct 21, 2017
Databases
databases
testbook-test-series
bplustrees
+
–
0
votes
0
answers
1671
Timestamp ordering
Q.1 https://gateoverflow.in/60008/ugcnet-dec2014-iii-08 Q. 2 https://gateoverflow.in/66815/ugcnet-dec2010-ii-18 According to question no. 1 Time stamping is an optimistic protocol. But according to question no. 2 Time stamp ordering is pessimistic Which one is correct...plzz clarify it...
Q.1 https://gateoverflow.in/60008/ugcnet-dec2014-iii-08Q. 2 https://gateoverflow.in/66815/ugcnet-dec2010-ii-18According to question no. 1 Time stamping is an optimistic p...
rishu_darkshadow
445
views
rishu_darkshadow
asked
Oct 20, 2017
Databases
databases
concurrency
+
–
1
votes
1
answer
1672
Doubt database
What is basic difference between mandatory attributes and multivalued attributes???
What is basic difference between mandatory attributes and multivalued attributes???
air1ankit
294
views
air1ankit
asked
Oct 19, 2017
Databases
databases
database-normalization
rdbms
+
–
1
votes
2
answers
1673
Database
1- R(ABCD) FD'S ARE {AB->C ,C->D,D->EA ,DE->F,EF->B} 2-R(ABCD) FDS ARE { A->BC, CD->E, B->D,E-A} 3- R(ABCD) {AB-> CD,C->B,D->C} Find the candidate key ??? For above questions and please explain too.
1- R(ABCD) FD'S ARE {AB->C ,C->D,D->EA ,DE->F,EF->B}2-R(ABCD) FDS ARE { A->BC, CD->E, B->D,E-A}3- R(ABCD) {AB- CD,C->B,D->C} Find the candidate key ??? For above questi...
air1ankit
452
views
air1ankit
asked
Oct 17, 2017
Databases
databases
database-normalization
data-dependency
+
–
2
votes
1
answer
1674
Database management
Que- R(ABCD) and fds are { A->B ,B->C,C->A} then number of candidate key is........? Explain please
Que- R(ABCD) and fds are { A->B ,B->C,C->A} then number of candidate key is........?Explain please
air1ankit
482
views
air1ankit
asked
Oct 17, 2017
Databases
databases
database-normalization
+
–
1
votes
1
answer
1675
DBMS #DOUBT ...
correct???
correct???
air1ankit
285
views
air1ankit
asked
Oct 17, 2017
Databases
databases
database-normalization
+
–
1
votes
2
answers
1676
OUTPUT OF THE SQL QUERY
Arnabi
830
views
Arnabi
asked
Oct 17, 2017
Databases
sql
databases
+
–
2
votes
1
answer
1677
B+ tree
Upasana singh
551
views
Upasana singh
asked
Oct 17, 2017
Databases
databases
bplustrees
+
–
0
votes
0
answers
1678
View Serializable schedules
Consider the following schedule: S: r1(A), r3(D), w1(B), r2(B), r4(B), w2(C), r5(C), w4(E), r5(E), w5(B) The number of serial schedules which are view equal to schedule S ?
Consider the following schedule:S: r1(A), r3(D), w1(B), r2(B), r4(B), w2(C), r5(C), w4(E), r5(E), w5(B)The number of serial schedules which are view equal to schedule S ?...
Upasana singh
565
views
Upasana singh
asked
Oct 17, 2017
Databases
view-serializable
databases
+
–
2
votes
0
answers
1679
Transactions
shivangi5
393
views
shivangi5
asked
Oct 16, 2017
Databases
databases
transaction-and-concurrency
conflict-serializable
+
–
1
votes
2
answers
1680
Indexing
shivangi5
950
views
shivangi5
asked
Oct 16, 2017
Databases
indexing
databases
bplustrees
+
–
Page:
« prev
1
...
51
52
53
54
55
56
57
58
59
60
61
...
97
next »
Email or Username
Show
Hide
Password
I forgot my password
Remember
Log in
Register