Science (English Medium) Class 12 - CBSE Question Bank Solutions

Observe the following table carefully and· write the names of the most appropriate columns, which can be considered as (i) candidate keys and. (ii) primary key:

Write the definition of a function SumEO(int VALUES[], int N) in C++, which should display the 4 sum of even value and sum of odd values of the array separately.

Example: If the array VALUES contains

Then the functions should display the output as:

Sum of even values = 42 (i.e., 20+22)

Sum of odd values= 99 (i.e., 25+21+53)

Write a definition for a function UpperHalf(int Mat[4][4]) in C++ which displays the elements in the same way as per the example is shown below.

For example, if the content of the array Mat is as follows:

Thew function should display the content in the following format:

Let us assume Data[20][15] 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 Data(10][5], if the element Data[10][l5] is stored at the memory location 15000.

Write SQL queries for (i) to (iv) and find outputs for SQL queries (v) to (viii) which are based on the table.

TABLE: Account

TABLE: TRANSACT

1) To display details of all transaction of TYPE Depos1t from Table TRANSACT.

2) To display the ANO and AMOUNT of all Depos1ts and Withdrawals done in the month of October 2017 from table TRANSACT.

3) To display the last date of the transaction (DOT) from the table TRANSACT for the Accounts having ANO as 103

4) To display all ANO, ANAME and DOT of those persons from tables ACCOUNT and TRANSACT who have done transactions less than or equal to 3000?

5) SELECT ANO, ANAME FROM ACCOUNT WHERE ADDRESS NOT IN ('CHENNAI', 'BANGALORE');

6) SELECT DISTINCT ANO FROM TRANSACT

7) SELECT ANO, COUNT(*), MIN(AMOUNT) FROM TRANSACT GROUP BY AND HAVING COUNT(*) > 1;

8) SELECT COUNT(*), SUM(AMOUNT) FROM TRANSACT WHERE DOT <= '2017-06-01'

State any one Absorption Law of Boolean Algebra and verily it using truth table.

ARR[15] ft:20] is a two-dimensional array, which is stored in the memory along the row with each of its elements occupying 4 .bytes. Find the .address of the element ARR[5)[15], if the element ARR[lO] [5] is stored at the memory location 35000.

Observe the following table MEMBER 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 :

MEMBER

RESULT

Write SQL queries for (i) to (iv) and find outputs for SQL queries (v) to (viii), which are based on the tables.

DVD

MEMBER

1) To display all details from the table MEMBER in descending order of ISSUEDATE

2) To display the DCODE and DTITLE of all Folk Type DVDs from the table DVD.

3) To display the DTYPE and number of DVDs in each DTYPE from the table DVD.

4) To display all NAME and ISSUEDATE of those members from the table. MEMBER who have DVDs issued (i.e., ISSUEDATE) in the year 2017

5) SELECT MIN(ISSUEDATE) FROM MEMBER

6) SELECT DISTINCT DTYPE FROM DVD;

7) SELECT D.DCODE, NAME, DTITLE FROM DVD D, MEMBER M WHERE D.DCODE=M.DCODE;

8) SELECT DTITLE FROM DVD WHERE DTYPE NOT IN ("Folk", "Classical" ) ;

Give a suitable example in C++ to illustrate with its definition within a class and a declaration of an object with the help of it.

A two-dimensional array ARR[50][20] is stored in the memory along the row with each of its elements occupying 4 bytes. Find the address of the element ARR[30] [10], if the element ARR[10] [5] is stored at the memory location 15000.

Write a function REVROW(int P[] [5], int N, int M) in C++ to display the content of a two-dimensional array, with each row content in reverse order.

For example, if the content of the array is as follows:

The function should display output as

Consider the following DEPT and EMPLOYEE tables. Write SQL queries for (i) to (iv) and find outputs for SQL queries (v) to (viii).

Table: DEPT

Table: EMPLOYEE

Note: DOJ refers to the date of joining ·and DOB refers to the date of Birth of employees

1) To display Eno, Name, Gender from the table EMPLOYEE in ascending order of Eno.

2) To display the Name of all the MALE Employees from the table EMPLOYEE.

3) To display the Eno and Name of those employees from the table EMPLOYEE who are born between '1987-01-01' and '1991-12-01'.

4) To count and display FEMALE employees who have Joined after '1986-01-01'.

5) SELECT COUNT(*), DCODE FROM EMPLOYEE GROUP BY DCODE HAVING COUNT(*)>1;

6) SELECT DISTINCT DEPARTMENT FROM DEPT;

7) SELECT NAME, DEPARTMENT FROM EMPLOYEE E, DEPT D WHERE E.DCODE=D.DCODE AND EN0<1003;

8) SELECT MAX(DOJ), MIN(DOB) FROM EMPLOYEE;

Verify the following using Boolean Laws : U'+V = U'V'+ U' .V + U.V

Answer the question (i)  to (iv) based on the following:

class Teacher
{
   int TCode;
protected:
      char Name[20];
public:
      Teacher();
      void Enter() ; void Show();
};

class Course
(
   int ID;
protected:
      Char Title[30];
public:
      Course();
      void Initiate();
      void Display();
};

class Schedule : public Course, private Teacher
{
    int DD, MM, YYYY;
public:
    Schedule();
    void Start();
    void View();
};

void main()
{
   Schedule S;
}

1) Which type of Inheritance out of the following is illustrated in the above example?

2) Write the name of all the member which are directly accessible by the member function View() of Class Schedule.

3) Write the names of all the members, which are directly accessible by the object S of Class Schedule declared in the main() function.

4) What will be the order of execution of the constructors, when the object S of the Class Schedule Schedule is declared inside the main() function?

Answer the questions (i) to (iv) based on the following:

class First
{
    int X1;
protected:
    float X2;
public:
    First();
    void Enter1(); void Display1;
};

class Second: private First
{
    int Y1;
protected:
    float Y2;
public:
    Second();
    void Enter2();
    void Display();
};

class Third : public Second
{
    int Z1;
public:
    Third{);
    void Enter3();
    void Display{);
};

void main()
{
    Third T;  //Statement 1·
    __________;  // Statement 2
}

1) Which type of Inheritance out of the following is illustrated in the above example?

Single Level Inheritance, Multilevel Inheritance, Multiple Inheritance

2) Write the names of all the member functions, which are directly accessible by the object T of class Third as declared in main() function.

3) Write Statement 2 to call function Display() of class Second from the object T of class Third

4) What will be the order of execution of the constructors, when the object T of class Third is declared inside main()?

Answer the questions (i) to (iv) based on the following:

class Interior
{
    int Orderid;
    char Address[20];
protected:
   float Advance;
public:
   Interior();
   void Book(); void View();
};

class Painting:public Interior
{
    int Wall,Area,ColorCode;
protected:
    char Type;
public:
   Painting();
   void PBook();
   void PView();
};

class Billing : public Painting
{
   float Charges;
   void Calculate();
public:
   Billing();
   void Bill();
   void BillPrint();
};

1) Which type of Inheritance out of the following is illustrated in the above example?

• Single Level Inheritance
• Multi-Level Inheritance
• Multiple Inheritance

2) Write the names of all the data members, which are directly accessible from the member functions of class Painting.

3) Write the names of all the member functions, which are directly accessible from an object of class Billing.

4) What will be the order of execution of the constructors, when an object of class Billing is declared?

Find and write the output of the. following C++ program code

Note : Assume au· required header files are already included in the program.

#define Diff(N1,N2) ((N1>N2)?Nl-N2:N2-N1)
void main()
{
    int A,B,NUM[] = {10,23,14,54,32};
    for(int CNT =4; CNT > 0; CNT--)
    {
        A=NUM[CNT];
        B=NUM[CNT-1];
        cout<<Diff(A,B)<< '#';
    }
}

Find and write the output of the following C++ program code:

Note: Assume all required header files are already included in the program

void Revert(int &Num, int Last=2)
{
   Last =(Last%2==0)?Last+l: Last - l;
   for(int C=l; C <= Last; C++)
      Num+=C;
)

void main()
{
    int A=20, B=4;
    Revert(A, B) ;
    cout<<A<<"&"<<B<<end1;
    B--;
    Revert{A,B);
    cout<<A<<"#"<<B<<endl;
    Revert{B);
    cout<<A<<"#"<<B<<endl;
}

Observe the following C++ code and answer the questions (i) and (ii).

Note: Assume all necessary files are included.

class FIRST
{
   int Numl;
public:
    void Display()
    {
        cout<<Numl<<endl;            //Member Function 1
    }
};

class SECOND: public FIRST
{
    int Num2;
public:
     void Display()                //Member Function 2
     {
         cout<<Num2<<endl;
     }
};

Void main()
{
   SECOND S;
   ___________                    // Statement 1
   ___________                    // Statement 2
  
}

1) Which Objected Programming features is illustrated by the definition of classes FIRST and SECOND?

2) Write Statement 1 and Statement 2 to execute Member Function 1 and Member Function 2 respectively using the object S