Skip to content
← 2019

Computer Science · 2019 · Set 91/4

CBSE Class 12 Computer Science 2019 — Set 91/4

CBSE Class XII Board 2019 · Set 91/4

Real board examination⚠ Old pattern · pre-2020 syllabus

This paper has 24 questions on a topic removed in CBSE’s 2023-24 syllabus update (each marked Not in syllabus). It’s kept for historical accuracy — the exam really asked it that year — but isn’t in the current syllabus and doesn’t count toward a concept’s importance. Switch to to focus on what’s still examinable.

About this paper

The real Class-12 board examination held in 2019. Every question below is solved the concept-first way. Sample papers are labelled honestly — never shown as a past exam.

Total marks
—
Questions
—
Duration
—
Sections
—

The marks / questions / duration above are the official exam pattern. We currently have 46 of this paper’s questions, with 46 fully solved and 3 being re-checked for symbol-extraction issues. Questions we couldn’t yet extract or verify are held — never shown as complete.

The question paper

The questions we hold for this paper, laid out by section. Solutions are on the Answers tab.

Board Examination

Computer Science

CBSE Class XII Board 2019 · Set 91/4

Series/Set: 91/4Roll No. ________
Time Allowed: —Maximum Marks: —
Section A

Q1.
Write the names of the correct header files, which must be included in the following C++ code to compile the code successfully: void main() { char L[]="CS 2018"; int N=strlen(L); cout<<L[N-1]; }
⚠ This question is not in the current syllabus — C++ — discontinued language, not in the current Python-only syllabus
[1]
Q2.
Find the output of the following C++ code considering that the binary file STOCK.DAT exists on the hard disk with the following 5 records for the class STOCK containing Name and Price. Name Price Rice 110 Wheat 60 Cheese 200 Pulses 170 Sauce 150 void main() { fstream File; File.open("STOCK.DAT",ios::binary|ios::in); Stock S; for (int I=1; I<=2; I++) { File.seekg((2*I-1)sizeof(S)); File.read((char)&S, sizeof(S)); cout << "Read : " << File.tellg()/sizeof(S)<< endl; } File.close(); }
(OR)
Differentiate between seekg() and tellg().
⚠ This question is not in the current syllabus — C++ — discontinued language, not in the current Python-only syllabus
[1]
Q3.
Write the names of any four fundamental data types of C++.
⚠ This question is not in the current syllabus — C++ — discontinued language, not in the current Python-only syllabus
[2]
Q4.
Rewrite the following C++ program after removing any/all syntactical error(s). Underline each correction done in the code: Note : Assume all required header files are already included in the program. #define Area(L,B) = L*B structure Recta { int Length,Breadth; }; void main() { Recta R = [10,15]; cout<<Area(Length.R,Breadth.R); }
⚠ This question is not in the current syllabus — C++ — discontinued language, not in the current Python-only syllabus
[2]
Q5.
Find and write the output of the following C++ program code: Note : Assume all required header files are already included in the program. void Alter(char *S1, char *S2) { char T; T=S1; S1=S2; S2=T; cout<<S1<<"&"<<S2<<end1; } void main() { char X[]="First", Y[]="Second"; Alter(X,Y); cout<<X<<""<<Y<<end1; }
⚠ This question is not in the current syllabus — C++ — discontinued language, not in the current Python-only syllabus
[2]
Page 1 of 9
Q6.
Observe the following C++ code and find the possible output(s) from the options (i) to (iv) following it. Also, write the minimum and maximum values that can possibly be assigned to the variable End. Note : Assume all the required header files are already being included in the code. The function random(N) generates any possible integer between 0 and N-1 (both values included). void main() randomize(); int A[]=10,20,30,40,50,60,70,80; int Start = random(2) + 1; int End = Start + random(4); for(int I=Start; I<=End, I++) cout<<A[I]<<""; (i) 102030 (ii) 2030405060 (iii) 30405060 (iv) 40506070
⚠ This question is not in the current syllabus — C++ — discontinued language, not in the current Python-only syllabus
[2]
Q7.
Given the following class Test and assuming all necessary header file(s) included, answer the questions that follow the code: class Test int Marks; char TName[20]; public: Test(int M) //Function 1 Marks = M; Test(char S[]) //Function 2 strcpy(TName,S); Test(char S[], int M) //Function 3 Marks = M; strcpy(TName,S); Test(Test T) //Function 4 Marks = T.Marks + 10; strcpy(TName,T.TName); ; void main() Test T1(10); //Statement I Test T2(70); //Statement II Test T3(30, "PRACTICAL"); //Statement III ________; //Statement IV (i) Which of the statement(s) out of (I), (II), (III), (IV) is/are incorrect for object(s) of the class Test? (ii) What is Function 4 known as? Write the Statement IV, that would execute Function 4.
⚠ This question is not in the current syllabus — C++ — discontinued language, not in the current Python-only syllabus
[2]
Q8.
Observe the following C++ code and answer the questions (i) and (ii). Note : Assume all necessary files are included. class Point int X,Y; public: Point(int I=10, int J=20) //Function 1 X = J; Y = I; void Show() //Function 2 cout<< " Points are " << X << " " << Y <<endl; ~Point() //Function 3 cout<<"Points Erased"<<endl; ; void main() Point P(5); P.Show(); (i) For the class Point, what is Function 3 known as? When is it executed? (ii) What is the output of the above code, on execution? OR Explain Polymorphism in context of Object Oriented Programming. Also give a supporting example in C++.
⚠ This question is not in the current syllabus — C++ — discontinued language, not in the current Python-only syllabus
[2]
Q9.
⚠ This question is not in the current syllabus — C++ — discontinued language, not in the current Python-only syllabus
[2]
Q10.
Evaluate the following Postfix expression, showing the stack contents: 250,45,9,/,5,+,20,*,- OR Convert the following Infix expression to its equivalent Postfix expression, showing the stack contents for each step of conversion: A + B * C ^ D - E
⚠ This question is not in the current syllabus — C++ — discontinued language, not in the current Python-only syllabus
[2]
Q11.
Write a user-defined function TotalPrice() in C++ to read each object of a binary file STOCK.DAT, and display the Name from all such records whose Price is above 150. Assume that the file STOCK.DAT is created with the help of objects of class Stock, which is defined below: class Stock char Name[20]; float Price; public: char* RName() return Name; float RPrice() return Price; ; OR A binary file DOCTORS.DAT contains records stored as objects of the following class: class Doctor int DNo; char Name[20]; float Fees; public: int *GetNo() return DNo; void Show() cout<<Dno<<" * " <<Name<< " * " <<Fees<<endl; ; Write definition for function Details(int N) in C++, which displays the details of the Doctor from the file DOCTORS.DAT, whose DNo matches with the parameter N passed to the function.
⚠ This question is not in the current syllabus — C++ — discontinued language, not in the current Python-only syllabus
[2]
Page 2 of 9
Q12.
Find and write the output of the following C++ program code: Note : Assume all required header files are already included in the program. void Convert(float X, int Y=2) X=X/Y; Y=X+Y; cout<<X<<"*"<<Y<<endl; void main() float M=15, N=5; Convert(M,N); Convert(N); Convert(M);
⚠ This question is not in the current syllabus — C++ — discontinued language, not in the current Python-only syllabus
[3]
Q13.
⚠ This question is not in the current syllabus — C++ — discontinued language, not in the current Python-only syllabus
[3]
Q14.
Let us assume P[20][10] is a two-dimensional array, which is stored in the memory along the row with each of its elements occupying 2 bytes, find the address of the element P[10][5], if the address of the element P[5][2] is 25000. OR Let us assume P[20][30] is a two-dimensional array, which is stored in the memory along the column with each of its elements occupying 2 bytes. Find the address of the element P[5][6], if the base address of the array is 25000.
⚠ This question is not in the current syllabus — C++ — discontinued language, not in the current Python-only syllabus
[3]
Q15.
A text file named MESSAGE.TXT contains some text. Another text file named SMS.TXT needs to be created such that it would store only the first 150 characters from the file MESSAGE.TXT. Write a user-defined function LongToShort() in C++ that would perform the above task of creating SMS.TXT from the already existing file MESSAGE.TXT. OR A text file named CONTENTS.TXT contains some text. Write a user-defined function LongWords() in C++ which displays all such words of the file whose length is more than 9 alphabets. For example : if the file CONTENTS.TXT contains : "Conditional statements of C++ programming language are if and switch" Then the function LongWords() should display the output as : Conditional statements programming
⚠ This question is not in the current syllabus — C++ — discontinued language, not in the current Python-only syllabus
[3]
Q16.
Write the definition of a class GRAPH in C++ with following description: Private Members XUnit // integer YUnit // integer Type // char array of size 20 AssignType() /* Member function to assign value of Type based upon XUnit and YUnit as follows: */ Condition Type XUnit = 0 Or YUnit = 0 None XUnit is more than YUnit Bar XUnit is less than or equal to YUnit Line Public Members InXY() /* Function to allow user to enter values of XUnit and YUnit and then invoke AssignType() to assign value of Type */ OutXY() // Function to display XUnit, Yunit and Type
⚠ This question is not in the current syllabus — C++ — discontinued language, not in the current Python-only syllabus
[4]
Page 3 of 9
Q17.
Answer the questions (i) to (iv) based on the following: class Ground int Rooms; protected: void Put(); public: void Get(); ; class Middle : private Ground int Labs; public: void Take(); void Give(); ; class Top : public Middle int Roof; public: void In(); void Out(); ; void main() Top T; (i) Which type of Inheritance out of the following is illustrated in the above example? Single Level Inheritance, Multilevel Inheritance, Multiple Inheritance (ii) Write the names of all the members, which are directly accessible by the member function Give() of class Middle. (iii) Write the names of all the members, which are directly accessible by the member function Out() of class Top. (iv) Write the names of all the members, which are directly accessible by the object T of class Top declared in the main() function. OR Consider the following class HeadQuarter class HeadQuarter int Code; char Des[20]; protected : char Address[40]; public: void Get()cin>>Code;gets(Des);gets(Address); void Put()cout<<Code<<Des<<Address<<endl; ; Write a code in C++ to protectedly derive another class FrontOffice from the base class HeadQuarter with following members. Data Members Location of type character of size 10 Budget of type double Member Functions A constructor function to assign Budget as 100000 Assign() to allow user to enter Location and Budget Display() to display Location and Budget
⚠ This question is not in the current syllabus — C++ — discontinued language, not in the current Python-only syllabus
[4]
Q18.
Write a user-defined function Pop(Book B[], int T), which pops the details of a Book, from the static stack of Book B, at the location T (representing the Top end of the stack), where every Book of the stack is represented by the following structure: struct Book int Bno; char Bname[20]; ; OR For the following structure of Books in C++ struct Book int Bno; char Bname[20]; Book *Link; ; Given that the following declaration of class BookStack in C++ represents a dynamic stack of Books: class BookStack Book *Top; //Pointer with address of Topmost Book of Stack public: BookStack() Top = NULL; void Push(); //Function to push a Book into the dynamic stack void Pop(); //Function to pop a Book from the dynamic stack ~BookStack(); ; Write the definition for the member function void BookStack::Push(), that pushes the details of a Book into the dynamic stack of BookStack.
⚠ This question is not in the current syllabus — C++ — discontinued language, not in the current Python-only syllabus
[4]
Section B

Q1.
Name the Python Library modules which need to be imported to invoke the following functions: (i) sqrt() (ii) start()
[1]
Q2.
Write a statement in Python to open a text file WRITEUP.TXT so that new content can be written in it. OR Write a statement in Python to open a text file README.TXT so that existing content can be read from it.
[1]
Q3.
Write the names of any four data types available in Python.
[2]
Q4.
Rewrite the following code in python after removing all syntax error(s). Underline each correction done in the code. 250 = Number WHILE Number<=1000: if Number=>750: print Number Number=Number+100 else print Number*2 Number=Number+50
[2]
Page 4 of 9
Q5.
Find and write the output of the following python code: Msg1="WeLcOME" Msg2="GUeSTs" Msg3="" for I in range(0,len(Msg2)+1): if Msg1[I]>="A" and Msg1[I]<="M": Msg3=Msg3+Msg1[I] elif Msg1[I]>="N" and Msg1[I]<="Z": Msg3=Msg3+Msg2[I] else: Msg3=Msg3+"*" print Msg3
[2]
Q6.
What possible output(s) are expected to be displayed on screen at the time of execution of the program from the following code? Also specify the minimum values that can be assigned to each of the variables BEGIN and LAST. import random VALUES=[10,20,30,40,50,60,70,80] BEGIN=random.randint(1,3) LAST=random.randint(BEGIN,4) for I in range(BEGIN,LAST+1): print VALUES[I],"-", (i) 30 - 40 - 50 - (ii) 10 - 20 - 30 - 40 - (iii) 30 - 40 - 50 - 60 - (iv) 30 - 40 - 50 - 60 - 70 -
[2]
Q7.
Write four features of object oriented programming.
[2]
Q8.
class Box: #Line 1 L = 10 #Line 2 Type="HARD" #Line 3 def _init_(self,T,TL=30): #Line 4 self.Type = T #Line 5 self.L = TL #Line 6 def Disp(self): #Line 7 print self.Type,Box.Type #Line 8 print self.L,Box.L #Line 9 B1=Box("SOFT",20) #Line 10 B1.Disp() #Line 11 Box.Type="FLEXI" #Line 12 B2=Box("HARD") #Line 13 B2.Disp() #Line 14 Write the output of the above Python code. OR class Target: #Line 1 def _init_(self): #Line 2 self.X = 20 #Line 3 self.Y = 24 #Line 4 def Disp(self): #Line 5 print self.X,self.Y #Line 6 def _del_(self): #Line 7 print "Target Moved" #Line 8 def One(): #Line 9 T=Target() #Line 10 T.Disp() #Line 11 One() #Line 12 (i) What are the methods/functions mentioned in Line 2 and Line 7 specifically known as? (ii) Mention the line number of the statement, which will call and execute the method/function shown in Line 2.
[2]
Q9.
Write a python method/function Swapper(Numbers) to swap the first half of the content of a list Numbers with second half of the content of list Numbers and display the swapped values. Note : Assuming that the list has even number of values in it. For example : If the list Numbers contains [35,67,89,23,12,45] After swapping the list content should be displayed as [23,12,45,35,67,89] OR Write a python method/function Count3and7(N) to find and display the count of all those numbers which are between 1 and N, which are either divisible by 3 or by 7. For example : If the value of N is 15 The sum should be displayed as 7 (as 3,6,7,9,12,14,15 in between 1 to 15 are either divisible by 3 or 7)
[2]
Q10.
Evaluate the following Postfix expression, showing the stack contents: 250,45,9,/,5,+,20,*,- OR Convert the following Infix expression to its equivalent Postfix expression, showing the stack contents for each step of conversion: A + B * C ^ D - E
[2]
Q11.
Write a method/function ISTOUPCOUNT() in python to read contents from a text file WRITER.TXT, to count and display the occurrence of the word "IS" or "TO" or "UP". For example : If the content of the file is IT IS UP TO US TO TAKE CARE OF OUR SURROUNDING. IT IS NOT POSSIBLE ONLY FOR THE GOVERNMENT TO TAKE RESPONSIBILITY The method/function should display Count of IS TO and UP is 6 OR Write a method/function AEDISP() in python to read lines from a text file WRITER.TXT, and display those lines, which are starting either with A or starting with E. For example : If the content of the file is A CLEAN ENVIRONMENT IS NECESSARY FOR OUR GOOD HEALTH. WE SHOULD TAKE CARE OF OUR ENVIRONMENT. EDUCATIONAL INSTITUTIONS SHOULD TAKE THE LEAD. The method should display A CLEAN ENVIRONMENT IS NECESSARY FOR OUR GOOD HEALTH. EDUCATIONAL INSTITUTIONS SHOULD TAKE THE LEAD.
[2]
Page 5 of 9
Q12.
Find and write the output of the following python code: def Changer(P,Q=10): P=P/Q Q=P%Q print P,"#",Q return P A=200 B=20 A=Changer(A,B) print A,"",B B=Changer(B) print A,"",B A=Changer(A) print A,"",B
[3]
Q13.
Consider the following randomly ordered numbers stored in a list: 106, 104, 106, 102, 105, 10 Show the content of list after the First, Second and Third pass of the selection sort method used for arranging in ascending order. Note : Show the status of all the elements after each pass very clearly encircling the changes. OR Consider the following randomly ordered numbers stored in a list: 106, 104, 106, 102, 105, 107 Show the content of list after the First, Second and Third pass of the bubble sort method used for arranging in descending order. Note : Show the status of all the elements after each pass very clearly encircling the changes.
[3]
Q14.
Write definition of a method/function AddOddEven(VALUES) to display sum of odd and even values separately from the list of VALUES. For example : If the VALUES contain [15, 26, 37, 10, 22, 13] The function should display Even Sum: 58 Odd Sum: 65 OR Write definition of a method/function HowMany(ID,Val) to count and display number of times the value of Val is present in the list ID. For example : If the ID contains [115,122,137,110,122,113] and Val contains 122 The function should display 122 found 2 Times
[3]
Q15.
Considering the following definition of class STOCK, write a method/function COSTLY() in python to search and display Name and Price from a pickled file STOCK.DAT, where Price of the items are more than 1000. class Stock : def _init_(self,N,P): self.Name=N self.Price=P def Show(self): print self.Name,"@",self.Price OR Considering the following definition of class DOCTORS, write a method/function SPLDOCS() in python to search and display all the content from a pickled file DOCS.DAT, where Specialisation of DOCTORS is "CARDIOLOGY". class DOCTORS : def _init_(self,N,S): self.Name=N self.Specialisation=S def Disp(self): print self.Name,"#",self.Specialisation
[3]
Q16.
Define a class HOUSE in Python with the following specifications: Instance Attributes - Hno # House Number - Nor # Number of Rooms - Type # Type of the House Methods/function - AssignType() # To assign Type of House based on Number of Rooms as follows: Nor Type <=2 LIG ==3 MIG >3 HIG - Enter() # To allow user to enter value of Hno and Nor. Also, this method should call AssignType() to assign Type - Display() # To display Hno, Nor and Type
[4]
Page 6 of 9
Q17.
Answer the questions (i) to (iii) based on the following: class Furniture(object): #Line 1 def _init_(self,Q): #Line 2 self.Qty = Q def GetMore(self,TQ): #Line 3 self.Qty =self.Qty+TQ def FRDisp(self): #Line 4 print self.Qty class Fixture(object): #Line 5 def _init_(self,TQ): #Line 6 self.Qty=TQ def GetMore(self,TQ): #Line 7 self.Qty =self.Qty+TQ def FXDisp(self): #Line 8 print self.Qty class Flat(Furniture,Fixture): #Line 9 def _init_(self,fno): #Line 10 self.Fno=fno Q=0 if self.Fno<100: Q=10 else: Q=20 Furniture._init_(self,Q): #Line 11 Fixture._init_(self,Q): #Line 12 def More(self,Q): #Line 13 Furniture.GetMore(self,Q) Fixture.GetMore(self,Q) def FLDisp(self): #Line 14 print self.Fno, Furniture.FRDisp(self) Fixture.FXDisp(self) FL=Flat(101) #Line 15 FL.More(2) FL.FLDisp() (i) Write the type of the inheritance illustrated in the above. (ii) Find and write the output of the above code. (iii) What is the difference between the statements shown in Line 11 and Line 12? OR Define inheritance. Show brief python example of Single Level, Multiple and Multilevel Inheritance.
[4]
Q18.
Write QueueUp(Client) and QueueDel(Client) methods/functions in Python to add a new Client and delete a Client from a List of Clients names, considering them to act as insert and delete operations of the Queue data structure. OR Write PushOn(Book) and Pop(Book) methods/functions in Python to add a new Book and delete a Book from a List of Book titles, considering them to act as push and pop operations of the Stack data structure.
[4]
Section C

Q1.
⚠ This question is not in the current syllabus — Boolean Algebra / canonical forms — removed from the current CS 083 syllabus
[1]
Q2.
Tarini Wadhawa is in India and she is interested in communicating with her uncle in Australia. She wants to show one of her own designed gadgets to him and also wants to demonstrate its working without physically going to Australia. Which protocol out of the following will be ideal for the same? (i) POP3 (ii) SMTP (iii) VoIP (iv) HTTP
[1]
Q3.
Give two differences between 3G and 4G telecommunication technologies.
⚠ This question is not in the current syllabus — 3G/4G mobile-generation comparison — not in the current CS 083 syllabus
[1]
Q4.
State any one Distributive Law of Boolean Algebra and verify it using truth table.
⚠ This question is not in the current syllabus — Boolean Algebra / logic — removed from the current CS 083 syllabus
[2]
Q5.
Draw the Logic Circuit of the following Boolean Expression: A.B + A.C
⚠ This question is not in the current syllabus — Boolean Algebra / logic gates — removed from the current CS 083 syllabus
[2]
Page 7 of 9
Q6.
Damodar Mohan has been informed that there had been a backdoor entry to his computer, which has provided access to his system through a malicious user/programs, allowing confidential and personal information to be subjected to theft. It happened because he clicked a link provided in one of the pop-ups from a website announcing him to be winner of prizes worth 1 Million Dollars. Which of the following has caused this out of the following? (i) Virus (ii) Worm (iii) Trojan Horse Also, mention, what he should do to prevent this infection.
⚠ This question is not in the current syllabus — Malware / cyber-safety — not in the current CS 083 syllabus
[2]
Q7.
Write the expanded names for the following abbreviated terms used in Networking and Communications: (i) MBPS (ii) WAN (iii) CDMA (iv) WLL
[2]
Q8.
Reduce the following Boolean Expression to its simplest form using K-Map: F(P,Q,R,S) = Σ(0,1,2,3,5,6,7,10,14,15)
⚠ This question is not in the current syllabus — Boolean Algebra / K-Map — removed from the current CS 083 syllabus
[3]
Q9.
Jonathan and Jonathan Training Institute is planning to set up its centre in Amritsar with four specialised blocks for Medicine, Management, Law courses alongwith an Admission block in separate buildings. The physical distances between these blocks and the number of computers to be installed in these blocks are given below. You as a network expert have to answer the queries as raised by their board of directors as given in (i) to (iv). Shortest distances between various locations in metres: Admin Block to Management Block 60 Admin Block to Medicine Block 40 Admin Block to Law Block 60 Management Block to Medicine Block 50 Management Block to Law Block 110 Law Block to Medicine Block 40 Number of Computers installed at various locations are as follows: Admin Block 150 Management Block 70 Medicine Block 20 Law Block 50 (i) Suggest the most suitable location to install the main server of this institution to get efficient connectivity. (ii) Suggest the devices to be installed in each of these buildings for connecting computers installed within the building out of the following: Modem, Switch, Gateway, Router (iii) Suggest by drawing the best cable layout for effective network connectivity of the blocks having server with all the other blocks. (iv) Suggest the most suitable wired medium for efficiently connecting each computer installed in every building out of the following network cables: Co-axial Cable, Ethernet Cable, Single Pair Telephone Cable
[4]
Page 8 of 9
Q10.
Write SQL queries for (i) to (iv) and write outputs for SQL queries (v) to (viii), which are based on the table given below: Table : TRAINS TNO TNAME START END 11096 Ahimsa Express Pune Junction Ahmedabad Junction 12015 Ajmer Shatabdi New Delhi Ajmer Junction 1651 Pune Hbj Special Pune Junction Habibganj 13005 Amritsar Mail Howrah Junction Amritsar Junction 12002 Bhopal Shatabdi New Delhi Habibganj 12417 Prayag Raj Express Allahabad Junction New Delhi 14673 Shaheed Express Jaynagar Amritsar Junction 12314 Sealdah Rajdhani New Delhi Sealdah 12498 Shane Punjab Amritsar Junction New Delhi 12451 Shram Shakti Express Kanpur Central New Delhi 12030 Swarna Shatabdi Amritsar Junction New Delhi Table : PASSENGERS PNR TNO PNAME GENDER AGE TRAVELDATE P001 13005 R N AGRAWAL MALE 45 2018-12-25 P002 12015 P TIWARY MALE 28 2018-11-10 P003 12015 S TIWARY FEMALE 22 2018-11-10 P004 12030 S K SAXENA MALE 42 2018-10-12 P005 12030 S SAXENA FEMALE 35 2018-10-12 P006 12030 P SAXENA FEMALE 12 2018-10-12 P007 13005 N S SINGH MALE 52 2018-05-09 P008 12030 J K SHARMA MALE 65 2018-05-09 P009 12030 R SHARMA FEMALE 58 2018-05-09 NOTE : All Dates are given in 'YYYY-MM-DD' format. (i) To display details of all Trains which Start from New Delhi. (ii) To display the PNR, PNAME, GENDER and AGE of all Passengers whose AGE is below 50. (iii) To display total number of MALE and FEMALE Passengers. (iv) To display details of all Passengers travelling in Trains whose TNO is 12015. (v) SELECT MAX (TRAVELDATE), MIN(TRAVELDATE) FROM PASSENGERS WHERE GENDER = 'FEMALE'; (vi) SELECT END, COUNT(*) FROM TRAINS GROUP BY END HAVING COUNT(*)>1; (vii) SELECT DISTINCT TRAVELDATE FROM PASSENGERS; (viii) SELECT TNAME, PNAME FROM TRAINS T, PASSENGERS P WHERE T.TNO = P.TNO AND AGE BETWEEN 50 AND 60;
[8]
Page 9 of 9