Dark Mode

Recent questions tagged databases

0 votes

1 answer

121

gate doubt
A database relation R has 10 attributes (A, B, C, D,..., J). "CDEF" is known to be a candidate key of relation R. There may be other candidate keys, which are unknown. What is the maximum number of candidate keys that R could simultaneously have?

Deepak Joshi asked in Databases Oct 8, 2023

by Deepak Joshi

618 views

0 votes

1 answer

122

CANDIDATE KEYS
Consider a relation R'(P, Q, R, S, T) The functional dependency of the relation R' are as follows - P->QR RS->T * -> * is non empty subset of R'. It may be trivial or non-trivial dependency. Which of the following is ... there exists another candidate key of R' which must contain S'. C.Some candidate keys of R' contain R and some do not. D.None

24aaaa23 asked in Databases Oct 2, 2023

190 views

2 votes

2 answers

123

sql
Consider the label student (sid, sname, class, avg_marks). Q1: Select sid from student S1 Where not exists (Select sid from student S where S.class=5 and S1.avg_marks <= S.avg_marks) Q2: Select sid from student S1 Where s1. avg_marks>Any (Select distinct ... output B. will show sid of students who has maximum avg_marks. C. will show sid of student whose avg_marks is second highest. D.None

24aaaa23 asked in Databases Oct 2, 2023

380 views

0 votes

1 answer

124

Çșȇ ʛấẗẻ asked in Databases Sep 23, 2023

by Çșȇ ʛấẗẻ

190 views

2 votes

1 answer

125

made easy test series 2023
Consider a relation R having seven attributes ABCDEFG. Fields of R contain only atomic values. FDs = {CD → G, A → BC, B → CF, E → A, F → EG, G → D} is set of functional dependencies. So, how many candidates key does the relation R have?

kaustubh7 asked in Databases Sep 20, 2023

410 views

0 votes

6 answers

126

made easy test series
Consider a relation $R(ABCDEFGH)$. How many superkeys will be there in relation $R$ if the candidate keys for relation are ${A, BC, CDE, EF}$?

kaustubh7 asked in Databases Sep 20, 2023

847 views

2 votes

1 answer

127

Applied Roots - DBMS Practice Test 2 (SQL query order question)
A SQL query is written in its format as clauses are arranged in a specific sequence and these clauses are executed in different sequence. If we're writing a query using select, from, where, group by, having, order by, Distinct clauses. Then ... clauses are needed to be replaced while writing it's execution order. A) 1 B) 2 C) 3 D) 4

equimanthorn asked in Databases Sep 15, 2023

by equimanthorn

332 views

0 votes

1 answer

128

#DBMS #Normalization
please can someone help with part (a) of this question.

bhucho asked in Databases Sep 13, 2023

by bhucho

257 views

0 votes

1 answer

129

Ace Test Series | DBMS | B+ Trees
Consider the following description: To construct the B+ tree use the following values. Consider the database block size as 512 bytes, block pointer as 6 bytes, record pointer as 7 bytes and search key value as 9 bytes. What will be the number of data entries possible in level 2 of the B+ tree, if fill factor of the node is 0.8? 17,954 16,954 18,954 19,954

none30 asked in Databases Sep 6, 2023

by none30

367 views

0 votes

0 answers

130

Finding minimum number of tables needed to represent ER diagram
Find minimum number of tables needed to represent following ER diagram? This question would have been relatively simple as we would implicitly convert the ERD to 3NF (asked in GATE 2008). But what if the questions asks us to find minimum tables needed to represent above ERD in 1NF or 2NF?. What would our approach will be in that case?

rexritz asked in Databases Aug 29, 2023

470 views

1 vote

1 answer

131

ISRO cs 2020
Given R(ABCD) FD's={A->C,B->D}. Is this in 3NF?If NO why?

Sai eswar asked in Databases Aug 20, 2023

534 views

1 vote

2 answers

132

UGC NET CSE | June 2023 | Part 2: 44
Which one of the following is $\text{NOT}$ a part of $\text{ACID}$ properties of a database transaction? Atomicity Consistency Isolation Deadlock-freedom

admin asked in Databases Jul 28, 2023

by admin

279 views

0 votes

1 answer

133

DBMS Functional Dependencies
Will a single attribute key considered as a prime attribute as well? I know If it is a compound key like (ABC) then my prime attribute set would be {A,B,C,AB,BC,AC} But if I have only 1 Candidate key in my relation (A) then will A ... or not? Also if multiple single attribute keys are there then what happens (Say {A}, {B} are both candidates) with the prime attributes?

Mrityudoot asked in Databases Jul 28, 2023

301 views

Page:

« prev
1
2
3
4
5
6
7
8
9
10
...
97
next »

Recent questions tagged databases