List of practice Questions

Let us consider two relations Student and Major as shown in Table 1 and Table 2 respectively.
Table 1 : Student

Sr No.	Name	Course
1.	Aman	CS
2.	Ravi	ECO
3.	Mohit	HIS
4.	Sanjay	MATH

Table 2 : Major

Sr.No	Name	Course
1.	Sanjay	MATH
2.	Abhay	ENG
3.	Sita	HINDI
4.	Aman	CS
5.	Ravi	ECO

How many Tuples will be in the result table after Student U Major operation.

Which of the following statement(s) is/are true?

A. Selection operation yields horizontal subset of a relation.
B. Selection operation yields vertical subset of a relation.
C. Union operator can work on relation with different degree.
D. Intersection and Cartesian product operations are not binary.
E. A record is a column on a datasheet.

Let us consider two relations HISTORY and SCIENCE as depicted in the following Tables 1 and 2 respectively: 

Table 1: HISTORY

SNo	NAME	CLASS
1	MOHAN	6A
2	SANJAY	6B
3	YOGESH	7A

Table 2: SCIENCE

SNo	NAME	CLASS
1	NARESH	6B
2	SANJAY	6B
3	YOGESH	7A

 
What is the output of HISTORY - SCIENCE?