Public Model Question Paper

Download CBSE Class 12th Standard CBSE Computer Science question papers, sample papers, important questions, and previous year solved papers in PDF format. Get free study materials, NCERT solutions, and exam preparation resources for Class 12th Standard CBSE Computer Science

Questions:

Generic 2

10 x 2 = 20

Given the following truth table, device a Sum of Product(SOP) and Product of Sum(POS) form of boolean expression from it:

A	B	C	F(A,B,C)
0	0	0	1
0	0	1	1
0	1	0	1
0	1	1	1
1	0	0	0
1	0	1	1
1	1	0	1
1	1	1	0

Explain the following terms in short:
(i) DHTML
(ii) ISP

Find the output of the following program:
#include<iostream.h>
struct POINT
{
  int x,y,z;
};
void StepIn(POINT &P,int Step=1)
{
   P.x+=Step;
   P.y-=Step;
   P.z+=Step;
}
void StepOut(POINT &P,int step=1)
{
   P.x-=step;
P.y+=step;
   P.z-=step;
}
void main()
{
   POINT P1={15,25,5},P2={10,30,20};
   StepIn(P1);
   StepOut(P2,4);
   cout<<P1.x<<','<<P1.y<<','<<P1.z<<endl;
cout<<P2.x<<','<<P2.y<<','<<P2.z<<endl;
StepIn(P2,12);
cout<<P2.x<<','<<P2.y<<','<<P2.z<<endl;
}

What is the benefit of using default parameter/ argument in a function? Give a suitable example to illustrate it using C++ code.

Write code for a function void Convert(int T[], int Num) in c++, which reposition all the elements of the array by shifting the element to the last position.

0	1	2	3	4
22	25	70	32	12

The changed content will be:

0	1	2	3	4
25	70	32	12	22

Based on the following C++ code find out the expected correct output from the options i) to iv).Also find out the minimum and the maximum value that can be assigned to the variable Trick used in code at the time when value of Count is 3.
#include<iostream.h>
#include<conio.h>
#include<stdlib.h>
void main()
{
   char Status[][10]={"EXCEL","GOOD","OK"};
   int Turn=10,Trick;
   for(int Count=1;Count<4;Count++)
   {
   Trick =random(Count);
   cout<<Turn-Trick<<Status[Trick]<<"#";
   }
getch();
}
i) 10EXCEL#10EXCEL#80k#
ii) 10EXCEL#80k#9GOOD#
iii) 10EXCEL#9GOOD#10EXCEL#
iv) 10EXCEL#10GOOD#80k#

c^^

Answer the questions (i) and (ii) after going through the following program:
#include<iostream.h>
#include<string.h>
class Bazar
{
   char Type [ 20 ] ;
char Product [ 20 ] ;
int Qty ;
   float Price ;
Bazar ( ) / / Function 1
{
strcpy ( Type , "electronic" ) ;
     strcpy ( Product , "calculator" ) ;
     Qty = 10 ;
   Price = 225 ;
}
public:
   void disp ( )
{
   count<<Type<<"-"<<Product<<":" ;
     count<<Qty<<"@<<Price<<endl ;
   }
   void main ( )
   {
   Bazar B; / /Statement 1
B.disp ( ) ; / /Statement 1
}
(i) Will Statement 1 initialise all the data members for object B with the values given in the function 1? (Yes or No). Justify your answer suggesting the corrections to be made in the above code.
(ii) What shall be the possible output when the program gets executed? (assuming, if required the suggested corrections are made in the program).

What do you understand by primary key? Give a suitable example of the primary key from a table containing some meaningful data.

10.

Give the difference between the type casting and automatic type conversion. Also, give a suitable C++ code to illustrate both.

Generic 4

5 x 4 = 20

11.

Write a function in C++ to perform insert operation in a dynamic queue containing DVD's information (represented with the help of an array of structureDVD).
struct DVD
{
long No;
char title[20];
DVD *Link;
};

12.

Assuming the class GAMES as declard below, write a function in C++ to read the objects of GAMES from binary file GAMES.DAT and
display those details of those GAMES, which are meant for children of Age Range"8 to 13"
class GAMES
{
   int Gamecode;
char GameName[10];
   char *AgeRange;
public:
   void Enter()
{
   cin>>GameCode;
   gets(GameName);
gets(AgeRange);
}
void Display()
   {
   cout<cout< }
   char *AgeR() {return AgeRange;}
};

13.

List the output of the program below.In other words, everytime there is a cout statement, list the values that will appear on the screen.
#include<iostream.h>
#include<conio.h>
void main()
{
clrscr();
for(int i=1;i<3;i++)
   for(int j=1;j<=5;j+=2)
   cout<<i<<"*"<<j<<"="<<i*j<<endl;
double a=1;
while(a<32)
   a*=2;
cout<<"a="<<a<<endl;
i=8,j=3;
int k=i/j;
double b=i/j;
double c=((double)i/(double)j);
cout<<"Now k="<<k<<", b="<<b<<", c="<<c<<endl;
getch();
}

14.

Answer the questions (i) to (iii) based on the following code:
class Stationary
{
   char Type;
   char Manufacturer[10];
   public:
   stationary();
void Read_sta_details();
   void Disp_sta_details();
};
class office : public stationary
{
int no_of_types;
   float cost_of_sta;
   public:
   void Read_off_details();
void Disp_off_details();
};
class printer : private office
{
int no_of_user;
   char delivery_details[10];
public:
   void Read_pri_details();
void Disp_pri_details();
};
void main()
{
   printer MyPrinter;
}
(i)Mention the member names, which are accessible by MyPrinter declared in main() function.
(ii) What is the size of MyPrinter in bytes?
(iii) Mention the names of functions accessible from the member function Read_pri_details() of class printer.

15.

Write a program using three functions to calculate the volume of a cube, a cylinder, and a rectangular box.The function names should be the same.

Generic 3

5 x 3 = 15

16.

Evaluate the following postfix expression using a stack.Show the contains of stack after execution of each operation.
TRUE,FALSE,TRUE,FALSE,NOT,OR,TRUE,OR,OR,AND

17.

Give the output of the following program segment.(Assume all required hedder files are included in the program).
#include<iostream.h>
void main()
{
int a=32,*X=&a;
char ch=65,&eco=ch;
eco+=a;
*X+=ch;
cout<,a<<','<<ch<<end1;
}

18.

Give the output of the following program segment:(Assume all desired header file(s) are already included)
void main()
{
  float *ptr,Ponts[]={20,50,30,40,10};
Ptr=points;
  cout<<*ptr<<end1;
ptr+=2;
  ponits[2]+=2.5;
cout<<*ptr<<end1;
  ptr++;
  (*ptr)+=2.5;
cout<<points[3]<<end1;
}

19.

To print the number from 1 to 10 with help of do-while loop.

20.

To know the use of if-else statement.

Fill up / 1 Marks

10 x 1 = 10

21.

Write the dual of the boolean expression \((A+0).(A.1.\bar { A } )\)

22.

Write the product of Sum (POS) form of the function G(U,V,W) for the following truth table representation of G:

U	V	W	G
0	0	0	1
0	0	1	0
0	1	0	1
0	1	1	0
1	0	0	1
1	0	1	0
1	1	0	0
1	1	1	1

23.

Why GNU is known as "GNU Not Unix"?

24.

What is modem?

25.

Give the SQL statement to create a table STUDENT with Roll Number, Name, Age and Marks.

26.

An array circular queue[10] of integers exixt,where currently
Rear=0, Front=1
Answer the following questions based on the above given data:
(i) How many values arte there in queue?
(ii) If five valuesare deleted,whatwould be the new value of Front?

27.

What is the purpose of header files in a program?

28.

How many times is the loop executed?
int i=0, j=0;
do
{
i=j;
}
while(j<5);

29.

In function overloading how is matching done?

30.

Give the output of the following program:
int a=44;
cout<<a++<<"\t"<<a<<"\n"<<++a;
cout<<endl<<a<<endl;

Generic 6

5 x 6 = 30

31.

Write SQL commands for (a) to (g) and write the outputs for (h) on the basis of table COLLEGE
TABLE: COLLEGE

No	Name	Age	Department	Dateof Join	Basic	Sex
1	Shalaz	45	Biology	13/02/88	10500	M
2	Sammera	54	Biology	10/01/90	9500	F
3	Yagyen	43	Physics	27/02/98	8500	M
4	Pratyush	34	Chemistry	11/01/93	7500	M
5	Aren	51	Mathematics	22/01/91	8500	M
6	Reeta	27	Chemistry	14/02/94	9000	F
7	Urvashi	29	Biology	10/02/93	8500	F
8	Teena	35	Mathematics	02/02/89	10500	F
9	Viren	49	Mathematics	03/01/88	9000	M
10	Prakash	22	Physics	17/02/92	8000	M

(a) To change the Basic salary to 10500 of all those teachers from college who joined the COLLEGE after 01/02/89 and are above the age of 50.
(b) To display Name, Age and Basic of all those from COLLEGE, who belong to Physics and Chemistry department only.
(c) To display all the department names from COLLEGE with no duplication.
(d) To list names of all teachers from COLLEGE with their date of joining in ascending order within their Basic salaries in ascending order.
(e) To display maximum salary amongst the female teachers and also amongst the male teachers from COLLEGE.(Give a single command)
(f) To insert a new row in the table COLLEGE with the following data:
15,"ATIN",27,"Physics",'15/05/02',8500,"M"
(g) To delete a row from table COLLEGE in which NAME is VIREN.
(h) Give the output of the following SQL statements:
(i) SELECT COUNT(Name) FROM COLLEGE;
(ii) SELECT MIN(Basic)FROM COLLEGE WHERE Age>40;

32.

Write SQL commands for (a) to (g) on the basis of the table SPORTS
TABLE: SPORTS

STUDENTNO	CLASS	NAME	GAME1	GRADE	GAME2	GRADE1
10	7	Sameer	Cricket	B	Swimming	A
11	8	Sujit	Tennis	A	Skating	C
12	7	Kamal	Swimming	B	Football	B
13	7	Veena	Tennis	C	Tennis	A
14	9	Archana	Basketball	A	Cricket	A
15	10	Arpit	Cricket	A	Atheletics	C

(a) Display the names of the students, who have grade 'C' in either GAME1 or GAME2 or both.
(b) Display the number of students getting grade'A' in cricket.
(c) Display the names of the students who have same game for both GAME1 and GAME2.
(d) Display the games taken up by the students, whose name starts with 'A'.
(e) Add a new column names MARKS.
(f) Assign a value 200 for Marks for all those who are getting grade 'B' or grade 'A' in both GAME1 and GAME2.
(g) arrange the whole table in the alphabetical order of NAME.

33.

Given the following family relation. Write SQL commands for questions (a) to (f) and output of (g) based on the table FAMILY
TABLE: FAMILY

NO	NAME	FEMALE MEMBERS	MALEMEMBERS	INCOME	OCCUPATION
1	Mishra	3	2	7000	Service
2	Gupta	4	1	50000	Business
3	Khan	6	3	8000	Mixed
4	Chaddha	2	2	25000	Business
5	Yadav	7	2	20000	Mixed
6	Joshi	3	2	14000	Service
7	Mayura	6	3	5000	Farming
8	Rao	5	2	10000	Service

(a) To select all the information of family, whose Occupation is service.
(b) To list the name of family, where female members are more than 3.
(c) To list all names of family with income in ascending order.
(d) To display family's name, male members and occupation of business family.
(e) To count the number of family, whose income is less than 10,000.
(f) To insert a new record in the FAMILY table with the following data
9,"D'SOUZA",2,1,15000,"Service"
(g) Give the output of the following SQL commands
(i) SELECT MIN(DISTINCT Income) FROM FAMILY;
(ii) SELECT MIN(FemaleMembers) FROM FAMILY WHERE Occupation='Mixed';
(iii) SELECT SUM(Income) FROM FAMILY WHERE Occupation='Service';
(iv) SELECT AVG(Income) FROM FAMILY;

34.

Consider the following tables CUSTOMER and ONLINESHOP.Write SQL commands for the statements (a) to (d) and give outputs for SQL queries(e) to (h).
TABLE: CUSTOMER

CID	CNAME	GENDER	SID	AREA
1001	R SHARMA	FEMALE	101	NORTH
1002	M R TIWARY	MALE	102	SOUTH
1003	M K KHAN	MALE	103	EAST
1004	A K SINGH	MALE	102	EAST
1005	S SEN	FEMALE	101	WEST
1006	R DUBEY	MALE	104	NORTH
1007	M AGARWAL	FEMALE	104	NORTH
1008	S DAS	FEMALE	103	SOUTH
1009	R K PATIL	MALE	102	NORTH
1010	N KRISHNA MURTY	MALE	102	SOUTH

TABLE: ONLINESHOP

SID	SHOP
101	MY BUY
102	ECO BUY
103	JUST SHOPPING
104	SHOPPING EASY

(a) To display CNAME, AREA of all female customers from CUSTOMER table.
(b) To display the details of all the CUSTOMERS in ascending order of CNAME within SID.
(c) To display the total number of customers for each AREA from CUSTOMER table.
(d) to display CNAME and corres[ponding SHOP from CUSTOMER table and ONLINESHOP table.
(e) SELECT COUNT(*), GENDER FROM CUSTOMER GROUP BY GENDER;
(f) SELECT COUNT(*) FROM ONLINESHOP;
(g) SELECT CNAME FROM CUSTOMER WHERE CNAME LIKE 'L%';
(h) SELECT DISTINCT AREA FROM CUSTOMER;

35.

Write SQL queries for (a) to (f) and write the output for the SQL queries mentioned in (g) parts (i) to (iv) on the basis of tables ITEMS and TRADERS.
TABLE: ITEMS

code	IName	Qty	price	company	Tcode
1001	DIGITAL PAD 121	120	11000	XENITA	T01
1006	LED SCREEN 40	70	38000	SANTORA	T02
1004	CAR GPS SYSTEM	50	2150	GEOKNOW	T01
1003	DIGITAL CAMERA 12X	160	8000	DIGICLICK	T02
1005	PEN DRIVE 32 GB	600	1200	STOREHOME	T03

TABLE: TRADERS

Tcode	TName	City
T01	ELECTRONIC SALES	MUMBAI
T03	BUSY STORE CORP	DELHI
T02	DISP HOUSE INC	CHENNAI

(a) To display the details of all the items in ascending order of item names(i.e. INAME).
(b) To display item name and price of all those items whose price is in the range of 10000 nd 22000(both values inclusive)
(c) To display the number of items, which are traded by each trader. The expected output of this query should be:

T01	2
T03	1
T02	2

(d) To display the Price, item name(ie.name) and quantity(ie.Qty) of those items, which have quantity more than 150.
(e) To display the names of those traders, who are either from DELHI or from MUMBAI.
(f) To display the name of the companies and the name of the items in descending order of company names.
(g) Obtain the outputs of the following SQL queries based on the data given in the tables ITEMS and TRADERS above.
(i) SELECT MAX(Price), MIN(Price) FROM ITEMS;
(ii) SELECT Price * Qty AMOUNT
FROM ITEMS WHERE Code=1004;
(iii) SELECT DISTINCT Tcode FROM ITEMS;
(iv) SELECT IName, TName
FROM ITEMS I, TRADERS T
WHERE I.Code=T.TCode AND Qty<100;

Visit QB365-SLMS - https://www.qb365.in/slms/

Answers Key:

Generic 2

10 x 2 = 20

A	B	C	F	MInterms	Maxterm
0	0	0	1	\(\bar { A } .\bar { B } .\bar { C } \)
0	0	1	1	\(\bar { A } .\bar { B } .C\)
0	1	0	0		\(A+\bar { B } +C\)
0	1	1	1	\(\bar { A } .B.C\)

A	B	C	F	Minterms	Maxterm
1	0	0	0		\(\bar { A } +B+C\)
1	0	1	1	\(A.\bar { B } .C\)
1	1	0	1	\(A.B.\bar { C } \)
1	1	1	0		\(\bar { A } +\bar { B } +\bar { C } \)

Sum of Products(SOP) expression contain sum of all minterms for output as 1.
   \(=\bar { A } .\bar { B } .\bar { C } +\bar { A } .\bar { B } .C+\bar { A } .B.C+A.\bar { B } .C+A.B.\bar { C } \)
   \(=\sum (0,1,3,5,6)\)
Product of Sum(POS) expression contains product of all maxterms for output as 0.
   \(=(A+\bar { B } +C).(\bar { A } +B+C).(\bar { A } +\bar { B } +\bar { C } )\quad \)
  \(=\prod (2,4,7)\)

(i) DHTML DHTML stands for Dynamic HyperText Markup Language. It refers to the web content that changes according to the user request. It will react the user input without sending requests to the web server.

(ii) ISP ISP stands for Internet Service Provider. It refers to the company that provides Internet Services. Some common examples of ISPs are Airtel, BSNL, Tata docomo, etc.

Output
16,24,6
6,34,16
18,22,28

A default parameter is a function parameter that has a default value provided to it. If the user does not supply a value for this parameter, the default value will be used.
If the user does supply a value for the default parameter, the user supplied value is used.
Consider the following program:
void Printvalues(int nValue1, int nValue2=10)
{
   cout<<"1st value:"<<nValue1<<endl;
   cout<<"2nd value:"<<nValue2<<endl;
}
int main()
{
   PrintValue(1);
   //nValues2 will use default parameter
//of 10
   PrintValues(3,4);
   //override default value for nValue2
   return 0;
}
Output
1st value:1
2nd value:10
1st value:3
2nd value:4

#include
void Cnver(int T[], int Num)
{
int temp = t[0];
for(int i=0;i<(Num-1);i++)
{
T[i]=T[i+1];
}

i) and iii)
Minimum value =0
Maximum value=2

C^^

(i) No. Since, the default constructor Bazar ( ) is declared inside private section, it cannot initialise Correction needed is:
The constructor Bazar ( ) should be declared inside public section.
(ii) Output
Electronic-calculator : 10@225

A primary key is a set of one or more attributes that can uniquely identify tuples within the relation.
e.g. Table: Item

ItemNo	Name	State	City
11	Pastry	10	Ajmer
12	Pizza	15	Delhi
13	Cake	5	Puna
14	Burger	35	Delhi

The attribute ItemNo is a primary key in ITEM table as it contains a unique value for each tuple in a relation.

10.

Type casting It is used by the programmer to convert value of one type to another type. It is forced type conversion. It is done by putting the target datatype in parentheses before the data to be converted.
e.g. float X=(double)15/6);

Automatic type conversion It is automatically done by the compiler itself wherever required. It is implicit type conversion
e.g. float X=3;

Generic 4

5 x 4 = 20

11.

void Insert()
{
   DVD *p=new DVD;
count<<"Enter the DVD Number and Title";
cin>>p->No;
gets(p->title);
p->Link = NULL);
if((front == NULL )&& (rear == NULL))
{
   front = rear = p;
}
   else
{
   rear->Link=p;
rear = p;

}

12.

void READGAMES()
{
  GAMES obj;
  ifstream infile(:GAMES.DAT:);
while(infile.read((char*)&obj,sizeof(obj)))
{
   if(strcmp(obj.Agr(),"8 to 13")==0)
   obj.Display();
}
  infile.close();
}

13.

1*1=1
1*3=3
1*5=5
2*1=2
2*3=6
2*5=10
a=32
Now k=2, b=2, c=2.666667

14.

(i) Data members: None
member functions: Read_pri_details(), Disp_pri_details().
(ii) 29 Bytes

(iii) Member functions: Read_sta_details(), Disp_sta_details(), Read_off_details(),
Disp_off_details(), Disp_pri_details().

15.

#include<iostream.h>
#include<conio.h>
int volume(int a);
double volume(float r, int h);
int volume(int 1, int b, int h);
void main()
{
int a, l, b, h;
float r:
clrscr();
cout<<"Enter the side of cube ";
cin>>a;
cout<<"Enter the radius and height of cylinder ";
cin>>r>>h;
cout<<"\nEnter the side of rectangular cube\n";
cin>>l>>b>>h;
cout<<"Volume of cube="<<volume(a);
cout<<"\nVolume of cylinder="<<volume(r,h);
cout<<"\nVolume of rectangular cube="<<volume(l,b,h);
getch();
}
int volume(int a)
{
return(a*a*a);
}
double volume(float r, int h)
{
return(3.1461*r*r*h);
}
int volume (int l, int b, int h)
{
return(l*b*h);
}
Output
Enter the side of cube 2
Enter the radius and height of cylinder 2 3
Enter the side of rectangular cube
3 4 5
Volume of cube=8
Volume of cylinder=62.922
Volume of rectangular cube=60

Generic 3

5 x 3 = 15

16.

In the given, expression true and false are operands and AND, NOT and OR operators.

Scanned Elements	operation	Stack Status
TRUE	PUSH TRUE	TRUE
FALSE	PUSH FALSE	TRUE,FALSE
TRUE	PUSH TRUE	TRUE,FALSE,TRUE
FALSE	PUSH FALSE	TRUE,FALSE,TRUE,FALSE
NOT	POP one operand NOT FALSE=TRUE PUSH TRUE	TRUE,FALSE,tRUE,TRUE
OR	POP two operands Evaluate: TRUE OR TRUE=TRUE PUSH TRUE	TRUE,FALSE,tRUE
TRUE	PUSH TRUE	TRUE,FALSE,TRUE,TRUE
OR	POP two operands Evaluate: TRUE OR TRUE=TRUE PUSH TRUE	TRUE,FALSE,TRUE
OR	POP two operands Evaluate: FALSE OR TRUE=TRUE PUSH TRUE	TRUE,TRUE
AND	POP two operands AND TRUE=TRUE PUSH TRUE	TRUE

Output TRUE

17.

129,a

18.

Output
20
32.5
42.5

19.

#include<iostream.h>
#include<conio.h>
void main()
{
int digit =1;
do
{
cout<<digit++<<" ";

}
while(digit<=10);
getch();
}
Output
1 2 3 4 5 6 7 8 9 10

20.

#include<iostream.h>
void main()
{
   int code;
   code =1;
if( code==1)
cout<<" The water was too warm\n"
   else
cout<<" the water were all finished";
}
Output:
The water was too warm
Some of valid if-else statements are:
(i) If ((ch >= 'a') && (ch <= 'z'))
   cout<<ch<<" is a lowercase letter";
else
   cout<<ch<<" is not a lowercase letters";
(ii) if((age == 50) || (age >= 20))
   cout<<" You are old";
else
cout<<" You are young";

Fill up / 1 Marks

10 x 1 = 10

21.

()
Using duality principle, changing (+) to (.) and vice-versa and by replacing 0's with 1's and 1's with 0's, the dual for the given expression is as follows:\((A.1)+(A+0+\bar { A } )\)

22.

()

U	V	W	G	Maxterms
0	0	0	1	U+V+W
0	0	1	0	\(U+V+\bar { W } \)
0	1	0	1	\(U+\bar {V}+ W \)
0	1	1	1	\(U+\bar {V}+\bar { W } \)
1	0	0	1	\(\bar {U}+V+W \)
1	0	1	0	\(\bar{U}+V+\bar { W } \)
1	1	0	0	\(\bar {U}+\bar {V}+W \)
1	1	1	1	\(\bar {U}+\bar {V}+\bar { W } \)

POS form of function G(U,V,W) is : \((U+V+\bar { W } ).(U+\bar { V } +\bar { W } ).(\bar { U } +V+\bar { W } ).(\bar { U } +\bar { V } +W)\)

23.

()
GNU is a recursive acronym for "GNU Not Unix", which was selected because its design is similar to Unix but it does not contain actual UNIX code.

24.

()
A modem is a data communication equipment that facilitates data communication through telephone lines. It is used to convert digital data into analog and vice-versa.

25.

()
CREATE TABLE STUDENT( ROLL Number NUMBER(5) Primary key, Name CHAR(20), Age NUMBER(2), MARKS NUMBER(4));

26.

()
(i) 10
(ii) Front = 6

27.

()
Header files provide function prototype declarations for library functions.Header files are also known as include files

28.

()
Infinite loop because the value of i and j is always equal to zero.

29.

()
In function overloading, the matching is done on the basis of number of argument and types of argument.If two functions have same argument,then matching is done on the basis of sequence
or type of arguments.There is no rule of matching on the basis of return type.

30.

()
The output is as
45 45
45
46

Generic 6

5 x 6 = 30

31.

(a)UPDATE COLLEGE SET Basic=10500
WHERE DateofJoin>'01/02/89' AND Age>50;
(b) SELECT Name, Age, Basic From COLLEGE
WHERE Department='Physics' OR Department='Chemistry';
(c)SELECT DISTINCT Department FROM COLLEGE;
(d) SELECT Name, DateofJoin, Basic FROM COLLEGE ORDER BY Basic, DateofJoin;
(e) SELECT MAX(Basic) FROM COLLEGE GROUP BY SEX;
(f) INSERT INTO COLLEGE VALUES(15,'ATIN',27 'Physics','15/05/02'8500,'M');
(g) DELETE FROM COLLEGE WHERE Name='VIREN';
(h) The output is given after excluding the insertion and deletion of rows performing in above queries.
(i)

