Register
Webpage for Databases:

Recent questions tagged databases

0 votes
0 answers
2431
graph based protocol
In Graph based Protocol :- Why acquireing second lock on a data item needs to lock their parent data in tree . please explain
In Graph based Protocol :-Why acquireing second lock on a data item needs to lock their parent data in tree .please explain
User Avatar
1 votes
1 answer
2432
b+ tree
construct a b+ tree to insert the following numbers (order is 3) 3,2,5,7,6,23,24,35,67,44,43,42,17,18,19 ?
construct a b+ tree to insert the following numbers (order is 3) 3,2,5,7,6,23,24,35,67,44,43,42,17,18,19 ?
User Avatar
1 votes
1 answer
2434
UGC NET CSE | December 2012 | Part 2 | Question: 13
Which of the following is true? A relation in BCNF is always in 3NF A relation in 3NF is always in BCNF BCNF and 3NF are same A relation in BCNF is not in 3NF
Which of the following is true?A relation in BCNF is always in 3NFA relation in 3NF is always in BCNFBCNF and 3NF are sameA relation in BCNF is not in 3NF
User Avatar
0 votes
2 answers
2435
Database Views
Views are useful for _____ unwanted information, and for collecting together information from more than one relation into a single view. A. Hiding B. Deleting C. Highlighting D. All of the above
Views are useful for _____ unwanted information, and for collecting together information from more than one relation into a single view.A. HidingB. DeletingC. Hi...
User Avatar
0 votes
1 answer
2436
recovery from failure
IN DEFFERED DATABASE MODIFICATION ,A TRANSACTION IS PARTIALLY COMMITED AND FAILURE OCCURS BEFORE COMMIT AND A LOG IS CREATED AS FOLLOWS <T,STARTS> <T,A,500> <T,COMMITS> Q-> WILL THE ORIGINAL DATABSE WILL MODIFIED OR NOT?? PLEASE EXPLAIN.
IN DEFFERED DATABASE MODIFICATION ,A TRANSACTION IS PARTIALLY COMMITED AND FAILURE OCCURS BEFORE COMMIT AND A LOG IS CREATED AS FOLLOWS<T,STARTS><T,A,500><T,COMMITS>Q- WI...
User Avatar
6 votes
2 answers
2438
ISRO2011-53
In functional dependency Armstrong inference rules refers to Reflexive, Augmentation and Decomposition Transitive, Augmentation and Reflexive Augmentation, Transitive, Reflexive and Decomposition Reflexive, Transitive and Decomposition
In functional dependency Armstrong inference rules refers toReflexive, Augmentation and DecompositionTransitive, Augmentation and ReflexiveAugmentation, Transitive, Refle...
User Avatar
3 votes
2 answers
2439
ISRO2011-21
Which type of DBMS provides support for maintaining several versions of the same entity? Relational Database Management System Hierarchical Object Oriented Database Management System Network
Which type of DBMS provides support for maintaining several versions of the same entity?Relational Database Management SystemHierarchicalObject Oriented Database Manageme...
User Avatar
5 votes
2 answers
2440
ISRO2009-71
Which of the following contains complete record of all activity that affected the contents of a database during a certain period of time? Transaction log Query language Report writer Data manipulation language
Which of the following contains complete record of all activity that affected the contents of a database during a certain period of time?Transaction logQuery languageRepo...
User Avatar
0 votes
1 answer
2441
which of the following is not a uml diagram a. use cases b. class diagrams c. analysis diagram d. swimlane diagram
which of the following is not a UML diagrama. Use casesb. Class Diagramsc. Analysis Diagramd. Swimlane Diagram
User Avatar
1 votes
1 answer
2442
which operation is used to extract specific columns from a table
which operation is used to extract specific columns from a table?
which operation is used to extract specific columns from a table?
User Avatar
0 votes
1 answer
2443
Armstrong inference rule does not determine
Armstrong inference rule does not determine a. Reflexivity b. Augmentation c. Transitivity d. Mutual Dependency
Armstrong inference rule does not determinea. Reflexivityb. Augmentationc. Transitivityd. Mutual Dependency
User Avatar
0 votes
1 answer
2444
which commands are used to control access over objects in relational database
which commands are used to control access over objects in relational database
which commands are used to control access over objects in relational database
User Avatar
5 votes
3 answers
2445
ISRO2008-33
The join operation can be defined as a cartesian product of two relations followed by a selection a cartesian product of two relations a union of two relations followed by cartesian product of the two relations a union of two relations
The join operation can be defined asa cartesian product of two relations followed by a selectiona cartesian product of two relationsa union of two relations followed by c...
User Avatar
5 votes
3 answers
2447
ISRO2007-60
Which of the following is correct with respect to Two phase commit protocol? Ensures serializability Prevents Deadlock Detects Deadlock Recover from Deadlock
Which of the following is correct with respect to Two phase commit protocol?Ensures serializabilityPrevents DeadlockDetects DeadlockRecover from Deadlock
User Avatar
4 votes
2 answers
2448
ISRO2007-54
BCNF is not used for cases where a relation has Two (or more) candidate keys Two candidate keys and composite The candidate key overlap Two mutually exclusive foreign keys
BCNF is not used for cases where a relation hasTwo (or more) candidate keysTwo candidate keys and compositeThe candidate key overlapTwo mutually exclusive foreign keys
User Avatar
8 votes
5 answers
2449
ISRO2007-52
Which operation is used to extract specified columns from a table? Project Join Extract Substitute
Which operation is used to extract specified columns from a table?ProjectJoinExtractSubstitute
User Avatar
5 votes
2 answers
2450
ISRO2007-51
Armstrong&rsquo;s inference rule doesnot determine Reflexivity Augmentation Transitivity Mutual dependency
Armstrong&rsquo;s inference rule doesnot determineReflexivityAugmentationTransitivityMutual dependency
User Avatar
6 votes
4 answers
2451
ISRO2007-50
A view of database that appears to an application program is known as Schema Subschema Virtual table None of these
A view of database that appears to an application program is known asSchemaSubschemaVirtual tableNone of these
User Avatar
7 votes
3 answers
2452
ISRO2007-48
Which of the following is aggregate function in SQL? Avg Select Ordered by distinct
Which of the following is aggregate function in SQL?AvgSelectOrdered bydistinct
User Avatar
6 votes
2 answers
2453
ISRO2007-47
Which commands are used to control access over objects in relational database? CASCADE & MVD GRANT & REVOKE QUE & QUIST None of these
Which commands are used to control access over objects in relational database?CASCADE & MVDGRANT & REVOKEQUE & QUISTNone of these
User Avatar
2 votes
2 answers
2456
ISI2011-PCB-CS-5a
Consider relations $R(A, B)$ and $S(B, C)$. Find a propositional formula $\phi$ such that the following two relational algebra expressions produce the same answer. $\pi_{A,B}(\sigma_\phi(R \bowtie S))$ $R \cap ({\rho_T(A)}(\pi_C(S)) \times \pi_B(S))$
Consider relations $R(A, B)$ and $S(B, C)$. Find a propositional formula $\phi$ such that the following two relational algebra expressions produce the same answer.$\pi_{A...
User Avatar
0 votes
1 answer
2457
Procedure to Delete Nodes from B+ Tree ?
User Avatar
0 votes
1 answer
2458
.The data dictionary tells the DBMS
A. what files are in the database B. what attribute are possessed by the data C. what these files contain D. All of the above
A. what files are in the databaseB. what attribute are possessed by the dataC. what these files containD. All of the above
User Avatar
6 votes
5 answers
2460
ISRO2009-70
A locked database file can be Accessed by only one user Modified by users with the correct password Used to hide sensitive information Updated by more than one user
A locked database file can beAccessed by only one userModified by users with the correct passwordUsed to hide sensitive informationUpdated by more than one user
User Avatar
Page: