Recent questions in Databases

0 votes

0 answers

1

ACE Test Series

asked 20 minutes ago in Databases by ben10 (389 points) | 8 views

0 votes

0 answers

2

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?

asked 20 minutes ago in Databases by Shamim Ahmed Active (1.1k points) | 5 views

0 votes

0 answers

3

ME[Minimum number of Tables needed]

asked 6 hours ago in Databases by jatin khachane 1 Active (3.5k points) | 33 views

+1 vote

1 answer

4

MOCK1_54_55
Consider a B+ tree for the following set of key values: 2,3,5,7,11,17,19,23,29,31,9,10,8 Assume that the tree is initially empty and values are added in the order mentioned above. The number of pointers that will fit in one node is four. Q54. What will be the root of the ... if 23 and 19 are deleted one after the other then what will be the new root? (A 9 (B) 7,8,11 (C) 7,10 (D 11

asked 11 hours ago in Databases by BOB (259 points) | 44 views

0 votes

0 answers

5

Madeasy DBMS 2019 test
By default take ROOT at level 1 or 0? and if asked for B tree then take all the levels but for B+ records only at leaf so only leaf level keys right?

asked 16 hours ago in Databases by Markzuck (153 points) | 25 views

0 votes

0 answers

6

grade up
Database that are designed and managed specifically to meet information needs are called Database Management system Data Warehouses Transaction databases Production databases

asked 23 hours ago in Databases by sim1234 (213 points) | 19 views

+1 vote

1 answer

7

dbms transactions
Number of serial schedules but not conflict to schedule (S) S: r1(A),r2(A),r3(A),r4(A),w1(B),w2(B),w3(B),w4(B)

asked 23 hours ago in Databases by manisha11 Active (1.3k points) | 75 views

+1 vote

0 answers

8

MadeEasyDb
Which one is true? a. Secondry index over key must be dense. b. Clustering index must be dense. c. primary index must be sparse. d.both a and c

asked 1 day ago in Databases by Abhisek Tiwari 4 Active (2k points) | 41 views

0 votes

0 answers

9

Testbook chapter test dbms
The number of rows returned by sql query on given relation: SELECT * from emp where eno NOT IN (SELECT manager from emp) Query intends to find the number of employees who are not MANAGER so emp 2,3,4 are ruled out. But since it includes comparison ... will return false. So NOT IN will give true and number of rows returned will be 1. Answer given is 0. Please clarify.

asked 1 day ago in Databases by shreyansh jain Active (1.1k points) | 53 views

0 votes

0 answers

10

Self Doubt
Average number of comparisons of insertion sort is better than bubble sort by a constant factor ? True or False?

asked 1 day ago in Databases by Shadan Karim (381 points) | 24 views

0 votes

3 answers

11

ME Test Series
Minimum relations required which satisfies the 2nd normal from is _____

asked 1 day ago in Databases by Shadan Karim (381 points) | 74 views

+1 vote

1 answer

12

Non trivial dependency
Given below is the set F of functional dependencies for the relational schema $R = (A, B, C, D, E, F, G, H, I, J)$ $HD\rightarrow A $ $ D\rightarrow EFG $ $ HDB \rightarrow CJ $ $H \rightarrow IJ$ $A \rightarrow BC$ What are all the non-trivial functional dependencies that follow from the given functional dependencies$?$

asked 1 day ago in Databases by Lakshman Patel RJIT Boss (20.9k points) | 61 views

–1 vote

1 answer

13

ACE test

asked 1 day ago in Databases by newdreamz a1-z0 (499 points) | 33 views

–1 vote

0 answers

14

DBMS GATE 2009 QUESTION
Can anyone explain?

asked 2 days ago in Databases by phaneendrababu (141 points) | 15 views

0 votes

0 answers

15

self_doubt
https://gateoverflow.in/39703/gate2016-1-51 In this question What if the transactions T1 and T2 are scheduled in this manner X1(A)X1(B)X2(C)X2(D)S1(C)S2(A)…. will this schedule cause deadlock according to the implementation of the above question ? here X1(P) is exclusive lock on data variable P by transaction T1 and S1(P) is shared lock on P by transaction T1.

asked 2 days ago in Databases by Shivam Kasat Junior (845 points) | 25 views

0 votes

0 answers

16

ZEAL MOCK GATE (DBMS)
IN THESE QUESTION WHAT I DID IN 2) there is Multi valued atrribute so we will create one table for it with ab as key NAMED it AS(BETA) table and 3) is same where b1 is partial key and depending on first tables primary key so both are equivalent please tell me that i am right or not answer is C)

asked 2 days ago in Databases by Prince Sindhiya Loyal (5.4k points) | 14 views

0 votes

0 answers

17

Primary multilevel index
What is the difference between primary multilevel index and B tree?

asked 2 days ago in Databases by Mayank Gupta 3 Junior (505 points) | 5 views

0 votes

0 answers

18

Self Doubt
What is wrong in the below query?

asked 2 days ago in Databases by Shadan Karim (381 points) | 30 views

0 votes

0 answers

19

Self doubt
[closed]

asked 2 days ago in Databases by Shadan Karim (381 points) | 13 views

0 votes

0 answers

20

B+ tree doubt
Consider a B+ -tree in which the maximum no. of keys in a root is 11. What will be minimum no. of keys in a non-root node? What will be the same in a B-Tree Please also refer the source from where clear-cut formulae are given

asked 3 days ago in Databases by Subham Nagar Junior (893 points) | 19 views

+1 vote

1 answer

21

Self doubt
Minimum number of tuples in R Natural join S where R and S contains m and n tuples respectively .

asked 3 days ago in Databases by Shadan Karim (381 points) | 62 views

0 votes

0 answers

22

View Serializability
Can you please suggest some good resources to understand ‘How to draw Polygraph’ to check VS what is extra Constraint that we have to manage in polygraph compare to Precedence Graph? Thanks):

asked 3 days ago in Databases by Abhisek Tiwari 4 Active (2k points) | 11 views

0 votes

0 answers

23

ME TEST
Consider that blocks can hold either ten records or 99 keys and 100 pointers. Assume that the average B+ tree node is atleast 70% full, i.e. except root it will have 69 keys and 70 pointers. The total number of blocks needed for a 10000, record file, if ... data file is a sequential file, sorted on the search key, with 10 records per block with dense index are ________. ANS GIVEN IS 1147.

asked 4 days ago in Databases by newdreamz a1-z0 (499 points) | 17 views

0 votes

0 answers

24

ME test
Which of the following statement false of relation R is in 3NF but not BCNF? A.Relation R must consist atleast two over-lapped candidate keys. B.Relation R must consist proper subset of candidate key determines proper subset of some other candidate ... one compound candidate key and other candidate keys simple candidate key. D.Relation R must consist atleast two compound candidate keys.

asked 4 days ago in Databases by newdreamz a1-z0 (499 points) | 24 views

0 votes

0 answers

25

JOIN (Natural join)
In a natural join, the common attribute occur only once, but in join https://gateoverflow.in/3718/gate2004-it-74 Select * from Student, Department in this common, attribute we have given m+n I tried in w3 schools https://www.w3schools.com/sql/ ... * FROM Orders, Customers WHERE City='Berlin' AND OrderID = '10248' here common attribute is occuring only once, PLease guide .

asked 4 days ago in Databases by Learner_jai Active (2.2k points) | 17 views

0 votes

0 answers

26

[Personal Doubt] View Serializability
Is every serializable schedule view serializable?, or like conflict serializable, there could be a serializable schedule which isn’t view serializable?

asked 4 days ago in Databases by shreejeetp (399 points) | 14 views

0 votes

0 answers

27

ME question
Consider the following transactions: The number schedules of T1 and T2 recoverable ? (ANS GIVEN IS 20 )

asked 4 days ago in Databases by newdreamz a1-z0 (499 points) | 32 views

+1 vote

0 answers

28

ME OTS 4
Consider the following relational schema: R(A, B, C, D, E, F, G, H ) with FD set {AB → C, AC→ B, AD → E, B → D, BC → A, E → G} the following relations are sub relations of the relation R. 1. R1(A, B, C) 2. R2(A, B, C, D) 3. R3(A, ... of sub relation are in BCNF __________. Ans : 1 ( R1) Doubt : Ck : FHBC , then wont be "BC-> A " a partial dependency in all 3 relations ?

asked 4 days ago in Databases by HeadShot Active (3.7k points) | 44 views

0 votes

0 answers

29

ME Test Series

asked 4 days ago in Databases by Shadan Karim (381 points) | 68 views

+1 vote

0 answers

30

ME Test Series

asked 5 days ago in Databases by Shadan Karim (381 points) | 21 views

tags	tag:apple
author	user:martin
title	title:apple
content	content:apple
exclude	-tag:apple
force match	+apple
views	views:100
score	score:10
answers	answers:2
is accepted	isaccepted:true
is closed	isclosed:true

Recent questions in Databases

Recent Posts

Recent Blog Comments