Register
Webpage for Databases:

Recent questions tagged databases

1 votes
0 answers
1712
NPTEL
Which of the following can be described as a programming model used to develop applications processing massive amounts of data in a distributed and/or parallel manner? 1. Map Reduce 2 .OLAP 3. Mahout 4. Cloud Computing
Which of the following can be described as a programming model used to develop applications processing massive amounts of data in a distributed and/or parallel manner?1. ...
User Avatar
1 votes
0 answers
1713
nptel
Consider the following database Col 1 Col 2 Col 3 1 2 3 4 5 6 7 8 9 If Col1 and Col2 form a column family and Col3 is another column family, how is the data stored? A. 1 2 3 4 5 6 7 8 9 B. 1 4 7 2 5 8 3 6 9 C. 1 2 4 5 7 8 3 6 9 D. 1 4 7 3 6 9 2 5 8
Consider the following databaseCol 1Col 2Col 3123456789If Col1 and Col2 form a column family and Col3 is another column family, how is the data stored?A. 1 2 3 4 5 6 7 8 ...
User Avatar
1 votes
0 answers
1715
nptel
Consider the following schedule $S$. S: l1(A),l3(D),l1(B),u1(A),l2(C),l2(B),l1(D),l2(B),l3(C),l4(A),l4(C),l5(A); Which of the following is a valid set of transactions that are potential victims? 1. {T1,T2,T3,T5} 2. {T1,T2} 3. {T1,T2,T3,T4} 4. {T1,T2,T3}
Consider the following schedule $S$. S: l1(A),l3(D),l1(B),u1(A),l2(C),l2(B),l1(D),l2(B),l3(C),l4(A),l4(C),l5(A); Which of the following is a valid set of transactions tha...
User Avatar
3 votes
1 answer
1720
aggregation:minimum number of tables
User Avatar
0 votes
0 answers
1721
Weak entity set
If the identifying relationship set has a descriptive attribute, then the movement of an attribute will be on weak entity side? pls explain with proper reference
If the identifying relationship set has a descriptive attribute, then the movement of an attribute will be on weak entity side?pls explain with proper reference
User Avatar
1 votes
1 answer
1722
serial schedules
If total n! serial schedules are possible , will all of them give the same result?
If total n! serial schedules are possible , will all of them give the same result?
User Avatar
0 votes
2 answers
1723
DBMS-Decomposition
Which of the following statement is true while decomposition ? 3NF guaranteed dependency preserving 3NF guaranteed lossless property Both of the above None of the above
Which of the following statement is true while decomposition ? 3NF guaranteed dependency preserving3NF guaranteed lossless propertyBoth of the aboveNone of the above
User Avatar
1 votes
1 answer
1724
Minimum tables required
1.Minimum number of tables required which satisfies 1NF ? 2.Minimum number of tables required which satisfies 3NF ?
1.Minimum number of tables required which satisfies 1NF ?2.Minimum number of tables required which satisfies 3NF ?
User Avatar
3 votes
0 answers
1726
Concurrent transactions
Number of concurrent transactions that can be formed with 3 transactions having 3,2 and 1 operations respectively. Here should the answer be 60 or 54 ? Should we include serial transactions also in the answer or should we subtract it?
Number of concurrent transactions that can be formed with 3 transactions having 3,2 and 1 operations respectively.Here should the answer be 60 or 54 ? Should we include s...
User Avatar
1 votes
1 answer
1727
Number of relations in ER diagram
Minimum number of relations or tables required ?
Minimum number of relations or tables required ?
User Avatar
4 votes
4 answers
1728
Random Doubt, Candidate Key, DBMS
If A Relation R(A,B,C,D) and CK given is (AB,C) and FD is given as A->C Then the relation is in which highest normal form?
If A Relation R(A,B,C,D) and CK given is (AB,C)and FD is given as A->C Then the relation is in which highest normal form?
User Avatar
0 votes
2 answers
1729
SQL query
Answer given on virtual gate is a1,a3,a2 I'm getting a1,a3,a2,a1 as duplicate values are allowed in SQL. What is my mistake here ?
Answer given on virtual gate is a1,a3,a2I'm getting a1,a3,a2,a1 as duplicate values are allowed in SQL. What is my mistake here ?
User Avatar
2 votes
2 answers
1730
CANDIDATE KEY
User Avatar
0 votes
1 answer
1731
B+ Tree: Insert operation
answer on virtual gate ia given 2, while my answer is 1.
answer on virtual gate ia given 2, while my answer is 1.
User Avatar
3 votes
1 answer
1732
ER Diagram: Minimum number of tables needed
this question is from virtual gate test series. what is the minimum number of RDBMS tables needed for the following er diagram:
this question is from virtual gate test series. what is the minimum number of RDBMS tables needed for the following er diagram:
User Avatar
1 votes
1 answer
1733
UGC NET CSE | December 2009 | Part 2 | Question: 47
Analysis of large database to retrieve information is called (A) OLTP (B) OLAP (C) OLDP (D) OLPP
Analysis of large database to retrieve information is called(A) OLTP(B) OLAP(C) OLDP(D) OLPP
User Avatar
1 votes
0 answers
1734
UGC NET CSE | December 2009 | Part 2 | Question: 45
The name of the transaction file shall be provided by the operator and the file that contains the edited transactions ready for execution shall be called (A) Batch. Exe (B) Trans. Exe (C) Opt. Exe (D) Edit.Exe
The name of the transaction file shall be provided by the operator and the file that contains the edited transactions ready for execution shall be called(A) Batch. Exe(B)...
User Avatar
3 votes
2 answers
1735
UGC NET CSE | December 2009 | Part 2 | Question: 19
A function that has no partial functional dependencies is in __________ form. (A) 3 NF (B) 2 NF (C) 4 NF (D) BCNF
A function that has no partial functional dependencies is in __________ form.(A) 3 NF(B) 2 NF(C) 4 NF(D) BCNF
User Avatar
1 votes
1 answer
1736
UGC NET CSE | December 2009 | Part 2 | Question: 18
Match the following : ... $\text{4-a, 3-b, 2-c, 1-d}$ $\text{3-a, 4-b, 1-c, 2-d}$
Match the following :$\begin{array}{clcl} \text{(1)} & \text{Determinants} & \text{(a)}\ & \text{No attribute can be added} \\ \text{(2)} & \text{Candidate key} & \t...
User Avatar
5 votes
4 answers
1737
UGC NET CSE | December 2009 | Part 2 | Question: 17
Specialization is __________ process. (A) top-down (B) bottom up (C) both (A) and (B) (D) none of these
Specialization is __________ process.(A) top-down(B) bottom up(C) both (A) and (B)(D) none of these
User Avatar
2 votes
4 answers
1738
UGC NET CSE | December 2009 | Part 2 | Question: 16
The E-R model is expressed in term of I. Entities II. The relationship among entities. III. The attributes of the entities. IV. Functional relationship. (A) I, II (B) I, II, IV (C) II, II, IV (D) I, II, III
The E-R model is expressed in term ofI. EntitiesII. The relationship among entities.III. The attributes of the entities.IV. Functional relationship.(A) I, II(B) I, II, IV...
User Avatar
0 votes
1 answer
1739
maximum size of join
User Avatar
0 votes
1 answer
1740
Sparse and Dense index doubt
Block size 1000 B Search key 12 B Pointer size 8B What is max records of DB 1) For Dense index B+ tree of 2 level 2) For Sparse index B+ tree of 2 level How ans will differ , Plz show
Block size 1000 BSearch key 12 BPointer size 8BWhat is max records of DB1) For Dense index B+ tree of 2 level2) For Sparse index B+ tree of 2 levelHow ans will differ , P...
User Avatar
Page: