Register
Webpage for Databases:

Recent questions tagged databases

1 votes
0 answers
1441
Test seriesDatabases
User Avatar
0 votes
2 answers
1442
Test question
Consider the join of a relation R with a relation S. If R has 100 tuples and S has 9 tuples then the maximum and minimum sizes of the join respectively under referential integrity constraint: 9 and 0 9 and 9 9+100 and 0 9*100 and 9
Consider the join of a relation R with a relation S. If R has 100 tuples and S has 9 tuples then the maximum and minimum sizes of the join respectively under referential ...
User Avatar
2 votes
1 answer
1443
index
Every ________ index is Clustered a)primary b)secondary
Every ________ index is Clustereda)primaryb)secondary
User Avatar
2 votes
0 answers
1444
Tuples
Consider a relation R(A,B,C) with the following functional dependency AC→B .A can take 200 distinct values, B can take 100 distinct values and C can take 1000 distinct values. What is the maximum and minimum possible tuples of the self join of R on C?
Consider a relation R(A,B,C) with the following functional dependency AC→B .A can take 200 distinct values, B can take 100 distinct values and C can take 1000 distinct ...
User Avatar
2 votes
1 answer
1446
ER tables
Number of tables in case of 1)1:N + total participation (on n side) 2) 1:N + partial participation
Number of tables in case of 1)1:N + total participation (on n side)2) 1:N + partial participation
User Avatar
1 votes
1 answer
1450
MadeEasy Test Series: Databases - Joins
Can someone explain this question?
Can someone explain this question?
User Avatar
0 votes
1 answer
1451
We have 2 Schedule S1 and S2 ... There are no Conflict Operation in S1 and S2.
We have 2 Schedule S1 and S2 ... There are no Conflict Operation in S1 and S2. So can we say they are conflict equivalent ?
We have 2 Schedule S1 and S2 ... There are no Conflict Operation in S1 and S2. So can we say they are conflict equivalent ?
User Avatar
1 votes
0 answers
1452
Conflict equivalent
User Avatar
3 votes
1 answer
1453
MadeEasy Test Series: Databases - Indexing
" For any data file, it is possible to construct two separate dense first level indexes on different keys. " How the above statement is true ??
" For any data file, it is possible to construct two separate dense first level indexes on different keys. "How the above statement is true ??
User Avatar
0 votes
1 answer
1454
MadeEasy Test Series: Databases - B Tree
" B+ tree index has more levels than B tree index for large number of keys. " How the above statement is true ??
" B+ tree index has more levels than B tree index for large number of keys. "How the above statement is true ??
User Avatar
0 votes
0 answers
1455
Database transaction single user environment
Indicate how the recovery schema works on single user environment if system fails i) After the transaction starts and before read. ii) After the read and before write. iii) After the write and before commit. Answer Request▾
Indicate how the recovery schema works on single user environment if system failsi) After the transaction starts and before read.ii) After the read and before write.iii) ...
User Avatar
0 votes
0 answers
1459
What should be in Superclass and subclass ,,,
Regarding below question https://gateoverflow.in/1031/gate2004-34
Regarding below questionhttps://gateoverflow.in/1031/gate2004-34
User Avatar
0 votes
0 answers
1461
Database indexing
User Avatar
0 votes
0 answers
1462
Transaction
User Avatar
0 votes
0 answers
1463
SQL and trc
How to solve SQL problems related to subqueries quickly? Though I have concepts still I face some difficulties in solving this problems
How to solve SQL problems related to subqueries quickly?Though I have concepts still I face some difficulties in solving this problems
User Avatar
0 votes
0 answers
1464
Database index.
A file can have either one primary index or one clustered index but not both. True or false ? Give an answer with explanation.
A file can have either one primary index or one clustered index but not both. True or false ? Give an answer with explanation.
User Avatar
1 votes
0 answers
1465
View Seializability
Can anyone explain or give any link to study View Serializability ... Will be really thankful..
Can anyone explain or give any link to study View Serializability ... Will be really thankful..
User Avatar
0 votes
0 answers
1469
NUMBER OF FK
Asked to find minimum number of F.K's Here basically i want to know that when we made a table for many to many relation i.e R1,we add the P.k of both the entity (E1 AND E2) as F.K in new relation, Does AD collectively referred as FK or A and D as two different F.K in a new relation
Asked to find minimum number of F.K'sHere basically i want to know that when we made a table for many to many relation i.e R1,we add the P.k of both the entity (E1 AND E2...
User Avatar
Page: