Dark Mode

Recent questions tagged databases

0 votes

0 answers

1

Subject : Databse Topic: 2pl locking protocol..... If the given schedule is allowed under any 2pl( basic 2pl,strict or rigorous) then it is also allowed in conflict serializble , so if the schedule which is allowed in conflict serializable then also we can say it will be allowed in 2pl?

Ashutosh888 asked in Databases 16 hours ago

12 views

0 votes

1 answer

2

#dbms #normalisation
2NF , 3NF, BCNF decomposition allowed if lossless and dependency preserving , both conditions must preserve. Otherwise given decomposition wrong for normal forms. Is this statement correct????

chinmay_rajpurohit asked in Databases Mar 2

by chinmay_rajpurohit

80 views

0 votes

0 answers

3

Ace workbook dbms

gaddalakonda_ganesh asked in Databases Feb 28

by gaddalakonda_ganesh

82 views

0 votes

2 answers

4

When is a group of attributes prime?
Given the candidate keys CD and DE and the functional dependency AB->CDE. Is CDE considered prime because all attributes (C, D and E) are prime? Or is it non-prime because CDE is not found in a candidate key as a whole? Therefore, my question is if a group of prime attributes is also prime due to its attributes or it has to be part of a candidate key as well.

Mira67 asked in Databases Feb 20

by Mira67

182 views

3 votes

3 answers

5

GATE CSE 2023 | Question: 6
Which one of the options given below refers to the degree (or arity) of a relation in relational database systems? Number of attributes of its relation schema. Number of tuples stored in the relation. Number of entries in the relation. Number of distinct domains of its relation schema.

admin asked in Databases Feb 15

by admin

1.0k views

1 vote

2 answers

6

GATE CSE 2023 | Question: 51
Consider the following table named $\text{Student}$ in a relational database. The primary key of this table is $\text{rollNum}.$ $\text{Student}$ ... database. SELECT * FROM Student WHERE gender = 'F' AND marks > 65; The number of rows returned by the query is ___________.

admin asked in Databases Feb 15

by admin

898 views

1 vote

0 answers

7

GATE CSE 2023 | Question: 52
Consider a database of fixed-length records, stored as an ordered file. The database has $25,000$ records, with each record being $100$ bytes, of which the primary key occupies $15$ bytes. The data file is block-aligned in that each data ... required to identify the block in the data file that may contain a record with the key, in the worst case, is _____________.

admin asked in Databases Feb 15

by admin

1.8k views

0 votes

1 answer

8

GATE CSE 2023 | Memory Based Question: 34
Which one of the options given below refers to the degree (or arity) of a relation in relational database systems? Number of tuples stored in relation. Number of distinct domains of its relation schema. Number of attributes in relation. Number of entries in relation.

GO Classes asked in Databases Feb 6

421 views

1 vote

1 answer

9

DBMS
can we make weak entity type as composite attribute of another weak entity type?

striver23 asked in Databases Feb 4

128 views

0 votes

0 answers

10

TestBook TestSeries question to find max child possible in B+ Tree
In a B+ Tree index having order 6, which is the maximum number of child pointers it can have. Keys are numbered from 1 to 83. What can be the maximum number of nodes which can be used to store all the keys? A. 17 B. 19 C. 59 D. 57

Sahil_Lather asked in Databases Jan 29

by Sahil_Lather

111 views

0 votes

1 answer

11

TestBook TestSeries Finding number of records under join of 2 tables
Assume a relation R' having 200 records. These records are stored in blocks having block factor as 20. Consider another relation S' having 120 records and all these records are stored in 30 blocks. These two tables have to be joined ... the total number of block access required to join R and S ? A. 2430 B. 6010 C. 6120 D. 1230

Sahil_Lather asked in Databases Jan 29

by Sahil_Lather

74 views

0 votes

0 answers

12

Databases
Please explain option c.

Overflow04 asked in Databases Jan 25

76 views

Page:

1
2
3
4
5
6
...
90
next »

Recent questions tagged databases