Observe the following table CANDIDATE carefully and write the name of the RDBMS operation out of (i) SELECTION (ii) PROJECTION (iii) UNION (iv) CARTESIAN PRODUCT, which has been used to produce the output as shown in RESULT ? Also,find the Degree and Cardinality of the RESULT.

TABLE: CANDIDATE

No	NAME	STREAM
C1	AJAY	LAW
C2	ADITI	MEDICAL
C3	ROHAN	EDUCATION
C4	RISHAB	ENGINEERING

RESULT

No	NAME
C3	ROHAN

Write Addnew(Book) and Remove(Book) methods in Python to Add a new Book and Remove a Book from a List of Books, considering them to act as PUSH and POP operations of the data structure Stack.

Write the definition of a Method AFIND(CITIES) to display all the city names from a list of CITIES, which are starting with alphabet A.

For example:
If the list CITIES contains ['AHMEDABAD','CHENNAI','NEW DELHI','AMRITSAR','AGRA']

The following should get displayed
AHMEDABAD
AMRITSAR
AGRA

Differentiate between file modes r+ and w+ with respect to Python.

Observe the following table CANDIDATE carefully and write the name of the RDBMS operation out of (i) SELECTION (ii) PROJECTION (iii) UNION (iv) CARTESIAN PRODUCT, which has been used to produce the output as shown in RESULT ? Also,find the Degree and Cardinality of the RESULT.

TABLE: CANDIDATE

RESULT

Observe the following table carefully and write the names of the most appropriate columns, which can be considered as (i) candidate keys and (ii) primary key.