Login
Register
@
Dark Mode
Profile
Edit my Profile
Messages
My favorites
Register
Activity
Q&A
Questions
Unanswered
Tags
Subjects
Users
Ask
Previous Years
Blogs
New Blog
Exams
Dark Mode
Webpage for Databases:
Recent questions tagged databases
3
votes
1
answer
31
GO Classes Test Series 2024 | Mock GATE | Test 13 | Question: 31
Let $\text{R}_1, \text{R}_2, \ldots,\text{ }R_n$ be a decomposition of schema $\text{U}$. Let $u(\text{U})$ be a relation, and let $r_i=\Pi_{\text{R}_i}(u)$ ... $u=r_1 \bowtie r_2 \bowtie r_3 \bowtie r_4 \bowtie . . r_n$ None of the above
GO Classes
asked
in
Databases
Jan 28
by
GO Classes
362
views
goclasses2024-mockgate-13
goclasses
databases
relational-algebra
1-mark
3
votes
1
answer
32
GO Classes Test Series 2024 | Mock GATE | Test 13 | Question: 32
The order of a leaf node in a $\text{B tree}$ is the maximum number of (value, data record pointer) pairs it can hold. Given that the block size is $1 \mathrm{~K}$ bytes, data record pointer is $7$ bytes long, the value field is $9$ bytes long and a block pointer is $6$ bytes long, what is the order of the leaf node?
GO Classes
asked
in
Databases
Jan 28
by
GO Classes
446
views
goclasses2024-mockgate-13
goclasses
numerical-answers
databases
b-tree
1-mark
3
votes
1
answer
33
GO Classes Test Series 2024 | Mock GATE | Test 13 | Question: 33
Consider the following two schedules consisting to two transaction $\mathrm{T}_1$ and $\mathrm{T}_2$ : Which of the following is/are true about these schedules? Both $\mathrm{S}_1$ and $\mathrm{S}_2$ are ... and also conflict serializable. $\mathrm{S}_1$ and $\mathrm{S}_2$ are neither conflict equivalent nor conflict serializable.
GO Classes
asked
in
Databases
Jan 28
by
GO Classes
240
views
goclasses2024-mockgate-13
goclasses
databases
transaction-and-concurrency
conflict-serializable
1-mark
5
votes
1
answer
34
GO Classes Test Series 2024 | Mock GATE | Test 13 | Question: 64
Consider the following schema: The primary key fields are underlined, and the domain of each field is listed after the field name. Assume there are no NULL values in any column of any relation and every relation has at least one tuple. ... who have a rating of $10 $ OR have reserved boat $104.$ All sids of sailor table Empty set.
GO Classes
asked
in
Databases
Jan 28
by
GO Classes
456
views
goclasses2024-mockgate-13
goclasses
databases
sql
2-marks
3
votes
2
answers
35
GO Classes Test Series 2024 | Mock GATE | Test 13 | Question: 65
Let $r(X, Y)$ and $s(Y)$ be two relations. What is returned by the following relational algebra query? Values of $r.X$ which are related to every value of $s.Y$. Values of $r.Y$ which are related to every value of $s.Y$. ... which are not related to some value of $s.Y$. Values of $r.X$ which are not related to any value of $s.Y$.
GO Classes
asked
in
Databases
Jan 28
by
GO Classes
457
views
goclasses2024-mockgate-13
goclasses
databases
relational-algebra
2-marks
0
votes
1
answer
36
please explain this sql question and how do we get the answer?
pcla
asked
in
Databases
Jan 27
by
pcla
144
views
databases
sql
3
votes
2
answers
37
GO Classes Test Series 2024 | Mock GATE | Test 12 | Question: 23
An attribute $A$ is called prime if $A$ is in any of the candidate keys. Assume in the following statements, $\mathrm{A}$ is an attribute $\&\;\mathcal{X}$ is a set of attributes. Consider the following statements: Domain of each attribute is an ... $\text{A - BCNF, B - 3NF, C - 2NF, D - 1NF}$
GO Classes
asked
in
Databases
Jan 21
by
GO Classes
414
views
goclasses2024-mockgate-12
goclasses
databases
database-normalization
functional-dependency
1-mark
3
votes
0
answers
38
GO Classes Test Series 2024 | Mock GATE | Test 12 | Question: 24
Assume that a data file has an index consisting of $\text{N}$ items, where $\text{N}$ is large. If a binary search of the index is used to find an item, then, of the following, which best approximates the mean number of comparisons required to locate a ... $\left(\log _2 \text{N}\right)-1$ $\text{N} \log _2 \text{N}$
GO Classes
asked
in
Databases
Jan 21
by
GO Classes
684
views
goclasses2024-mockgate-12
goclasses
databases
indexing
1-mark
12
votes
1
answer
39
GO Classes Test Series 2024 | Mock GATE | Test 12 | Question: 25
Let $\mathrm{R}(\mathrm{a}, \mathrm{b})$ be a schema and $\mathrm{Q} 1$ and $\mathrm{Q} 2$ are queries on $\mathrm{R}$. Q1: SELECT * FROM R; Q2: (SELECT * FROM R) INTERSECT (SELECT * FROM R); Which of the ... to $\text{Q2}$ is always contained in the answer to $\text{Q1}.$ $\text{Q1}$ and $\text{Q2}$ produce different answers.
GO Classes
asked
in
Databases
Jan 21
by
GO Classes
700
views
goclasses2024-mockgate-12
goclasses
databases
sql
1-mark
8
votes
2
answers
40
GO Classes Test Series 2024 | Mock GATE | Test 12 | Question: 55
Consider the following partial schedule for several data items for transactions $T_i$ with timestamp $i:$ How many transactions are Aborted by the timestamp scheduler?
GO Classes
asked
in
Databases
Jan 21
by
GO Classes
794
views
goclasses2024-mockgate-12
goclasses
numerical-answers
databases
transaction-and-concurrency
2-marks
3
votes
0
answers
41
GO Classes Test Series 2024 | Mock GATE | Test 11 | Question: 13
Given the portion of an ER diagram shown above (with a thickened arrow from $R$ to $A),$ which of the following statements are true? $R$ connects each entity in $A$ to at least one entity in $B$ $R$ connects each entity in $A$ to at ... in $B$ to at most one entity in $A$ only I and II only II and III only I and IV only III and IV
GO Classes
asked
in
Databases
Jan 13
by
GO Classes
610
views
goclasses2024-mockgate-11
goclasses
databases
er-diagram
1-mark
12
votes
1
answer
42
GO Classes Test Series 2024 | Mock GATE | Test 11 | Question: 57
You are given a table named Alums that contains the names and personal information of all graduates of the college that you work for. It includes name and age attributes, and a state attribute specifying the state in which a person ... of the youngest graduate living in California (CA)? only II only III only I and II only II and III
GO Classes
asked
in
Databases
Jan 13
by
GO Classes
865
views
goclasses2024-mockgate-11
goclasses
databases
sql
2-marks
2
votes
1
answer
43
GO Classes Test Series 2024 | Mock GATE | Test 11 | Question: 58
Consider the following notation for operations of transactions: ... above schedules is/are recoverable? Only $\text{S}_2$ Only $\text{S}_3$ Only $\text{S}_1, \text{S}_3$ None
GO Classes
asked
in
Databases
Jan 13
by
GO Classes
348
views
goclasses2024-mockgate-11
goclasses
databases
transaction-and-concurrency
2-marks
4
votes
0
answers
44
GO Classes Test Series 2024 | Mock GATE | Test 11 | Question: 59
Which of the following statements is/are false? In a cascade-less schedule if a transaction $T_j$ read a data item written by transaction $T_i$ then the commit of $T_i$ has to be before this read operation of $T_j$ A ... $2 \mathrm{PL}$ (could have been produced using the $2 \mathrm{PL}$ locking protocol) is conflict-serializable.
GO Classes
asked
in
Databases
Jan 13
by
GO Classes
420
views
goclasses2024-mockgate-11
goclasses
databases
transaction-and-concurrency
conflict-serializable
multiple-selects
2-marks
8
votes
4
answers
45
GO Classes Test Series 2024 | Mock GATE | Test 11 | Question: 60
In a relational database relation, we say a non-empty set of attributes $\mathrm{X}$ is closed (with respect to a given set of functional dependencies FD) if $X^{+}=X$ (where $X^{+}$is the closure of $X).$ ... $2.$ $R$ is in $2 N F$. $R$ is in $3 N F$.
GO Classes
asked
in
Databases
Jan 13
by
GO Classes
951
views
goclasses2024-mockgate-11
goclasses
databases
database-normalization
functional-dependency
multiple-selects
2-marks
0
votes
1
answer
46
Made Easy Test Series
Isn’t F$^{+}$ minimal cover? If C $\rightarrow$ A is already there, then why does augmented CD $\rightarrow$ A needs to be?
Mrityudoot
asked
in
Databases
Jan 12
by
Mrityudoot
137
views
made-easy-test-series
databases
functional-dependency
0
votes
0
answers
47
Topic name:Finding number of Cnadiadte and Super Keys
r=(a1,a2,a3,...a8) assumne that a1a2a3 is a canidate key and other cks we dont know.Then find the number of possible candidate keys and number of superkeys?
supratikde707
asked
in
Databases
Jan 9
by
supratikde707
144
views
databases
0
votes
1
answer
48
Minimal Cover
In questions asking for the number of FDs in minimal cover if I get say A $\rightarrow$ B A $\rightarrow$ C D $\rightarrow$ EF Then what do I count them as 2 or 3 or 4 FDs?
Mrityudoot
asked
in
Databases
Jan 8
by
Mrityudoot
215
views
databases
canonical-cover
2
votes
2
answers
49
ISRO 2024
Which of the following SQL query deletes all tuples in the teacher relation for those teachers associated with a department located in the building with name CSE and which is in department relation: DELETE FROM teacher WHERE dept_name IN CSE'; DELETE FROM ... WHERE dept_name IN ( SELECT dept_name FROM department WHERE building = CSE); DELETE FROM teacher WHERE dept_name IN CSE';
Ramayya
asked
in
Databases
Jan 7
by
Ramayya
445
views
isro-2024
databases
sql
query
0
votes
1
answer
50
ISRO 2024
Fifth Normal form is concerned with Join Dependency Domain-key Multivalued dependency Functional dependency
Ramayya
asked
in
Databases
Jan 7
by
Ramayya
163
views
databases
normal-forms
0
votes
1
answer
51
ISRO 2024
Amongst the ACID properties of a transaction ‘Durability’ property requires that the changes made to the database by a successful transaction persist Except in case of an operating system crash Except in case of a disk crash Except in case of a power failure Always, even if there is a failure of any kind
Ramayya
asked
in
Databases
Jan 7
by
Ramayya
174
views
isro-2024
databases
transaction-and-concurrency
0
votes
2
answers
52
ISRO 2024
Entity Relationship model shows the Static view Functional view Dynamic view All of the above
Ramayya
asked
in
Databases
Jan 7
by
Ramayya
306
views
isro-2024
databases
er-diagram
Page:
« prev
1
2
3
4
5
6
7
...
97
next »
Subscribe to GATE CSE 2024 Test Series
Subscribe to GO Classes for GATE CSE 2024
Quick search syntax
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 Posts
Post GATE 2024 Guidance [Counseling tips and resources]
GATE CSE 2024 Result Responses
[Project Contest] Pytorch backend support for MLCommons Cpp Inference implementation
Participating in MLCommons Inference v4.0 submission (deadline is February 23 12pm IST)
IIITH PGEE 2024 Test Series by GO Classes
Subjects
All categories
General Aptitude
(3.5k)
Engineering Mathematics
(10.4k)
Digital Logic
(3.6k)
Programming and DS
(6.2k)
Algorithms
(4.8k)
Theory of Computation
(6.9k)
Compiler Design
(2.5k)
Operating System
(5.2k)
Databases
(4.8k)
CO and Architecture
(4.0k)
Computer Networks
(4.9k)
Artificial Intelligence
(79)
Machine Learning
(48)
Data Mining and Warehousing
(25)
Non GATE
(1.4k)
Others
(2.7k)
Admissions
(684)
Exam Queries
(1.6k)
Tier 1 Placement Questions
(17)
Job Queries
(80)
Projects
(11)
Unknown Category
(870)
64.3k
questions
77.9k
answers
244k
comments
80.0k
users
Recent questions tagged databases
Recent Blog Comments
category ?
Hi @Arjun sir, I have obtained a score of 591 in ...
download here
Can you please tell about IIT-H mtech CSE self...
Please add your admission queries here:...