Evaluate the following C++ expressions, where a,b and c are integers and d,f are floating point numbers. The values are: a=5,b=3 and d=1.5
i) c=a-(b++)*(--d)
ii)f=(++b)*b-a

What is wrong with the following C++ statement?
long float y;

Evaluate the following C++ expression for x=10, y=5 and z=11
(x==y)||(!(z==y))&&(z<x)

What is the effect of absence of break in switch-case statement?

Observe the following C++ code and write the name(s) of the header file(s),which will be essentially required to run it in a C++ compiler.
void main()
{
    int Number;
    cin>>Number;
if(abs(Number)==Number);
    cout<<"Positive"<<endl;
}

What is wrong with the following C++ statement?
long float y;

Do you see any similarity between a typedef name and a reference name? If yes, what is it?

Which value of x will be printed in following case and why?
int x=9;
void main()
{
  int x = 10;
  cout<<x;
}

Observe the following C++ code and write the name(s) of the header file(s), which will be essentially required to run it in a C++ compiler.
void main()
{
    char Text[20],C;
    cin>>Text;
    C=tolower(Text[0]);
    cout<<c<<"is the first char of"<<Text<<endl;
}

Write the names of the header files to which the following belong: i) puts()  ii) sin()

Evaluate the following C++ expressions, where a,b and c are integers and d,f are floating point numbers. The values are: a=5,b=3 and d=1.5
i) c=a-(b++)*(--d)
ii)f=(++b)*b-a

What is wrong with the following C++ statement?
long float y;

Differentiate between an identifier and keywords.

Show two different ways to declare as integer variable named intname and set its value to 15.

What is the effect of absence of break in switch-case statement?

Write the difference between = and ==

How is an entry controlled loop different from exit controlled loop?

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

When will you make a function inline?

What are nested structures? Give an example.

How 'I' operator is different from '%' operator?

Differentiate between an identifier and keywords.

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

Observe the following C++ code and write the name(s) of the header file(s),which will be essentially required to run it in a C++ compiler.
void main()
{
    int Number;
    cin>>Number;
if(abs(Number)==Number);
    cout<<"Positive"<<endl;
}

Which C++ header file(s) will be essentially required to be included to run/execute the following C++ code?
void main()
{
      int Eno_123;
      char Ename[]="RehanSwarop";
     cout<<setw(5)<<Eno_123<<setw(25)<<EName<<endl;
}

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

TABLE: TRADERS 