COUNT(Name)

(ii)

MIN(Basic)

8500

32.

(a) SELECT NAME FROM SPORTS WHERE GRADE ='C' OR GRADE1='C';
(b) SELECT COUNT (*) FROM SPORTS
WHERE (GAME1='CRICKET' AND GRADE='A') OR (GAME2='CRICKET'AND GRADE1='A');
(c) SELECT NAME FROM SPORTS WHERE GAME1=GAME2;
(d) SELECT GAME1, GAME2 FROM SPORTS WHERE NAME LIKE 'A%';
(e) ALTER TABLE SPORTS ADD(MARKS NUMBER(3));
(f) UPDATE SPORTS SET MARKS=200
WHERE GRADE ='A' OR GRADE='B' OR GRADE1='A' OR GRADE1='B';
(g) SELECT * FROM SPORTS ORDER BY NAME;

33.

(a) SELECT * FROM FAMILY WHERE Occupation='Sservice';
(b) SLECT Name FROM FAMILY WHERE FemaleMembers>3;
(c) SELECT Name, Income FROM FAMILY ORDER BY Income;
(d) SELECT N\ame, MaleMembers, Occupation FROM FAMILY WHERE Occupation='Business';
(e) SELECT COUNT(*) FROM FAMILY WHERE Income<10000;
(f) INSERT INTO FAMILY VALUES(9,'D'SOUZA',2,1,15000,'Service');
(g) The output is given after excluding the row given in part(f)
(i)

MIN(DISTINCT Income)

5000

(ii)

MIN(FemaleMembers)

(iii)

SUM(I|ncome)

31000

(iv)

AVG(Income)

17375

34.

(a)SELECT CNAME,AREA FROM CUSTOMER
WHERE GENDER ='FEMALE';
(b) SELECT * FROM CUSTOMER ORDER BY SID, CNAME;
(c) SELECT AREA COUNT(*) FROM CUSTOMER GROUP BY AREA;
(d) SELECT CUSTOMER .CNAME, ONLINESHOP.SHOP
FROM CUSTOMER, ONLINESHOP WHERE CUSTOMER.SID=ONLINESHOP.SID;
(e)

COUNT(*)	GENDER
4	FEMALE
6	MALE

(f)

COUNT(*)

(g) No rows selected.
(h)

DISTINCT AREA

NORTH

SOUTH

EAST

WEST

35.

(a) SELECT *FROM ITEMS ORDER BY IName;
(b) SELECT IName, Price FROM ITEMS
   WHERE Price BETWEEN 10000 AND 22000;
(c) SELECT TCode, COUNT(*) FROM ITEMS
   GROUP BY TCode;
(d) SELECT Price, IName, Qty
   FROM ITEMS
   WHERE Qty>150;
(e) SELECT TName
   FROM TRADERS
   WHERE City ='MUMBAI' OR City='DELHI';
(f) SELECT Company, IName
FROM ITEMS
ORDER BY Company DESC;
(g) (i)