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
Filter
User Bikram
Wall
Recent activity
All questions
All answers
Exams Taken
All Blogs
Questions by Bikram
0
votes
2
answers
1
Test by Bikram | Databases | Test 2 | Question: 30
Consider the following set of relations: EMP (eno, ename , dno) DEPT (dno, dname) Primary key columns are underlined and dno in EMP is a foreign key referring primary key of DEPT table. Now, consider the following queries: QUERY: $1$ SELECT ... Query:1 and Query:2 returns different number of columns. I, II only III, IV only II, III only I, IV only
asked
in
Databases
Aug 26, 2017
533
views
tbb-dbms-2
databases
sql
2
votes
1
answer
2
Test by Bikram | Databases | Test 2 | Question: 29
Let Depositor and Lender be relational schemas such that Depositor = {a/c number, cname , balance, branch} & Lender ={loan_number ,cname, amount , branch}. Now, consider the following queries on the database: Query $1$ ... 3 give same result. Query 1 and Query 3 give same result. Query 1, Query 2 and Query 3 give different results.
asked
in
Databases
Aug 26, 2017
705
views
tbb-dbms-2
databases
relational-calculus
1
vote
1
answer
3
Test by Bikram | Databases | Test 2 | Question: 28
Given below are some transaction schedules that involve three transactions $T1 \ T2 \ T3$: $\textbf{Schedule 1:}$ $T2 : Rx , T2 : Ry , T1 : Wx , T3 : Wy , T3 : Wz , T2 : Wz , T1 : Rz , T2 : Wy $ ... $1$ Schedule $2$ Schedule $3$ Schedule $4$
asked
in
Databases
Aug 26, 2017
269
views
tbb-dbms-2
databases
transaction-and-concurrency
conflict-serializable
3
votes
0
answers
4
Test by Bikram | Databases | Test 2 | Question: 27
Consider the relation: Exam(eid, marks) Assume that marks take not null integers only. Also, marks takes distinct values and the number of tuples are odd. Select marks from Exam E where (select Count(*) from Exam where marks < E. ... What does the above SQL query print? Mean of the marks Median of the marks Mode of the marks Average of the marks
asked
in
Databases
Aug 26, 2017
467
views
tbb-dbms-2
databases
sql
8
votes
3
answers
5
Test by Bikram | Databases | Test 2 | Question: 26
Assume that a data file contains $2000$ records that are ordered by a key attribute $K$ , and a primary index on attribute $K$ is built. The size of key is $5B$ and block pointer is $5B$. Each block of the system is of ... storing meta data). The total number of disk accesses required to fetch the record using the index (in average case) is _____.
asked
in
Databases
Aug 26, 2017
952
views
tbb-dbms-2
numerical-answers
databases
file-organization
indexing
3
votes
1
answer
6
Test by Bikram | Databases | Test 2 | Question: 25
Consider a relational table $T$ with sufficient number of records having attributes $T1, T2, \dots ,Tn$ (where $1 \leq p \leq n)$ Two queries $S1$ and $S2$ ... queries. Hashing will outperform ordered indexing on $S2$ but not $S1$. Hashing will outperform ordered indexing on $S1$ but not $S2$.
asked
in
Databases
Aug 26, 2017
303
views
tbb-dbms-2
databases
relational-algebra
0
votes
1
answer
7
Test by Bikram | Databases | Test 2 | Question: 24
Consider the relation schemas: Rank (name, rank) and student (name, country), where name in student table is a foreign key in table Rank. Which of the following TRC Queries displays all the student names from India along with their respective ranks? ...
asked
in
Databases
Aug 26, 2017
367
views
tbb-dbms-2
databases
relational-algebra
7
votes
1
answer
8
Test by Bikram | Databases | Test 2 | Question: 23
Consider the table employee' having two columns: 'EmpNo' and 'EmpName'. Run the following transaction on the table: COMMIT; ALTER TABLE employee ADD PhoneNo varchar(10); ROLLBACK; What are the columns in the ... ? EmpNo PhoneNo EmpNo EmpName Same as (B) but will throw an error indicating failed transaction EmpNo EmpName PhoneNo
asked
in
Databases
Aug 26, 2017
527
views
tbb-dbms-2
databases
sql
2
votes
1
answer
9
Test by Bikram | Databases | Test 2 | Question: 22
Consider the following relation schema: Student (RollNo, Sname, Scity) Packages (Pcode, Pname, Price) Registers (RollNo PCode, Date) What does the following SQL query return? Select distinct S.RollNo From Student S Where NOT ... RollNos of students who registered for at least one package. RollNos of students who registered for all the packages.
asked
in
Databases
Aug 26, 2017
392
views
tbb-dbms-2
databases
sql
2
votes
1
answer
10
Test by Bikram | Databases | Test 2 | Question: 21
Consider the following transaction involving two bank accounts $A$ and $B$ ... $A$ and $B$ should remain constant is that of: Atomicity Consistency Isolation Durability
asked
in
Databases
Aug 26, 2017
320
views
tbb-dbms-2
databases
transaction-and-concurrency
1
vote
1
answer
11
Test by Bikram | Databases | Test 2 | Question: 20
Assume that a B-Tree is used as an index for a large database table which has six levels (including the root node). If a new key is inserted into this index, then the maximum number of levels possible in the updated tree is ______.
asked
in
Databases
Aug 26, 2017
405
views
tbb-dbms-2
numerical-answers
databases
b-tree
1
vote
1
answer
12
Test by Bikram | Databases | Test 2 | Question: 19
A schedule with two transactions T1 and T2 is as mentioned below: ... The above schedule is an example of: Cascade-less schedule Recoverable schedule Both Cascade-less and Recoverable schedule Irrecoverable schedule
asked
in
Databases
Aug 26, 2017
299
views
tbb-dbms-2
databases
transaction-and-concurrency
2
votes
1
answer
13
Test by Bikram | Databases | Test 2 | Question: 18
The above ER diagram depicts a book rental scheme. If this ER diagram is mapped to a relational model, to correctly depict this above scenario, the total number of relations required will be _________.
asked
in
Databases
Aug 26, 2017
433
views
tbb-dbms-2
numerical-answers
databases
er-diagram
3
votes
2
answers
14
Test by Bikram | Databases | Test 2 | Question: 17
Which of the following is TRUE about the given schedule S? ... is conflict serializable. It is view serializable but not conflict serializable. It is conflict serializable but not view serializable. It is not serializable.
asked
in
Databases
Aug 26, 2017
479
views
tbb-dbms-2
databases
transaction-and-concurrency
serializability
conflict-serializable
view-serializable
3
votes
2
answers
15
Test by Bikram | Databases | Test 2 | Question: 16
$\sigma_{A=B \text{ and } B=C \text{ and } C=A} \bigg( \Pi_A (R) \times \Pi_B (R) \times \Pi_C (R) \bigg)$ The number of rows returned by the above relational algebraic expression is ________.
asked
in
Databases
Aug 26, 2017
423
views
tbb-dbms-2
numerical-answers
databases
relational-algebra
3
votes
1
answer
16
Test by Bikram | Databases | Test 2 | Question: 15
What is the number of rows returned by an SQL query on the below EMP table? ... EMP where manager IN (NULL, NULL,NULL); It will throw an error. Three rows are selected. No rows are selected. One row is selected.
asked
in
Databases
Aug 26, 2017
397
views
tbb-dbms-2
databases
sql
0
votes
1
answer
17
Test by Bikram | Databases | Test 2 | Question: 14
Consider the schedule $S = \{R1(A),R2(B),W2(A),W1(A)\}$ Assume that Transaction T1 has started execution before Transaction T2. Which of the following is TRUE in the above case? Allowed under Basic Timestamp ... Allowed under both Basic Timestamp Protocol and Thomas Write Rule. Not allowed under both Basic Timestamp Protocol and Thomas Write Rule.
asked
in
Databases
Aug 26, 2017
359
views
tbb-dbms-2
databases
transaction-and-concurrency
1
vote
1
answer
18
Test by Bikram | Databases | Test 2 | Question: 13
Consider the following table structures: CREATE TABLE dept(dno number PRIMARY KEY, dname varchar2(30)); CREATE TABLE emp(eno number PRIMARY KEY, ename varchar2(30), dno number references dept(dno) ON DELETE CASCADE ON UPDATE CASCADE) ... . Update on DEPT is always successful. Delete on DEPT is always successful. Update on EMP is always successful.
asked
in
Databases
Aug 26, 2017
451
views
tbb-dbms-2
databases
sql
2
votes
1
answer
19
Test by Bikram | Databases | Test 2 | Question: 12
Consider a table $R (A,B,C,D,E)$ where the functional dependencies are: $A \rightarrow B$ $B \rightarrow C$ $D \rightarrow E$ ... decomposition is: Dependency preserving and lossless. Dependency preserving and lossy. Neither dependency preserving nor lossless. Not dependency preserving but lossless.
asked
in
Databases
Aug 26, 2017
260
views
tbb-dbms-2
databases
database-normalization
9
votes
1
answer
20
Test by Bikram | Databases | Test 2 | Question: 11
Relation $L( p,q)$ is stored in $100$ blocks, with $50$ records per block (or tuples) of $L$ fitting in one block. Relation $K(m,n)$ is stored in $200$ blocks with $100$ ... $K$. Therefore, the total number of blocks required in the result of join operation is: ______ blocks.
asked
in
Databases
Aug 26, 2017
618
views
tbb-dbms-2
numerical-answers
databases
joins
Page:
1
2
3
4
5
6
...
43
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 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:...