Write the equivalent Boolean Expression F for the following circuit diagram :

Convert the following Boolean expression into its equivalent Canonical Sum of Product Form((SOP) (X’+Y+Z’).(X’+Y+Z).(X’+Y’+Z).(X’+Y’+Z’)

Assume that a text file named text1.txt already contains some text written into it, write a function named vowelwords(), that reads the file text1.txt and create a new file named text2.txt, which shall contain only those words from the file text1.txt which don’t start with an uppercase vowel(i.e., with ‘A’,’E’,’I’,’O’,’U’). for example if the file text1.txt contains: Take One Apple And one glass milk daily. Then the file text2.txt shall contain : Take one glass milk daily.

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

Define a function in c++, which accepts a two dimensional array of integer and its size as argument and displays the element of middle row and the element of middle column.
e.g.
if the two dimensional array contains:

Output
Middle row: 6 7 8 
Middle column: 4 7 2 

Write a Get1From2() function in c++ to transfer the content from two array FIRST[] and SECOND[] to array ALL[].the even places(0,2,4...) of array ALL[] should get the content from the array First[] and odd places (1,3,5,...) of the array ALL[] should get the content from the array SECOND[].
e.g if the FIRST[]array contain
       30,60,90
and the SECOND[] array contains
       10,50,80
 The ALL[] array should contain
       30,10,60,50,90,80

Rewrite the following program after removing the syntactical errors if any.Underline each correction.
#include<iostream.h>
void main()
{
   First=10,Second=20;
   Jumpto(First;Second);
   Jumpto(Second);
}
void Jumpto(int N!,int N2=20)
{
    N1=N1+N2;
    cout<<N1>>N2;
}

Find out the expected correct output from the options (i) to (iv) for the following C++ code.Also find out the minimum and the maximum value that can be assigned to the variable stop used in the code.
void main()
{
     int Begin=3,stop;
     for(int Run=1;Run<4;Run++)
    {
       stop=random(Begin)+6;
       cout<<Begin++<<stop<<"*";
   }
}
i) 36*46*59*  ii) 37*46*56*   iii) 37*48*57*   iv) 35*45*57*

Find The output of the following program:
# include
class METRO
{
     int Mno , TripNo , PassengerCount;
     public:
         METRO (int Tmno = 1)
         {
               Mno = Tmno;
               TripNo=0;
                PassengerCount = 0;
         void Trip (int PC=20)
         {
              TripNo++;
               PassengerCount += PC;
         }
         void StatusShow ( )
         {
          count<<Mno<<<<":"<<TripNo<<":"<<Passengercount<<end1;
         }
};
void main ( )
{
    METRO M (5) , T;
    M. Trip ( );
    T. Trip (50);
    M. StatusShow ( );
    M. Trip (30) ;
    T. StatusShow ( );
    M. StatusShow ( );

Find the output of the following program:

#include<iostream.h>
void main()
{
    int A=5,B=10;
    for( int I=1; I<=2;I++)
    {
          cout<<"Line 1="<<A++<<"&"<<B-2<<endl; 
         cout<<"Line 2="<<++B<<"&"<<A+3<<endl;

     } 

}

What is the need of normalization?

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

What will be the output of the following program?
int area (int s)
{
   return (s*s);
}
float area (int b, int h)
{
   return (0.5*b*h);
}
void main()
{
cout< cout< cout< getch();
}

Give the logic function F=AB+A’B’+A’B. Assuming the complements are available. Simplify the function using De Morgan’s Theorem. Synthesize F by using NOR gates only.

Given the logic function F = xyz + yz’w + x’yz. Minimize it using K- Map.

 Write a function in C++ to add a new object in a binary file “Customer.dat”. assume the binary file is containing the objects of the following class: class customer
{
int CNo; Char CName[21];
public:
void Enterdata( )
{cin>>CNo.;gets(CName);} v
oid dispdata( )
{ cout<< CNo.<<CName;}
};

Find the output of the following program:
#include< iostream.h >
 void main( )
{
long NUM=1234543;
int F=0,S=0;
do
{
int R=NUM % 10;
f (R %2 != 0)
F += R;
else S += R;
NUM / = 10;
}
while (NUM>0);
cout<< F-s
}

Evaluate the following postfix notation of expression:
20,10,+,5,2,*,-,10,/

To print the numbers from 1 to 10 with the help of while loop

To know the use of if-else statement.

An array ARR[10][20] is stored in the memory with each element occupying 2 bytes of space. Assuming the base address of ARR to be 800,compute the address of ARR[9][11], when the array is stored as :
i) Row wise ii) Column wise

An array ARR[15][20] is stored in the memory, along the row with each element occupying 4 bytes . Find out the base address and the address of the element ARR[3][2] if the element ARR[5][2] is stored at the address 1500.

 Answer the questions (i) to (iv) based on following code:
class World
{
int H;
protected int s;
public:
void INPUT(int);
void OUTPUT( );
};
class Country :
private World
{
int T;
protected:
int U;
public :
void INDATA(int, int);
void OUTDATA();
};
class State :
Public Country
{
int M; public :
void DISPLAY(void);
};
(i) Name the base class and derived class of the class Country.
(ii) Name the data member that can be accessed from function DISPLAY( )
(iii) Name the member functions, which can be accessed from the objects of class State.
(iv) Is the member function OUTPUT() accessible by the objects of the class Country ?

 Answer the questions (i) to (iv) based on the following code :
class CUSTOMER
{ int Cust_no;
char Cust_Name[20];
protected:
void Register();
public: CUSTOMER();
void Status(); };
class SALESMAN
{
int Salesman_no;
char Salesman_Name[20];
protected: float Salary;
public: SALESMAN();
void Enter( );
void Show( );
};
class SHOP :
private CUSTOMER , public SALESMAN
{
char Voucher_No[10];
char Sales_Date[8];
public:
SHOP();
void Sales_Entry();
void Sales_Detail();
}
(iii) Write the names of data members which are accessible from objects belonging to class CUSTOMER.
(iv) Write the names of all the member functions which are accessible from objects belonging to class SALESMAN.
(v) Write the names of all the members which are accessible from member functions of class SHOP. (iv) How many bytes will be required by an object belonging to SHOP?

Trine Tech Corporation (TTC) is a professional consultancy company. the company is planning to set up their offices in India with its hub at Hyderabad. As a network advisor, you have to understand their requirement and suggest them the best available solutions. Their queries are mentioned as (i) to (iv) below.
Block to block distance(in m)

 Expected number of computers to be in each block

(i) Which will be the most appropriate block, where TTC should plan to install their server?
(ii) Draw a block to block cable layout to connect all the building in the most appropriate manner for efficient communication.
(iii) What will be the best possible connectivity out of the following, you will suggest to connect the new setup of offices in Bangalore with its London based office.

•   Satellite link                  
•   Infrared

(iv) Which of the following device will be suggested by you to connect each computer in each of the buildings?

• Switch                    
• Modem
• Gateway

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 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'

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

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)

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');

Observe the program segment given below carefully and fill the blanks marked as Statement 1 and Statement 2 using seekg() and tellg() functions for performing the required task
#include
class Employee
{
int Eno;char Ename[20];
public:
//Function to count the total number of records
int Countrec();
};
int Item::Countrec()
{
fstream File;
File.open("EMP.DAT",ios::binary|ios::in);
______________________ ///Statement 1- To take the file pointer to
//the end of file.
int Bytes =
______________________ //Statement 2-To return total number of bytes from the beginning of file to the file pointer.
int Count = Bytes / sizeof(Item);
File.close();
return Count;
}

Observe the program segment given below carefully and fill the blanks marked as Statement 1 and Statement 2 using seekp() and seekg() functions for performing the required task
#include <fstream.h >
class Item
{
int Ino;char Item[20];
public:
//Function to search and display the content from a particular record number
void Search(int );
//Function to modify the content of a particular record number
void Modify(int);
};
void Item::Search(int RecNo)
{
fstream File;
File.open("STOCK.DAT",ios::binary| ios::in);
_______________//Statement 1
File.read((char*)this,sizeof(Item));
cout<"< File.close();
}
void Item::Modify(int RecNo)
{
fstream File;
File.open("STOCK.DAT",ios::binary|ios::in|ios::out);
cout>>Ino;
cin.getline(Item,20);
____________//Statement 2
File.write((char*)this,sizeof(Item));
File.close();
}

