Register
Webpage for Databases:

Recent questions tagged databases

4 votes
2 answers
2401
ISRO2016-56
Goals for the design of the logical scheme include avoiding data inconsistency being able to construct query easily being able to access data efficiently All of the above
Goals for the design of the logical scheme includeavoiding data inconsistencybeing able to construct query easilybeing able to access data efficientlyAll of the above
User Avatar
0 votes
1 answer
2402
UGC NET CSE | June 2012 | Part 2 | Question: 12
A Transaction Manager is which of the following? Maintains a log of transactions Maintains before and after database images Maintains appropriate concurrent control All of the above
A Transaction Manager is which of the following?Maintains a log of transactionsMaintains before and after database imagesMaintains appropriate concurrent controlAll of th...
User Avatar
1 votes
1 answer
2403
UGC NET CSE | June 2012 | Part 2 | Question: 9
What deletes the entire file except the file structure? ERASE DELETE ZAP PACK
What deletes the entire file except the file structure?ERASEDELETEZAPPACK
User Avatar
1 votes
1 answer
2404
UGC NET CSE | June 2012 | Part 2 | Question: 7
In multiuser database if two users wish to update the same record at the same time, they are prevented from doing so by Jamming Password Documentation Record lock
In multiuser database if two users wish to update the same record at the same time, they are prevented from doing so byJammingPasswordDocumentationRecord lock
User Avatar
0 votes
2 answers
2405
UGC NET CSE | June 2014 | Part 2 | Question: 50
Match the following $:$ ... $\text{a-ii; b-iii; c-i; d-iv}$ $\text{a-iv; b-i; c-ii; d-iii}$
Match the following $:$$\begin{array} {cIcI} & \textbf{List – I} && \textbf{List – II} \\ \text{a.} & \text{DDL} & \text{i.} & \text{LOCK TABLE} \\ \text{b.} & \tex...
User Avatar
2 votes
3 answers
2406
UGC NET CSE | June 2014 | Part 2 | Question: 49
Let $R =\{A, B, C, D, E, F\}$ be a relation schema with the following dependencies $C \rightarrow F$, $E \rightarrow A$, $EC \rightarrow D$, $A \rightarrow B$. Which of the following is a key for $R$ ? CD EC AE AC
Let $R =\{A, B, C, D, E, F\}$ be a relation schema with the following dependencies $C \rightarrow F$, $E \rightarrow A$, $EC \rightarrow D$, $A \rightarrow B$. Which of t...
User Avatar
3 votes
3 answers
2407
UGC NET CSE | June 2014 | Part 2 | Question: 48
A clustering index is created when _______. Primary key is declared and ordered No key ordered Foreign key ordered There is no key and no order
A clustering index is created when _______. Primary key is declared and ordered No key orderedForeign key orderedThere is no key and no order
User Avatar
0 votes
2 answers
2408
UGC NET CSE | June 2014 | Part 2 | Question: 46
Manager’s salary details are hidden from the employee. This is called as Conceptual level data hiding Physical level data hiding External level data hiding Local level data hiding
Manager’s salary details are hidden from the employee. This is called asConceptual level data hidingPhysical level data hidingExternal level data hiding Local level...
User Avatar
10 votes
4 answers
2409
ISRO2014-63
Consider the following table The table is in which normal form? First Normal Form Second Normal Form Third Normal Form but not BCNF Third Normal Form and BCNF
Consider the following tableThe table is in which normal form?First Normal FormSecond Normal FormThird Normal Form but not BCNFThird Normal Form and BCNF
User Avatar
1 votes
1 answer
2410
Sql DBMS
User Avatar
6 votes
2 answers
2411
ISRO2014-11
An aggregation association is drawn using which symbol? A line which loops back on to the same table A small open diamond at the end of a line connecting two tables A small closed diamond at the end of a line connecting two tables A small closed triangle at the end of a line connecting two tables
An aggregation association is drawn using which symbol?A line which loops back on to the same tableA small open diamond at the end of a line connecting two tablesA small ...
User Avatar
0 votes
1 answer
2413
What element will be in root of B+ Tree after inserting (1,4,7,10,17,21,31,25,19,20)? Assume branching factor is 4
What element will be in root of B+ Tree after inserting (1,4,7,10,17,21,31,25,19,20). Assume branching factor is 4
User Avatar
2 votes
2 answers
2416
Dbms Normalization
User Avatar
8 votes
1 answer
2417
Question on Join
Let us consider 3 relations R1(ABD), R2(BCE) and R3(CF). The primary keys of R1 , R2 and R3 are A, B and C respectively. The number of tuples in R1, R2 and R3 are 50,40,80 respectively. Maximum size of R1*R2*R3 where * denotes natural join.
Let us consider 3 relations R1(ABD), R2(BCE) and R3(CF). The primary keys of R1 , R2 and R3 are A, B and C respectively. The number of tuples in R1, R2 and R3 are 50,4...
User Avatar
1 votes
2 answers
2418
E-R and Relational Model
Which of the following are true for relational database? Number of rows is cardinality, number of columns is degree Tuple is an entity, column is a relation Relation is an entity, tuple is a relationship Row is a tuple, column is an attribute b & d a & d b & c c & d
Which of the following are true for relational database?Number of rows is cardinality, number of columns is degreeTuple is an entity, column is a relationRelation is an e...
User Avatar
0 votes
1 answer
2420
Sql DBMS
User Avatar
12 votes
4 answers
2422
ISRO2011-15
What is the equivalent serial schedule for the following transactions? $\text{T}_1 - \text{T}_2 - \text{T}_3$ $\text{T}_3 - \text{T}_1 - \text{T}_2$ $\text{T}_2 - \text{T}_1 - \text{T}_3$ $\text{T}_1 - \text{T}_3 - \text{T}_2$
What is the equivalent serial schedule for the following transactions? $\text{T}_1 - \text{T}_2 - \text{T}_3$$\text{T}_3 - \text{T}_1 - \text{T}_2$$\text{T}_2 - \text{T}_...
User Avatar
2 votes
1 answer
2423
B+ tree
Consider a B+ tree with order 15, what is the max no of records that can be indexed with 3 levels ?
Consider a B+ tree with order 15, what is the max no of records that can be indexed with 3 levels ?
User Avatar
7 votes
3 answers
2425
ISRO2015-39
If a node has $K$ children in $B$ tree, then the node contains exactly _____ keys. $K^2$ $K-1$ $K+1$ $\sqrt{K}$
If a node has $K$ children in $B$ tree, then the node contains exactly _____ keys.$K^2$$K-1$$K+1$$\sqrt{K}$
User Avatar
5 votes
3 answers
2429
ISRO2015-19
The maximum length of an attribute of type text is $127$ $255$ $256$ It is variable
The maximum length of an attribute of type text is$127$$255$$256$It is variable
User Avatar
8 votes
3 answers
2430
ISRO2015-16
Consider the following Relationship Entity Diagram(ERP) Which of the following possible relations will not hold if the above ERD is mapped into a relation model? Person (NID, Name) Qualification (NID, ExamID, QualifiedDate) Exam (ExamID, NID, ExamName) Exam (ExamID, ExamName)
Consider the following Relationship Entity Diagram(ERP)Which of the following possible relations will not hold if the above ERD is mapped into a relation model?Person (NI...
User Avatar
Page: