Recent questions in Databases

0 votes

0 answers

1

How to know which type of join shall I apply in dbms relational algebra?

asked 6 hours ago in Databases by Fida (13 points) | 11 views

0 votes

1 answer

2

#questions
R(ABCDEF) FD={AB$\rightarrow$C,C$\rightarrow$D,D$\rightarrow$E,E$\rightarrow$F,F$\rightarrow$A} FIND NUMBER OF SUPERKEY

asked 10 hours ago in Databases by amit166 (233 points) | 25 views

0 votes

0 answers

3

Serializable Schedule
It's a question I already asked and correct answer is 2 but what's wrong with this approach help me :(

asked 13 hours ago in Databases by Na462 Loyal (6.4k points) | 18 views

0 votes

1 answer

4

SQL sub query

asked 1 day ago in Databases by Anand Yadav (7 points) | 30 views

0 votes

0 answers

5

Self-doubt
How many indexes of each of the following type can be present at maximum in a relation and why? i)Primary Indexing ii)Clustering indexing iii)Secondary Indexing

asked 2 days ago in Databases by satendra (195 points) | 16 views

0 votes

1 answer

6

Self-Doubt
We say every bcnf is 3nf also but suppose in a bcnf relation the dependency is not preserved then how can we say that it is in 3nf since every 3nf must be dependency preserving.

asked 2 days ago in Databases by satendra (195 points) | 15 views

0 votes

1 answer

7

Made easy

asked 2 days ago in Databases by abhishekmehta4u Boss (23.9k points) | 22 views

0 votes

0 answers

8

Dbms doubt
MY_CLASSES TREM COURSE TITLE CREDITS INSTRUCTOR DAYS TIME ROOM GRADE Fall2018 ICS314 software engg 3 C MOORE T,R 8:00-10:00 LEC1 Fall2018 ICS321 DBMS 3 R .Hall M,W 10:00-12:00 LEC2 Assume COURSE detemine TITLE and number of CREDITS ,but ... the significant functional dependencies 3 Identify the Normal form and why 4 Normalize the table into BCNF relation and write the resulting tables

asked 2 days ago in Databases by hitendra singh Junior (885 points) | 12 views

0 votes

1 answer

9

self doubt
What is the minimum and maximum no of elements can be present in below points with order "n" 1. B+ tree internal node 2. B+ tree root node 3. B+ leaf node 4. B tree internal node 5. B tree root node 6. B tree leaf node Thank you in advance.

asked 2 days ago in Databases by iamdeepakji (79 points) | 8 views

0 votes

0 answers

10

Gate2017
In the below question ,it is not mentioned as to how the relation R is associated with A and B.If i take A(M)---R---(1)B(A is related to B using many to one ) and A has total participation then option 3 is correct .If i take B(1)---R--- ... partial Relationship R is many-to-one and the participation of A in R is total Relationship R is many-to-one and the participation of A in R is partial

asked 2 days ago in Databases by satendra (195 points) | 6 views

0 votes

0 answers

11

Conflict serializabilty
For the given schedule which of the following statement is true? S: R4(A), R2(A), R3(A), W1(B), W2(C), R4(B), W2(B) (a) The schedule cannot be serialized (b) The schedule is equivalent to T3, T4, T1, T2 (c) The schedule is equivalent to T1, T4, T3, T2 (d) The schedule is equivalent to T2, T3, T1, T4

asked 2 days ago in Databases by sahil_malik (135 points) | 9 views

0 votes

0 answers

12

Gate made easy
Consider the following statements: S1: Entire database can not be locked. S2: Entire relation can be locked. Which of the above statements is/are true (a) S1 only (b) S2 only (c) Both S1 and S2 are true (d) Both S1 and S2 are false

asked 4 days ago in Databases by kaushal dewangan (53 points) | 17 views

0 votes

0 answers

13

Assertions in SQL-Self Doubt
Whenever Assertions are created, the predicate that the Assertion specifies must hold true at the time of assertion creation. Now Whenever we make changes to any table in the database, do all the assertions present in the database are checked ... all Assertions are checked and executed (Even when some assertions are not related to the tables which have been changed)?

asked 4 days ago in Databases by Ayush Upadhyaya Boss (13.9k points) | 18 views

0 votes

1 answer

14

Test Series
From the following statements which of them is/are true about SQL a) All attributes used in the group by clause must appear in the select clause b) An SQL query can contain a having clause only if it has a group by clause c) An SQL query can contain a having ... if it does not have a group by clause d) Not all attributes used in the group by clause need to appear in the select clause