Why are NAND and NOR gates called Universal gates?

State the distributive laws of boolean algebra. How do they differ from the distributive laws of ordinary algebra?

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

Write the Sum of Product(SOP) form of the function F(A,B,C) for the following truth table representation of F: 

Write the Sum of Product(SOP) form of the function F(P,Q, R) for the following truth table representation of F: 

Name any two common web browsers.

Create a table named PROGRAMMERS with the following structure:

i) Display the name of the programmer, which has the highest salary.
ii) Update the salary of all programmer by 2000 whose name start with letter 'R'.

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

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

Differentiate between SQL commands DROP TABLE and DROP VIEW.

What are DDL and DML?

Name any two components required for networking.

What is the function modem?

In the networking, what is WAN? How is it different from LAN?

Write one advantage of star topology of network? Also, illustrate how five computers can be connected with each other using star topology of ntework

Suppose a data structure is stored in a circular queue with N memory locations what will be the queue full condition?

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?

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

How does a compiler decide as to which function should be invoked when there are many functions with the same name?

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?

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

How are abstraction and encapulation interrelated?

Differentiate between an identifier and keywords.

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

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

Study the following tables FLIGHTS and FARES and Write SQL commands for the questions (a) to (d) and give outputs for SQL queries (e) and (f)
TABLE: FLIGHTS

TABLE: FARES 

(a) Display FL_NO and NO_FLIGHT from KANPUR to BENGALURU from the table FLIGHTS.
(b) Arrange the contents of the table FLIGHTS in the ascending order of FL_NO.
(c) Display the FL_NO and fare to be paid for the flights from DELHI to MUMBAI using the tables FLIGHTS and FARES where the fare to be paid=FARE+FARE*TAX0.
(d) Display the minimum fare INDIAN AIRLINES is offering from the table FARES.
(e) SELECT FL_NO. NO_FLIGHT, AIRLINES FROM FLIGHTS, FARES
 WHERE STARTING='DELHI' AND FLIGHTS.FL_NO=FARES.FL_NO;
(f) SELECT COUNT(DISTINCT ENDING) FROM FLIGHTS;

Study the following tables DOCTOR and SALARY and write SQL commands for the equations (a) to (d) and give outputs for SQL queries (e) and (f) 
TABLE: DOCTOR 

TABLE: SALARY 

(a) Display NAME of all doctors who are in MEDICINE department having more than 10 yrs experience from the table DOCTOR.
(b) Display the average salary of all doctors working in ENT department using the tables DOCTOR and SALARY.SALARY=BASIC+ ALLOWANCE.
(c) Display the minimum ALLOWANCE of female doctors.
(d) Display the highest consultation fee among all male doctors.
(e) SELECT COUNT(*) FROM DOCTOR WHERE SEX='F';
(f) SELECT NAME, DEPT, BASIC FROM DOCTOR, SALARY
WHERE DEPT='ENT' AND DOCTOR.ID=SALARY.ID;

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%";

Write SQL queries for (a) to (f) and write the outputs for (g) parts (i) to (iv) on the basis of tables APPLICANTS and COURSES.
TABLE: APPLICANTS

TABLE: COURSES 

(a) To display NAME, FEE, Gender, JOINYEAR about the APPLICANTS, who have joined 
before 2010.
(b) To display the names of applicants, who are paying FEE more than 30000.
(c) To display the names of all applicants in ascending order of their joinyear.
(d) To display the year and the total number of applicants joined in each year
from the table APPLICANTS>
(e) To display the C_ID and the number of applicants registered in the course 
from the APPLICANTS table.
(f) To display the applicant's name with their respective course's name from the 
tables APPLICANTS and COURSES.
(g) Give the output of the following SQL statements:
(i) SELECT NAME,JOINYEAR FROM APPLICANTS WHERE GENDER='F' AND C_ID='A02';
(ii) SELECT MIN(JOINYEAR) FROM APPLICANTS WHERE GENDER='M';
(iii) SELECT AVG(FEE) FROM APPLICANTS WHERE C_ID='A01' OR C_ID='A05';
(iv) SELECT SUM(FEE), C_ID FROM APPLICANTS GROUP BY C_ID HAVING COUNT(*)=2;

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;