PYQBOOK

Filter Questions

Exam

Branch

Paper-Name

Subject

Topic

Found 475 question(s)

Q106 NAT GATE CS Medium 2 Marks 2024

DBMS → Relational Algebra

Consider two relations R(A,B) with tuples (10,20), (20,30), (30,45), (30,40), (80,30), (50,50) and S(A,C) with tuples (10,90), (20,30), (30,40), (40,80), (50,95). The total number of tuples obtained by evaluating the expression σ_{B<C}(R ⨝_{R.A=S.A} S) is

Enter Numerical Answer:

Q107 MCQ GATE CS Easy 1 Mark 2024

DBMS → Relational Model

Which one of the options given below refers to the degree (or arity) of a relation in relational database systems?

Choose One:

A) Number of attributes of its relation schema.

B) Number of tuples stored in the relation.

C) Number of entries in the relation.

D) Number of distinct domains of its relation schema.

Q108 NAT GATE CS Easy 2 Marks 2024

DBMS → SQL

A table Student has rows (1, Naman, M, 62), (2, Aliya, F, 70), (3, Aliya, F, 80), (4, James, M, 82), (5, Swati, F, 65). The query 'SELECT * FROM Student WHERE gender = 'F' AND marks > 65;' returns how many rows?

Enter Numerical Answer:

Q109 NAT GATE CS Medium 1 Mark 2024

DL → Number Representation

A particular number is written as 132 in radix-4 representation. The same number in radix-5 representation is

Enter Numerical Answer:

Q110 MCQ GATE CS Medium 1 Mark 2024

DL → Number Representation

Consider a system that uses 5 bits for representing signed integers in 2's complement format. In this system, two integers A and B are represented as A=01010 and B=11010. Which one of the following operations will result in either an arithmetic overflow or an arithmetic underflow?

Choose One:

A) A+B

B) A-B

C) B-A

D) 2*B

1
2
3
.....
20
21
22
23
24
.....
93
94
95