asked 4 days ago in Databases by Manas Mishra Junior (853 points) | 35 views

0 votes

0 answers

15

Self Doubt
Start T; Write(A); Checkpoint; Commit; System Crash; Consider the above transaction T. Suppose the system crashes after the performing the above transaction.Will the recovery manager keep the above transaction into Redo-list ,if yes then what statement will be kept into redo-list?

asked 5 days ago in Databases by satendra (195 points) | 24 views

0 votes

0 answers

16

GSET 2018(Gujarat State Eligibilty Test ) CS & IT

asked 5 days ago in Databases by sherlock_john (13 points) | 6 views

0 votes

1 answer

17

Super Keys
How many Super keys Possible for R(A,B,C,D,E) with 1. {A,BC,DE} as the keys ? 2. {A,BC,CDE} as the keys ?

asked 5 days ago in Databases by Na462 Loyal (6.4k points) | 17 views

0 votes

0 answers

18

Made easy
In question 46 . I think Dependency preserving is not possible.

asked 5 days ago in Databases by abhishekmehta4u Boss (23.9k points) | 20 views

0 votes

0 answers

19

Self-Doubt
In B+ trees ,after splitting a node we copy the splitted key in the right subtree(leaf node) as per the standard procedure.Is it valid to copy the splitted key to left subtree(leaf node) instead of right subtree(leaf) ? Reference:https://gateoverflow.in/1330/gate2009-44

asked 6 days ago in Databases by satendra (195 points) | 7 views

0 votes

1 answer

20

Normalization

asked 6 days ago in Databases by abhishekmehta4u Boss (23.9k points) | 34 views

0 votes

0 answers

21

Database-Indexing
I have two doubts here (1)Doubt1-The number of blocks needed to store file must be 3000 and not 2930. Record organisation is unspanned and so 1 block can contain only 10 records. Here in solution, they are trying to fit bytes into blocks and ... didn't tell, for purpose of optimisation we can consider multi-level indexing with primary index. What should be the correct answer here?

asked 6 days ago in Databases by Ayush Upadhyaya Boss (13.9k points) | 26 views

0 votes

1 answer

22

Database-Transactions
Consider a database transaction involving two bank account x and y. read(x) x=x-50 write(x) read(y) y=y+50 write(y) Which of the following constraints fail if transaction fails after just after write(x) operation. (A)Atomicity (B)Durability (C ... in the Inconsistent state. Consistency should have been more appropriate here and hence (D) should have been the choice. Why (A).

asked 6 days ago in Databases by Ayush Upadhyaya Boss (13.9k points) | 29 views

0 votes

0 answers

23

ER Diagram to Relation
Consider ER Diagram Identify the Minimum number of relation satisfying 2nf ? A. 1 B. 2 C. 3 D. 4

asked 6 days ago in Databases by Na462 Loyal (6.4k points) | 56 views

0 votes

0 answers

24

DBMS: Unique and CHECK constraint
In this above question, given answer is 5, but I think answer should be 10 as UNIQUE constraint allows NULL value. please confirm.

asked Oct 11 in Databases by chauhansunil20th Junior (505 points) | 16 views

0 votes

1 answer

25

DBMS:natural join and Using join
In the following question, why option B is not correct?

asked Oct 11 in Databases by chauhansunil20th Junior (505 points) | 14 views

0 votes

0 answers

26

Number of Conflict Equal and View Equal Schedules

asked Oct 11 in Databases by Ayush Upadhyaya Boss (13.9k points) | 29 views

0 votes

1 answer

27

made easy test series
The answer given is wrong? .Someone, please check.

asked Oct 11 in Databases by amitqy (309 points) | 30 views

0 votes

0 answers

28

Database Btree
Consider search field V= 9bytes block size B= 512 bytes record pointer Pr=7 bytes and block pointer Pb is 6 bytes. How many children can a node have or order of tree so that each node can come in a single block How is the answer 23?? I am getting 24.

asked Oct 11 in Databases by Anilava Kundu (41 points) | 8 views

0 votes

1 answer

29

Relational Algebra Fundamental Operation

asked Oct 11 in Databases by pradeepchaudhary Junior (603 points) | 18 views

0 votes

1 answer

30

self doub

asked Oct 11 in Databases by Shubham Aggarwal Junior (907 points) | 16 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