1
GATE CSE 1999
MCQ (Single Correct Answer)
+1
-0.3

The relational algebra expression equivalent to the following tuple calculus expression:

$$\left\{ {t|t \in r \wedge \left( {t\left[ A \right] = 10 \wedge t\left[ B \right] = 20} \right)} \right\}$$ is:
A
$${\sigma _{\left( {A = 10 \vee B = 20} \right)}}\left( r \right)$$
B
$${\sigma _{\left( {A = 10} \right)}}\left( r \right) \cup {\sigma _{\left( {B = 20} \right)}}\left( r \right)$$
C
$${\sigma _{\left( {A = 10} \right)}}\left( r \right) \cap {\sigma _{\left( {B = 20} \right)}}\left( r \right)$$
D
$${\sigma _{\left( {A = 10} \right)}}\left( r \right) - {\sigma _{\left( {B = 20} \right)}}\left( r \right)$$
2
GATE CSE 1999
MCQ (Single Correct Answer)
+2
-0.6
For the schedule given below, which of the following is correct: GATE CSE 1999 Database Management System - Transactions and Concurrency Question 29 English
A
This schedule is serialized and can occur in a scheme using 2PL protocol
B
This schedule is serializable but cannot occur in a scheme using 2PL protocol
C
This schedule is not serializable but can occur in a scheme using 2PL protocol
D
This schedule is not serializable and cannot occur in a scheme using 2PL protocol.
3
GATE CSE 1999
MCQ (Single Correct Answer)
+1
-0.3
Which of the following is correct?
A
B-trees are for storing data on disk and B+ trees are for main memory.
B
Range queries are faster on B+ trees.
C
B-trees are for primary indexes and B+ trees are for secondary indexes.
D
The height of a B+ tree is independent of the number of records.
4
GATE CSE 1999
MCQ (More than One Correct Answer)
+2
-0
Zero has two representations in:
A
Sign magnitude
B
$$1's$$ complement
C
$$2's$$ complement
D
None of the above
EXAM MAP
Medical
NEETAIIMS
Graduate Aptitude Test in Engineering
GATE CSEGATE ECEGATE EEGATE MEGATE CEGATE PIGATE IN
Civil Services
UPSC Civil Service
Defence
NDA
Staff Selection Commission
SSC CGL Tier I
CBSE
Class 12