Commerce (English Medium) इयत्ता १२ - CBSE Question Bank Solutions

Write the output of the queries (i) to (iv) based on the table, WORKER given below:

TABLE: WORKER

1. SELECT F_NAME, CITY FROM WORKER ORDER BY STATE DESC;
2. SELECT DISTINCT (CITY) FROM WORKER;
3. SELECT F_NAME, STATE FROM WORKER WHERE L_NAME LIKE '_HA%';
4. SELECT CITY, COUNT(*) FROM WORKER GROUP BY CITY;

Write the definition of a Python function named LongLines() which reads the contents of a text file named 'LINES.TXT' and displays those lines from the file which have at least 10 words in it. For example, if the content of 'LINES.TXT' is as follows: 

Once upon a time, there was a woodcutter
He lived in a little house in a beautiful, green wood.
One day, he was merrily chopping some wood.
He saw a little girl skipping through the woods, whistling happily.
The girl was followed by a big gray wolf. 

Then the function should display output as:

He lived in a little house in a beautiful, green wood.
He saw a little girl skipping through the woods, whistling happily.

Write a function count_Dwords() in Python to count the words ending with a digit in a text file "Details.txt".

Example:
If the file content is as follows:
On seat2 V1P1 will sit and
On seat1 VVIP2 will be sitting
The output will be:
The number of words ending with a digit is 4

Write the outputs of the SQL queries (i) to (iv) based on the relations COMPUTER and SALES given below:

1. SELECT MIN(PRICE), MAX(PRICE) FROM COMPUTER;
2. SELECT COMPANY, COUNT(*) FROM COMPUTER GROUP BY COMPANY HAVING COUNT(COMPANY) > 1;
3. SELECT PROD_NAME, QTY_SOLD FROM COMPUTER C, SALES S WHERE C.PROD_ID=S.PROD_ID AND TYPE = 'INPUT';
4. SELECT PROD_NAME, COMPANY, QUARTER FROM COMPUTER C, SALES S WHERE C.PROD_ID=S.PROD_ID;

The code given below reads the following records from the table employee and displays only those records that have employees coming from the city 'Delhi':

E_code - String
E_name - String
Sal - Integer
City - String

Note the following to establish connectivity between Python and MySQL:

• Username is root
• Password is root
• The table exists in a MySQL database named emp.
• The details (E_code,E_name,Sal,City) are the attributes of the table.

Write the following statements to complete the code:

Statement 1 - to import the desired library.

Statement 2 - to execute the query that fetches records of the employees/coming from the city ‘Delhi’.

Statement 3 - to read the complete data of the query (rows whose city is Delhi) into the object named details, from the table employee in the database.

import ____________ as mysql  #Statement 1
def display():
   mydb=mysql.connect(host="localhost",user="root"
   passwd="root", database=" emp")
   mycursor=mydb.cursor()
   ____________ #Statement 2
   details = ____________ # Statement 3
   for i in details:
       print (i)

The school has asked their estate manager Mr Rahul to maintain the data of all the labs in a table LAB. Rahul has created a table and entered data from 5 labs.

Based on the data given above answer the following questions:

(i) Identify the columns which can be considered as Candidate keys.

(ii) Write the degree and cardinality of the table.

(iii) Write the statements to:

      (a) Insert a new row with appropriate data.

      (b) Increase the capacity of all the labs by 10 students which are on
           the 'I' Floor.

                                     OR

(iii) Write the statements to:

        (a) Add a constraints PRIMARY KEY to the column LABNO in the table.

        (b) Delete the table LAB.

Which of the following statements is FALSE about keys in a relational database?

In case of ______ switching, before a communication starts, a dedicated path is identified between the sender and the receiver.

Write a function, lenWords(STRING), that takes a string as an argument and returns a tuple containing length of each word of a string.
For example, if the string is "Come let us have some fun", the tuple will have (4, 3, 2, 4, 4, 3)

Consider the table CLUB given below and write the output of the SQL queries that follow.

1. SELECT COUNT(DISTINCT SPORTS) FROM CLUB;
2. SELECT CNAME, SPORTS FROM CLUB
   WHERE DOAPP<"2006-04-30" AND CNAME LIKE "%NA";
3. SELECT CNAME, AGE, PAY FROM CLUB WHERE GENDER = "MALE" AND PAY BETWEEN 1000 AND 1200;

Write a function in Python to read a text file, Alpha.txt and displays those lines which begin with the word ‘You’.

Write a function, vowelCount() in Python that counts and displays the number of vowels in the text file named Poem.txt.

Consider the tables PRODUCT and BRAND given below:

Write SQL queries for the following:

1. Display product name and brand name from the tables PRODUCT and BRAND.
2. Display the structure of the table PRODUCT.
3. Display the average rating of Medimix and Dove brands.
4. Display the name, price, and rating of products in descending order of rating.

How is http different from https?

Give one difference between alternate key and candidate key.

Define the following:

Exception Handling

Define the following:

Throwing an exception

Define the following:

Catching an exception

Explain catching exceptions using try and except block.

You have learnt how to use math module in Class XI. Write a code where you use the wrong number of arguments for a method (say sqrt() or pow()). Use the exception handling process to catch the ValueError exception.