Dark Mode

Recent questions tagged rdbms

0 votes

0 answers

1

testbook
Can you help me understand the last 2 options

Rohit Chakraborty asked in Databases Jan 3

by Rohit Chakraborty

123 views

1 vote

0 answers

2

#self doubt
The following key values are inserted into a B+ tree, where order of the internal node is 5 and order of leaf node is 4. The order of the internal node is the maximum number of tree pointers in each node. The maximum number of times leaf nodes would get split up as a result if the insertion sequence is: 3, 10, 12, 14, 29, 38, 45, 55, 60

Dknights asked in Databases Dec 24, 2023

104 views

1 vote

1 answer

3

#Applied Course
Consider the below-given statements about the transactions where L-Si(X) indicates that transaction Ti acquires a shared lock on X. L-Xi(X) indicates that transaction Ti acquires an exclusive lock on X. Ui indicates that transaction Ti releases its lock on X. I. The schedule S: L-S1(X); R1( ... ;U1(Y); L-X2(Y); W2(Y); R2(X); U2(X); C2; U2(Y); Is generated by both 2PL and strict-2PL.

Dknights asked in Databases Dec 19, 2023

144 views

0 votes

1 answer

4

MadeEasy Test Series: How many tuples will be present in the output of the following SQL query.
My doubt here is, if NOT EXISTS gets an empty set as the input then every tuple of the table in the outer query must satisfy the condition. Am I right? For example, in the above question - The ... the same below) Can anyone please explain whether I am approaching this right, or if I am missing something?

tishhaagrawal asked in Databases Dec 16, 2023

by tishhaagrawal

357 views

0 votes

1 answer

5

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”.

Dknights asked in Databases Dec 13, 2023

142 views

0 votes

2 answers

6

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!!!

gateexplore asked in Databases Sep 22, 2023

459 views

0 votes

1 answer

7

Dbms practice - Self doubt
Consider the below instance of relation : Employee: Emp_rating Emp_name Emp_mail Emp_sal 1. Surabhi sm301@gj 40000 2. Vishu sp11@ap 60000 1. Surabhi Null 50000 3. Yashy ar@dy 60000 The maximum possible number of alternate keys for the above relational instance is/are _____

Rahhul A asked in Databases Aug 3, 2023

420 views

0 votes

0 answers

8

Question 12 please anyone describe whole solution

kishan kushavaha asked in Databases May 1, 2023

by kishan kushavaha

37 views

0 votes

0 answers

9

Ace workbook dbms

gaddalakonda_ganesh asked in Databases Feb 28, 2023

by gaddalakonda_ganesh

304 views

2 votes

1 answer

10

Who manages what? (ACID peoperties)
Which manager manages each of the ACID properties? I found that transaction processing (TP) manager manages Isolation from wikipedia, meanwhile I read from another source that it is managed by concurrency control manager. Also what about the other ... which managers control them? Can you please list down the managers of the properties or any sources know to you?

h4kr asked in Databases Dec 19, 2022

by h4kr

539 views

0 votes

0 answers

11

selfdoubt
can a relationship have a degree of one if both the entities are same and participating in one form? ex: employee helps employee

Khushi vishwakarma asked in Databases Nov 16, 2022

by Khushi vishwakarma

222 views

0 votes

0 answers

12

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 .

ykrishnay asked in Databases Sep 6, 2022

543 views

0 votes

1 answer

13

DBMS Join | Test Series | MadeEasy
In relational databases, the natural join of two tables: Can be equivalent to cartesian product of these two tables Is combination of union and filtered cartesian product Is combination of selection and filtered cartesian product Is combination of projection and filtered cartesian product MSQ Please describe your choice(s).

anupamsworld asked in Databases Aug 7, 2022

by anupamsworld

385 views

1 vote

0 answers

14

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

anupamsworld asked in Databases Jul 29, 2022

by anupamsworld

533 views

1 vote

2 answers

15

Minimum number of tables needed to construct a self referential relation with many to many relationship?

Srken asked in Databases Nov 12, 2021

by Srken

1.6k views

1 vote

2 answers

16

gradeup quiz question
please explain the question

ajay_rajpurohit asked in Databases Oct 4, 2021

by ajay_rajpurohit

376 views

0 votes

1 answer

17

#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.

Abhishek tarpara asked in Databases Sep 17, 2021

by Abhishek tarpara

892 views

4 votes

4 answers

18

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

Tuhin Dutta asked in Databases May 27, 2019

2.4k views

0 votes

1 answer

19

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 ___________

Hirak asked in Databases May 25, 2019

by Hirak

685 views

0 votes

2 answers

20

MADE EASY FREE TEST Q47
Find the total number of tables required. Ans given was 4, bit how can it be 4? According to me, E1 and E2 will require 2 tables at begining, then for E3 and E1 we need another table, then for E2 and E3 we need another and for E3 and E2’s many to many relation i need another one. So total =5. But ans given was 4.. explain pls.

Hirak asked in Databases May 4, 2019

by Hirak

353 views

1 vote

0 answers

21

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?

ajaysoni1924 asked in Databases Mar 23, 2019

by ajaysoni1924

489 views

0 votes

0 answers

22

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?

Shamim Ahmed asked in Databases Dec 18, 2018

by Shamim Ahmed

308 views

0 votes

0 answers

23

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.

cidacoder asked in Databases Dec 8, 2018

282 views

0 votes

5 answers

24

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

Pooja Khatri asked in Databases Jul 13, 2018

by Pooja Khatri

2.4k views

0 votes

2 answers

25

UGC NET CSE | July 2018 | Part 2 | Question: 62
Consider a relation book (title, price) which contains the titles and prices of different books. Assuming that no two books have the same price, what does the following SQL query? Select title from book as B where (select ... Title of the sixth most expensive books Titles of the seven most expensive books Title of the seventh most expensive books

Pooja Khatri asked in Databases Jul 13, 2018

by Pooja Khatri

1.9k views

0 votes

1 answer

26

UGC NET CSE | July 2018 | Part 2 | Question: 66
For a database relation $R(a, b, c, d)$ where the domains of a, b, c and d include only atomic values and only the following functional dependencies and those that can be inferred from them hold: $a \rightarrow c$ ... in ____ First normal form but not in second normal form Second normal form but not in third normal form Third normal form BCNF

Pooja Khatri asked in Databases Jul 13, 2018

by Pooja Khatri

708 views

2 votes

4 answers

27

UGC NET CSE | July 2018 | Part 2 | Question: 67
A many-to-one relationship exists between entity sets $r_1$ and $r_2$. How will it be represented using functional dependencies if $Pk(r)$ denotes the primary key attribute of relation $r$? $Pk(r_1) \rightarrow Pk(r_2)$ ... $Pk(r_2) \rightarrow Pk(r_1) \text{ or } Pk(r_1) \rightarrow Pk(r_2)$

Pooja Khatri asked in Databases Jul 13, 2018

by Pooja Khatri

1.2k views

1 vote

1 answer

28

2NF Question.
Given a table $R(ABCDEF)$ $ABC -> D$ $ABD -> E$ $CD -> F$ $CDF -> B$ $BF -> D$ It's candidate keys are $ABC, ACD.$ So while checking for $2NF$, Can I say that $ABD -> E$ is not partially dependent because $ABD$ as a whole is not a part of candidate key even though $AB$ is a part of candidate key.

Rahul Ranjan 1 asked in Databases May 27, 2018

by Rahul Ranjan 1

1.8k views

3 votes

2 answers

29

ER Diagram- min no of relations
How the correct answer is 2?

Shubham Kumar Gupta asked in Databases Jan 19, 2018

by Shubham Kumar Gupta

857 views

1 vote

0 answers

30

Can foreign key be renamed...if yes then what is the effect on relation?

Kamal Raj Praveen asked in Databases Jan 14, 2018

by Kamal Raj Praveen

241 views

Page:

Recent questions tagged rdbms