Register

Recent questions tagged rdbms

0 votes
0 answers
2
testbook
Can you help me understand the last 2 options
Can you help me understand the last 2 options
User Avatar
0 votes
1 answer
6
self doubt
how many of the following points are correct? The schedule has (RW, WW (lost update), WR, and uncommitted read problems) and schedule is not recoverable if “T1 commits before T2”.
how many of the following points are correct?The schedule has (RW, WW (lost update), WR, and uncommitted read problems)and schedule is not recoverable if “T1 commits be...
User Avatar
0 votes
2 answers
7
DBMS
The correct answer is a and d. I just wanted to know that why not b and c. It is possible that it may be speed and color is also a candidate key. If you have any clarification on this let me know!!!
The correct answer is a and d. I just wanted to know that why not b and c. It is possible that it may be speed and color is also a candidate key. If you have any clarific...
User Avatar
0 votes
0 answers
10
Ace workbook dbms
User Avatar
0 votes
0 answers
12
selfdoubt
can a relationship have a degree of one if both the entities are same and participating in one form? ex: employee helps employee
can a relationship have a degree of one if both the entities are same and participating in one form?ex: employee helps employee
User Avatar
0 votes
0 answers
13
DBMS -- Book Confusion
which is best book for DBMS korth or navathe ? since i know that both book is great but i wanted to follow 1 particular book that is easy to understand and simple language for all topics. please suggest .
which is best book for DBMS korth or navathe ?since i know that both book is great but i wanted to follow 1 particular book that is easy to understand and simple language...
User Avatar
1 votes
0 answers
15
Finding Candidate Keys | Class Practice | Unacademy
Find the candidate key(s) of the relation R(UVWXYZ) with FD set F={UV-->W, XW-->Y, U-->XZ, Y-->U} XW UV, YV, WXV YUV, XV, WV None of these
Find the candidate key(s) of the relation R(UVWXYZ) with FD set F={UV >W, XW >Y, U >XZ, Y >U}XWUV, YV, WXVYUV, XV, WVNone of these
User Avatar
1 votes
2 answers
16
Minimum number of tables needed to construct a self referential relation with many to many relationship?
I think it needs three tables but have lil bit confusion
User Avatar
1 votes
2 answers
17
gradeup quiz question
please explain the question
please explain the question
User Avatar
0 votes
1 answer
18
#DBMS #dependency
What is the number of redundent FD’s possible for given set of FD , A->B, B->C,C->D for relation R(ABCD)?? please explain in detail.
What is the number of redundent FD’s possible for given set of FD , A->B, B->C,C->D for relation R(ABCD)?? please explain in detail.
User Avatar
4 votes
4 answers
19
Doubt on database normalization for relation having all prime attributes
In a relation, if every attribute is prime but key may not be simple then the relation is in ______. A. 1NF B. 2NF C. 3NF D. BCNF
In a relation, if every attribute is prime but key may not be simple then the relation is in ______.A. 1NFB. 2NFC. 3NFD. BCNF
User Avatar
0 votes
1 answer
20
VANI Question Bank :DBMS
Minimum number of tables required to represent the relation R where the $A_n$ stands for the primary key of each entity is ___________
Minimum number of tables required to represent the relation R where the $A_n$ stands for the primary key of each entity is ___________
User Avatar
1 votes
0 answers
22
DBMS Korth Edition 6 Exercise 2 Question 4 (Page No. 53)
In the instance of instructor shown below, no two instructors have the same name. From this, can we conclude that name can be used as a superkey (or primary key) of instructor?
In the instance of instructor shown below, no two instructors havethe same name. From this, can we conclude that name can be used as asuperkey (or primary key) of instruc...
User Avatar
0 votes
0 answers
23
ER Diagram
How 1:1 cardinality with total participation of atleast 1 entity needs min no. of tables = 1 ? 1:1 with partial participation of both entities needs min no of tables = 2?
How 1:1 cardinality with total participation of atleast 1 entity needs min no. of tables = 1 ?1:1 with partial participation of both entities needs min no of tables = 2?
User Avatar
0 votes
0 answers
24
Database Management System
If NO ATTRIBUTES are common in both relations (R and S) then the result of natural join is ?? a. Empty relation. b. Cartesian Product of the relations.
If NO ATTRIBUTES are common in both relations (R and S) then the result of natural join is ??a. Empty relation.b. Cartesian Product of the relations.
User Avatar
0 votes
5 answers
25
UGC NET CSE | July 2018 | Part 2 | Question: 61
In RDBMS, which type of Join returns all rows that satisfy the join condition? Inner Join Outer Join Semi Join Anti Join
In RDBMS, which type of Join returns all rows that satisfy the join condition?Inner JoinOuter JoinSemi JoinAnti Join
User Avatar
Page: