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

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, which is/are essentially required to run/execute the following C++ code.
void main()
{
     char CH,Text[]="+ve Attitude";
     for(int I=0;Text[I]!='\0';I++)
        if(Text[I]=='  ')
              cout<<endl;
        else
        {
     CH=toupper(Text[I]);
      cout<<CH;
       }
}

A function printing is defined as
void printing(char c= '*', int l=40)
{
   for(int x=0;x<1;x++)
   cout<<c;
 cout<<endl;
}
How will you invoke the function printing for following output:
i) to print '*' 40 times
ii) to print '=' 30 times

What are nested structures? Give an example.

Write declaration for two overloadded functions named bar().They both return float type.the first takes one argument of type char and second takes two argument of type char.If this impossible,explain why?

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

Write two applications of cyber law:

What is the difference between #define and const? Explain with suitable example.

c^^

What is the relationship between class and object?Illustrate with a suitable example.

QUEUE is a queue with 6 memory locations and with Front=2, Rear=5. Indexing should be start from 1.QUEUE:......., Lindon, Berlin, Rome, Paris,........Where......, denoted empty locations.
  Diagrammatically display the queue including Front and Rear as the following operations take place:
 (i) Athens is added
(ii) Two cities are deleted
(iii) Madrid is added
(iv) Moscow is added
(v) Three cities are deleted
(vi) Oslo is added

Convert \(\bar { X } .Y+Y.(\bar { Z } (\bar { Z } +Y))\) into canonical product of sums form.

To show the use of goto statement.

Write a function QDELETE() in C++ to perform delete operation on a Linked Queue, which contains Passenger number and Passenger name.Consider the following definition of node in the code:
struct node
{
  long int Pno;
  char Pname[20];
  node *Link;
};
 

Answer the questions (a) and (b) on the basis of the following tables SHOPPE and ACCESSORIES.
                                             TABLE SHOPPE

                                         TABLE ACCESSORIES

(a) Write the SQL queries:

(i) To display Name and price of all the Accessories in ascending order of their price.
(ii) To display id and Sname of all Shoppe located in Nehru place.
(iii) To display Minimum and Maximum price of each Name of Accessories.
(iv) To display Name,Price of all Accessories and their respective SName,where they are available.
(b) Write the output of the following SQL commands;
(i) SELECT DISTINCT NAME FROM ACCESSORIES WHERE PRICE>=5000;
(ii)SELECT AREA.COUNT (*) FROM SHOPPE GROUP BY AREA;
(iii)SELECT COUNT (DISTINCT AREA) FROM SHOPPE;
(iv)SELECT NAME,PRICE*0.05 DISCOUNT FROM ACCESSORIES WHERESNO IN ('S02','S03');

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;

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

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