Arts (English Medium) इयत्ता १२ - CBSE Important Questions

A Binary file, CINEMA.DAT has the following structure:

{MNO:[MNAME, MTYPE]}

Where

• MNO - Movie Number
• MNAME - Movie Name
• MTYPE is Movie Type

Write a user defined function, findType(mtype), that accepts mtype as parameter and displays all the records from the binary file CINEMA.DAT, that have the value of Movie Type as mtype.

How are text files different from binary files?

Explain the use of ‘Foreign Key’ in a Relational Database Management System. Give example to support your answer.

Explain the concept of “Alternate Key” in a Relational Database Management System with an appropriate example.

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?

Give one difference between alternate key and candidate key.

______ command is used to remove the primary key from a table in SQL.

Which of the following commands will delete the table from the MYSQL database?

______ is a non-key attribute, whose values are derived from the primary key of some other table.

Which function is used to display the total number of records from a table in a database?

To establish a connection between Python and SQL databases, connect() is used. Which of the following arguments may not necessarily be given while calling connect()?

Differentiate between count() and count(*) functions in SQL with appropriate examples.

Consider the following tables – Bank_Account and Branch:

Table: Bank_Account

Table: Branch

What will be the output of the following statement?

SELECT * FROM Bank_Account NATURAL JOIN Branch;

Write the output of the queries based on the table, TECH_COURSE given below:

1. SELECT DISTINCT TID FROM TECH_COURSE;
2. SELECT TID, COUNT(*), MIN(FEES) FROM TECH_COURSE GROUP BY TID HAVING COUNT(TID)>1;
3. SELECT CNAME FROM TECH_COURSE WHERE FEES>15000 ORDER BY CNAME;
4. SELECT AVG(FEES) FROM TECH_COURSE WHERE FEES BETWEEN 15000 AND 17000;

Write the outputs of the SQL queries based on the relations Teacher and Placement given below:

Table: Teacher

Table: Placement

1. SELECT Department, avg(salary) FROM Teacher GROUP BY Department;
2. SELECT MAX(Date_of_Join), MIN(Date_of_Join) FROM Teacher;
3. SELECT Name, Salary, T.Department, Place FROM Teacher T, Placement P WHERE T.Department = P.Department AND Salary>20000;
4. SELECT Name, Place FROM Teacher T, Placement P WHERE Gender = ’F’ AND T.Department = P.Department;

Write the command to view all tables in a database.

Predict the output of the code given below:

s="welcome2cs" 

n = len(s)
m=""
for i in range(0, n):
       if (s[i] >= 'a' and s[i] <= 'm'):
            m = m +s[i].upper()
 elif (s[i] >= 'n' and s[i] <= 'z'):
          m = m +s[i-1]
 elif (s[i].isupper()):
     m = m + s[i].lower()
 else:
     m = m +'&'
print(m)

The code given below reads the following record from the table named student and displays only those records that have marks greater than 75:

• RollNo - integer
• Name - string
• Clas - integer
• Marks - integer

Note the following to establish connectivity between Python and MYSQL:

• Username is root.
• The password is the tiger.
• The table exists in an MYSQL database named school.

Write the following missing statements to complete the code:

Statement 1 - to form the cursor object
Statement 2 - to execute the query that extracts records of those students whose marks are greater than 75.
Statement 3 - to read the complete result of the query (records whose marks are greater than 75) into the object named data, from the table student in the database.

import mysql.connector as mysql
def sql_data():
       con1=mysql.connect(host="localhost",user="root",password="tiger", database="school")
       mycursor=_______________ #Statement 1
       print("Students with marks greater than 75 are :")
                  _________________________ #Statement 2
                 data=__________________ #Statement 3
                for i in data:
                   print(i)
                print()

Navdeep creates a table RESULT with a set of records to maintain the marks secured by students in Sem1, Sem2, Sem3, and their divisions. After the creation of the table, he entered data of 7 students in the table.

Based on the data given above answer the following questions:

1. Identify the most appropriate column, which can be considered as the Primary key.
2. If two columns are added and 2 rows are deleted from the table result, what will be the new degree and cardinality of the above table?
3. Write the statements to:
   a. Insert the following record into the table
   Roll No - 108, Name - Aadit, Sem1- 470, Sem2 - 444, Sem3 - 475, Div - I.
   b. Increase the SEM2 marks of the students 3% whose name begins with ‘N’.
   OR
   Write the statements to:
   a. Delete the record of students securing IV division.
   b. Add a column REMARKS in the table with datatype as varchar with 50 characters.