(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:

(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;

Consider the following tables CARDEN and CUSTOMER and answer(a) and (b) parts of this questions:
TABLE: CARDEN 

TABLE: CUSTOMER

(a) Write SQL commands for the following statements:
(i) To display the name of all the SILVER colored cars.
(ii) To display name of CAR,MAKE and sitting Capacity of cars in descending order of their sitting Capacity.
(iii) To display the higher Charges at which a vehicle can be hired from CARDEN.
(iv) Todisplay the customer name and the corresponding name of the cars hired by them.
(b) Give the output of the following SQL queries:
(i) SELECT COUNT(DISTINCT Make) FROM CARDEN;
(ii) SELECT MAX(Carges),MIN (Charges) FROM CARDEN;
(iii) SELECT COUNT(*) Make FROM CARDEN;
(iv) SELECT CarName FROM CARDEN WHERE Capacity=4;

Consider the following tables STORE and SUPPLIERS and answer (a) and (b) parts of this questions:
TABLE: STORE 

TABLE: SUPPLIERS 

(a) Write SQL commands for the following statements:
(i) To display details of all the items in the STORE table in ascending order of LastBuy.
(ii)To display ItemNo and Item name of those items from STORE table, whose Rate is more than Rs 15.
(iii) To display the details of those items whose Supplier code(Scode) is 22 or Quantity in store(Qty) is more than 110 from the table STORE.
(iv) To display minimum rate of items for each Supplier individually as per Scode from the table STORE.
(b) Give the output of the following SQL queries:
(i) SELECT COUNT(DISTINCT Scode) FROM STORE;
(ii) SELECT Rate *Qty FROM STORE WHERE ItemNo=2004;
(iii) SELECT Item, Sname FROM STORE S,SUPPLIERS P
WHERE S.Scode=P.Scode AND ItemNo=2006;
(iv) SELECT MAX(LastBuy) FROM STORE;

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

TABLE: STREAM 

(a) To display the name of streams in alphabetical order from table STREAM.
(b) To display the number of students whose POINTS are more than 5.
(c) To update GRADE to 'A' for all those students, who are getting more than 8 as POINTS.
(d) ARTS+MATHS stream is no more available. Make necesary change in table STREAM.
(e) SELECT SUM(POINTS) FROM STUDENT WHERE AGE>14;
(f) SELECT STRCDE, MAX(POINTS) FROM STUDENT GROUP BY STRCDE HAVING SCODE BETWEEN 105 AND 130;
(g) SELECT AVG(AGE) FROM STUDENT WHERE SCODE IN(102,105,110,120);
(h) SELECT COUNT(STRNAME) FROM STREAM WHERE STRNAME LIKE "SCI%";

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

TABLE:RECEIPIENT 

(a) To display the names of all Sender from Mumbai.
(b) To display the RecID, Sender Name, Sender Address, Rec Name, Rec Address for every Recipient.
(c) To display Recipient details in ascending order of RecName.
(d) To display number of Recipients from each city.
(e) SELECT DISTINCT SenderCity FROM SENDER;
(f) SELECT A.SenderName, B.Recname FROM SENDER A, RECIPIENT B
    WHERE A.Sender ID=B.SenderID AND B>RecCity='Mumbai';
(g) SELECT Recname, RecAddress FROM RECIPIENT
      WHERE RecCity NOT IN('Mumbai','Kolkata');
(h) SELECT RecID, RecNam FROM RECIPIENT
     WHERE SenderID='MU02' OR SenderID='ND50';

Reduce the following Boolean expression using K-Map:
F(A,B,C,D)=(0,1,2,4,5,8,9,10,11)

Reduce the following Boolean Expression using K-Map:
F(A,B,C,D)= \(\Sigma \)(0,1,2,4,5,6,8,10)

Reduce the folowing Boolean expression ussing K-Map
F(U,V,W,Z)=\(\Sigma \)(0,1,2,3,4,10,11)

If F(a,b,c,d)=(0,2,4,5,7,8,10,12,13,15), obtain the simplified form using K-Map

If F(a,b,c,d) = (0,1,3,4,5,7,8,9,11,12,13,15), obtain the simplified form using KMap

Write a function QINSERT() in C++ to perform insert operation on a linked queue, which contains client no and Client name.Consider the following definition of NODE in the code of QINSERT():
struct NODE
{
     long int Cno;              //Client number
     char Cname[20];        //Client name
     NODE *Next;
};

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;
};

Write a function QUEINS() in C++to insert an element in a dynamically allocated queue containing nodes of the following given structure.
struct Node
{
   int Pid;                      //Product id
   char Pname[20];        //Product name
   Node *Next;
};

Write a function in C++ to insert an element in a dynamically allocated queue,where each node contains a Name(char) as data.Assume the following definition of THENODE for the same:
structTHENODE
{
  char Name[20];
  THENODE *Link;
};

Write function PUSHBOOK() in C++ to perform insert operation on adynamic stack,which contains Book_no and Book_Titile.Consider the following defination of NODE,while writing your C++code.
struct NODE
{
  char Book_No;
  char Book_Title[20];
  NODE *Next;
};

Write a function COUT_TO() in C++ to cout the presence of aworld 'to' in text file NOTES.TXT is as it is very important to know that smoking is injurious to health,let us take initiative to stop it.The function COUT_TO()will display the following message cout of-to=in file:3

Write a function EUCout() in C++,which should reads each character of a a text file.IMP.TXT,should count and display the occurrence of
alphabets E and U (including small case e and u too). e.g. if the file contain is as follows: Update information is simplified by official websites.The EUCount() function should display the output as:
                           E:4
                           U:1

Write the function in C++ to read the content of a text file PLACES.TXT and display all those lines on screen,which are either starting with'P' or starting with'S'

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;}
};

Write a function in C++ to search for the details(phone no and Calls) of those phons, which have more than 1000 calls from a binary file phons.dat. Assuming that this binary file contains records? objects of class phone, which is defined below.
class phone
{
  char phoneno[10];
  int calls;
  public:
     void get(){gets(phoneno);
     cin>>calls;
     void billing(){cout<<int getCalls(){return calls;}
};

To show the working of function returning object.

To show the use of static function.

 Find the ouptput of the following :
#include< iostream.h >
#include< conio.h >
#include< stdio.h >
#include< string.h >
#include< ctupe.h >
void main( )
{
char *Name= “IntRAneT”;
for(int x =0; x=0;x < strlen(Name);x++)
{
if(islower(Name[x]))
Name[x]=toupper(Name[x]);
{
if(islower(Name[x]))
Name[x]=toupper (Name[x]);
else
if(isupper(Name[x]))
if(x%2==0)
Name[x]=tolower(Name[x]
else
ame[x]=Name[x-1];
}
puts(Name)
}
 

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 functions [I] to [IV].

Consider the following C++ code and answer the questions from (i) to (iv)
class Student
{
    int Class, Rno;
    char Section;
    protected:
       char SName[20];
   public:
       Student();
       void Stentry();
       void Stdisplay();
};
class Score : private Student
{
    float Marks[5];
    protected:
       char Grade[5];
    public:
       Score();
       void Sentry();
       void Sdisplay();
};
class Report : public Score
{
    float Total, Avg;
    public:
        char OverallGrade, Remarks[20];
        Report();
        void REaluate();
        void RPrint();

};
(i) Which type of inheritance is shown in the above example?
(ii) Write the names of those data members, which can be directly accessed from the objects of class Report.
(iii) Write the names of those member functions, which can be directly accessed  from the objects of class Report.
(iv) Write the names of those data members, which can be directly accessd from the Sentry() function of class Score.

To check the number is divisible by 6 or not using nested if statement

To show the use of continue statement.

Rewrite the following program after removing the syntactical error(s), (if any). Underline each correction.
#include<iostream.h>
const int Multiple 3;
void main()
{
value = 15;
for( int Counter=1; Counter=<5; Counter++, value-=2)
if(value%Multiple==0)
       cout<<Value*Multiple;        
       cout<<endl;
else 
       cout<<Value+Multiple<<endl;
}

Write the following program execute successfully? If not, state the reason(s).
#include<stdio.h>
void main()
{
    int x, sum=0;
    cin<<n;
    for( X=1, x<100, x+=2)
     if x%2==0
       sum +=x;
cout>>"sum=">>sum;
}

Write a program to print the following output after inputting the value of n. The user should be prompted again for the value of n, if the inputted value does not lie between 1 to 6 do the inclusive.

                                 1
                          1     2     3
                    1     2    3     4    5
              1    2     3    4     5     6    7
              -    -     -      -      -      -     -
     1       2   -     -     -       -     -      -   (2n-1)

Generally there are four data types, each of which can be signed or unsigned.Write names of all four data types.

If v is an identifier of int type and is holding value 255. Is the following statement correct?
char code = v;

Do you see any similarity between a typedef name and a reference name? If yes, what is it?

Which value of x will be printed in following case and why?
int x=9;
void main()
{
  int x = 10;
  cout<<x;
}

In the following program:
i) How many times will the while loop run?
ii) What would be the last value of A displaced out?
#include<iostream.h>
void main()
{
      int A=10;
      while(++A<15)
      { 
          cout<<A++;
     }
}

Which of the network (out of LAN, PAN and MAN) is formed, When you connect two mobiles using Bluetooth to transfer a picture file?

Write one advantage of bus topology of the network. Also, illustrate how four computers can be connected with each other using star topology of network?

Expand the following abbreviations:

(i) HTTP                     (ii) ARPANET 

What is a protocol? Which is used to search information from internet using an internet. 

What is the advantage of using SWITCH over HUB?

Write the Product of Sum(POS) form of the function F(X, Y, Z) for the following truth table representation of F:

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

Find the complement of the following boolean function \({ F }_{ 1 }=A.B+\bar { C } .\bar { D } \) :

Why are NAND and NOR gates called Universal gates?

Express \(P+\bar { Q } .R\) in canonical SOP form

What are DDL and DML?

Differentiate between SQL commands DROP TABLE and DROP VIEW.

Write a query on the SALESPEOPLE table, whose output will exclude all salespeople with a rating >=100, unless they are located in Delhi.

What is the difference between degree and cardinality of a table? What is the degree and cardinality of the following table?

Differentiate between the terms degree and cardinality in context of RDBMS. 

Explain the concept of candidate keys with the help of an appropriate example.

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?

How wil you know that a linear queue is full?

Suppose a circular queue maintained by an array Q with 12 memory locations and Front and Rear are the two pointers.
Find the number of elements in Q when:
(i) Front=4, Rear=8
(ii) Front=10, Rear=3
(iii) Front=5, Rear=6
and then two elements are deleted.

What are the drawbacks of linear queue?

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.

The changed content will be:

Write a function COUT_TO() in C++ to cout the presence of aworld 'to' in text file NOTES.TXT is as it is very important to know that smoking is injurious to health,let us take initiative to stop it.The function COUT_TO()will display the following message cout of-to=in file:3

Write a function EUCout() in C++,which should reads each character of a a text file.IMP.TXT,should count and display the occurrence of
alphabets E and U (including small case e and u too). e.g. if the file contain is as follows: Update information is simplified by official websites.The EUCount() function should display the output as:
                           E:4
                           U:1

Write a function in C++ to search for the details(phone no and Calls) of those phons, which have more than 1000 calls from a binary file phons.dat. Assuming that this binary file contains records? objects of class phone, which is defined below.
class phone
{
  char phoneno[10];
  int calls;
  public:
     void get(){gets(phoneno);
     cin>>calls;
     void billing(){cout<<int getCalls(){return calls;}
};

Write a function in C++ to count the words "to" and "the" present in a text file POEM.TXT.(Note that the words "to" and "the" are complete words.)

Write a function to count the member of words prsent in a text file named PAPER.TXT.Assume that each word is separated by a single blank/space in the beginning and end of the file.

How are the object's behaviour and object's characteristics represented in OOP?

Why function overloading is used?

How are abstraction and encapulation interrelated?

Inheritance allows code reusability in OOp.Explain how?

Observe the program segment carefully and answer the question that follows: class member
{
int member_no;
char member_name[20];
public:
void enterDetail( );
void showDetail( );
int getMember_no( ){ return member_no;}
};
void update(member NEW )
{
fstream File;
File.open( “member.dat”, ios::binary|ios::in|ios::out) ;
member i;
while(File .read((char*) & i , sizeof (i)))
{
if(NEW . getMember_no( ) = = i . getMember_no( ))
{
___________//missing statement
File.write((char*) &NEW , sizeof (NEW));
}
}
File.close() ;
}
If the function update( ) is supposed to modify the member_name field of a record in the file “ member.dat” with the values of member NEW passed as argument, write the appropriate statement for the missing statement using seekp( ) or seekg( ), whichever is needed, in the above code that would write the modified record at its proper place.

Generally there are four data types, each of which can be signed or unsigned.Write names of all four data types.

How 'I' operator is different from '%' operator?

What is wrong with the following C++ statement?
long float y;

Differentiate between an identifier and keywords.

Show two different ways to declare as integer variable named intname and set its value to 15.