Login
Register
Dark Mode
Brightness
Profile
Edit Profile
Messages
My favorites
My Updates
Logout
Webpage for Databases:
Recent questions tagged databases
0
votes
1
answer
301
Deadlock prevention techniques | Wait-Die | Wound-Wait
MSQ Which among the following is/are TRUE regarding the deadlock prevention techniques: Wound-wait is premptive Wait-die is non-premptive Starvation is possible in wound-wait Starvation does not occur in wait-die
MSQ Which among the following is/are TRUE regarding the deadlock prevention techniques:Wound-wait is premptiveWait-die is non-premptiveStarvation is possible in wound-wai...
Souvik33
373
views
Souvik33
asked
Dec 19, 2022
Databases
databases
deadlock-prevention-avoidance-detection
operating-system
multiple-selects
+
–
0
votes
2
answers
302
Database Relations | Heighest normal form
MSQ A relation R(A,B,C,D) has only trivial functional dependencies of the form ( A→A, AB→AB,ABC→A, etc) Then consider the following options: The relation is surely in BCNF The relation is surely in 3NF The relation is surely in 2NF None of the above
MSQ A relation R(A,B,C,D) has only trivial functional dependencies of the form ( A→A, AB→AB,ABC→A, etc)Then consider the following options:The relation is surely in...
Souvik33
785
views
Souvik33
asked
Dec 17, 2022
Databases
database-normalization
databases
bcnf
normal-forms
multiple-selects
+
–
1
votes
1
answer
303
DRDO CSE 2022 Paper 2 | Question: 14
A relational database contains two tables movie, and genre, in which movie table has columns movie_no, movie_name, and genre_id, while genre table has columns genre_id, and genre_name. Following insert statements were executed successfully to populate the ... How many rows and columns will be retrieved by the following SQL statement? Select * from movie, genre
A relational database contains two tables movie, and genre, in which movie table has columns movie_no, movie_name, and genre_id, while genre table has columns genre_id, a...
admin
383
views
admin
asked
Dec 15, 2022
Databases
drdocse-2022-paper2
databases
sql
5-marks
descriptive
+
–
1
votes
0
answers
304
DRDO CSE 2022 Paper 2 | Question: 15 (a)
Answer the following. __________ is the operation that reverses the normalization to denormalization form.
Answer the following.__________ is the operation that reverses the normalization to denormalization form.
admin
452
views
admin
asked
Dec 15, 2022
Databases
drdocse-2022-paper2
databases
database-normalization
2-marks
fill-in-the-blanks
+
–
2
votes
2
answers
305
DRDO CSE 2022 Paper 2 | Question: 15 (b)
Answer the following. ___________ removes all the rows of the given table.
Answer the following.___________ removes all the rows of the given table.
admin
410
views
admin
asked
Dec 15, 2022
Databases
drdocse-2022-paper2
databases
database-normalization
2-marks
fill-in-the-blanks
+
–
1
votes
0
answers
306
DRDO CSE 2022 Paper 2 | Question: 15 (c)
Answer the following. Which of the following are not keys in the database? Compliment * Agreement Construct Supplement
Answer the following.Which of the following are not keys in the database?Compliment *AgreementConstructSupplement
admin
267
views
admin
asked
Dec 15, 2022
Databases
drdocse-2022-paper2
databases
database-normalization
1-mark
descriptive
+
–
2
votes
0
answers
307
Since it is already in 3NF, why decompose further?
Since the schema is already in 3NF we can keep the relations to 1, cant we? If you think the answer is different please explain how
Since the schema is already in 3NF we can keep the relations to 1, cant we? If you think the answer is different please explain how
h4kr
364
views
h4kr
asked
Dec 15, 2022
Databases
databases
+
–
0
votes
1
answer
308
Calcutta University Question Paper
Consider a relation r1(A, B, C), r2(C, D, E) and r3(E, G) with primary keys A, C and E respectively. Assume that r1 has 1000 tuples, r2 has 1500 tuples and r3 has 750 tuples. The number of resultant tuple in are
Consider a relation r1(A, B, C), r2(C, D, E) and r3(E, G) with primary keys A, C and E respectively. Assume that r1 has 1000 tuples, r2 has 1500 tuples and r3 has 750 tup...
sikkaBrown
789
views
sikkaBrown
asked
Dec 14, 2022
Databases
databases
tuple-relational-calculus
+
–
0
votes
2
answers
309
#gate cs applied course
Dknights
403
views
Dknights
asked
Dec 12, 2022
Databases
sql
databases
+
–
0
votes
2
answers
310
#gate cs applied course
how both query result is the same, please give an example.
how both query result is the same, please give an example.
Dknights
355
views
Dknights
asked
Dec 12, 2022
Databases
sql
databases
+
–
0
votes
1
answer
311
Database | BCNF
Consider the following relation, R(A,B,C) and the following functional dependencies FD={ A→B, B→C, C→A }. Consider the following statements Statement I: The following relation is in BCNF, as A,B and C are key. Statement II: A prime attribute cannot be ... I and II both are correct. None of statement I and II is correct Only statement II is correct. Only statement I is correct.
Consider the following relation, R(A,B,C) and the following functional dependencies FD={ A→B, B→C, C→A }.Consider the following statementsStatement I: The following...
Souvik33
521
views
Souvik33
asked
Dec 10, 2022
Databases
databases
bcnf
functional-dependency
+
–
0
votes
1
answer
312
#gradeup
Dknights
342
views
Dknights
asked
Dec 7, 2022
Databases
databases
relational-algebra
tuple-relational-calculus
gradeup-test-series
+
–
1
votes
0
answers
313
self doubt
Any attribute(s) determining a prime attribute, automatically becomes a prime(s) attribute True or false
Any attribute(s) determining a prime attribute, automatically becomes a prime(s) attributeTrue or false
JAINchiNMay
442
views
JAINchiNMay
asked
Dec 1, 2022
Databases
self-doubt
databases
database-normalization
true-false
+
–
0
votes
1
answer
314
Databases
In Query1, how mid is projected from did.?????????/
In Query1, how mid is projected from did.?????????/
Overflow04
250
views
Overflow04
asked
Nov 29, 2022
Databases
databases
test-series
+
–
0
votes
0
answers
315
Databases
How to identify many to many relationship. Can R2 be one to one.
How to identify many to many relationship.Can R2 be one to one.
Overflow04
335
views
Overflow04
asked
Nov 29, 2022
Databases
test-series
databases
relational-model
+
–
0
votes
0
answers
316
a) Following relational schema is given: Doctor (DName, Reg_no,D_City), Patient (Pname, Disease, P_City) and Assigned To (Pname, Dname) Give expression in Relational Algebra for each of the queries: i) Get the names of patients who are assigned to more than one doctor. ii) Get the names of doctors who are treating patients with 'Polio’. iii) Get the details of doctors who are treating to the patient belongs to the same city. iv) Count the number of patients treated by each doctor
ayushrathore111
864
views
ayushrathore111
asked
Nov 28, 2022
Databases
databases
relational-algebra
+
–
Page:
« prev
1
...
6
7
8
9
10
11
12
13
14
15
16
...
97
next »
Email or Username
Show
Hide
Password
I forgot my password
Remember
Log in
Register