Find the output of the following C++ code considering that the binary file MEM.DAT exists on the hard disk with a data of 1000 members.

class MEMBER
{
	int Mcode;char MName[20];
public:
	void Register();void Display();
};
void main()
{
	fstream MFile;
	MFile.open('MEM.DAT',ios::binary|ios::in);
	MEMBER M;
	MFile.read((char*)&M, sizeof(M));
	cout<<'Rec:'<<MFile.tellg()/sizeof(M)<<endl;
	MFile.read((char*)&M, sizeof(M));
	MFile.read((char*)&M, sizeof(M));
	cout<<'Rec:'<<MFile.tellg()/sizeof(M)<<endl;
	MFile.close();
}

Find the output of the following C++ code considering that the binary file MEM.DAT exists on the hard disk with a data of 1000 members.

class MEMBER
{
	int Mcode;char MName[20];
public:
	void Register();void Display();
};
void main()
{
	fstream MFile;
	MFile.open('MEM.DAT',ios::binary|ios::in);
	MEMBER M;
	MFile.read((char*)&M, sizeof(M));
	cout<<'Rec:'<<MFile.tellg()/sizeof(M)<<endl;
	MFile.read((char*)&M, sizeof(M));
	MFile.read((char*)&M, sizeof(M));
	cout<<'Rec:'<<MFile.tellg()/sizeof(M)<<endl;
	MFile.close();
}

Give a suitable example of a table with sample data and illustrate Primary and Alternate Keys in it.

Consider the following tables CARDEN and CUSTOMER and answer (b) and (c) parts of question:

TABLE: CARDEN

TABLE: CUSTOMER

Write SQL commands for the following statements:

1. To display the names of all the silver colored
2. To display name of car, make and capacity of cars in descending order of their sitting
3. To display the highest charges at which a vehicle can be hired from
4. To display the customer name and the corresponding name of the cars hired by them

Consider the following tables CARDEN and CUSTOMER and answer (b) and (c) parts of question:

TABLE: CARDEN

TABLE: CUSTOMER

Give the output of the following SQL queries:

1. SELECT COUNT(DISTINCT Make) FROM CARDEN;
2. SELECT MAX(Charges),MIN(Charges) FROM CARDEN;
3. SELECT COUNT(*),Make FROM CARDEN;
4. SELECT CarName FROM CARDEN WHERE Capacity=4;