Write the type of C++ Operators (Arithmetic, Logical, and Relational Operators) from the following:
(i) !(ii) !=(iii) &&(iv) %

Observe the following program very carefully and write the name of those header file(s), which are essentially needed to compile and execute thefollowing program successfully:
void main() { char text[20], newText[20]; gets(text); strcpy(newText,text); for(int i=0;i<strlen(text);i++) if(text[i]==’A’) text[i]=text[i]+2; puts(text); }
Rewrite the following C++ code after removing any/all Syntactical Error(s) with each correction underlined.
Note: Assume all required header files are already being included in the program.
#define float PI 3.14 void main( ) { float R=4.5,H=1.5; A=2*PI*R*H + 2*PIpow(R,2); cout<<'Area='<<A<<endl; }
Find and write the output of the following C++ program code: Note: Assume all required header files are already being included in the program.
void main( ) { int Ar[ ] = { 6 , 3 , 8 , 10 , 4 , 6 , 7} ; int *Ptr = Ar , I ; cout<<++*Ptr++ << '@' ; I = Ar[3] - Ar[2] ; cout<<++*(Ptr+I)<<'@'<<"\n" ; cout<<++I + *Ptr++ << '@' ; cout<<*Ptr++ <<'@'<< '\n' ; for( ; I >=0 ; I -=2) cout<<Ar[I] << '@' ; }
Find and write the output of the following C++ program code:
typedef char STRING[80]; void MIXNOW(STRING S) { int Size=strlen(S); for(int I=0;I<Size;I+=2) { char WS=S[I]; S[I]=S[I+1]; S[I+1]=WS; } for (I=1;I<Size;I+=2) if (S[I]>='M' && S[I]<='U') S[I]='@'; } void main() { STRING Word="CBSEEXAM2019"; MIXNOW(Word); cout<<Word<<endl; }
Observe the following program and find out, which output(s) out of (i) to (iv) willbe expected from the program? What will be the minimum and the maximum value assigned to the variable Alter?
Note: Assume all required header files are already being included in the program.
void main( ) { randomize(); int Ar[]={10,7}, N; int Alter=random(2) + 10 ; for (int C=0;C<2;C++) { N=random(2) ; cout<<Ar[N] +Alter<<"#"; } } (i) 21#20# (ii) 20#18# (iii) 20#17# (iv) 21#17#
What is a copy constructor? Illustrate with a suitable C++ example.
Write the output of the following C++ code. Also, write the name of feature of Object Oriented Programming used in the following program jointly illustrated by the Function 1 to Function 4.
void My_fun ( ) // Function 1 { for (int I=1 ; I<=50 ; I++) cout<< "-" ; cout<<end1 ; } void My_fun (int N) // Function 2 { for (int I=1 ; I<=N ; I++) cout<<"*" ; cout<<end1 ; } void My_fun (int A, int B) // Function 3 { for (int I=1. ;I<=B ;I++) cout <<A*I ; cout<<end1 ; } void My_fun (char T, int N) // Function 4 { for (int I=1 ; I<=N ; I++) cout<<T ; cout<<end1; } void main ( ) { int X=7, Y=4, Z=3; char C='#' ; My_fun (C,Y) ; My_fun (X,Z) ; }
OR
Write any four differences between Constructor and Destructor function with respect to object oriented programming
Define a class Ele_Bill in C++ with the following descriptions:
Private members: Cname of type character array Pnumber of type long No_of_units of type integer Amount of type float. Calc_Amount( ) This member function should calculate the amount asNo_of_units*Cost .
Amount can be calculated accordingto the following conditions:
No_of_units Cost First 50 units Free Next 100 units 0.80 @ unit Next 200 units 1.00 @ unit Remaining units 1.20 @ unit Public members: * A function Accept( ) which allows user to enter Cname, Pnumber, No_of_units and invoke function Calc_Amount(). * A function Display( ) to display the values of all the data members on the screen.
Answer the questions (i) to (iv) based on the following:
class Faculty { int FCode; protected: char FName[20]; public: Faculty(); void Enter(); void Show(); }; class Programme { int PID; protected: char Title[30]; public: Programme(); void Commence(); void View(); }; class Schedule: public Programme, Faculty { int DD,MM,YYYY; public: Schedule(); void Start(); void View(); }; void main() { Schedule S; //Statement 1 ___________ //Statement 2 }
OR
Consider the following class State :
class State { protected : int tp; public : State( ) { tp=0;} void inctp( ) { tp++;}; int gettp(); { return tp; } };
Write a code in C++ to publically derive another class ‘District’ with the following additional members derived in the public visibility mode.
Data Members :
Dname string
Distance float
Population long int
Member functions :
DINPUT( ) : To enter Dname, Distance and population
DOUTPUT( ) : To display the data members on the screen.
(i) Write the names of all the member functions, which are directly accessible by the object S of class Schedule as declared in main() function.
(ii) Write the names of all the members, which are directly accessible by the memberfunction Start( ) of class Schedule.
(iii) Write Statement 2 to call function View( ) of class Programme from the object S of class Schedule.
(iv) What will be the order of execution of the constructors, when the object S of class Schedule is declared inside main()?
Write a user-defined function AddEnd4(int A[][4],int R,int C) in C++ to find and display the sum of all the values, which are ending with 4 (i.e., unit place is 4).
For example if the content of array is:
24 | 16 | 14 |
19 | 5 | 4 |
The output should be 42
OR
Write a user defined function in C++ to find the sum of both left and right diagonal elements from a two dimensional array.
Write a user-defined function EXTRA_ELE(int A[ ], int B[ ], int N) in C++ to find and display the extra element in Array A. Array A contains all the elements of array B but one more element extra. (Restriction: array elements are not in order)
Example : If the elements of Array A is 14, 21, 5, 19, 8, 4, 23, 11
and the elements of Array B is 23, 8, 19, 4, 14, 11, 5
Then output will be 21
OR
Write a user defined function Reverse(int A[],int n) which accepts an integer array and its size as arguments(parameters) and reverse the array.
Example : if the array is 10,20,30,40,50 then reversed array is 50,40,30,20,10
An array S[10] [30] is stored in the memory along the column with each of its element occupying 2 bytes. Find out the memory location of S[5][10], if element S[2][15] is stored at the location 8200.
OR
An array A[30][10] is stored in the memory with each element requiring 4 bytes of storage ,if the base address of A is 4500 ,Find out memory locations of A[12][8], if the content is stored along the row.
Write the definition of a member function Ins_Player() for a class CQUEUE in C++, to add a Player in a statically allocated circular queue of PLAYERs considering the following code is already written as a part of the program:
struct Player { long Pid; char Pname[20]; }; const int size=10; class CQUEUE { Player Ar[size]; int Front, Rear; public: CQUEUE( ) { Front = -1; Rear=-1; } void Ins_Player(); // To add player in a static circular queue void Del_Player(); // To remove player from a static circular queue void Show_Player(); // To display static circular queue };
Convert the following Infix expression to its equivalent Postfix expression, showing the stack contents for each step of conversion.
A/B+C*(D-E)
OR
Evaluate the following Postfix expression :
4,10,5,+,*,15,3,/,-
Write a function RevText() to read a text file “ Input.txt “ and Print only word starting with ‘I’ in reverse order .
Example: If value in text file is: INDIA IS MY COUNTRY
Output will be: AIDNI SI MY COUNTRY
OR
Write a function in C++ to count the number of lowercase alphabets present in a text file “BOOK..txt”.
Write a function in C++ to search and display details, whose destination is
“Cochin” from binary file “Bus.Dat”. Assuming the binary file is containing the objects of the following class:
class BUS { int Bno; // Bus Number char From[20]; // Bus Starting Point char To[20]; // Bus Destination public: char * StartFrom ( ); { return From; } char * EndTo( ); { return To; } void input() { cin>>Bno>>; gets(From); get(To); } void show( ) { cout<<Bno<< ":"<<From << ":"<<To<<endl; } };
OR
Write a function in C++ to add more new objects at the bottom of a binary file “STUDENT.dat”, assuming the binary file is containing the objects of the following class :
class STU { int Rno; char Sname[20]; public: void Enter() { cin>>Rno;gets(Sname); } void show() { count << Rno<<sname<<endl; } };
Find the output of the following C++ code considering that the binary file PRODUCT.DAT exists on the hard disk with a list of data of 500 products.
class PRODUCT { int PCode;char PName[20]; public: void Entry();void Disp(); }; void main() { fstream In; In.open("PRODUCT.DAT",ios::binary|ios::in); PRODUCT P; In.seekg(0,ios::end); cout<<"Total Count: "<<In.tellg()/sizeof(P)<<endl; In.seekg(70*sizeof(P)); In.read((char*)&P, sizeof(P)); In.read((char*)&P, sizeof(P)); cout<<"At Product:"<<In.tellg()/sizeof(P) + 1; In.close(); }
OR
Which file stream is required for seekg() ?
What is the role of a parameter/argument passed in a function? Can a default value be assigned to a parameter(Yes/No)? If yes, justify your answer with the help of a suitable example otherwise give reason.
Raman suggests Kishan the following header files which are required to be included in the given C++ program. Identify the header files which are wrongly suggested by Raman.
Program:
void main() { char Grade; cin.get(Grade); if(isalpha(Grade)) cout.put(Grade); }
Suggested header files:-
1. iostream.h
2. stdio.h
3. conio.h
4. ctype.h
Rewrite the following program after removing the syntactical errors (if any). Underline each correction.
#include<iostream.h> #include<conio.h> Typedef int Num; Num full=100; Num Calc(int X) { full=(X>2)?1:2; return (full%2) } void main { int full = 1000; full =Calc(::full); cout<<::full<<"::">>full>>endl; }
Write the output of the following C++ program code (assume all necessary header files are included in program) :
void Encrypt(char *S, int key) { char *Temp=S; if(key%2==0) { key--; } while (*Temp!='\0') { *Temp+=key; Temp+= key; } } void main() { int Key_Set[]={1,2,3}; char Pvt_Msg[]="Computer2017"; for(int C=0; C<2; C++) { Encrypt(Pvt_Msg, Key_Set[C]); cout<<"New Encrypted Message after Pass "<<C+1<<" is : "<<Pvt_Msg; cout<<endl; } }
Write the output of the following C++ program code(assume all necessary header files are included in program):
struct Ticket
{
char Level;
int Price;
};
void Compute(Ticket &T)
{
if (T.Level==’A’)
T.Price+=50;
else if (T.Level==’B’)
T.Price+=30;
else if (T.Level==’C’)
T.Price+=25;
cout<
{
Compute(Mon_Show[count–]);
}
}
Consider the following C++ program code and choose the option(s) which are not possible as output. Also, print the minimum & maximum value of variable Pick during complete execution of the program.(assume all necessary header files are included in program):
const int NUM=5; void main() { randomize(); int V1=1, V2=5, Pick; while(V1<V2) { Pick = random(NUM) + (V2-V1); cout<<Pick<<":"; V1++; } }
(a) 5:6:6:6:
(b) 4:7:5:3:
(c) 8:6:1:2:
(d) 7:5:3:1
What do you mean by Data Abstraction in OOPs? Explain its significance with a suitable example.
Answer the question (i) & (ii) after going through the following code. (assume all necessary header files are included in program):-
class Game { char Name [21]; int No_of_Players; public: Game() //Function 1 { strcpy(Name, "Cricket"); No_of_Players=11; cout<<"New Game Starts\n"; } Game(char N[], int No) //Function 2 { strcpy(Name, N); No_of_Players=No; cout<<Name<<"comprises"<<No_of_Players<<"number of players\n"; } ~Game() //Function 3 { cout<<"Game Ends\n"; } };
(i) Give the name of the feature of OOP which is implemented by Function 1 & 2 together in the above class Game.
(ii) Anuj made changes to the above class Game and made Function 3 private. Will he be able to execute the Line 1 successfully given below? Justify.
void main()
{
Game ABC; //Line 1
}
Define a class Bill in OOP with the following specification:-
Private members:
1. Bill_no – type long(bill number)
2. Bill_period – type integer(number of months)
3. No_of_calls – type integer(number of mobile calls)
4. Payment_mode – type string(“online” or “offline”)
5. Amount – type float(amount of bill)
6. Calculate_Bill() function to calculate the amount of bill given as per the following conditions:
No_of_calls | Calculation Rate/call (in rupees) |
---|---|
<=500 | 1.0 |
501-1200 | 2.0 |
>1200 | 4.0 |
Also, the value of Amount should be reduced by 5% if Payment_mode is “online”.
Public members:
1. A member function New_Bill() that will accept the values for Bill_no, Bill_period, No_of_calls, Payment_mode from the user and invoke Caluclate_Bill() to assign the value of Amount.
2. A member function Print_Bill() that will display all details of a Bill.
Answer the question from (i) to (iv) based on the given below code (assume all necessary header files are included in program):- class City { int City_Id; char City_Name[30]; protected: int City_Population; public: City(); void Get_Population(); void New_City(); void Show_City; }; class State : public City { int State_Id; char State_Name[25]; protected: int State_Population; public: State(); void New_State(); void Print_State(); }; class Country : private State { int Country_Id; char Country_Name[25]; public; Country(); void New_Country(); void Display_Country(); };
(i) Write name of the class whose constructor is invoked first on the creation of a new object of class Country.
(ii) Write name of the data members which are accessible through the object of class Country.
(iii) List name of the members which are accessible through the member function “void New_Country()”.
(iv) What will be the size(in bytes) of an object of class Country & State respectively.
Write the definition of function named Array_Swap() that will accept an integer array & its size as arguments and the function will interchange/swap elements in such a way that the first element is swapped with the last element, second element is swapped with the second last element and so on, only if anyone or both the elements are odd.
E.g. if initially array of seven elements is:
5, 16, 4, 7, 19, 8, 2
After execution of the above function, the contents of the array will be:
2,16, 19, 7, 4, 8, 5
An array A[50][30] is stored along the row in the memory with each element requiring 4 bytes of storage. If the element A[10][15] is stored at 21500, then find out the base address of the array and the memory address of element stored at location A[30][25]?
Observe the following table and answer the parts(i) and(ii) accordingly
Table:Product
Pno | Name | Qty | PurchaseDate |
---|---|---|---|
101 | Pen | 102 | 12-12-2011 |
102 | Pencil | 201 | 21-02-2013 |
103 | Eraser | 90 | 09-08-2010 |
109 | Sharpener | 90 | 31-08-2012 |
113 | Clips | 900 | 12-12-2011 |
(i) Write the names of most appropriate columns, which can be considered as candidate keys.
(ii) What is the degree and cardinality of the above table?
Write SQL queries for (i) to (iv) and find outputs for SQL queries (v) to (viii), which are based on the tables.
TRAINER
TID | TNAME | CITY | HIREDATE | SALARY |
---|---|---|---|---|
101 | SUNAINA | MUMBAI | 1998-10-15 | 90000 |
102 | ANAMIKA | DELHI | 1994-12-24 | 80000 |
103 | DEEPTI | CHANDIGARG | 2001-12-21 | 82000 |
104 | MEENAKSHI | DELHI | 2002-12-25 | 78000 |
105 | RICHA | MUMBAI | 1996-01-12 | 95000 |
106 | MANIPRABHA | CHENNAI | 2001-12-12 | 69000 |
COURSE
CID | CNAME | FEES | STARTDATE | TID |
---|---|---|---|---|
C201 | AGDCA | 12000 | 2018-07-02 | 101 |
C202 | ADCA | 15000 | 2018-07-15 | 103 |
C203 | DCA | 10000 | 2018-10-01 | 102 |
C204 | DDTP | 9000 | 2018-09-15 | 104 |
C205 | DHN | 20000 | 2018-08-01 | 101 |
C206 | O LEVEL | 18000 | 2018-07-25 | 105 |
(i) Display the Trainer Name, City & Salary in descending order of their Hiredate.
(ii) To display the TNAME and CITY of Trainer who joined the Institute in the month of December 2001.
(iii) To display TNAME, HIREDATE, CNAME, STARTDATE from tables TRAINER and COURSE of all those courses whose FEES is less than or equal to 10000.
(iv) To display number of Trainers from each city.
(v) SELECT TID, TNAME, FROM TRAINER WHERE CITY NOT IN(‘DELHI’, ‘MUMBAI’);
(vi) SELECT DISTINCT TID FROM COURSE;
(vii) SELECT TID, COUNT(*), MIN(FEES) FROM COURSE GROUP BY TID HAVING COUNT(*)>1;
(viii) SELECT COUNT(*), SUM(FEES) FROM COURSE WHERE STARTDATE< ‘2018-09-15’;
State any one Distributive Law of Boolean Algebra and Verify it using truth table.
Draw the Logic Circuit of the following Boolean Expression:
((U + V’).(U + W)). (V + W’)
Derive a Canonical SOP expression for a Boolean function F(X,Y,Z) represented by the following truth table:
X | Y | Z | F(X,Y,Z) |
---|---|---|---|
0 | 0 | 0 | 1 |
0 | 0 | 1 | 1 |
0 | 1 | 0 | 0 |
0 | 1 | 1 | 0 |
1 | 0 | 1 | 0 |
1 | 1 | 0 | 0 |
1 | 1 | 1 | 1 |
Reduce the following Boolean Expression to its simplest form using K-Map:
F(X,Y,Z,W)= Σ (0,1,2,3,4,5,8,10,11,14)
Arun opened his e-mail and found that his inbox was full of hundreds of unwanted mails. It took him around two hours to delete these unwanted mails and find the relevant ones in his inbox. What may be the cause of his receiving so many unsolicited mails? What can Arun do to prevent this happening in future?
Assume that 50 employees are working in an organization. Each employee has been allotted a separate workstation to work. In this way, all computers are connected through the server and all these workstations are distributed over two floors. In each floor, all the computers are connected to a switch. Identify the type of network?
Your friend wishes to install a wireless network in his office. Explain him the difference between guided and unguided media.
Write the expanded names for the following abbreviated terms used in Networkingand Communications:
(i) CDMA (ii) HTTP (iii) XML (iv) URL
Multipurpose Public School, Bangluru is Setting up the network between its Different Wings of school campus. There are 4 wings
namedasSENIOR(S),JUNIOR(J),ADMIN(A)andHOSTEL(H).
Multipurpose Public School, Bangluru
Distance between various wings are given below:
WingAtoWingS | 100m |
WingAtoWingJ | 200m |
WingAtoWingH | 400m |
WingAtoWingJ | 300m |
WingAtoWingH | 100m |
WingAtoWingH | 450m |
Number of Computers installed at various wings are as follows:
Wings | NumberofComputers |
WingA | 20 |
WingS | 150 |
WingJ | 50 |
WingH | 25 |
(i)Suggest the best wired medium and draw the cable layout to efficiently connect various wings of Multipurpose PublicSchool, Bangluru.
(ii) Name the most suitable wing where the Server should be installed. Justify your answer.
(iii) Suggest a device/software and its placement that would provide data security for the entire network of the School.
(iv) Suggest a device and the protocol that shall be needed to provide wireless Internet access to all smartphone/laptop users in the campus of Multipurpose Public School, Bangluru.
Differentiate between DDL & DMLcommands. Identify DDL & DML commands from the following:-
(UPDATE, SELECT, ALTER, DROP)
Consider the following relations MobileMaster & MobileStock:-
MobileMaster
M_Id | M_Id M_Company |
M_Name | M_Price | M_Price M_Mf_Date |
---|---|---|---|---|
MB001 | Samsung | Galaxy | 4500 | 2013-02-12 |
MB003 | Nokia | N1100 | 2250 | 2011-04-15 |
MB004 | Micromax | Unite3 | 4500 | 2016-10-17 |
MB005 | Sony | XperiaM | 7500 | 2017-11-20 |
MB006 | Oppo | SelfieEx | 8500 | 2010-08-21 |
106 | MANIPRABHA | CHENNAI | 2001-12-12 | 69000 |
MobileStock
MobileMaster
S_Id | M_Id | M_Qty | M_Supplier |
---|---|---|---|
S001 | MB004 | 450 | New Vision |
S002 | MB003 | 250 | Praveen Gallery |
S003 | MB001 | 300 | Classic Mobile Store |
S004 | MB006 | 150 | A-one Mobiles |
S005 | MB003 | 150 | The Mobile |
S006 | MB006 | 50 | Mobile Centre |
Write the SQL query for questions from (i) to (iv) & write the output of SQL command for questions from (v) to (viii) given below:-
(i) Display the Mobile company, Mobile name & price in descending order of their manufacturing date.
(ii) List the details of mobile whose name starts with „S..
(iii) Display the Mobile supplier & quantity of all mobiles except „MB003..
(iv) To display the name of mobile company having price between 3000 & 5000.
(v) SELECT M_Id, SUM(M_Qty) FROM MobileStock GROUP BY M_Id;
(vi) SELECT MAX(M_Mf_Date), MIN(M_Mf_Date) FROM MobileMaster;
(vii) SELECT M1.M_Id, M1.M_Name, M2.M_Qty, M2.M_Supplier FROM MobileMaster M1, MobileStock M2 WHERE M1.M_Id=M2.M_Id AND M2.M_Qty>=300;
(viii) SELECT AVG(M_Price) FROM MobileMaster;
State & prove De-Morgan‟s law using truth table.
Draw the equivalent logic circuit diagram of the following Boolean expression:-
(A‟ + B).C’
Write the SOP form for the Boolean Function F(X,Y,Z) represented by the given truth table:-
X | Y | Z | F |
---|---|---|---|
0 | 0 | 0 | 0 |
0 | 0 | 1 | 1 |
0 | 1 | 0 | 1 |
0 | 1 | 1 | 0 |
1 | 0 | 0 | 0 |
1 | 0 | 1 | 0 |
1 | 1 | 0 | 1 |
1 | 1 | 1 | 1 |
Reduce the following Boolean expression using K-Map:-
F(U,V,W,Z)= ð(0,2,5,7,12,13,15)
A teacher provides “http://www.XtSchool.com/default.aspx” to his/her students to identify the URL & domain name.
Which out of the following does not come under Cyber Crime?
(i) Copying data from the social networking account of a person without his/her information & consent.
(ii) Deleting some files, images, videos, etc. from a friend‟s computer with his consent.
(iii) Viewing & transferring funds digitally from a person‟s bank account without his/her knowledge.
(iv) Intentionally making a false account on the name of a celebrity on a social networking site.
Expand the following:-
1. GSM 2. TDMA
What is the significance of cookies stored on a computer?
Kabir wants to purchase a Book online and placed the order for that book using an e-commerce website. Now, he is going to pay the amount for that book online using his Mobile, he needs which of the following to complete the online transaction:-
1. A bank account,
2. A Mobile connection/phone which is attached to above bank account,
3. The mobile banking app of the above bank installed on that mobile,
4. Login credentials(UserId & Password) provided by the bank,
5. All of above.
What do you mean by data encryption? For what purpose it is used for?
Sanskar University of Himachal Pradesh is setting up a secured network for its campus at Himachal Pradesh for operating their day-to-day office & web based activities. They are planning to have network connectivity between four buildings. Answer the question (i) to (iv) after going through the building positions in the campus & other details which are given below:
The distances between various buildings of university are given as:-
Building 1 | Building 2 | Distance(in mtrs.) |
---|---|---|
Main | Admin | 50 |
Main | Finance | 100 |
Main | Academic | 70 |
Admin | Finance | 50 |
Finance | Academic | 70 |
Admin | Academic | 60 |
Number of computers:-
Building | No. of Computers |
---|---|
Main | 150 |
Admin | 75 |
Finance | 50 |
Academic | 60 |
As a network expert, you are required to give best possible solutions for the given queries of the university administration:-
(a) Suggest cable layout for the connections between the various buildings,
(b) Suggest the most suitable building to house the server of the network of the university,
(c) Suggest the placement of following devices with justification:
1. Switch/Hub
2. Repeater
(d) Suggest the technology out of the following for setting-up very fast Internet connectivity among buildings of the university
1. Optical Fibre
2. Coaxial cable
3. Ethernet Cable
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 SQL queries for (i) to (iv) and find outputs for SQL queries (v) to (viii), which are based on the tables
TABLE : BOOK
Code | BNAME | TYPE |
---|---|---|
F101 | The priest | Fiction |
L102 | German easy | Literature |
C101 | Tarzan in the lost world | Comic |
F102 | Untold Story | Fiction |
C102 | War Heroes | Comic |
TABLE: MEMBER
MNO | MNANE | CODE | ISSUEDATE |
---|---|---|---|
M101 | RAGHAV SINHA | L102 | 2016-10-13 |
M103 | SARTHAK JOHN | F102 | 2017-02-23 |
M102 | ANISHA KHAN | C101 | 2016-06-12 |
(i) To display all details from table MEMBER in descending order of ISSUEDATE.
(ii) To display the BNO and BNAME of all Fiction Type books from the table BOOK
(iii) To display the TYPE and number of books in each TYPE from the table BOOK
(iv) To display all MNAME and ISSUEDATE of those members from table MEMBER who have books issued (i.e ISSUEDATE) in the year 2017.
(v) SELECT MAX(ISSUEDATE) FROM MEMBER;
(vi) SELECT DISTINCT TYPE FROM BOOK;
(vii) SELECT A.CODE,BNAME,MNO,MNAME FROM BOOK A, MEMBER B
WHERE A.CODE=B.CODE ;
(viii) SELECT BNAME FROM BOOK
WHERE TYPE NOT IN (“FICTION”, “COMIC”);
State Distributive Laws of Boolean Algebra and verify them using truth table.
Draw the Logic Circuit of the following Boolean Expression using only NAND Gates:
X.Y + Y.Z
Derive a Canonical SOP expression for a Boolean function F, represented by the following truth table:
U | V | W | F(U,V,W) |
---|---|---|---|
0 | 0 | 0 | 1 |
0 | 0 | 1 | 0 |
0 | 1 | 0 | 1 |
0 | 1 | 1 | 1 |
1 | 0 | 0 | 0 |
1 | 0 | 1 | 0 |
1 | 1 | 0 | 1 |
1 | 1 | 1 | 0 |
Reduce the following Boolean Expression to its simplest form using K-Map:
F(X,Y,Z,W)= Σ (0,1,2,3,4,5,10,11,14)