Category: Class 12

Tamilnadu State Board New Syllabus Samacheer Kalvi 12th Computer Science Guide Pdf Chapter 15 Data Manipulation Through SQL Text Book Back Questions and Answers, Notes.

Tamilnadu Samacheer Kalvi 12th Computer Science Solutions Chapter 15 Data Manipulation Through SQL

12th Computer Science Guide Data Manipulation Through SQL Text Book Questions and Answers

I. Choose the best answer (I Marks)

Question 1
Which of the following is an organized collection of data?
a) Database
b) DBMS
c) Information
d) Records
Answer:
a) Database

Question 2.
SQLite falls under which database system?
a) Flat file database system
b) Relational Database system
c) Hierarchical database system
d) Object oriented Database system
Answer:
b) Relational Database system

Question 3.
Which of the following is a control structure used to traverse and fetch the records of the database?
a) Pointer
b) Key
c) Cursor
d) Insertion point
Answer:
c) Cursor

Question 4.
Any changes made in the values of the record should be saved by the command
a) Save
b) Save As
c) Commit
d) Oblige
Answer:
c) Commit

Question 5.
Which of the following executes the SQL command to perform some action?
a) execute()
b) Key()
c) Cursor()
d) run()
Answer:
a) execute()

Question 6.
Which of the following function retrieves the average of a selected column of rows in a table?
a) Add()
b) SUM()
c) AVG()
d) AVERAGE()
Answer:
c) AVG()

Question 7.
The function that returns the largest value of the selected column is
a) MAX()
b) LARGE ()
c) HIGH ()
d) MAXIMUM ()
Answer:
a) MAX()

Question 8.
Which of the following is called the master table?
a) sqlite_master
b) sql_master
c) main_master
d) master_main
Answer:
a) sqlite_master

Question 9.
The most commonly used statement in SQL is
a) cursor
b) select
c) execute
d) commit
Answer:
b) select

Question 10.
Which of the following clause avoid the duplicate?
a) Distinct
b) Remove
c) Wher
d) Group By
Answer:
a) Distinct

II. Answer the following questions (2 Marks)

Question 1.
Mention the users who use the Database.
Answer:
Users of databases can be human users, other programs, or applications.

Question 2.
Which method is used to connect a database? Give an example.
Answer:

• Connect()method is used to connect a database
• Connecting to a database means passing the name of the database to be accessed.
• If the database already exists the connection will open the same. Otherwise, Python will open a new database file with the specified name.

Example:
import sqlite3
# connecting to the database
connection = sqlite3.connect (“Academy.db”)
# cursor
cursor = connection. cursor()

Question 3.
What is the advantage of declaring a column as “INTEGER PRIMARY KEY”
Answer:
If a column of a table is declared to be an INTEGER PRIMARY KEY, then whenever a NULL will be used as an input for this column, the NULL will be automatically converted into an integer which will one larger than the highest value so far used in that column. If the table is empty, the value 1 will be used.

Question 4.
Write the command to populate record in a table. Give an example.
Answer:

• To populate (add record) the table “INSERT” command is passed to SQLite.
• “execute” method executes the SQL command to perform some action.

Example:
import sqlite3
connection = sqlite3.connect
(“Academy.db”)
cursor = connection.cursor()
CREATE TABLE Student ()
Rollno INTEGER PRIMARY KEY,
Sname VARCHAR(20), Grade CHAR(1),
gender CHAR(l), Average DECIMAL
(5,2), birth_date DATE);”””
cursor.execute(sql_command)
sqLcommand = “””INSERT INTO Student (Rollno, Sname, Grade, gender, Average, birth_date)
VALUES (NULL, “Akshay”, “B”, “M”, “87.8”, “2001-12-12″);”””
cursof.execute(sql_ command) sqLcommand .= “””INSERT INTO Student \ (Rollno, Sname, Grade, gender, Average, birth_date)
VALUES (NULL, “Aravind”, “A”, “M”, “92.50”,”2000-08-17″);””” cursor.execute (sql_ command)
#never forget this, if you want the changes to be saved:
connection.commit()
connection.close()
print(“Records are populated”)
OUTPUT:
Records are populated

Question 5.
Which method is used to fetch all rows from the database table?
Answer:
Displaying all records using fetchall( )
The fetchall( ) method is used to fetch all rows from the database table
result = cursor.fetchall( )

III. Answer the following questions (3 Marks)

Question 1.
What is SQLite? What is its advantage?
Answer:

• SQLite is a simple relational database system, which saves its data in regular data files or even in the internal memory of the computer.
• SQLite is designed to be embedded in applications, instead of using a separate database server program such as MySQL or Oracle.
• SQLite is fast, rigorously tested, and flexible, making it easier to work.

Question 2.
Mention the difference between fetchone() and fetchmany().
Answer:

Question 3.
What is the use of the Where Clause? Give a python statement Using the where clause.
Answer:

• The WHERE clause is used to extract only those records that fulfill a specified condition.
• The WHERE clause can be combined with AND, OR, and NOT operators.
• The AND and OR operators are used to filter records based on more than one condition.

Example:
import sqlite3
connection = sqlite3.
connect(“Academy, db”)
cursor = connection. cursor()
cursor, execute (“SELECT DISTINCT (Grade) FROM student where gender=’M'”)
result = cursor. fetchall()
print(*result, sep=”\n”)
OUTPUT:
(‘B’,)
(‘A’,)
(‘C’,)
(‘D’,)

Question 4.
Read the following details. Based on that write a python script to display department wise records.
Database name: organization, db
Table name: Employee
Columns in the table: Eno,
EmpName,
Esal, Dept

Contents of Table: Employee

Coding:
import sqlite3
connection = sqlite3. connect
(” organization, db”)
cursor = connection, cursor ()
sqlcmd=””” SELECT *FROM
Employee ORDER BY Dept”””
cursor, execute (sqlcmd)
result = cursor, fetchall ()
print (“Department wise Employee List”)
for i in result:
print(i)
connection. close()
Output:
Department wise Employee List
(1003,’Helena’,32000, ‘Accounts’)
(1001,’Aswin’,28000,’IT’)
(1005,’Hycinth’,41000,’IT’)

Question 5.
Read the following details.Based on that write a python script to display records in desending order of Eno
Database name : organization.db
Table name : Employee
Columns in the table : Eno, EmpName, Esal, Dept
Contents of Table: Employee

Coding:
import sqlite3
connection = sqlite3 . connect
(“organization, db”)
cursor = connection, cursor ()
cursor, execute (“SELECT *
FROM Employee ORDER BY Eno DESC”)
result = cursor, fetchall ()
print (“Department wise
Employee List in descending order:”)
for i in result:
print(i)
connection.close()
Output:
Department wise Employee List in descending order:
(1005,’Hycinth’,41000,’IT’)
(1003,’Helena’,32000, ‘Accounts’)
(1001,’Aswin’,28000,’IT’)

IV. Answer the following questions (5 Marks)

Question 1.
Write in brief about SQLite and the steps used to use it.
Answer:
SQLite is a simple relational database system, which saves its data in regular data files or even in the internal memory of the computer. It is designed to be embedded in applications, instead of using a separate database server program such as MySQL or Oracle. SQLite is fast, rigorously tested, and flexible, making it easier to work. Python has a native library for SQLite. To use SQLite,
Step 1 import sqliteS
Step 2 create a connection using connect ( ) method and pass the name of the database File
Step 3 Set the cursor object cursor = connection.cursor( )

1. Connecting to a database in step2 means passing the name of the database to be accessed. If the database already exists the connection will open the same. Otherwise, Python will open a new database file with the specified name.
2. Cursor in step 3: is a control structure used to traverse and fetch the records of the database.
3. Cursor has a major role in working with Python. All the commands will be executed using cursor object only.

To create a table in the database, create an object and write the SQL command in it.
Example:- sql_comm = “SQL statement”
For executing the command use the cursor method and pass the required sql command as a parameter. Many commands can be stored in the SQL command can be executed one after another. Any changes made in the values of the record should be saved by the command “Commit” before closing the “Table connection”.

Question 2.
Write the Python script to display all the records of the following table using fetchmany()

Answer:
Database : supermarket
Table : electronics
Python Script:
import sqlite3
connection = sqlite3.connect
(” supermarket. db”)
cursor = connection.cursor()
cursor.execute
(“SELECT * FROM electronics “)
print(“Fetching all 5 records :”)
result = cursor.fetchmany(5)
print(*result,sep=” \ n”)
Output:
Fetching all 5 records :
(1003,’Scanner’ ,10500)
(1004,’Speaker’,3000)
(1005,’Printer’,8000)
(1008,’Monitor’,15000)
(1010,’Mouse’,700)

Question 3.
What is the use of HAVING clause. Give an example python script.
Answer:
Having clause is used to filter data based on the group functions. This is similar to WHERE condition but can be used only with group functions. Group functions cannot be used in WHERE Clause but can be used in HAVING clause.
Example
import sqlite3
connection= sqlite3.connect(“Academy.db”)
cursor = connection. cursor( )
cursor.execute(“SELECT GENDER,COUNT(GENDER) FROM Student GROUP BY GENDER HAVING COUNT(GENDER)>3 “)
result = cursor. fetchall( )
co= [i[0] for i in cursor, description]
print(co)
print( result)
OUTPUT
[‘gender’, ‘COUNT(GENDER)’]
[(‘M’, 5)]

Question 4.
Write a Python script to create a table called ITEM with the following specifications.
Add one record to the table.
Name of the database: ABC
Name of the table :- Item
Column name and specification :-
Icode : integer and act as primary key
Item Name : Character with length 25
Rate : Integer
Record to be added : 1008, Monitor, 15000
Answer:
Coding:
import sqlite3
connection = sqlite3 . connect (“ABC.db”)
cursor = connection, cursor ()
sql_command = ” ” ”
CREATE TABLE Item (Icode INTEGER,
Item_Name VARCHAR (25),
Rate Integer); ” ‘” ”
cursor, execute (sql_command)
sql_command = ” ” “INSERT INTO Item
(Icode,Item_name, Rate)VALUES (1008,
“Monitor”, “15000”);” ” ”
cursor, execute (sqlcmd)
connection, commit ()
print(“Table Created”)
cursor. execute(SELECT *FROM ITEM”)
result=cursor.fetchall():
print(“CONTENT OF THE TABLE
print(*result,sep=”\n”)
connection, close ()
Output:
Table Created
CONTENT OF THE TABLE :
(1008, ‘Monitor’, 15000)

Question 5.
Consider the following table Supplier and item.
Write a python script for
i) Display Name, City and Item name of suppliers who do not reside in Delhi.
ii) Increment the SuppQty of Akila by 40
Name of the database : ABC
Name of the table : SUPPLIER

i) Display Name, City and Itemname of suppliers who do not reside in Delhi:
Coding:
import sqlite3
connection = sqlite3.
connection/’ABC.db”)
cursor = connection, cursor ()
sqlcmd=”””(“SELECT SUPPLIER. Name,SUPPLIER.City,Item.ItemName FROM SUPPLIER,Item WHERE SUPPLIER.City NOT IN(“Delhi”) and SUPPLIER.Icode=Item.Icode” ” ”
cursor, execute(sqlcmd)
result = cursor.fetchall()
print(” Suppliers who do not reside in Delhi:”)
for r in result:
print(r)
conn.commit ()
conn, close ()
Output:
Suppliers who do not reside in Delhi:
(‘ Anu’ / Bangalore’/Mouse’)
(‘Shahid7,’Bangalore7,’Monitor’)
(‘Akila’/Hydrabad’,’Printer’)
(‘Girish’/Hydrabad’/Scanner’)
(‘Shylaja’/Chennai’/Monitor’)
(‘ La vanya’/ Mumbai’/ Printer’)

ii) Increment the SuppQty of Akila by 40: import sqlite3
connection = sqlite3.
connection/’ABC.db”)
cursor = connection, cursor ()
sqlcmd=”””UPDATE SUPPLIER
SET Suppqty=Suppqty+40 WHERE
Name=’Akila”””
cursor, execute(sqlcmd)
result = cursor.fetchall()
print
(“Records after SuppQty increment:”)
for r in result:
print(r)
conn.commit ()
conn, close ()
Output:
Records after SuppQty increment:
(‘S001′ /PrasadVDelhi’,1008,100)
(‘S002′ ,’Anu’ /Bangalore’,1010,200)
(‘S003′ /Shahid’/Bangalore’, 1008,175)
(‘S004’/Akila’/Hydrabad’,1005,235)
(‘S005′ /Girish’/Hydrabad’, 003,25)
(‘S006′ /Shylaja’/Chennai’,1008,180)
(‘S007′ ,’Lavanya’,’Mumbai’,1005,325)

12th Computer Science Guide Data Manipulation Through SQL Additional Questions and Answers

I. Choose the best answer (I Marks)

Question 1.
…………………… command is used to populate the table.
a) ADD
b) APPEND
c) INSERT
d) ADDROW
Answer:
c) INSERT

Question 2.
Which has a native library for SQLite?
(a) C
(b) C++
(c) Java
(d) Python
Answer:
(d) Python

Question 3.
………………….. method is used to fetch all rows from the database table.
a) fetch ()
b) fetchrowsAll ()
c) fectchmany ()
d) fetchall ()
Answer:
d) fetchall ()

Question 4.
………………….. method is used to return the next number of rows (n) of the result set.
a) fetch ()
b) fetchmany ()
c) fetchrows ()
d) tablerows ()
Answer:
b) fetchmany ()

Question 5.
How many commands can be stored in the sql_comm?
(a) 1
(b) 2
(c) 3
(d) Many
Answer:
(d) Many

Question 6.
…………………..clause is used to extract only those records that fulfill a specified condition.
a) WHERE
b) EXTRACT
c) CONNECT
d) CURSOR
Answer:
a) WHERE

Question 7.
…………………..clause is used to sort the result-set in ascending or descending order.
a) SORT
b) ORDER BY
c) GROUP BY
d) ASC SORT
Answer:
b) ORDER BY

Question 8.
………………….. clause is used to filter database on the group functions?
a) WHERE
b) HAVING
c) ORDER
d) FILTER
Answer:
b) HAVING

Question 9.
What will be the value assigned to the empty table if it is given Integer Primary Key?
(a) 0
(b) 1
(c) 2
(d) -1
Answer:
(b) 1

Question 10.
The sqlite3 module supports ………………. kinds of placeholders:
a) 1
b) 2
c) 3
d) 5
Answer:
b) 2

Question 11.
……………… has a native library of SQlite.
a) Python
b) C++
c) Java
d) C
Answer:
a) Python

Question 12.
All the SQlite commands will be executed using……………… object only
a) connect
b) cursor
c) CSV
d) python
Answer:
b) cursor

Question 13.
Which method returns the next row of a query result set?
(a) Fetch ne( )
(b) fetch all( )
(c) fetch next( )
(d) fetch last( )
Answer:
(a) Fetch ne( )

Question 14.
…………… function returns the number of rows in a table satisfying the criteria specified in the WHERE clause.
a) Distinct
b) count
c) Having
d) Counter
Answer:
b) count

Question 15.
Count () returns …………… if there were no matching rows.
a) 0
b) 1
c) NOT NULL
d) NULL
Answer:
a) 0

Question 16.
…………… contains the details of each column headings
a) cursor, description
b) cursor.connect
c) cursor.column
d) cursor.fieldname
Answer:
a) cursor, description

Question 17.
Which one of the following is used to print all elements separated by space?
(a) ,
(b) .
(c) :
(d) ;
Answer:
(a) ,

II. Answer the following questions (2 and 3 Marks)

Question 1.
Write the SQLite steps to connect the database.
Answer:
Step 1: Import sqlite3
Step 2: Create a connection using connect o method and pass the name of the database file.
Step 3 : Set the cursor object cursor = connection, cursor ()

Question 2.
Mention the frequently used clauses in SQL?
Answer:

1. DISTINCT
2. WHERE
3. GROUP BY
4. ORDER BY
5. HAVING

Question 3.
Write a Python code to create a database in SQLite.
Answer:
Python code to create a database in SQLite:
import sqlite3
connection = sqlite3.connect (“Academy.db”)
cursor + connection.cursorQ

Question 4.
Define: sqlite_master
Answer:
sqlite_master is the master table which holds the key information about the database tables.

Question 5.
Give a short note on GROUP BY class.
Answer:

• The SELECT statement can be used along with the GROUP BY clause.
• The GROUP BY clause groups records into summary rows. It returns one record for each group.
• It is often used with aggregate functions (COUNT, MAX, MIN. SUM, AVG) to group the result -set by one or more columns.

Question 6.
Write short notes on

1. COUNT ()
2. AVG ()
3. SUM ()
4. MAX ()
5. MIN ()

Answer:

1. COUNT ( ) function returns the number of rows in a table.
2. AVG () function retrieves the average of a selected column of rows in a table.
3. SUM () function retrieves the sum of a selected column of rows in a table.
4. MAX( ) function returns the largest value of the selected column.
5. MIN( ) function returns the smallest value of the selected column.

Question 7.
Write a program to count the number of male and female students from the student table
Example
Answer:
import sqlite3
connection= sqlite3.connect(“Academy.db”)
cursor = connection.cursor( )
cursor.execute(“SELECT gender,count(gender) FROM student Group BY gender”)
result = cursor. fetchall( )
print(*result,sep=”\n”)
OUTPUT
(‘F’, 2)
(‘M’, 5)

Question 8.
Explain Deletion Operation with a suitable example.
Answer:
Deletion Operation:
Similar to Sql command to delete a record, Python also allows to delete a record.
Example: Coding to delete the content of Rollno 2 from “student table”

Coding:
# code for delete operation
import sqlite3
# database name to be passed as parameter
conn = sqlite3.connect(“Academy.db”)
# delete student record from database
conn.execute(“DELETE from Student
where Rollno=’2′”)
conn.commitQ
print(“Total number of rows deleted conn.total_changes)
cursor =conn.execute(“SELECT * FROM
Student”)
for row in cursor:
print(row)
conn.close()
OUTPUT:
Total number of rows deleted : 1
(1, ‘Akshay’, ‘B’, ‘M’, 87.8, ‘2001-12-12’)
(3, ‘BASKAR’, ‘C’, ‘M’, 75.2, ‘1998-05-17’)
(4, ‘SAJINI’, ‘A’, ‘F, 95.6, ‘2002-11-01’)
(5, ‘VARUN’, ‘B’, ‘M’, 80.6, ‘2001-03-14’)
(6, ‘Priyanka’, ‘A’, ‘F, 98.6, ‘2002-01-01’)
(7, ‘TARUN’, ‘D’, ‘M’, 62.3, ‘1999-02-01’)

Question 9.
Explain Table List with suitable example.
Answer:
Program to display the list of tables created in a database:
Coding:
import sqlite3
con = sqlite3.connect(‘Academy.db’)
cursor = con.cursor()
cursor.execute(“SELECT name FROM sqlite_master WHERE type=’table’;”) print(cursor.fetchall())
OUTPUT:
[(‘Student’,), (‘Appointment’,), (‘Person’,)]

Question 10.
Write a short note on cursor. fetchall(),cursor.fetchone(),cursor. fetchmany()
Answer:
cursor.fetchall():
cursor.fetchall() method is to fetch all rows from the database table .
cursor.fetchone():
cursor.fetchone() method returns the next row of a query result set or None in case there is no row left. cursor.fetchmany:
cursor.fetchmany() method that returns the next number of rows (n) of the result set

Question 11.
How to create a database using SQLite? Creating a Database using SQLite:
Answer:
# Python code to demonstrate table creation and insertions with SQL
# importing module import sqlite3
# connecting to the database connection = sqlite3.connect (“Academy.db”)
# cursor
cursor = connection.cursor()
In the above example a database with the name “Academy” would be created. It’s similar to the sql command “CREATE DATABASE Academy;”

Question 12.
Explain fetchall() to display all records with suitable examples?
Answer:
Displaying all records using fetchall():
The fetchall() method is used to fetch all rows from the database table.

Example:
import sqlite3
connection = sqlite3.connect(” Academy.db”)
cursor = connection.cursor()
cursor.execute(“SELECT FROM student”)
print(“fetchall:”)
result = cursor.fetchall()
for r in result:
print(r)
OUTPUT:
fetchall:
(1, ‘Akshay’, ‘B’, ‘M’, 87.8, ‘2001-12-12’)
(2, ‘Aravind’, ‘A’, ‘M’, 92.5, ‘2000-08-17’)
(3, ‘BASKAR’, ‘C’, ‘M’, 75.2, ‘1998-05-17’)
(4, ‘SAJINT, ‘A’, ‘F’, 95.6, ‘2002-11-01’)
(5, ‘VARUN’, ‘B’, ‘M’, 80.6, ‘2001-03-14’)
(6, ‘PRIYA’, ‘A’, ‘F’, 98.6, ‘2002-01-01’)
(7, ‘TARUN’, ‘D’, ‘M’, 62.3, ‘1999-02-01’)

Question 13.
Explain fetchone() to display a single record(one row) with a suitable example?
Answer:
Displaying A record using fetchone():
The fetchoneQ method returns the next row of a query result set or None in case there is no row left.

Example:
import sqlite3
connection = sqlite3.
connect(” Academy.db”)
cursor = connection.cursor()
cursor.execute(“SELECT * FROM student”)
print(“\nfetch one:”)
res = cursor.fetchone()
print(res)
OUTPUT:
fetch one:
(1, ‘Akshay’, ‘B’, ‘M’, 87.8, ‘2001-12-12’)

Question 14.
Explain fetchone() to display all records with suitable examples?
Answer:
Displaying all records using fetchone(): Using while ioop and fetchone() method we can display all the records from a table.

Example:
import sqlite3
connection = sqlite3 .connect(” Academy. db”)
cursor = connection.cursor()
cursor.execute(”SELECT * FROM student”)
print(“fetching all records one by one:”)
result = cursor.fetchone()
while result is not None:
print(result)
result = cursor.fetchone()
OUTPUT:
fetching all records one by one:
(1, ‘Akshay’, ‘B’, ‘M’, 87.8, ‘2001-12-12’)
(2, ‘Aravind’, ‘A’, ‘M’, 92.5, ‘2000-08-17’)
(3, ‘BASKAR’, ‘C’, ‘M’, 75.2, ‘1998-05-17’)
(4, ‘SAJINI’, ‘A’, ‘F’, 95.6, ‘2002-11-01’)
(5, ‘VARUN’, ‘B’, ‘M’, 80.6, ‘2001-03-14’)
(6, ‘PRIYA’, ‘A’, ‘F’, 98.6, ‘2002-01-01’)
(7, ‘TARUN’, ‘D’, ‘M’, 62.3, ‘1999-02-01’)
Chapter 15.indd 297 70-02-2019 15:40:10

Question 15.
Explain fetchmany() to display a specified number of records with suitable example?
Answer:
Displayingusing fetchmany():
Displaying specified number of records is done by using fetchmany(). This method returns the next number of rows (n) of the result set.

Example : Program to display the content of tuples using fetchmany()
import sqlite3 .
connection = sqlite3. connect
(” Academy, db”)
cursor = connection.cursor()
cursor.execute
(“SELECT FROM student”)
print(“fetching first 3 records:”)
result = cursor.fetchmany(3)
print(result)
OUTPUT:
fetching first 3 records:
[(1, ‘Akshay’, ‘B’, ‘M’, 87.8, ‘2001-12-12′),
(2,’ Aravin d’, ‘A’, ‘M’, 92.5, /2000-08-17′),
(3, ‘BASKAR’, ‘C’, ‘M’, 75.2, ‘1998-05-17’)]

II. Answer the following questions (5 Marks)

Question 1.
Explain clauses in SQL with suitable examples.
Answer:

• SQL provides various clauses that can be used in the SELECT statements.
• These clauses can be called through a python script.
• Almost all clauses will work with SQLite.

The various clauses is:

• DISTINCT
• WHERE
• GROUPBY
• ORDER BY.
• HAVING

Data of Student table:
The columns are Rollno, Sname, Grade,
gender, Average, birth_date
(1, ‘Akshay’, ‘B’, ‘M’, 87.8, ‘2001-12-12’)
(2, ‘Aravind’, ‘A’, ‘M’, 92.5, ‘2000-08-17’)
(3, ‘BASKAR’, ‘C’, ‘M’, 75.2, ‘1998-05-17’)
(4, ‘SAJINT, ‘A’, ‘F’, 95.6, ‘2002-11-01’)
(5, ‘VARUN’, ‘B’, ‘M’, 80.6, ‘2001-03-14’)
(6, ‘PRIYA’, ‘A’, ‘F’, 98.6, ‘2002-01-01’)
(7, ‘TARUN’, ‘D’, ‘M’, 62.3, ‘1999-02-01’)

i) SQL DISTINCT CLAUSE

• The distinct clause is helpful when there is a need of avoiding the duplicate values present in any specific columns/ table.
• When we use a distinct keyword only the unique values are fetched.

Example:
Coding to display the different grades scored by students from “student table”:

import sqlite3
connection = sqlite3.connect(” Academy, db”)
cursor = connection.cursorQ cursor.execute(“SELECT DISTINCT (Grade) FROM student”)
result = cursor.fetchall()
print (result)
OUTPUT:
[(‘B’,), (‘A’,), (‘C’,), (‘D’,)]

Without the keyword “distinct” in the “Student table” 7 records would have been displayed instead of 4 since in the original table there are actually 7 records and some are with duplicate values.

ii) SQL WHERE CLAUSE
The WHERE clause is used to extract only those records that fulfill a specified condition.

Example:
Coding to display the different grades scored by male students from “student table”.
import sqlite3
connection = sqlite3.connec
(“Academy.db”)
cursor = connection.cursor()
cursor.execute(” SELECT DISTINCT i (Grade) FROM student where gender=’M”)
result = cursor.fetchall()
print(*result/sep=”\n”)
OUTPUT:
(‘B’,)
(‘A’,)
(‘C’,)
(‘D’,)

iii) SQL GROUP BY Clause :

• The SELECT statement can be used along with the GROUP BY clause.
• The GROUP BY clause groups records into summary rows.
• It returns one records for each group,
• It is often used with aggregate functions (COUNT, MAX, MIN, SUM, AVG) to group the result-set by one or more columns.

Example:
Coding to count the number of male and ; female from the student table and display j the result.

Coding:
import sqlite3;
connection = sqlite3.connect(“Academy.db”)
cursor = connection.cursor()
cursor.execute(“SELECT gender,count(gender) FROM student Group BY gender”)
result = cursor.fetchall() j
print(*result,sep=”\n”)
OUTPUT:
(‘F’, 2)
(‘M’, 5)

iv) SQL ORDER BY Clause

• The ORDER BY clause can be used along with the SELECT statement to sort the data of specific fields in an ordered way.
• It is used to sort the result-set in ascending or descending order.

Example
Coding to display the name and Rollno of the students in alphabetical order of names . import sqlite3
connection = sqlite3.connect(” Academy.db”)
cursor = connection.cursor()
cursor.execute(“SELECT Rollno,sname FROM student Order BY sname”)
result = cursor.fetchall()
print (*result, sep=” \ n”)
OUTPUT
(1, ‘Akshay’)
(2, ‘Aravind’)
(3, ‘BASKAR’)
(6, ‘PRIYA’)
(4, ‘SAJINI’)
(7, ‘TARUN’)
(5, ‘VARUN’)

v) SQL HAVING Clause

• Having clause is used to filter data based on the group functions.
• Having clause is similar to WHERE condition but can be used only with group functions.
• Group functions cannot be used in WHERE Clause but can be used in HAVING clause.

Example:
import sqlite3
connection = sqlite3.connect(” Academy, db”)
cursor = connection.cursor()
cursor.execute(“SELECT GENDER,COUNT(GENDER) FROM Student GROUP BY GENDER HAVING COUNT(GENDER)>3”)
result = cursor.fetchall()
co = [i[0] for i in cursor, description]
print(co)
print(result)
OUTPUT:
[‘gender7,’ COUNT (GENDER)’ ]
[(‘M’, 5)]

Question 2.
Write a python program to accept 5 students’ names, their ages, and ids during run time and display all the records from the table?
Answer:
In this example we are going to accept data using Python input() command during runtime and then going to write in the Table called “Person”
Example
# code for executing query using input data
import sqlite3
#creates a database in RAM
con =sqlite3.connect(“Academy,db”)
cur =con.cursor( )
cur.execute(“DROP Table person”)
cur.execute(“create table person (name, age, id)”)
print(“Enter 5 students names:”)
who =[input( ) for i in range(5)]
print(“Enter their ages respectively:”)
age =[int(input()) for i in range(5)]
print(“Enter their ids respectively:”)
p_d =[int(input( ))for i in range(5)]
n =len(who)
for i in range(n):
#This is the q-mark style:
cur.execute(“insert into person values(?,?,?)”, (who[i], age[i], p_id[i]))
#And this is the named style:
cur.execute(“select *from person”)
#Fetches all entries from table
print(“Displaying All the Records From Person Table”)
print (*cur.fetchall(), sep=’\n’)
OUTPUT
Enter 5 students names:
RAM
KEERTHANA
KRISHNA
HARISH
GIRISH
Enter their ages respectively:
28
12
21
18
16
Enter their ids respectively:
1
2
3
4
5
Displaying All the Records From Person Table
(‘RAM’, 28, 1)
(‘KEERTHANA’, 12, 2)
(‘KRISHNA’, 21, 3)
(‘HARISH’, 18,4)
(‘GIRISH’, 16, 5)

Question 3.
Write a Python program to store and retrieve the following data in SQLite3.
Database Schema:

Date to be inserted as tuple:

Answer:
Python Program:
import sqlite3
connection = sqlite3.connect (“Academy.db”)
cursor = connection.cursor()
cursor.execute (“””DROP TABLE Student;”””)
sql_command = “”” CREATE TABLE Student ( Rollno INTEGER PRIMARY KEY ,
Sname VARCHAR(20), Grade CHAR(l), gender CHAR(l), Average DECIMAL (5, 2));””” cursor.execute(sql_command)
sql_command = “””INSERT INTO Student VALUES (1001, “KULOTHUNGAN”, “M”, “75.2”);”””
sql_command = “””INSERT INTO Student VALUES (1002, “KUNDAVAI”, “F”, “95.6”);”””
sql_command = “””INSERT INTO Student VALUES (1003, “RAJARAJAN”, “M”, “80.6”);”””
sql_command = “””INSERT INTO Student VALUES (1004, “RAJENDRAN”, “M”, “98.6”);”””
sql_command = “””INSERT INTO Student VALUES (1005, “AVVAI”, “F”, “70.1”);”””
cursor.execute (sql_ command)
connection.commit()
connection.close()

Tamilnadu State Board New Syllabus Samacheer Kalvi 12th Computer Science Guide Pdf Chapter 3 Scoping Text Book Back Questions and Answers, Notes.

Tamilnadu Samacheer Kalvi 12th Computer Science Solutions Chapter 3 Scoping

12th Computer Science Guide Scoping Text Book Questions and Answers

I. Choose the best answer (I Marks)

Question 1.
Which of the following refers to the visibility of variables in one part of a program to another part of the same program.
a) Scope
b) Memory
c) Address
d) Accessibility
Answer:
a) Scope

Question 2.
The process of binding a variable name with an object is called
a) Scope
b) Mapping
c) late binding
d) early binding
Answer:
b) Mapping

Question 3.
Which of the following is used in programming languages to map the variable and obj ect?
a) ::
b) :=
c) =
d) ==
Answer:
c) =

Question 4.
Containers for mapping names of variables to objects is called
a) Scope
b) Mapping
c) Binding
d) Name spaces
Answer:
d) Name spaces

Question 5.
Which scope refers to variables defined in current function?
a) Local Scope
b) Global scope
c) Module scope
d) Function Scope
Answer:
a) Local Scope

Question 6.
The process of subdividing a computer program into separate sub-programs is called
a) Procedural Programming
b) Modular programming
c) Event Driven Programming
d) Object oriented Programming
Answer:
b) Modular programming

Question 7.
Which of the following security technique that regulates who can use resources in a computing environment?
a) Password
b) Authentication ‘
c) Access control
d) Certification
Answer:
c) Access control

Question 8.
Which of the following members of a class can be handled only from within the class?
a) Public members
b) Protected members
c) Secured members
d) Private members
Answer:
d) Private members

Question 9.
Which members are accessible from outside the class?
a) Public members
b) Protected members
c) Secured members
d) Private members
Answer:
a) Public members

Question 10.
The members that are accessible from within the class and are also available to its sub classes is called
a) Public members
b) Protected members
c) Secured members
d) Private members
Answer:
b) Protected members

II. Answer the following questions (2 Marks)

Question 1.
What is a scope?
Answer:
Scope refers to the visibility of variables, parameters, and functions in one part of a program to another part of the same program.

Question 2.
Why scope should be used for variables. State the reason
Answer:

• Every variable defined in a program has global scope.
• Once defined, every part of your program can access that variable.
• But it is a good practice to limit a variable’s scope to a single definition.
• This way, changes inside the function can’t affect the variable on the outside of the function in unexpected ways.

Question 3.
What is Mapping?
Answer:
The process of binding a variable name with an object is called mapping. = (equal to sign) is used in programming languages to map the variable and object.

Question 4.
What do you mean by Namespaces?
Answer:
Names paces are containers for mapping names of variables to objects.

Question 5.
How Python represents the private and protected Access specifiers?
Answer:
Private members of a class are denied access from the outside of the class. They can be handled only within the class.
Protected members of a class are accessible from within the class and are also available to its sub-classes. No other process is permitted access to it.

III. Answer the following questions (3 Marks)

Define Local scope with an example.
Answer:
Local scope:

• Local scope refers to variables defined in the current function.
• Always, a function will first lookup for a variable name in its local scope.
• Only if it does not find it there, the outer scopes are checked.

Example:

• On execution of the above code, the variable a displays the value 7, because it is defined and available in the local scope.

Question 2.
Define Global scope with an example
Answer:
Global variable:

• A variable which is declared outside of all the functions in a program is known as Global variable.
• Global variable can be accessed inside or outside of all the functions in a program

Example:

• On execution of the above code the variable a which is defined inside the, function displays the value 7 for the function call Disp() and then it displays 10, because a is defined in global scope.

Question 3.
Define Enclosed scope with an example
Answer:
Enclosed Scope:

• A variable which is declared, inside a function which contains another function definition with in it, the inner function can also access the variable of the outer function. This scope is called enclosed scope.
• When a compiler or interpreter search for a variable in a program, it first searches Local, and then searches Enclosing scopes.

Example:

Question 4.
Why access control is required?
Answer:
Access control is a security technique that regulates who or what can view or use resources in a computing environment.
It is a fundamental concept in security that minimizes risk to the object. In other words, access control is a selective restriction of access to data.
In Object-oriented programming languages, it is implemented through access modifies.
Classical object-oriented languages, such as C++ and Java, control the access to class members by the public, private, and protected keywords.

Question 5.
Identify the scope of the variables in the following pseudo-code and write its output
color:= Red
mycolor():
b:=Blue
myfavcolor():
g:=Green
printcolor, b, g
myfavcolor()
printcolor, b
mycolor()
print color
Answer:
Scopes:
g – Local scope
b – Enclosed scope
color – Global scope
Output:
Red Blue Green
Red Blue
Red

IV. Answer the following questions (5 Marks)

Question 1.
Explain the types of scopes for variable or LEGB rule with example.
Answer:
Types of Scope:
There are four types of Scope namely
Local Scope, Global Scope, Enclosed Scope and Built-in Scope:
Local Scope:

• Local scope refers to variables defined in the current function.
• Always, a function will first lookup for a variable name in its local scope.
• Only if it does not find it there, the outer scopes are checked.

Example:

• On execution of the above code the variable a displays the value 7, because it is defined and available in the local scope.

Global Scope:

• A variable which is declared outside of all the functions in a program is known as a global variable.
• This means global variable can be accessed inside or outside of all the functions in a program.

Example:

• On execution of the above code the variable ‘a’ which is defined inside the function displays the value 7 for the function call Disp() and then it displays 10; because a is defined in global scope.
• Enclosed Scope:
• All programming languages permit functions to be nested. A function (method) with in another function is called nested function.
• A variable which is declared inside a function which contains another function definition with in it, the inner function can also access the variable of the outer function. This scope is called enclosed scope.
• When a compiler or interpreter search for a variable in a program, it first search Local, and then search Enclosing scopes.

Example:

• In the above example Displ() is defined with in Disp().
• The variable ‘a’ defined in Disp( ) can be even used by Displ( ) because it is also a member of Disp().

Built-in Scope:

• The built-in scope has all the names that are pre-loaded into the program scope when we start the compiler or interpreter.
• Any variable or module which is defined in the library functions of a programming
  language has a Built-in or module scope. They are loaded as soon as the library files are imported to the program.

LEGB rule:

• The LEGB rule is used to decide the order in which the scopes are to be searched for scope resolution.
• The scopes are listed below in terms of hierarchy (highest to lowest).

Scope also defines the order in which variables have to be mapped to the object in order to obtain the value.

Example:
1. x:= ‘outer x variable’
2. display ():
3. x:= ‘inner x variable’
4. print x
5. display()

• When the above statements have executed the statement (4) and (5) display the result as

Output:
outer x variable
inner x variable

• Above statements give different outputs because the same variable name ‘x’ resides in different scopes, one inside the function display() and the other in the upper level.
• The value ‘outer x variable’ is printed when x is referenced outside the function definition.
• Whereas when display() gets executed, ‘inner x variable’ is printed which is the x value inside the function definition.
• From the above example, we can guess that there is a rule followed, in order to decide from which scope a variable has to be picked.

Question 2.
Write any Five Characteristics of Modules
Answer:

• Modules contain instructions, processing logic, and data.
• Modules can be separately compiled and stored in a library.
• Modules can be included in a program.
• Module segments can be used by invoking a name and some parameters.
• Module segments can be used by other modules.

Question 3.
Write any five benefits of using modular programming.
Answer:

• Less code to be written.
• A single procedure can be developed for reuse, eliminating the need to retype the code many times.
• Programs can be designed more easily because a small team deals with only a small part of the entire code.
• Modular programming allows many programmers to collaborate on the same application.
• The code is stored across multiple files.
• Code is short, simple, and easy to understand.
• Errors can easily be identified, as they are localized to a subroutine or function.
• The same code can be used in many applications.
• The scoping of variables can easily be controlled.

12th Computer Science Guide Scoping Additional Questions and Answers

I. Choose the best answer (1 Mark)

Question 1.
Names paces are compared with ……………………….
(a) Programs
(b) Dictionaries
(c) Books
(d) Notebooks
Answer:
(b) Dictionaries

Question 2.
The scope of a ……………. is that part of the code where it is visible
a) Variable
b) Keyword
c) Function
d) Operator
Answer:
a) Variable

Question 3.
Find the value of a.
1. a: = 5
2. b: = a
3. a: = 3
(a) 0
(b) 3
(c) 5
(d) 2
Answer:
(b) 3

Question 4.
The inner function can access the variable of the outer function. This is called ………… scope.
a) Local
b) Enclosed
c) Function
d) Global
Answer:
b) Enclosed

Question 5.
The duration for which a variable is alive is called its ……………………………
(a) Scale
(b) Life time
(c) Static
(d) Function
Answer:
(b) Lifetime

Question 6.
InObjectOrientedProgrammingLanguageAccesscontrolisimplementedthrough ………….
a) Access modules
b) Access modifiers
c) Access variables
d) Keywords
Answer:
b) Access modifiers

Question 7.
………… is a selective restriction of access to data in a program?
a) Control variable
b) Access control
c) System authentication
d) Module
Answer:
b) Access control

Question 8.
How many types of variable scopes are there?
(a) 1
(b) 2
(c) 3
(d) 4
Answer:
(d) 4

Question 9.
How many variables can be mapped to the same instance?
a) 2
b) 3
c) Multiple
d) 4
Answer:
c) Multiple

Question 10.
A variable which is declared outside of all the functions in a program is known as …………………………… variable.
(a) L
(b) E
(c) G
(d) B
Answer:
(c) G

Question 11.
Which of the following rule is used to decide the order in which the scopes are to be searched for scope resolution?
a) LGEB
b) LEGB
c) LBEG
d) LGBE
Answer:
b) LEGB

Question 12.
How many types of variable scope are there?
a) 2
b) 3
c) 4
d) 6
Answer:
c) 4

Question 13.
A variable which is declared outside all the functions in a program is known as
a) Local
b) Enclosed
c) Global
d) Extern
Answer:
c) Global

Question 14.
The scope of a nested function is …………………………… scope
(a) Local
(b) Global
(c) Enclosed
(d) Built-in
Answer:
(c) Enclosed

Question 15.
Which of the following programming enables programmers to divide up the work and retry pieces of the program independently?
a) Procedural Programming
b) Modular Programming
c) Object-Oriented Programming
d) Structural Programming
Answer:
b) Modular Programming

Question 16.
Which of the following contain instructions, processing logic, and data?
a) Scopes
b) Indentation
c) Modules
d) Access control
Answer:
c) Modules

Question 17.
Which of the following members of a class are denied access from outside the class?
a) Protected
b) Private
c) Public
d) Enclosed
Answer:
b) Private

Question 18.
Variables of built-in scopes are loaded as …………………………… files.
(a) Exe
(b) Linker
(c) Object
(d) Library
Answer:
(d) Library

Question 19.
By default the Python class members are
a) Private
b) Protected
c) Public
d) Global
Answer:
c) Public

Question 20.
By default the C++ and Java class members are
a) Protected
b) Private
c) Public
d) Local
Answer:
b) Private

Question 21.
…………….. are composed of one or more independently developed Modules
a)’Access control
b) Programs
c) Encapsulation
d) Members of a class
Answer:
b) Programs

Question 22.
Identify which is not a module?
(a) Algorithm
(b) Procedures
(c) Subroutines
(d) Functions
Answer:
(a) Algorithm

II. Answer the following questions (2 and 3 Marks)

Question 1.
Define variable.
Answer:
Variable are addresses (references, or pointers, to an object in memory.

Question 2.
Define lifetime?
Answer:
The duration for which a variable is alive is called its ‘lifetime’.

Question 3.
Define Modular programming.
Answer:
The process of subdividing a computer program into separate sub-programs is called modular programming.

Question 4.
Define: module
Answer:

• A module is a part of a program.
• Programs are composed of one or more independently developed modules

Question 5.
Define nested function.
Answer:
A function (method) within another function is called a nested function.

Question 6.
Write a note on module
Answer:

• A module is a part of a program.
• Programs are composed of one or more independently developed modules.
• A single module can contain one or several statements closely related to each other.
• Modules work perfectly on an individual level and can be integrated with other modules.
• A software program can be divided into modules to ease the job of programming and debugging as well.
• A program can be divided into small functional modules that work together to get the output.
• The process of subdividing a computer program into separate subprograms is called Modular programming.
• Modular programming enables programmers to divide up the work and debug pieces of the program independently.
• The examples of modules are procedures, subroutines, and functions.

Question 7.
Write a note on modules?
Answer:
A module is a part of a program. Programs are composed of one or more independently developed modules. A single module can contain one or several statements closely related to each other. Modules work perfectly on an individual level and can be integrated with other modules.

III. Answer the following questions (5 Marks)

Question 1.
Explain how Access Specifiers are activated in Python, C++, and Java:
Answer:

• Python prescribes a convention of prefixing the name of the variable/ method with a single or double underscore to emulate the behaviour of protected and private access specifiers.
• C++ and Java, control the access to class members by the public, private, and protected
  keywords.
• All members in a Python class are public by default whereas by default in C++ and java all members are private.
• Any member can be accessed from outside the class environment in Python which is not. possible in C++ and java.

Tamilnadu State Board New Syllabus Samacheer Kalvi 12th Business Maths Guide Pdf Chapter 4 Differential Equations Miscellaneous Problems Text Book Back Questions and Answers, Notes.

Tamilnadu Samacheer Kalvi 12th Business Maths Solutions Chapter 4 Differential Equations Miscellaneous Problems

Question 1.
Suppose that Qd = 30 – 5P + 2\(\frac { dp }{dt}\) + \(\frac { d^2p }{dt^2}\) and Qs = 6 + 3P Find the equilibrium price for market clearance.
Solution :
Qd = 30 – 5P + 2\(\frac { dp }{dt}\) + \(\frac { d^2p }{dt^2}\) and
Qs = 6 + 3P
For market clearance, the required condition is
Qd = Qs

The auxiliary equation is m2 + 2m – 8 = 0
(m + 4) (m – 2) = 0
m = -4, 2
Roots are real and different
C.F = Ae^m₁x + Be^m₂x
C.F = Ae^-4t + Be^2t

The general solution is y = C.F + P.I
y = Ae^-ut + Be^2t + 3

Question 2.
Form the differential equation having for its general solution y = ax² + bx
Solution:
y = ax² + bx ……….. (1)
Since we have two arbitary constants, differentiative twice.

Question 3.
Solve yx²dx + e^-x dy = 0
Solution:
yx²dx + e^-x dy = 0
e^-x dy = -yx²dx
\(\frac { 1 }{y}\) dy = -x² e^x dx
Integrating on both sides

Question 4.
Solve (x² + y²) dx + 2xy dy = 0
Solution:
(x² + y²) dx + 2xy dy = 0
2xy dy = – (x² + y²) dx
\(\frac { dy }{dx}\) = \(\frac { -(x^2+y^2) }{2xy}\) ………. (1)
This is a homogeneous differential equation

\(\frac { 1 }{3}\) log(3v² + 1) = – logx + logc
log (3v² + 1)^1/3 + log x = log c
logx (3v² + 1)^1/3 = log c
⇒ x (3v² + 1)^1/3 = c
⇒ x[\(\frac { 3y^2 }{x^2}\) + 1]^1/3 = c

Question 5.
Solve x \(\frac { dy }{dx}\) + 2y = x⁴
Solution:

This solution is
y(I.F) = ∫Qx (I.F) dx + c
y(x²) = ∫(x³ × x²) dx + c
yx² = ∫x⁵ dx + c
⇒ yx² = \(\frac { x^6 }{6}\) + c

Question 6.
A manufacturing company has found that the cost C of operating and maintaining the equipment is related to the length’m’ of intervals between overhauls by the equation m² \(\frac { dc }{dm}\) + 2mc = 2 and c = 4 and whem m = 2. Find the relationship between C and m.
Solution:
m² \(\frac { dc }{dm}\) + 2mc = 2
÷ each term by m²
\(\frac { dc }{dm}\) + \(\frac { 2mc }{m^2}\) = \(\frac { 2 }{m^2}\)
\(\frac { dc }{dm}\) + \(\frac { 2c }{m}\) = \(\frac { 2 }{m^2}\)
This is a first order linear differential equation of the form
\(\frac { dc }{dm}\) + Pc = Q where P = \(\frac { 2 }{m}\) and Q = \(\frac { 2 }{m^2}\)
∫Pdm = 2 ∫\(\frac { 1 }{m}\)dm = 2 log m = log m²
I.F = e^∫Pdm = e^logm² = m²
General solution is
C (I.F) = ∫Q × (IF) dm + k
C(m²) = ∫\(\frac { 2 }{m^2}\) × (m²) dm + k
C(m²) = ∫2dm + k
Cm² = 2m + k ……….. (1)
when C = 4 and m = 2, we have
(4) (2)² = 2(2) + k
16 = 4 + k = 12
Equation (1)
Cm² = 2m + 12
Cm² = 2(m + 6)

Question 7.
Solve (D² – 3D + 2) y = e^4x
Solution:
(D² – 3D + 2) y = e^4x
The auxiliary equation is m² – 3m + 2 = 0
(m – 1) (m – 2) = 0
m = 1, 2
The roots are real and different
C.F = Ae^m₁x + Be^m₁x
C.F = Ae^x + Be^2x

The general solution is y = C.F + P.I
y = Ae^x + Be^2x + \(\frac { e^{4x} }{6}\) ………. (1)
When x = 0; y = 0

Question 8.
Solve \(\frac { dy }{dx}\) + y cos x = 2 cos x
Solution:
\(\frac { dy }{dx}\) + y cos x = 2 cos x
This is of the form \(\frac { dy }{dx}\) + Py = Q
Here P = cos x and Q = 2 cos x
∫Pdx = ∫cos x dx = sin x
I.F = e^∫pdx = e^{sin x}
The solution is
y (I.F) = ∫Q (I.F) dx + c
ye^{sin x} = ∫(2 cos x) e^{sin x} dx

Question 9.
Solve x²ydx – (x³ + y³) dy = 0
Solution:
x²ydx = (x³ + y³) dy = 0
x²ydx = (x³ + y³) dy
\(\frac { dy }{dx}\) = \(\frac { x^2y }{(x^3+y^3)}\) ……… (1)
This is a homogeneous differential equation, same degree in x and y

Question 10.
Solve \(\frac { dy }{dx}\) = xy + x + y + 1
Solution:

Tamilnadu State Board New Syllabus Samacheer Kalvi 12th Computer Science Guide Pdf Chapter 2 Data Abstraction Text Book Back Questions and Answers, Notes.

Tamilnadu Samacheer Kalvi 12th Computer Science Solutions Chapter 2 Data Abstraction

12th Computer Science Guide Data Abstraction Text Book Questions and Answers

I. Choose the best answer (1 Marks)

Question 1.
Which of the following functions build the abstract data type?
a) Constructors
b) Destructors
c) recursive
d) Nested
Answer:
a) Constructors

Question 2.
Which of the following functions retrieve information from the data type?
a) Constructors
b) Selectors
c) recursive
d) Nested
Answer:
b) Selectors

Question 3.
The data structure which is a mutable ordered sequence of elements is called
a) Built-in
b) List
c) Tuple
d) Derived data
Answer:
b) List

Question 4.
A sequence of immutable objects is called
a) Built-in
b) List
c) Tuple
d) Derived data
Answer:
c) Tuple

Question 5.
The data type whose representation is known is called
a) Built-in data type
b) Derived data type
c) Concrete data type
d) Abstract data type
Answer:
c) Concrete data type

Question 6.
The data type whose representation is unknown are called
a) Built-in data type
b) Derived data type
c) Concrete data type
d) Abstract data type
Answer:
d) Abstract data type

Question 7.
Which of the following is a compound structure?
a) Pair
b) Triplet
c) single
d) quadrat
Answer:
a) Pair

Question 8.
Bundling two values together into one can be considered as
a) Pair
b) Triplet
c) single
d) quadrat
Answer:
a) Pair

Question 9.
Which of the following allows to name the various parts of a multi-item object?
a) Tuples
b) Lists
c) Classes
d) quadrats
Answer:
c) Classes

Question 10.
Which of the following is constructed by placing expressions within square brackets?
a) Tuples
b) Lists
c) Classes
d) quadrats
Answer:
b) Lists

II. Answer the following questions (2 Marks)

Question 1.
What is abstract data type?
Answer:
Abstract Data type (ADT) is a type (or class) for objects whose behavior is defined by a set of values and a set of operations. The definition of ADT only mentions what operations are to be performed but not how these operations will be implemented.

Question 2.
Differentiate constructors and selectors.
Answer:

Question 3.
What is a Pair? Give an example.
Answer:

• Pair is a compound structure which is made up of a list of Tuple
• The way of bundling two values together into one can be considered as a Pair.
• Example: Pr = [10,20]
  a,b :=Pr
  In the above example ‘a’ becomes 10,’ b’ becomes 20.

Question 4.
What is a List? Give an example.
Answer:
The list is constructed by placing expressions within square brackets separated by commas.
An example for List is [10, 20].

Question 5.
What is a Tuple? Give an example.
Answer:

• A tuple is a comma-separated sequence of values surrounded by parentheses.
• Example: colour^ (‘red’, ‘blue’, ‘Green’)

III. Answer the following questions (3 Marks)

Question 1.
Differentiate Concrete Data Type and Abstract Data Type
Answer:

Question 2.
Which strategy is used for program designing? Define that Strategy.
Answer:
We are using here a powerful strategy for designing programs: ‘wishful thinking’.
Wishful Thinking is the formation of beliefs and making decisions according to what might be pleasing to imagine instead of by . appealing to reality.

Question 3.
Identify Which of the following are constructors and selectors?
(a) N1=number()
(b) accetnum(n1)
(c)  displaynum(n1)
(d)  eval(a/b)
(e) x,y= makeslope (m), makeslope(n)
(f) display()
Answer:

Question 4.
What are the different ways to access the elements of a list. Give example
Answer:
List is constructed by placing expressions within square brackets separated by commas. An example for List is [10, 20].
The elements of a list can be accessed in two ways. The first way is via our familiar method of multiple assignments, which unpacks a list into its elements and binds each element to a different name.
1st: = [10, 20]
x, y: = 1st
In the above example, x will become 10 and y will become 20.
A second method for accessing the elements in a list is by the element selection operator, also expressed using square brackets. Unlike a list literal, a square – bracket expression directly following another expression does not evaluate to a list value but instead selects an element from the value of the preceding expression.
1st [0]
10
1st [1]
20

Question 5.
Identify Which of the following are List, Tuple and class ?
(a) arr [1, 2, 34]
(b) arr (1, 2, 34)
(c) student [rno, name, mark]
(d) day= (‘sun’, ‘mon’, ‘tue’, ‘wed’)
(e) x= [2, 5, 6.5, [5, 6], 8.2]
(f) employee [eno, ename, esal, eaddress]
Answer:

IV. Answer the following questions (5Marks)

Question 1.
How will you facilitate data abstraction? Explain it with a suitable example.
Answer:
To facilitate data abstraction we need to create two types of functions namely

1. Constructors
2. Selectors

Constructors:
Constructors are functions that build the abstract data type.
Selectors:
Selectors are functions that retrieve information from the data type.
Example:

• We have an abstract data type called a city.
• This city object will hold the city’s name, and its latitude and longitude.
• To create a city object, you’d use a function like
  city =makecity (name, lat, Ion)
• Here makecity (name, lat, Ion) is the constructor which creates the object city.
• To extract the information of a city object, we would use functions(Selectors) like getname( city)
  getlat( city)
  getlon(city)
• In the above example, makecity (name, lat, Ion) is the constructor and getname(city),getlat( city) and getlon(city) are the selectors.
• Because the above functions extract the information of the city object.

Question 2.
What is a List? Why List can be called as Pairs. Explain with suitable example
Answer:

• Some languages like Python provides a compound structure called Pair which is made up of List or Tuple.
  The first way to implement pairs is with the List construct.

List:

• The list is constructed by placing expressions within square brackets separated by commas.
• Such an expression is called a list literal. The list can store multiple values.
• Each value can be of any type and can even be another list.
• Example :List := [10,20],
  The elements of a list can be accessed in two ways.
• The first way is via our familiar method of multiple assignments, which unpacks a list into its elements and binds each element to a different name.
  1st := [10,20]
  x, y := 1st
  In the above example, x will become x and y will become 20.
• A second method for accessing the elements in a list is by the element selection operator, also expressed using square brackets.
• Unlike a list literal, a square-brackets expression directly following another expression does not evaluate a list value but instead selects an element from the value of the preceding expression.
  1st[0]
  10
  Ist[l]
  20
• In both the example mentioned above mathematically we can represent list similar to a set as 1st[(0,10),(l,20)]
  List [(0,10), (1,20)] – Where
  
• Any way of bundling two values together into one can be considered as a pair.
• Lists are a common method to do so. Therefore List can be called as Pairs.

Example: Representing rational numbers using list:

• We can now represent a rational number as a pair of two integers in pseudo-code: a numerator and a denominator.
  rational(n, d):
  return [n, d]
  numer(x):
  return x[0]
  denom(x):
  return x[l]

Question 3.
How will you access the multi-item? Explain with example.
Answer:
We can use the structure construct (In OOP languages it’s called class construct) to represent multi-part objects where each part is named (given a name).

Consider the following pseudo-code:
class Person:
creation()
firstName :=””
lastName :=””
id :=””
email :=””
The new data type Person is pictorially represented as

The class (structure) construct defines the form for multi-part objects that represent a person.

• Its definition adds a new data type, in this case, a type named Person.
• Once defined, we can create new variables (instances) of the type.
• In this example, Person is referred to as a class or a type, while pi is referred to as an object or an instance.

12th Computer Science Guide Data Abstraction Additional Questions and Answers

I. Choose the best answer (1 Mark)

Question 1.
How many types of functions are needed to facilitate abstraction?
(a) 1
(b) 2
(c) 3
(d) 4
Answer:
(b) 2

Question 2.
Expansion of CDT is ………….
a) Collective Data Type
b) Class Data Type
c) Concrete Data Type
d) Central Data Type
Answer:
c) Concrete Data Type

Question 3.
To facilitate data abstraction we need to create types of functions
a) 2
b) 3
c) 4
d) 5
Answer:
a) 2

Question 4.
……………………………. is the representation for ADT.
(a) List
(b) Classes
(c) Int
(d) Float
Answer:
(b) Classes

Question 5.
Which of the following is contracted by placing expressions within square brackets separated by commas?
a) Tuple
b) List
c) Set
d) Dictionary
Answer:
b) List

Question 6.
The list is constructed by using …………….. and …………….
a) ();
b) [ ],
c) < >.;
d) [ ]
Answer:
b) [ ],

Question 7.
Identify the constructor from the following
(a) City = makecity(name, lat, lon)
(b) getname(city)
(c) getlat(city)
(d) getlon(city)
Answer:
(a) City = makecity(name, lat, lon)

Question 8.
Which of the following extract the information of the object?
a) Constructors
b) Selectors
c) Functions
d) Destructors
Answer:
b) Selectors

Question 9.
Which of the following is used to build the abstract data type?
a) Destructors
b) Constructors
c) Selectors
d) All of these
Answer:
b) Constructors

Question 10.
How many ways of representing pair data types are there?
(a) 1
(b) 2
(c) 3
(d) 4
Answer:
(b) 2

Question 11.
The process of providing only the essentials and hiding the details is known as …………….
a) Functions
b) Encapsulation
c) Abstraction
d) Pairs
Answer:
c) Abstraction

Question 12.
A D T expansion is …………….
a) Abstract Data Type
b) Absolute Data Type
c) Abstract Data Template
d) Application Development Template
Answer:
a) Abstract Data Type

Question 13.
How many objects can be created from a class?
(a) 0
(b) 1
(c) 2
(d) many
Answer:
(d) many

Question 14.
A powerful concept that allows programmers to treat codes as objects?
a) Encapsulation
b) Inheritance
c) Data Abstraction
d) Polymorphism
Answer:
c) Data Abstraction

II. Answer the following questions (2 and 3 Marks)

Question 1.
What are the two parts of a program?
Answer:
The two parts of a program are, the part that operates on abstract data and the part that defines a concrete representation.

III. Answer the following questions (5 Marks)

Question 1.
Explain the representation of Abstract data type using rational numbers.
Answer:

• Any program consists of two parts – the part that operates on abstract data and the part that defines a concrete representation, which is connected by a small set of functions that implement abstract data in terms of the concrete representation.
• To illustrate this technique, let us consider an example to design a set of functions for manipulating rational numbers.

Example:

• A rational number is a ratio of integers, and rational numbers constitute an important sub-class of real numbers.
• A rational number such as 8/3 or 19/23 is typically written as : < numerator > /< denominator > where both the < numerator > and < denominator > are placeholders for integer values.
• Both parts are needed to exactly characterize the value of the rational number.
• Actually dividing integers produces a float approximation, losing the exact precision of integers.
• However, you can create an exact representation for rational numbers by combining together the numerator and denominator.
  – – constructor
  – – constructs a rational number with numerator n, denominator d
  rational (n, d)
  – – selector
  numer(x) → returns the numerator of rational number x
  denom(y) → returns the denominator of rational number y.
• We have the operations on rational numbers defined in terms of the selector functions numer and denom, and the constructor function rational, but you haven’t yet defined these functions.
• We have to glue together a numerator and a denominator into a compound value
• The pseudo-code for the representation of the rational number using the above constructor and selector is
  x,y:=8,3
  rational (n,d)
  numer(x)/numer(y)
  – – output: 2.6666666666666665

Tamilnadu State Board New Syllabus Samacheer Kalvi 12th Economics Guide Pdf Chapter 6 Banking
Text Book Back Questions and Answers, Notes.

Tamilnadu Samacheer Kalvi 12th Economics Solutions Chapter 6 Banking

12th Economics Guide Banking Text Book Back Questions and Answers

PART – A

Multiple Choice questions

Question 1.
A Bank is a
a) Financial institutions
b) Corporate
c) An Industry
d) Service institutions
Answer:
a) Financial institutions

Question 2.
A commercial Bank is an institution that provides services
a) Accepting deposits
b) Providing loans
c) Both a and b
d) None of the above
Answer:
c) Both a and b

Question 3.
The Functions of commercial banks are broadly classified into
a) Primary Functions
b) Secondary Functions
c) Other Functions
d) a, b, and c
Answer:
d) a, b, and c

Question 4.
Bank credit refers to
a) Bank loañs
b) Advances
c) Bank loans and advances
d) Borrowing
Answer:
c) Bank loans and advances

Question 5.
Credit creation means.
a) Multiplication of loans and advances
b) Revenue
c) Expenditure
d) Debt
Answer:
a) Multiplication of loans and advances

Question 6.
NBFI does not have.
a) Banking license
b) government approval
c) Money market approval
d) Finance ministry approval
Answer:
a) Banking license

Question 7.
Central bank is …………………… authority of any country.
a) Monétary
b) Fiscal
c) Wage
d) National Income
Answer:
a) Monétary

Question 8.
Who will act as the banker to the Government of India?
a) SBI
b) NABARD
c) ICICI
d) RBI
Answer:
d) RBI

Question 9.
Lender of the last resort is one of the functions of.
a) Central Bank
b) Commercial banks
c) Land Development Banks
d) Co – operative banks
Answer:
a) Central Bank

Question 10.
Bank Rate means.
a) Re – discounting the first class securities
b) Interest rate
c) Exchange rate
d) Growth rate Repo Rate means.
Answer:
a) Re – discounting the first class securities

Question 11.
Repo Ràte means.
a) Rate at which the Commercial Banks are willing to lend to RBI
b) Rate at which the RBI is willing to lend to commercial banks
c) Exchange rate of the foreign bank
d) Growth rate of the economy .
Answer:
b) Rate at which the RBI is willing to lend to commercial banks

Question 12.
Moral suasion refers.
a) Optimization
b) Maximization,
c) Persuasion
d) Miñimization
Answer:
c) Persuasion

Question 13.
ARDC started functioning from
a) June 3 1963
b) July 5, 1963
c)July 1,1963
d) July 1, 1963
Answer:
d) July 1, 1963

Question 14.
NABARD was set up in .
a) July 1962
b) July 1972
c) July 1982
d) July 1992
Answer:
c) July 1982

Question 15.
EXIM bank was established in ……………..
a) June 1982
b) April 1982
c) May 1982
d) March 1982
Answer:
d) March 1982

Question 16.
The State Financial Corporation Act was passed by .
a) Governnent of India
b) Government of Tamilnadu
c) Government of Union Territòries
d) Local Government
Answer:
a) Governnent of India

Question 17.
Monetary policy is formulated by.
a) Co – operative banks
b) Commercial banks
c) Central bank
d) Foreign banks
Answer:
c) Central bank

Question 18.
Online Banking is also known as
a) E Banking.
b) Internet Banking
c) RTGS
d) NEFT
Answer:
b) Internet Banking

Question 19.
Expansions of ATM.
a) Automated Teller Machine
b) Adjustment Teller Machine
c) Automatic Teller mechanism
d) Any Time Money
Answer:
a) Automated Teller Machine

Question 20.
2016 Demonetization of currency includes denominations of
a) ₹ 500 and ₹ 1000
b) ₹ 1000 and ₹ 2000
c) ₹ 200 and ₹ 500
d) All the above
Answer:
a) ₹ 500 and ₹ 1000

PART – B

Answer the following questions in one or two sentences.

Question 21.
Define Commercial banks.
Answer:
Commercial bank refers to a bank, or a division of a large bank, which more specifically deals with deposit and loan services provided to corporations or large/middle-sized business – as opposed to individual members of the public/small business.

Question 22.
What is credit creation?
Answer:
Credit creation means the multiplication of loans and advances. Commercial banks receive deposits from the public and use these deposits to give loans.

Question 23.
Define central bank.
Answer:
A central bank is an institution that manages a state’s currency, money supply, and interest rates.

Question 24.
Distinguish between CRR and SLR.
CRR is the percentage of money, which a bank has to keep with RBI in the form of cash.
SLR is the proportion of liquid assets to time and demand liabilities.

Question 25.
Write the meaning of Open market operations
Answer:

1. In a narrow sense, the Central Bank starts the purchase and sale of Government securities in the money market.
2. In Broad Sense, the Central Bank purchases and sells not only Government securities but also other proper eligible securities like bills and securities of private concerns.
3. When the banks and the private individuals purchase these securities they have to make payments for these securities to the Central Bank.

Question 26.
What is rationing of credit?
Answer:
Rationing of credit is an instrument of credit control. It aims to control and regulate the purposes for which credit is granted by commercial banks.

Question 27.
Mention the functions of the agriculture credit department.
Answer:
Functions of Agriculture Credit Department:

1. To maintain an expert staff to study all questions on agricultural credit;
2. To provide expert advice to Central and State Government, State Co-operative Banks, and other banking activities.
3. To finance the rural sector through eligible institutions engaged in the business of agricultural credit and to co-ordinate their activities.

PART – C

Answer the following questions in one paragraph.

Question 28.
Write the mechanism of crédit creation by commercial banks.
Answer:

• Bank credit refers to bank loans and advances. Money is said to be created when the banks, through their lending activities, make a net addition to the total supply of money in the economy.
• Likewise, money is said to be destroyed when the loans are repaid by the borrowers. Consequently the credit creáted are wiped out.
• Banks have the power to expand or contract demand deposits. This power of the commercial banks to create deposits through their loans and advances is known as credit creation.

Question 29.
Give a brief note on NBFI.
Answer:
Non – Banking Financial Institution (NBFI):
1. A non – banking financial institution (NBFI) or non-bank financial company (NBFC) is a financial institution that does not have a full banking license or is not supervised by the central bank.

2. The NBFIs do not carry on pure banking business, but they will carry on other financial transactions. They receive deposits and give loans. They mobilize people’s savings and use the funds to finance expenditure on investment activities. In short, they are institutions which undertake borrowing and lending. They operate in both the money and the capital markets.

3. NBFIs can be broadly classified into two categories. Viz.., (1) Stock Exchange; and (2) Other Financial institutions. Under the latter category comes Finance Companies, Finance Corporations, ChitFunds, Building Societies, Issue Houses, Investment Trusts and Unit Trusts and Insurance Companies.

Question 30.
Bring out the methods of credit control.
Answer:
Credit Control Measures

Question 31.
What are the functions of NABARD?
Answer:
Functions of NABARD:
NABARD has inherited its apex role from RBI i.e, it is performing all the functions performed
by RBI with regard to agricultural credit.

1. NABARD acts as a refinancing institution for all kinds of production and investment credit to agriculture, small-scale industries, cottage, and village industries, handicrafts and rural crafts and real artisans and other allied economic activities with a view to promoting integrated rural development.

2. NABARD gives long-term loans (upto 20 Years) to State Government to enable them to subscribe to the share capital of cooperative credit societies.

3. NABARD gives long-term loans to any institution approved by the Central Government or contribute to the share capital or invests in securities of any institution concerned with agriculture and rural development.

4. NABARD has the responsibility of coordinating the activities of Central and State Governments, the Planning Commission (now NITI Aayog) and other all India and State level institutions entrusted with the development of small scale industries, village and cottage industries, rural crafts, industries in the tiny and decentralized sectors, etc.

5. It maintains a Research and Development Fund to promote research in agriculture and rural development.

Question 32.
Specify the function of IFCI.
Answer:
The functions of the Industrial Finance Corporation of India are

• Long term loans; both in rupees and foreign currencies.
• Underwriting of equity, preference and debenture issues.
• Subscribing to equity, preference and debenture issues. .
• Guaranteeing the deferred payments in respect of machinery imported from abroad or purchased in India.
• Guaranteeing of loans raised in foreign currency from foreign financial institutions.

Question 33.
Distinguish between money market and capital market.
Answer:

Question 34.
Mention the Objectives of demonetizations.
Answer:
Objectives of Demonetisation:

1. Removing Black Money from the country.
2. Stopping of Corruption.
3. Stopping Terror Funds.
4. Curbing Fake Notes.

Demonetisation is the act of stripping a currency unit of its status as legal tender. It occurs whenever there is a change of national currency. The current form or forms of money is pulled from circulation, often to be replaced with new coins or notes.

PART – D

Answer the following questions in about a page.

Question 35.
Explain the role of Commercial Banks in economic development.
Answer:
Role of Commercial Banks in Economic Development of a Country Role of Commercial Banks:

1. Capital Formation
2. Creation of Credit
3. Channelizing the funds
4. Encouraging Rights Type of Industries
5. Banks Monetize Debt
6. Finance to Government
7. Employment Generation
8. Bank Promote Entrepreneurship

1. Capital Formation:

• Banks play an important role in capital formation, which is essential for the economic development of a country.
• They mobilize the small savings of the people scattered over a wide area through their network of branches all over the country and make it available for productive purposes.

2. Creation of Credit:

• Banks create credit for the purpose of providing more funds for development projects.
• Credit creation leads to increased production, employment, sales and prices and thereby they bring about faster economic development.

3. Channelizing the Funds towards Productive Investment:

• Banks invest the savings mobilized by them for productive purposes.
• Capital formation is not the only function of commercial banks.

4. Encouraging Right Type of Industries:

• Many banks help in the development of the right type of industries by extending loan to right type of persons.
• In this way, they help not only for industrialization of the country but also for the economic development of the country.
• They grant loans and advances to manufacturers whose products are in great demand.

5. Banks Monetize Debt:

• Commercial banks transform the loan to be repaid after a certain period into cash, which can be immediately used for business activities.
• Manufacturers and wholesale traders cannot increase their sales without selling goods on credit basis.

6. Finance to Government:

• The government is acting as the promoter of industries in underdeveloped countries for which finance is needed for it.
• Banks provide long – term credit to Government by investing their funds in Government securities and short-term finance by purchasing Treasury Bills.

7. Employment Generation:

• After the nationalization of big banks, banking industry has grown to a great extent.
• Bank’s branches are opened frequently, which leads to the creation of new employment opportunities.

8. Banks Promote Entrepreneurship:

• In recent days, banks have assumed the role of developing entrepreneurship particularly in developing countries like India by inducing new entrepreneurs to take up well-formulated projects and provision of counseling services like technical and managerial guidance.

Question 36.
Elucidate the functions of commercial Banks.
Answer:
The functions of commercial Banks are classified as primary secondary and other functions.
(a) Primary Functions:

1. Accepting Deposits:
It implies that Commercial banks are mainly dependent on public deposits. There are two types of deposits, which are :

• Demand Deposits:
  It refers to deposits that can be with drawn by individuals without any prior notice to the bank
• Time Deposit:
  It refers to deposits that are made for certain committed period of time.

2. Advancing Loans:
It refers to granting loans to individuals and businesses. Commercial banks grant loans in the form of overdraft, cash credit and discounting bills of exchange.

b) Secondary Functions:

1. Agency Functions
It implies that commercial banks act as agents of customers by performing various functions. They are

• Collecting cheques
• Collecting Income
• Paying Expenses

2) General utility Function
It implies that commercial banks provide some utility to customers by performing various functions .

• Providing Locker Facilities
• Issuing Traveler’s cheques
• Dealing in Foreign Exchange

3) Transferring Funds :
It refers to transferring of funds from one bank to another. Funds are transferred by means of draft, telephonic transfer, and electronic transfer.

4) Letter of credit:
Commercial banks issue letters of credit to their customers to certify their creditworthiness.

• Underwriting securities
• Electronic Banking

(c) Other Functions:

1. Money supply
   It refers to one of the important functions of commercial banks that help in increasing money supply. With this function without printing additional money, the supply of money is increased.
2. Credit creation
   Credit creation means the multiplication of loans and advances.
3. Collection of statistics
   Banks collect and publish statistics relating to trade, commerce, and industry.

Question 37.
Describe the functions of Reserve Bank of India.
Answer:
Functions of Central Bank (Reserve Bank of India):
The Reserve Bank of India (RBI) is India’s central banking institution, which controls the monetary policy of the Indian rupee.

1. Monetary Authority:
It controls the supply of money in the economy to stabilize exchange rate, maintain healthy balance of payment, attain financial stability, control inflation, strengthen banking system.

2. The issuer of currency:
The objective is to maintain the currency and credit system of the country. It is the sole authority to issue currency. It also takes action to control the circulation of fake currency.

3. The issuer of Banking License:
As per Sec 22 of Banking Regulation Act, every bank has to obtain a banking license from RBI to conduct banking business in India.

4. Banker to the Government:
It acts as banker both to the central and the state governments. It provides short-term credit. It manages all new issues of government loans, servicing the government debt outstanding and nurturing the market for government securities. It advises the government on banking and financial subjects.

5. Banker’s Bank:
RBI is the bank of all banks in India as it provides loan to banks, accept the deposit of banks, and rediscount the bills of banks.

6. Lender of last resort:
The banks can borrow from the RBI by keeping eligible securities as collateral at the time of need or crisis, when there is no other source.

7. Act as clearing house:
For settlement of banking transactions, RBI manages 14 clearing houses. It facilitates the exchange of instruments and processing of payment instructions.

8. Custodian of foreign exchange reserves:
It acts as a custodian of FOREX. It administers and enforces the provision of Foreign Exchange Management Act (FEMA), 1999. RBI buys and sells foreign currency to maintain the exchange rate of Indian rupee v/s foreign currencies.

9. Regulator of Economy:
It controls the money supply in the system, monitors different key indicators like GDP, Inflation, etc.

10. Managing Government securities:
RBI administers investments in institutions when they invest specified minimum proportions of their total assets/liabilities in government securities.

11. Regulator and Supervisor of Payment and Settlement Systems:
The Payment and Settlement Systems Act of 2007 (PSS Act) gives RBI oversight authority for the payment and settlement systems in the country. RBI focuses on the development and functioning of safe, secure and efficient payment and settlement mechanisms.

12. Developmental Role:
This role includes the development of the quality banking system in India and ensuring that credit is available to the productive sectors of the economy. It provides a wide range of promotional functions to support national objectives.

It also includes establishing institutions designed to build the country’s financial infrastructure. It also helps in expanding access to affordable financial services and promoting financial education and literacy.

13. Publisher of monetary data and other data:
RBI maintains and provides all essential banking and other economic data, formulating and critically evaluating the economic policies in India. RBI collects, collates and publishes data regularly.

14. Exchange manager and controller:
RBI represents India as a member of the International Monetary Fund [IMF], Most of the commercial banks are authorized dealers of RBI.

15. Banking Ombudsman Scheme:
RBI introduced the Banking Ombudsman Scheme in 1995. Under this scheme, the complainants can file their complaints in any form, including online and can also appeal to the Ombudsman against the awards and the other decisions of the Banks.

16. Banking Codes and Standards Board of India:
To measure the performance of banks against Codes and standards based on established global practices, the RBI has set up the Banking Codes and Standards Board of India (BCSBI).

Question 38.
What are the objectives of Monetary policy? Explain.
Answer:
1) Neutrality of money :
Neutralists hold the view that monetary authority should aim at neutrality of money in the economy. Monetary changes could be the root cause of all economic fluctuations.

2) Exchange Rate stability :
Exchange rate stability was the traditional objective of monetary authority. This was the main objective under Gold standard among different countries. Instability in the Exchange rates results in unfavourable balance of payments. Therefore, stable exchange rates are advocated.

3) Price stability:
Price stability is considered the most genuine objective of monetary policy Stable prices repose public confidence. It promotes business activity and ensures equitable distribution of income and wealth. As a result, there is general wave of prosperity and welfare in the community.
But, price stability does not mean “price rigidity or price stagnation”

4) Full employment:
Full employment was considered as the main goal of monetary policy. With the publication of keynes General Theory of Employment, Interest and money in 1936, the objective of full employment gained full support as the chief objective of monetary policy.

5) Economic Growth:
Monetary policy should promote sustained and continuous economic growth by maintaining equilibrium between the total demand for money and total production capacity and further creating favourable conditions for saving and investment.
For bringing equality between demand and supply, a flexible monetary policy is the best course.

6) Equilibrium in the Balance of Payments:
Equilibrium in the balance of payments is another objective of monetary policy which emerged significantly in the post-war years. Monetary authority makes efforts to maintain equilibrium in the balance of payments.

12th Economics Guide Banking Additional Important Questions and Answers

One Mark Questions.

Question 1.
Reserve Bank of India was nationalised in …………………………
(a) 1947
(b) 1948
(c) 1949
(d)1950
Answer:
(c) 1949

Question 2.
Under British rule the first bank of India was …………………….
a) Bank of Bengal
b) Bank of Hindustan
c) Bank of Bombay
d) Bank of Madras
Answer:
b) Bank of Hindustan

Question 3.
The ……………………… Bank of India was changed into SBI
a) Mumbai
b) Chennai
c) Imperial
d) Presidency
Answer:
c) Imperial

Question 4.
Primary functions of the commercial bank is …………………………
(a) Accepting deposits from the public
(b) Making loans and advances to public
(c) Discounting bills of exchange
(d) Inter bank borrowing
Answer:
(a) Accepting deposits from the public

Question 5.
RBI commenced its operations on …………………………..
a) April 1,1934
b) April 1,1935
c) January 1,1949
d) April 1,1937
Answer:
b) April 1,1935

Question 6.
The coins are issued by …………………………
(a) Ministry of Finance
(b) RBI
(c) Central Bank
(d) State Bank
Answer:
(a) Ministry of Finance

Question 7.
The name Rupee was derived from the Sanskrit word …………….
a) Nomia
b) Rupay
c) Raupya
d) None of the above
Answer:
c) Raupya

Question 8.
The rate at which the RBI is willing to borrow from the commercial banks is called …………….
a) Reverse Repo Rate
b) Repo rate
c) Cash Reserve Ratio
d) Bank rate
Answer:
a) Reverse Repo Rate

Question 9.
Open Market operations enable the ………………………… to reduce the money supply in the economy.
(o) Commercial bank
(b) SBI
(c) ICICI
(d) RBI
Answer:
(d) RBI

Question 10.
Each Indian bank note has its amount written in …………….. language.
a) 15
b) 20
c) 17
d) 14
Answer:
c) 17

Question 11.
Regional Rural Banks were set up on ……………………
a) 1950
b) 1967
c)1970
d) 1975
Answer :
d) 1975

Question 12.
Industrial credit and Investment Corporation of India (ICICI) was set up on ………………
a) January 5, 1955
b) January 5,1973
c) February 15, 1976
d) February 5,1955
Answer:
a) January 5,1955

Question 13.
“Monetary History of the United states, 1867 -1960” was written by ………………
a) Milton Friedman
b) Irving Fisher
c) Walker
d) Culbertson.
Answer:
a) Milton Friedman

Question 14.
The qualitative credit control methods are also called …………………………
(a) Selective cash control
(b) Selective expenditure control
(c) Selective credit control
(d) Selective money control
Answer:
(c) Selective credit control

Question 15.
…………………. is the act of stripping a currency unit of its status as legal tender.
a) Fiscal policy
b) Demonitisation
c) Monetary policy
d) Money market.
Answer:
b) Demonetisation

II. Match the following:

Question 1.
A) Bank of Bengal – 1) 1843
B) Bank of Bombay – 2) 1809
C) Bank of Madras – 3) 1935
D) Reserve Bank of India – 4)1840

Answer:
a) 2 4 1 3

Question 2.
A) NEFT – 1) Automated Teller Machine
B) RTGS – 2) Payment Bank
C) ATM – 3) National Electronic Fund Transfer
D) Paytm – 4) Real Time Gross Settlement.

Answer:
c) 3 4 1 2

Question 3.
A) Expansionary monetary policy – 1) Milton Friedman
B) Contractionary monetary policy – 2) Cassel, Keynes
c) Monetary policy – 3) Cheap money policy
D) Price stability – 4) Dear money policy

Answer :
a) 3 4 1 2

III. Choose the correct pair

Question 1.
a) Nobel prize – J.M. Keynes
b) Monetary policy – Macro-Economic Policy
c) Money Market – Long term credit instruments
d) Capital Market – Short term credit instruments
Answer :
b) Monetary policy – Macro-Economic Policy

Question 2.
a) RBI – 1945
b) ARDC – 1968
c) RRB – 1975
d) NABARD – 1984
Answer:
c) RRB -1975

Question 3.
a) Neutrality of Money – Cassel, Keynes
b) Price stability – Wicksteed, Robertson
c) E-banking – Internet banking
d) Merger of banks – 2018
Answer:
c) E-banking – Internet banking

IV. Choose the incorrect pair
Question 1.
a)NABARD – Agricultural credit
b) All-India level Institutions – IFCI, ICICI, IDBI
c) State level Institutions – SFC, SIDC
d) RRB – Industrial Development Bank
Answer:
d) RRB – Industrial Development Bank

Question 2.
a) First Central Bank – The Ricks Bank
b) Commercial banks – Service motivated
c) Time Deposit – Recurring deposit
d) Primary Deposit -. Passive Deposits
Answer:
b) Commercial banks – Service motivated

Question 3.
a) Reserve Bank of India Act – 1935
b) Foreign Exchange Management Act – 1999
c) Banking Ombudsman Scheme -‘1995
d) Banking Regulation Act – 1949
Answer:
a) Reserve Bank of India Act -1935

V. Choose the correct statement.

Question 1.
a) Central Government is the sole authority to issue currency in India.
b)Variable cash Reserve Ratio as an objective of monetary policy was first suggested by J.M.Keynes.
c) SBI represents India as a member of the International Monetary Fund.
d )Variable cash Reserve Ratio was first followed by RBI.
Answer:
b) Variable cash Reserve Ratio as an objective of monetary policy was first suggested by J.M.Keynes.

Question 2.
a) RRBS provides credit and other facilities to urban Industries.
b)Contractionary Monetary policy decreases unemployment.
c) Expansionary Monetary policy is a cheap money policy.
d) Price stability means price rigidity or price stagnation.
Answer:
c) Expansionary Monetary policy is a cheap money policy.

Question 3.
a) The Minimum amount for NEFT transfer is 2 lakhs.
b) RTGS means National electronic fund transfer.
c) Capital market is concerned with raising capital by dealing in shares, bonds, and other long-term investments.
d) The rate at which the RBI is willing to borrow from the commercial banks is called Repo Rate.
Answer:
c) Capital market is concerned with raising capital by dealing in shares, bonds, and other long-term investments.

VI. Choose the incorrect statement

Question 1.
a) Variable cash Reserve Ratio was first introduced by J.M.Keynes.
b) Bank rate is otherwise called Discount Rate.
c) Commercial Banks are profit-motivated.
d) Public deposits are classified as Demand deposits, Time deposits, and Primary deposits.
Answer:
d) Public deposits are classified as Demand deposits, Time deposits, and Primary deposits.

Question 2.
a) Commercial banks provide long-term credit to maintain liquidity of assets.
b) Credit creation literally means the multiplication of loans and advances.
c) Rationing of credit is the oldest method of credit Control.
d) The modern banks create deposits in two ways such as primary deposit and derived deposit.
Answer:
a) Commercial banks provide long-term credit to maintain liquidity of assets.

Question 3.
a) The Agricultural Refinance Development Corporation was established on July 1, 1963.
b) Non – Banking Financial Institutions are supervised by the Central Bank.
c) If the Central Bank wants to control credit, it will raise the bank rate.
d) The share capital of NABARD was equally contributed by the RBI and the GOI.
Answer:
b) Non – Banking Financial Institutions are supervised by the Central Bank.

VII. Pick the odd one out:

Question 1.
a) State Financial Corporations.
b) Industrial Finance Corporation of India
c) Industrial Credit and Investment Corporation of India
d) Industrial Development Bank of India.
Answer:
a) State Financial Corporations.

Question 2.
a) Bank Rate Policy
b) Open Market Operations
c) Rationing of Credit
d) Variable Reserve Ratio
Answer:
c) Rationing of Credit

Analyse the reason:

Question 1.
Assertion (A): Reserve Bank of India had set up a separate Agricultural Credit Department.
Reason (R): RBI’s responsibility in the field of agriculture had been creased due to the predominance of agriculture in the Indian economy and the inadequacy of the formal agencies to cater to the huge requirements of the sector.
Answer:
a) Assertion (A): and Reason (R) both are true, and (R) is the correct explanation of (A).

Question 2.
Assertion (A): A central bank is an institution that manages a state’s currency, money supply, and interest rates.
Reason (R): Central bank through monetary policy controls the supply of money.
Answer:
a) Assertion (A) and Reason (R) both are true, and (R) is the correct explanation of (A).

Question 3.
Assertion (A) : RBI was given oversight authority for the payment and settlement systems in the country. .
Reason (R) : The payment and settlement systems Act came into force in 2007.
Answer:
a) Assertion (A) and Reason (R) both are true, and (R) is the correct explanation of (A).
Option:
a) Assertion (A) and Reason (R) both are true, and (R) is the correct explanation of (A).
b) Assertion (A) and Reason (R) both are true, but (R) is not the correct explanation of (A).
c) (A) is true, but (R) is false.
d) Both (A) and (R) are false.

IX. 2 Mark Questions

Question 1.
When and where was the first central bank established?
Answer:

• The Ricks Banks of Sweden, which had sprung from a private bank established in 1656 is the oldest central bank in the world.
• The Bank of England (1864) is the first bank of issues.

Question 2.
What are the functions of primary deposits?
Answer:
Primary Deposits:

1. It is out of these primary deposits that the bank makes loans and advances to its customers.
2. The initiative is taken by the customers themselves. In this case, the role of the bank is passive.
3. So these deposits are also called “Passive deposits”.

Question 3.
Name the classification of NBFIs.
Answer:

• Stock Exchange
• Other financial institutions Under the latter category comes Finance companies, Finance corporations, Chit funds, Building societies, etc.

Question 4.
Name the institutions for industrial finance.
Answer:
All-India level Institution:

• Industrial Finance Corporation of India
• Industrial Credit and Investment Corporation of India
• Industrial Development Bank of India.

State-level Institutions:

• State Financial Corporations
• State Industrial Development Corporation

Question 5.
Write RBI granting Regional Rural Banks concessions?
Answer:
The RBI has been granting many concessions to RRBs:

1. They are allowed to maintain the cash reserve ratio at 3 percent and statutory liquidity ratio at 25 percent; and
2. They also provide refinance facilities through NABARD.

Question 6.
State the specific objectives of monetary policy.
Answer:

• Neutrality of Money
• Stability of Exchange Rates
• Price stability
• Full employment
• Economic Growth
• Equilibrium in the Balance of Payments.

Question 7.
What is E-Banking?
Answer:
Online banking also known as internet banking, is an electronic payment system that enables customers of a bank or other financial institution to conduct a range of financial transactions through the financial institution’s website.

Question 8.
What do you know about Automated Teller Machine?
Answer:
ATMs were first introduced in 1967. Biometric authentication is already used in India, and its recognition is in place at Qatar National Bank ATMs.

Question 9.
Write a note on Paytm.
Answer:
Payments bank or Paytm is one of India’s e-commerce payment system and digital wallet company. It was established on August 2015, by the license of RBI.

Question 10.
Write a note on Debit Card.
Answer:
A Debit card is a card allowing the holder to transfer money electronically from their bank account when making a purchase.

Question 11.
What is demonetization?
Answer:
Demonetization is the act of stripping a currency unit of its status as legal tender. The current form or forms of money is pulled from circulation, often to be replaced with new coins or notes.

X. 3 Mark Questions

Question 1.
What are the functions of RBI agricultural credit?
Answer:
Role of RBI in agricultural credit:

1. RBI has been playing a very vital role in the provision of agricultural finance in the country.
2. The Bank’s responsibility in this field had been increased due to the predominance of agriculture in the Indian economy and the inadequacy of the formal agencies to cater to the huge requirements of the sector.
3. In order to fulfill this important role effectively, the RBI set up a separate Agriculture Credit Department.
4. However, the volume of informal loans has not declined sufficiently.

Question 2.
Write a note on Regional Rural Banks.
Answer:

• Regional Rural Banks (RRBs) was setup by the Government of India in 1975.
• The main objective of the RRBs is to provide credit and other facilities particularly to the small and marginal farmers, agricultural labourers, artisans, and smalls entrepreneurs so as to develop agriculture, trade, commerce, industry, and other productive activities in the rural areas.
• RBI provides refinance facilities to RRBs through NABARD.

Question 3.
Explain the functions of ICICI.
Answer:
ICICI was set up on 5th January 1955. The principal purpose of this institution is to channelize the world bank funds to the industry in India and also to help build up a capital market.

Functions:

1. Assistance to industries
2. Provision of foreign currency loans
3. Merchant banking
4. Letter of credit
5. Project promotion
6. Housing loans
7. Leasing operations

Question 4.
What is E-Banking?
Answer:

1. Online banking, also known as internet banking, is an electronic payment system that enables customers of a bank or other financial institution to conduct a range of financial transactions through the financial institution’s website.
2. The online banking system typically connects to or be part of the core banking system operated by a bank and is in contrast to branch banking which was the traditional way customers accessed banking services.

Question 5.
Differentiate NEFT and RTGS.
Answer:

XI. 5 Mark Questions

Question 1.
Differentiate Repo Rate and Reverse Repo Rate.
Answer:

Question 2.
Explain the functions of the Industrial Development Bank of India.
Answer:

• The functions of IDBI fall into two groups.
  • Assistance to other financial institutions.
  • Direct assistance to industrial concerns either on its own or in participation with other institutions.
• The IDBI can provide refinance in respect of term loans to industrial concerns given by the IFC, the SFCs, other financial institutions notified by the government, scheduled banks, and state cooperative banks.
• A special feature of the IDBI is the provision for the creation of a special fund known as the Development assistance fund.
• The fund is intended to provide assistance to industries which require heavy investments with a low anticipated rate of return.

Question 3.
Explain the State level institutions of Industrial Finance.
Answer:
1. State Financial Corporation (SFCs):
The government of India passed 1951 the State Financial corporations Act and SFCs were set up in many states. The SFCs are mainly intended for the development of small and medium industrial units within their respective states. However, in some cases, they extend to neighbouring states as well.

SFCs depend upon the IDBI for refinancing in respect of the term loans granted by them. Apart from these, the SFCs can also make temporary borrowings from the RBI and borrowings from IDBI and by the sale of bonds.

2. State Industrial Development Corporations(SIDCOs):
The Industrial Development Corporations have been set up by the state governments and they are wholly owned by them. These institutions are not merely financing agencies, are entrusted with the responsibility of accelerating the industrialization of their states.

Tamilnadu State Board New Syllabus Samacheer Kalvi 12th Computer Science Guide Pdf Chapter 1 Function Text Book Back Questions and Answers, Notes.

Tamilnadu Samacheer Kalvi 12th Computer Science Solutions Chapter 1 Function

12th Computer Science Guide Function Text Book Questions and Answers

I. Choose the best answer (I Marks)

Question 1.
The small sections of code that are used to perform a particular task is called
a) Subroutines
b) Files
c) Pseudo code
d) Modules
Answer:
a) Subroutines

Question 2.
Which of the following is a unit of code that is often defined within a greater code structure?
a) Subroutines
b) Function
c) Files
d) Modules
Answer:
b) Function

Question 3.
Which of the following is a distinct syntactic block?
a) Subroutines
b) Function
c) Definition
d) Modules
Answer:
c) Definition

Question 4.
The variables in a function definition are called as
a) Subroutines
b) Function
c) Definition
d) Parameters
Answer:
d) Parameters

Question 5.
The values which are passed to a function definition are called
a) Arguments
b) Subroutines
c) Function
d) Definition
Answer:
a) Arguments

Question 6.
Which of the following are mandatory to write the type annotations in the function definition
a) Curly braces
b) Parentheses
c) Square brackets
d) indentations
Answer:
b) Parentheses

Question 7.
Which of the following defines what an object can do?
a) Operating System
b) Compiler
c) Interface
d) Interpreter
Answer:
c) Interface

Question 8.
Which of the following carries out the instructions defined in the interface?
a) Operating System
b) Compiler
c) Implementation
d) Interpreter
Answer:
c) Implementation

Question 9.
The functions which will give exact result when same arguments are passed are called
a) Impure functions
b) Partial Functions
c) Dynamic Functions
d) Pure functions
Answer:
d) Pure functions

Question 10.
The functions which cause side effects to the arguments passed are called
a) Impure functions
b) Partial Functions
c) Dynamic Functions
d) Pure functions
Answer:
a) Impure functions

II. Answer the following questions (2 Marks)

Question 1.
What is a subroutine?
Answer:
Subroutines are the basic building blocks of computer programs. Subroutines are small sections of code that are used to perform a particular task that can be used repeatedly. In Programming languages, these subroutines are called Functions.

Question 2.
Define Function with respect to the Programming language.
Answer:

• A function is a unit of code that is often defined within a greater code structure.
• A function works on many kinds of inputs like variants, expressions and produces a concrete output.

Question 3.
Write the inference you get from X:=(78).
Answer:
Value 78 is bound to the name X.

Question 4.
Differentiate Interface and Implementation
Answer:

Question 5.
Which of the following is a normal function definition and which is a recursive function definition?
Answer:
(I) Let Recursive sum x y:
return x + y

(II) let disp:
print ‘welcome’

(III) let Recursive sum num:
if (num! = 0) then return num + sum (num – 1) else
return num

1. Recursive function
2. Normal function
3. Recursive function

III. Answer the following questions (3 Marks)

Question 1.
Mention the characteristics of Interface.
Answer:

• The class template specifies the interfaces to enable an object to be created and operated properly.
• An object’s attributes and behaviour is controlled by sending functions to the object.

Question 2.
Why strlen() is called pure function?
Answer:
strlen (s) is called each time and strlen needs to iterate over the whole of ‘s’. If the compiler is smart enough to work out that strlen is a pure function and that ‘s’ is not updated in the lbop, then it can remove the redundant extra calls to strlen and make the loop to execute only one time. This function reads external memory but does not change it, and the value returned derives from the external memory accessed.

Question 3.
What is the side effect of impure function? Give example.
Answer:

• Impure function has side effects when it has observable interaction with the outside world.
• The variables used inside the function may cause side effects through the functions which are not passed with any arguments. In such cases the function is called impure function.
• When a function depends on variables or functions outside of its definition block, you can never be sure that the function will behave the same every time it’s called.
• For example, the mathematical function random () will give different outputs for the same function call
  let random number
  let a:= random()
  if a> 10 then
  return: a
  else
  return 10
• Here the function random is impure as it not sure what the will be the result when we call
  the function

Question 4.
Differentiate pure and impure functions.
Answer:

Question 5.
What happens if you modify a variable outside the function? Give an example
Answer:
When a function depends on variables or functions outside of its definition block, you can never be sure that the function will behave the same every time it’s called.
For example let y: = 0
(int) inc (int) x
y: = y + x;
return (y)
In the above example the value of y get changed inside the function defintion due to which the result will change each time. The side effect of the inc ( ) function is it is changing the data ‘ of the external visible variable ‘y’.

IV. Answer the following questions (5 Marks)

Question 1.
What are called Parameters and Write a note on
1. Parameter Without Type
2. Parameter With Type
Answer:
Parameter:
Parameter is the variables in a function definition
Arguments:
Arguments are the values which are passed to a function definition
Parameters passing are of two types namely

1. Parameter without Type
2. Parameter with Type

1. Parameter without Type:
Let us see an example of a function definition.
(requires: b > =0 )
(returns: a to the power of b)
let rec pow a b:=
if b=0 then 1
else a pow a*(b-l)

• In the above function definition variable ‘b’ is the parameter and the value which is passed to the variable ‘b’ is the argument.
• The precondition (requires) and postcondition (returns) of the function is given.
• Note we have not mentioned any types (data types).
• Some language computer solves this type (data type) inference problem algorithmically, but some require the type to be mentioned.

2. Parameter with Type:
Now let us write the same function definition with types for some reason:
(requires: b > 0 )
(returns: a to the power of b )
let rec pow (a: int) (b: int): int: =
if b=0 then 1 else a * pow b (a-1)

• When we write the type annotations for ‘a’ and ‘b’ the parentheses are mandatory.
• There are times we may want to explicitly write down types.
• This useful on times when you get a type error from the compiler that doesn’t make sense.
• Explicitly annotating the types can help with debugging such an error message.

Question 2.
Identify in the following program
Answer:
let rec gcd a b : =
if b < > 0 then gcd b (a mod b) else return a
(I) Name of the function
gcd

(II) Identify the statement which tells it is a recursive function
let rec

(III) Name of the argument variable
a, b

(IV) Statement which invokes the function recursively
gcd b(a mod b) [when b < > 0]

(V) Statement which terminates the recursion
return a (when b becomes 0).

Question 3.
Explain with example Pure and impure functions.
Answer:
Pure functions:

• Pure functions are functions which will give exact result when the same arguments are passed.
• For example, the mathematical function sin (0) always results 0.
  Let us see an example.
  let square x
  return: x * x
• The above function square is a pure function because it will not give different results for the same input.

Impure functions:

• The variables used inside the function may cause side effects through the functions which are not passed with any arguments. In such cases, the function is called the impure function.
• When a function depends on variables or functions outside of its definition block, we can never be sure that the function will behave the same every time it’s called.
• For example, the mathematical functions random () will give different outputs for the same function call.
  let Random number
  let a := random() if a > 10 then
  return: a else
  return: 10
• Here the function Random is impure as it is not sure what will be the result when we call the function.

Question 4.
Explain with an example interface and implementation
Answer:
Interface Vs Implementation:
An interface is a set of actions that an object can do. For example, when you press a light switch, the light goes on, you may not have cared how it splashed the light. In an Object-Oriented Programming language, an Interface is a description of all functions that a class must have in order to be a new interface.

In our example, anything that “ACTS LIKE” a light, should have to function definitions like turn on ( ) and a turn off ( ). The purpose of interfaces is to allow the computer to enforce the properties of the class of TYPE T (whatever the interface is) must have functions called X, Y, Z, etc.

A class declaration combines the external interface (its local state) with an implementation of that interface (the code that carries out the behaviour). An object is an instance created from the class. The interface defines an object’s visibility to the outside world.

Characteristics of interface

• The class template specifies the interfaces to enable an object to be created and operated properly.
• An object’s attributes and behavior is controlled by sending functions to the object.

Example:

• • The person who drives the car doesn’t care about the internal working.
• To increase the speed of the car he just presses the accelerator to get the desired behaviour.
• Here the accelerator is the interface between the driver (the calling / invoking object) and the engine (the called object).
• In this case, the function call would be Speed (70): This is the interface.
• Internally, the engine of the car is doing all the things.
• It’s where fuel, air, pressure, and electricity come together to create the power to move the vehicle.
  All of these actions are separated from the driver, who just wants to go faster. Thus we separate interface from implementation.

12th Computer Science Guide Function Additional Questions and Answers

I. Choose the best answer (1 Mark)

Question 1.
……………………… are expressed using statements of a programming language.
(a) Algorithm
(b) Procedure
(c) Specification
(d) Abstraction
Answer:
(a) Algorithm

Question 2.
The recursive function is defined using the keyword
a) let
b) requires
c) name
d) let rec
Answer:
d) let rec

Question 3.
A function definition which calls itself is called
a) user-defined function
b) recursive function
c) built-in function
d) derived function
Answer:
b) recursive function

Question 4.
Find the correct statement from the following.
(a) a : = (24) has an expression
(b) (24) is an expression
Answer:
(a) a : = (24) has an expression

Question 5.
strlen() is an example of ………………. function.
a) pure
b) impure
c) user-defined
d) recursive
Answer:
a) pure

Question 6.
Evaluation of ………………. functions does not cause any side effects to its output?
a) Impure
b) built-in
c) Recursive
d) pure
Answer:
d) pure

Question 7.
The name of the function in let rec pow ab : = is …………………………
(a) Let
(b) Rec
(c) Pow
(d) a b
Answer:
(c) Pow

Question 8.
An …………….. is an instance created from the class.
a) Interface
b) object
c) member
d) function
Answer:
b) object

Question 9.
In object-oriented programs …………… are the interface.
a) classes
b) object
c) function
d) implementation
Answer:
a) classes

Question 10.
In b = 0, = is ……………………….. operator
(a) Assignment
(b) Equality
(c) Logical
(d) Not equal
Answer:
(b) Equality

II. Answer the following questions (2 and 3 Marks)

Question 1.
What are the two types of parameter passing?
Answer:

1. Parameter without type
2. Parameter with type

Question 2.
What is meant by Definition?
Answer:
Definitions are distinct syntactic blocks.

Question 3.
Write the syntax for the function definitions?
Answer:
let rec f_n a₁ a₂ … a_n : = k
f_n : Function name
a₁ … a_n – variable
rec: recursion

Question 4.
Define Argument.
Answer:
Arguments are the values which are passed to a function definition through the function definition

Question 5.
Write notes on Interface.
Answer:

• An interface is a set of actions that an object can do.
• Interface just defines what an object can do, but won’t actually do it

Question 6.
Define Implementation.
Answer:
Implementation carries out the instructions defined in the interface

Question 7.
Write notes on Pure functions.
Answer:

• Pure functions are functions which will give exact result when the same arguments are passed.
• Example: strlen(),sqrt()

Question 8.
Write notes on the Impure function.
Answer:

• The functions which cause side effects to the arguments passed are called
  Impure function.
• Example: random(), date()

Question 9.
What is a Recursive function?
Answer:
A function definition which calls itself is called a Recursive function.

Question 10.
Differentiate parameters and arguments.
Answer:

Question 11.
Give function definition for the Chameleons of Chromeland problem?
Answer:
let rec monochromatize abc : =
if a > 0 then
a, b, c : = a – 1, b – 1, c + 2
else
a: = 0, b: = 0, c: = a + b + c
return c

Question 12.
Define Object:
Answer:
An object is an instance created from the class.

III. Answer the following questions (5 Marks)

Question 1.
Explain the syntax of function definitions
Answer:

• The syntax to define functions is close to the mathematical usage.
• The definition is introduced by the keyword let, followed by the name of the function and its arguments; then the formula that computes the image of the argument is written after an = sign.
• If you want to define a recursive function: use “let rec” instead of “let”.

The syntax for function definitions:

• let rec fn al a2 … an := k
• Here the ‘fn’ is a variable indicating an identifier being used as a
  function name.
• The names ‘al’ to ‘an’ are variables indicating the identifiers used as parameters.
• The keyword ‘rec’ is required if ‘fn’ is to be a recursive function; otherwise, it may be omitted.

Question 2.
Write a short note and syntax for function types?
Answer:

• The syntax for function types
  x→→y
  x1 →→ x2→→y
  x1 →→….. →→xn→→ y
• The ‘x’ and ‘y’ are variables indicating types
• The type x →→ ‘y’ is the type of a function that gets an input of type ‘x’ and returns an output of type ‘y’ whereas xl→→ x2 →→y is a type of a function that takes two inputs, the first input is of type and the second input of type ‘xl’, and returns an output of type <y’.
• Likewise x1→→……. →→ >xn→→y has type ‘x’ as the input of n arguments and ‘y’ type as output

Question 3.
On the island, there are different types of chameleons. Whenever two different color chameleons meet they both change their colors to the third color. Suppose two types of chameleons are equal in number.
Construct an algorithm that arranges meetings between these two types so that they change their color to the third type. In the end, all should display the same color.
Answer:
let ree monochromatic a b c:=
if a > 0 then
a, b, c:= a -1, b -1, c + 2
else
a:= 0 b:= 0 c:= a + b + c
return c

HANDS-ON PRACTICE

Question 1.
Write the algorithmic function definition to find the minimum among 3 numbers.
Answer:
let min 3abc:=
if a < b then
if a < c then a else c
else
if b < c then b else c

Question 2.
Write the algorithmic recursive function definition to find the sum of ‘n ‘ natural numbers. Answer:
let rec sum num:
lf(num!=0)
then return num+sum(num-l)
else return num

Tamilnadu State Board New Syllabus Samacheer Kalvi 12th Computer Science Guide Pdf Chapter 16 Data Visualization Using Pyplot: Line Chart, Pie Chart and Bar Chart Text Book Back Questions and Answers, Notes.

Tamilnadu Samacheer Kalvi 12th Computer Science Solutions Chapter 16 Data Visualization Using Pyplot: Line Chart, Pie Chart and Bar Chart

12th Computer Science Guide Data Visualization Using Pyplot: Line Chart, Pie Chart and Bar Chart Text Book Questions and Answers

I. Choose the best answer (1 Mark)

Question 1.
Which is a python package used for 2D graphics?
a) matplotlib.pyplot
b) matplotlib.pip
c) matplotlib.numpy
d) matplotlib.plt
Answer:
a) matplotlib.pyplot

Question 2.
Identify the package manager for Python packages, or modules.
a) Matplotlib
b) PIP
c) plt.show()
d) python package
Answer:
b) PIP

Question 3.
Read the following code: Identify the purpose of this code and choose the right option from the following.
C:\Users\YourName\AppData\Local\Programs\Python\Python36-32\Scripts > pip – version
a) Check if PIP is Installed
b) Install PIP
c) Download a Package
d) Check PIP version
Answer:
d) Check PIP version

Question 4.
Read the following code: Identify the purpose of this code and choose the right option from the following.
C:\Users\Your Name\AppData\Local\Programs\Python\Python36-32\Scripts > pip list
a) List installed packages
b) list command
c) Install PIP
d) packages installed
Answer:
a) List installed packages

Question 5.
To install matplotlib, the following function will be typed in your command prompt. What does “-U”represents?
Python -m pip install -U pip
a) downloading pip to the latest version
b) upgrading pip to the latest version
c) removing pip
d) upgrading matplotlib to the latest version
Answer:
b) upgrading pip to the latest version

Question 6.
Observe the output figure. Identify the coding for obtaining this output.

a) import matplotlib.pyplot as pit
plt.plot([1,2,3],[4,5,1])
plt.show()

b) import matplotlib.pyplot as pit plt.
plot([1,2],[4,5])
plt.show()

c) import matplotlib.pyplot as pit
plt.plot([2,3],[5,1])
plt.showQ

d) import matplotlib.pyplot as pit pit .plot ([1,3], [4,1 ])
Answer:
a) import matplotlib.pyplot as pit
plt.plot([1,2,3],[4,5,1])
plt.show()

Question 7.
Read the code:
a. import matplotlib.pyplot as pit
b. plt.plot(3,2)
c. plt.show()
Identify the output for the above coding

Answer:
c

Question 8.
Which key is used to run the module?
a) F6
b) F4
c) F3
d) F5
Answer:
d) F5

Question 9.
Identify the right type of chart using the following hints.
Hint 1: This chart is often used to visualize a trend in data over intervals of time.
Hint 2: The line in this type of chart is often drawn chronologically.
a) Line chart
b) Bar chart
c) Pie chart
d) Scatter plot
Answer:
a) Line chart

Question 10.
Read the statements given below. Identify the right option from the following for pie chart. Statement A : To make a pie chart with Matplotlib, we can use the plt.pie() function.
Statement B : The autopct parameter allows us to display the percentage value using the Python string formatting.
a) Statement A is correct
b) Statement B is correct
c) Both the statements are correct
d) Both the statements are wrong
Answer:
b) Statement B is correct

II Answer the following questions (2 marks)

Question 1
Define Data Visualization.
Answer:
Data Visualization is the graphical representation of information and data. The objective of Data Visualization is to communicate information visually to users. For this, data visualization uses statistical graphics. Numerical data may be encoded using dots, lines, or bars, to visually communicate a quantitative message.

Question 2.
List the general types of data visualization.
Answer:

• Charts
• Tables
• Graphs
• Maps
• Infographics
• Dashboards

Question 3.
List the types of Visualizations in Matplotlib.
Answer:
There are many types of Visualizations under Matplotlib. Some of them are:

1. Line plot
2. Scatter plot
3. Histogram
4. Box plot
5. Bar chart and
6. Pie chart

Question 4.
How will you install Matplotlib?
Answer:

• Pip is a management software for installing python packages.
• We can install matplotlib using pip.
• First of all, we need to identify whether pip is installed in your PC. If so, upgrade the pip in your system.
• To check if pip is already installed in our system, navigate our command line to the location of Python’s script directory.
• You can install the latest version of pip from our command prompt using the following command:
  Python -m pip install -U pip
• To install matplotlib, type the following in our command prompt:
  Python -m pip install -U matplotlib

Question 5.
Write the difference between the following functions: plt. plot([1,2,3,4]), plt. plot ([1,2,3,4], [14, 9,16]).
Answer:

III. Answer the following questions (3 marks)

Question 1.
Draw the output for the following data visualization plot.
import matplotlib.pyplot as plt
plt.bar([1,3,5,7,9],[5,2,7,8,2], label=”Example one”)
plt.bar([2,4,6,8,10],[8,6,2,5,6], label=:”Example two”, color=’g’)
plt.legend()
plt.xlabel(‘bar number’)
plt.ylabel(‘bar height’)
plt.title(‘Epic Graph\nAnother Line! Whoa’)
plt.show()
Output:

Question 2.
Write any three uses of data visualization.
Answer:

1. Data Visualization helps users to analyze and interpret the data easily.
2. It makes complex data understandable and usable.
3. Various Charts in Data Visualization helps to show the relationship in the data for one or more variables.

Question 3.
Write the coding for the following:
a) To check if PIP is Installed in your PC.
b) To Check the version of PIP installed in your PC.
c) To list the packages in matplotlib.
Answer:
a) To check if PIP is Installed in your PC.

1. In command prompt type pip – version.
2. If it is installed already, you will get version.
3. Command : Python – m pip install – U pip

b) To Check the version of PIP installed in your PC.
C:\ Users\ YourName\ AppData\ Local\ Programs\ Py thon\ Py thon36-32\ Scripts>
pip-version

c) To list the packages in matplotlib.
C:\ Users\ Y ou rName\ AppData\ Local\ Programs\ Py thon\ Py thon36-32\ Scripts>
pip list

Question 4.
Write the plot for the following pie chart output.
Coding:
import matplotlib. pyplot as pit
sizes = [54.2,8.3,8.3,29.2]
labels= [“playing”,”working”,”eating”,”sleeping”]
exp=(0,0,0.1,0)
pit.pie (sizes labels = labels,explode=exp,autopct=”%.If%%, shadow-True, counterclock=False,strartangle-90)
pit, axes (). set_aspect (“equal”)
pit. title (“Interesting Graph \nCheck it out”)
plt.show ()

IV. Answer the following questions (5 Marks)

Question 1.
Explain in detail the types of pyplots using Matplotlib.
Answer:
Matplotlib allows us to create different kinds of plots ranging from histograms and scatter plots to bar graphs and bar charts.

Line Chart:

• A Line Chart or Line Graph is a type of chart which displays information as a series of data points called ‘markers’ connected by straight line segments.
• A Line Chart is often used to visualize a trend in data over intervals of time – a time series – thus the line is often drawn chronologically.

Program for Line plot:
import matplotlib.pyplot as pit years = [2014, 2015, 2016, 2017, 2018] total_populations = [8939007, 8954518,, 8960387,8956741,8943721]
plt. plot (“years, total_populations)
plt. title (“Year vs Population in India”)
plt.xlabel (“Year”)
plt.ylabel (“Total Population”)
plt.showt

In this program,
Plt.titlet() →→7 specifies title to the graph
Plt.xlabelt) →→ specifies label for X-axis
Plt.ylabelO →→ specifies label for Y-axis
Output:

Bar Chart:

• A BarPlot (or Bar Chart) is one of. the most common type of plot. It shows the relationship between a numerical variable and a categorical variable.
• Bar chart represents categorical data with rectangular bars. Each bar has a height corresponds to the value it represents.
• The bars can be plotted vertically or horizontally.
• It is useful when we want to compare a given numeric value on different categories.
• To make a bar chart with Matplotlib, we can use the plt.bart) function.

Program:
import matplotlib.pyplot as pit
# Our data
labels = [“TAMIL”, “ENGLISH”, “MATHS”, “PHYSICS”, “CHEMISTRY”, “CS”]
usage = [79.8,67.3,77.8,68.4,70.2,88.5]
# Generating the y positions. Later, we’ll use them to replace them with labels. y_positions = range (len(labels))
# Creating our bar plot
plt.bar (y_positions, usage)
plt.xticks (y_positions, labels)
plt.ylabel (“RANGE”)
pit.title (“MARKS”)
plt.show()
Output:

Pie Chart:

• Pie Chart is probably one of the most common type of chart.
• It is a circular graphic which is divided into slices to illustrate numerical proportion.
• The point of a pie chart is to show the relationship of parts out of a whole.
• To make a Pie Chart with Matplotlib, we can use the plt.pie () function.
• The autopct parameter allows us to display the percentage value using the Python string formatting.

Program:
import matplotlib.pyplot as pit
sizes = [89, 80, 90,100, 75]
labels = [“Tamil”, “English”, “Maths”,
“Science”, “Social”]
plt.pie (sizes, labels = labels,
autopct = “%.2f”)
plt.axesfj.set aspect (“equal”)
plt.showt()
Output:

Question 2.
Explain the various buttons in a matplotlib window.
Answer:
Various buttons in a matplotlib window:

Home Button → The Home Button will help once you have begun navigating your chart. If you ever want to return back to the original view, you can click on this.
Forward/Back buttons → These buttons can be used like the Forward and Back buttons in your browser. You can click these to move back to the previous point you were at, or forward again.
Pan Axis → This cross-looking button allows you to click it, and then click and drag your graph around.
Zoom → The Zoom button lets you click on it, then click and drag a square that you would like to zoom into specifically. Zooming in will require a left click and drag. You can alternatively zoom out with a right click and drag.
Configure Subplots → This button allows you to configure various spacing options with your figure and plot.
Save Figure → This button will allow you to save your figure in various forms.

Question 3.
Explain the purpose of the following functions:
Answer:
a) plt.xlabel:
plt.xlabel Specifies label for X -axis
b) plt.ylabel:
plt.ylabel is used to specify label for y-axis
c) plt.title :
plt.title is used to specify title to the graph or assigns the plot title.
d) plt.legend():
plt.legend() is used to invoke the default legend with plt
e) plt.show():
plhshowQ is used to display the plot.

12th Computer Science Guide Data Visualization Using Pyplot: Line Chart, Pie Chart and Bar Chart Additional Questions and Answers

I. Choose the best answer (1 Mark)

Question 1.
………………. button is used to click and drag a graph around.
a) pan axis
b) home
c) zoom
d) drag
Answer:
a) pan axis

Question 2.
………………. charts display information as series of data points.
a) Bar
b) Pie
c) Line
d) Histogram
Answer:
c) Line

Question 3.
The representation of information in a graphic format is called …………………………
(a) chart
(b) graphics
(c) Infographics
(d) graphs
Answer:
c) Infographics

Question 4.
……………….refers to a graphical representation that displays data by way of bars to show the frequency of numerical data.
a) Bar chart
b) Line graph
c) Pie chart
d) Histogram
Answer:
d) Histogram

Question 5.
……………….represents the frequency distribution of continuous variables.
a) Bar chart
b) Line graph
c) Pie chart
d) Histogram
Answer:
d) Histogram

Question 6.
Find the Incorrect match from the following.
(a) Scatter plot – collection of points
(b) line charts – markers
(c) Box plot – Boxes
Answer:
(c) Box plot – Boxes

Question 7.
Which of the following plot we cannot rearrange the blocks from highest to lowest?
a) Line
b) Bar chart
c) Pie chart
d) Histogram
Answer:
d) Histogram

Question 8.
In ………………. graph, the width of the bars is always the same.
a) Line
b) Bar
c) Pie chart
d) Histogram
Answer:
b) Bar

Question 9.
The ………………. parameter allows us to display the percentage value using the Python string formatting in pie chart.
a) percent
b) autopct
c) pet
d) percentage
Answer:
b) autopct

Question 10.
Find the wrong statement.
If a single list is given to the plot( ) command, matplotlib assumes
(a) it is as a sequence of x values
(b) the sequence of y values
Answer:
(a) it is as a sequence of x values

Question 11.
………………. is the graphical representation of information and data.
a) Data visualization
b) Data Graphics
c) Data Dimension
d) Data Images
Answer:
a) Data visualization

Question 12.
………………. in data visualization helps to show the relationship in the data for more variables.
a) Tables
b) Graphics
c) Charts
d) Dashboards
Answer:
c) Charts

Question 13.
In a Scatter plot, the position of a point depends on its …………………………. value where each value is a position on either the horizontal or vertical dimension.
a) 2-Dimensional
b) 3-Dimensional
c) Single Dimensional
d) 4-Dimensional
Answer:
a) 2-Dimensional

Question 14.
……………………. plot shows the relationship between a numerical variable and a categorical variable.
(a) line
(b) Bar
(c) Scatter
(d) Box
Answer:
(b) Bar

Question 15.
…………………. is the representation of information in a graphic format.
a) Infographics
b) Graph
c) Symbol
d) Charts
Answer:
a) Infographics

Question 16.
…………………. is a collection of resources assembled to create a single unified visual display.
a) Infographics
b) Dashboard
c) Graph
d) Charts
Answer:
b) Dashboard

Question 17.
Matplotlib is a data visualization …………………. in Python.
a) control structure
b) dictionary
c) library
d) list
Answer:
c) library

Question 18.
Matplotlib allows us to create different kinds of …………………. ranging from histograms
a) Table
b) Charts
c) Maps
d) plots
Answer:
d) plots

Question 19.
Which function shows the percentage value in the pie chart?
(a) percent
(b) percentage
(c) slice
(d) auto pet
Answer:
(d) auto pet

Question 20.
…………………. command will take an arbitrary number of arguments.
a) show ()
b) plot ()
c) legend ()
d) title ()
Answer:
b) plot ()

Question 21.
The most popular data visualization library allows creating charts in few lines of code in python.
a) Molplotlib
b) Infographics
c) Data visualization
d) pip
Answer:
a) Molplotlib

II. Answer the following questions (2 and 3 Marks)

Question 1.
What is meant by Infographics?
Answer:
Infographics → An infographic (information graphic) is the representation of information in a graphic format.

Question 2.
Define Dashboard.
Answer:

• A dashboard is a collection of resources assembled to create a single unified visual display.
• Data visualizations and dashboards translate complex ideas and concepts into a simple visual format.
• Patterns and relationships that are undetectable in the text are detectable at a glance using the dashboard.

Question 3.
Write a note on matplotlib
Answer:

• Matplotlib is the most popular data visualization library in Python.
• It allows creating charts in few lines of code.

Question 4.
Write a note on the scatter plot.
Answer:

• A scatter plot is a type of plot that shows the data as a collection of points.
• The position of a point depends on its two dimensional value, where each value is a position on either the horizontal or vertical dimension.

Question 3.
What is Box Plot?
Answer:
Box plot: The box plot is a standardized way of displaying the distribution of data based on the five-number summary: minimum, first quartile, median, third quartile, and maximum.

III. Answer the following questions (5 Marks)

Question 1.
Write the key differences between Histogram and bar graph.
Answer:

Question 2.
Explain the purpose of
i) plt.plot()
ii) pt.bar()
iii) plt.sticks()
iv) plt.pie
Answer:
i) plt.plot():
plt.plot() is used to make a line chart or graph with matplotlib.

ii) plt.bar():
plt.bar() is used to make a bar chart with matplotlib.

iii) plt.xticks():

• plt.xticks() display the tick marks along the x-axis at the values represented.
• Then specify the label for each tick mark.
• It is used bar chart.

iv) plt.pie ():
plt.pie () is used to make a pie chart with matplotlib.

Question 3.
Draw the output for the following python code:
import matplotlib.pyplot as pit
a = [1,2,3]
b = [5,7,4]
x = [1,2,3]
y = [10,14,12]
plt.plot(a,b, label=/Lable 1′)
plt.plot(x,y, label=’Lable 2′)
plt.xlabel(‘X-Axis’)
plt.ylabel(‘Y-Axis’)
plt. legend ()
plt. show ()
Output:

Question 4.
Draw the chart for the given Python snippet.
import matplotlib.pyplot as plt
plt.plot([l,2,3,4], [1,4,9,16])
plt.show()
Output:

Hands-on Practice

Question 1.
Create a plot. Set the title, the x and y labels for both axes,
import matplotlib.pyplot as pit
x=[1,2,3]
Y=[5,7,4]
plt.plot(x,y)
plt.xlable(‘X-AXIS’)
plt.ylabel(‘Y -AXIS’)
plt.title(‘LINE GRAPH)
plt.show()

Question 2.
Plot a pie chart for your marks in the recent examination.
import matplotlib.pyplot as pit
s=[60,85,90,83,95] l=[‘LANG’,’ENG’,’MAT ‘,’SCI’,’SS’]
plt.pie(s,labels=l)
plt.title(‘MARKS’)
plt.show()

Question 3.
Plot a line chart on the academic performance of Class 12 students in Computer Science for the past 10 years.
import matplotlib.pyplot as pit
x=[2009,2010,2011,2012,2013,2014,2015,20 16,2017,2018]
y=[56,68,97,88,92,96,98,99,100,100]
plt.plot(x,y) plt.xlable(‘YEAR’)
plt.ylabel(‘PASS % IN C.S’)
plt. show ()

Question 4.
Plot a bar chart for the number of computer science periods in a week, import matplotlib.pyplot as pit x=[“MON”,”TUE”,”WED”, “THUR”,”FRI”]
y=[6,5,2,1,7] plt.bar(x,y) pit. xlable (‘ DAY S’) plt.ylabel(‘PERIOD’) plt.showQ

Tamilnadu State Board New Syllabus Samacheer Kalvi 12th Business Maths Guide Pdf Chapter 4 Differential Equations Ex 4.6 Text Book Back Questions and Answers, Notes.

Tamilnadu Samacheer Kalvi 12th Business Maths Solutions Chapter 4 Differential Equations Ex 4.6

Choose the most suitable answer from the given four alternatives:

Question 1.
The degree of the differential equation
\(\frac { d^2y }{dx^4}\) – (\(\frac { d^2y }{dx^2}\)) + \(\frac { dy }{dx}\) = 3
(a) 1
(b) 2
(c) 3
(d) 4
Solution:
(a) 1
Hint:
Since the power of \(\frac{d^{4} y}{d x^{4}}\) is 1

Question 2.
The order and degree of the differential equation \(\sqrt{\frac { d^2y }{dx^2}}\) = \(\sqrt{\frac { dy }{dx}+5}\) are respectively.
(a) 2 and 2
(b) 3 and 2
(c) 2 and 1
(d) 2 and 3
Solution:
(a) 1
Hint:
Squaring on both sides
\(\frac { d^2y }{dx^2}\) = \(\frac { dy }{dx}\) + 5
Highest order derivative is \(\frac { d^2y }{dx^2}\)
∴ order = 2
Power of the highest order derivative \(\frac { d^2y }{dx^2}\) = 1
∴ degree = 1

Question 3.
The order and degree of the differential equation
(\(\frac { d^2y }{dx^2}\))^3/2 – \(\sqrt{(\frac { dy }{dx})}\) – 4 = 0
(a) 2 and 6
(b) 3 and 6
(c) 1 and 4
(d) 2 and 4
Solution:
(a) 2 and 6
Hint:

Highest order derivative is \(\frac { d^2y }{dx^2}\)
∴ Order = 2
Power of the highest order derivative \(\frac { d^2y }{dx^2}\) is
∴ degree = 6

Question 4.
The differential equation (\(\frac { dx }{dy}\))³ + 2y^1/2 = x
(a) of order 2 and degree 1
(b) of order 1 and degree 3
(c) of order 1 and degree 6
(d) of order 1 and degree 2
Solution:
(b) of order 1 and degree 3
Hint:

Highest order derivative is \(\frac { dy }{dx}\)
∴ order = 1
Power of the highest order derivative \(\frac { dy }{dx}\) is 3
∴ degree = 3

Question 5.
The differential equation formed by eliminating a and b from y = ae^x + be^-x
(a) \(\frac { d^2y }{dx^2}\) – y = 0
(b) \(\frac { d^2y }{dx^2}\) – \(\frac { dy }{dx}\)y = 0
(c) \(\frac { d^2y }{dx^2}\) = 0
(d) \(\frac { d^2y }{dx^2}\) – x = 0
Solution:
(a) \(\frac { d^2y }{dx^2}\) – y = 0
Hint:

Question 6.
If y = ex + c – c³ then its differential equation is
(a) y = x\(\frac { dy }{dx}\) + \(\frac { dy }{dx}\) – (\(\frac { dy }{dx}\))³
(b) y + (\(\frac { dy }{dx}\))³ = x \(\frac { dy }{dx}\) – \(\frac { dy }{dx}\)
(c) \(\frac { dy }{dx}\) + (\(\frac { dy }{dx}\))³ – x\(\frac { dy }{dx}\)
(d) \(\frac { d^3y }{dx^3}\) = 0
Solution:
(a) y = x\(\frac { dy }{dx}\) + \(\frac { dy }{dx}\) – (\(\frac { dy }{dx}\))³
Hint:
y = cx + c – c³ ……… (1)
\(\frac { dy }{dx}\) = c
(1) ⇒ y = x\(\frac { dy }{dx}\) + \(\frac { dy }{dx}\) – (\(\frac { dy }{dx}\))³

Question 7.
The integrating factor of the differential equation \(\frac { dy }{dx}\) + Px = Q is
(a) e^∫pdx
(b) e^∫Pdx
(c) e^∫Pdy
(d) e^∫pdy
Solution:
(d) e^∫pdy

Question 8.
The complementary function of (D² + 4) y = e^2x is
(a) (Ax+B)e^2x
(b) (Ax+B)e^-2x
(c) A cos2x + B sin2x
(d) Ae^-2x + Be^2x
Solution:
(c) A cos2x + B sin2x
Hint:
A.E = m² + 4 = 0 ⇒ m = ±2i
C.F = e^0x (A cos 2x + B sin 2x)

Question 9.
The differential equation of y = mx + c is (m and c are arbitrary constants)
(a) \(\frac { d^2y }{dx^2}\) = 0
(b) y = x\(\frac { dy }{dx}\) + o
(c) xdy + ydx = 0
(c) ydx – xdy = 0
Solution:
(a) \(\frac { d^2y }{dx^2}\) = 0
Hint:
y = mx + c
\(\frac { dy }{dx}\) = m ⇒ \(\frac { d^2y }{dx^2}\) = 0

Question 10.
The particular intergral of the differential equation \(\frac { d^2y }{dx^2}\) – 8\(\frac { dy }{dx}\) + 16y = 2e^4x
(a) \(\frac { x^2e^{4x} }{2!}\)
(b) y = x\(\frac { e^{4x} }{2!}\)
(c) x²e^4x
(d) xe^4x
Solution:
(c) x²e^4x
Hint:

Question 11.
Solution of \(\frac { dx }{dy}\) + Px = 0
(a) x = ce^py
(b) x = ce^-py
(c) x = py + c
(d) x = cy
Solution:
(b) x = ce^-py

Question 12.
If sec^2x x isa na intergranting factor of the differential equation \(\frac { dx }{dy}\) + Px = Q then P =
(a) 2 tan x
(b) sec x
(c) cos 2 x
(d) tan 2 x
Solution:
(a) 2 tan x
Hint:
I.F = sec² x
e^∫pdx = sec²x
∫pdx = log sec² x
∫pdx = 2 log sec x
∫pdx = 2∫tan x dx ⇒ p = 2 tan x

Question 13.
The integrating factor of the differential equation is x \(\frac { dy }{dx}\) – y = x²
(a) \(\frac { -1 }{x}\)
(b) \(\frac { 1 }{x}\)
(c) log x
(c) x
Solution:
(b) \(\frac { 1 }{x}\)
Hint:

Question 14.
The solution of the differential equation where P and Q are the function of x is
(a) y = ∫Q e^∫pdx dx + c
(b) y = ∫Q e^-∫pdx dx + c
(c) ye^∫pdx = ∫Q e^∫pdx dx + c
(c) ye^∫pdx = ∫Q e^-∫pdx dx + c
Solution:
(c) ye^∫pdx = ∫Q e^∫pdx dx + c

Question 15.
The differential equation formed by eliminating A and B from y = e^-2x (A cos x + B sin x) is
(a) y₂ – 4y₁ + 5 = 0
(b) y₂ + 4y – 5 = 0
(c) y₂ – 4y₁ + 5 = 0
(d) y₂ + 4y₁ – 5 = 0
Solution:
(d) y₂ + 4y₁ – 5 = 0
Hint:
y = e^-2x (A cosx + B sinx)
y e^2x = A cosx + B sinx ………. (1)
y(e^2x) (2) + e^2x \(\frac { dy }{dx}\) = A(-sin x) + B cos x ………. (2)
Differentiating w.r.to x

Question 16.
The particular integral of the differential equation f (D) y = e^ax where f(D) = (D – a)²
(a) \(\frac { x^2 }{2}\) e^ax
(b) xe^ax
(c) \(\frac { x }{2}\) e^ax
(d) x² e^ax
Solution:
(a) \(\frac { x^2 }{2}\) e^ax

Question 17.
The differential equation of x² + y² = a²
(a) xdy + ydx = 0
(b) ydx – xdy = 0
(c) xdx – ydx = 0
(d) xdx + ydy = 0
Solution:
(d) xdx + ydy = 0
Hint:
x² + y² = a²
⇒ 2x + 2y \(\frac{d y}{d x}\) = 0
⇒ x dx + y dy = 0

Question 18.
The complementary function of \(\frac { d^y }{dx^2}\) – \(\frac { dy }{dx}\) = 0 is
(a) A + Be^x
(b) (A + B)e^x
(c) (Ax + B)e^x
(d) Ae^x + B
Solution:
(a) A + Be^x
Hint:
A.E is m² – m = 0
⇒ m(m – 1) = 0
⇒ m = 0, 1
CF is Ae^0x + Be^x = A + Be^x

Question 19.
The P.I of (3D² + D – 14) y = 13e^2x is
(a) \(\frac { 1 }{2}\) e^x
(b) xe^2x
(c) \(\frac { x^2 }{2}\) e^2x
(d) Ae^x + B
Solution:
(b) xe^2x
Hint:
(3D² + D – 14) y = 13e^2x

Question 20.
The general solution of the differential equation \(\frac { dy }{dx}\) = cos x is
(a) y = sinx + 1
(b) y = sinx – 2
(c) y = cosx + C, C is an arbitary constant
(d) y = sinx + C, C is an arbitary constant
Solution:
(d) y = sinx + C, C is an arbitary constant
Hint:
\(\frac { dy }{dx}\) = cos x
dy = cos x dx
∫dy = ∫cos x dx ⇒ y = sin x + c

Question 21.
A homogeneous differential equation of the form \(\frac { dy }{dx}\) = f(\(\frac { y }{x}\)) can be solved by making substitution.
(a) y = v x
(b) y = y x
(c) x = v y
(d) x = v
Solution:
(a) y = v x

Question 22.
A homogeneous differential equation of the form \(\frac { dy }{dx}\) = f(\(\frac { x }{y}\)) can be solved by making substitution.
(a) x = v y
(b) y = v x
(c) y = v
(d) x = v
Solution:
(a) y = v x

Question 23.
The variable separable form of \(\frac { dy }{dx}\) = \(\frac { y(x-y) }{x(x+y)}\) by taking y = v x and \(\frac { dy }{dx}\) = v + x \(\frac { dy }{dx}\)
(a) \(\frac { 2v^2 }{1+v}\) dv = \(\frac { dx }{x}\)
(b) \(\frac { 2v^2 }{1+v}\) dv = –\(\frac { dx }{x}\)
(c) \(\frac { 2v^2 }{1-v}\) dv = \(\frac { dx }{x}\)
(d) \(\frac { 1+v }{2v^2}\) dv = –\(\frac { dx }{x}\)
Solution:
(d) \(\frac { 1+v }{2v^2}\) dv = –\(\frac { dx }{x}\)
Hint:

Question 24.
Which of the following is the homogeneous differential equation?
(a) (3x – 5) dx = (4y – 1) dy
(b) xy dx – (x³ + y³) dy = 0
(c) y²dx + (x² – xy – y²) dy = 0
(d) (x² + y) dx (y² + x) dy
Solution:
(c) y²dx + (x² – xy – y²) dy = 0

Question 25.
The solution of the differential equation \(\frac { dy }{dx}\) = \(\frac { y }{x}\) + \(\frac { f(\frac { y }{x}) }{ f(\frac { y }{x}) }\) is
(a) f\(\frac { y }{x}\) = k x
(b) x f\(\frac { y }{x}\) = k
(c) f\(\frac { y }{x}\) = k y
(d) x f\(\frac { y }{x}\) = k
Solution:
(a) f\(\frac { y }{x}\) = k x

Subject Matter Experts at SamacheerKalvi.Guide have created Tamilnadu State Board Samacheer Kalvi 12th Computer Applications Answers Solutions Guide Pdf Free Download in English Medium and Tamil Medium are part of Samacheer Kalvi 12th Books Solutions.

Let us look at these TN Board Samacheer Kalvi 12th Std Computer Applications Guide Pdf of Text Book Back Questions and Answers, Notes, Chapter Wise Important Questions, Model Question Papers with Answers, Study Material, Question Bank and revise our understanding of the subject.

Students can also read Tamil Nadu 12th Computer Applications Model Question Papers 2020-2021 English & Tamil Medium.

Samacheer Kalvi 12th Computer Applications Book Solutions Answers Guide

Samacheer Kalvi 12th Computer Applications Book Back Answers

Tamilnadu State Board Samacheer Kalvi 12th Computer Applications Book Back Answers Solutions Guide.

• Chapter 1 Multimedia and Desktop Publishing
• Chapter 2 An Introduction to Adobe Pagemaker
• Chapter 3 Introduction to Database Management System
• Chapter 4 Introduction to Hypertext Pre-Processor
• Chapter 5 PHP Function and Array
• Chapter 6 PHP Conditional Statements
• Chapter 7 Looping Structure
• Chapter 8 Forms and Files
• Chapter 9 Connecting PHP and MYSQL
• Chapter 10 Introduction to Computer Networks
• Chapter 11 Network Examples and Protocols
• Chapter 12 DNS (Domain Name System)
• Chapter 13 Network Cabling
• Chapter 14 Open Source Concepts
• Chapter 15 E-Commerce
• Chapter 16 Electronic Payment Systems
• Chapter 17 E-Commerce Security Systems
• Chapter 18 Electronic Data Interchange – EDI

We hope these Tamilnadu State Board Class 12th Computer Applications Book Solutions Answers Guide Pdf Free Download in English Medium and Tamil Medium will help you get through your subjective questions in the exam.

Let us know if you have any concerns regarding TN State Board New Syllabus Samacheer Kalvi 12th Standard Computer Applications Guide Pdf Text Book Back Questions and Answers, Notes, Chapter Wise Important Questions, Model Question Papers with Answers, Study Material, Question Bank, Formulas, drop a comment below and we will get back to you as soon as possible.

Subject Matter Experts at SamacheerKalvi.Guide have created Tamilnadu State Board Samacheer Kalvi 12th Computer Science Book Answers Solutions Guide Pdf Free Download in English Medium and Tamil Medium are part of Samacheer Kalvi 12th Books Solutions.

Let us look at these TN State Board New Syllabus Samacheer Kalvi 12th Std Computer Science Guide Pdf of Text Book Back Questions and Answers, Notes, Chapter Wise Important Questions, Model Question Papers with Answers, Study Material, Question Bank and revise our understanding of the subject.

Students can also read Tamil Nadu 12th Computer Science Model Question Papers 2020-2021 English & Tamil Medium.

Samacheer Kalvi 12th Computer Science Book Solutions Answers Guide

Samacheer Kalvi 12th Computer Science Book Back Answers

Tamilnadu State Board Samacheer Kalvi 12th Computer Science Book Back Answers Solutions Guide.

Unit 1 Problem Solving Techniques

• Chapter 1 Function
• Chapter 2 Data Abstraction
• Chapter 3 Scoping
• Chapter 4 Algorithmic Strategies

Unit 2 Core Python

• Chapter 5 Python -Variables and Operators
• Chapter 6 Control Structures
• Chapter 7 Python Functions
• Chapter 8 Strings and String Manipulations

Unit 3 Modularity and OOPS

• Chapter 9 Lists, Tuples, Sets and Dictionary
• Chapter 10 Python Classes and Objects

Unit 4 Database Concepts and MySql

• Chapter 11 Database Concepts
• Chapter 12 Structured Query Language (SQL)
• Chapter 13 Python and CSV Files

Unit 5 Integrating Python with MySql and C++

• Chapter 14 Importing C++ Programs in Python
• Chapter 15 Data Manipulation Through SQL
• Chapter 16 Data Visualization Using Pyplot: Line Chart, Pie Chart and Bar Chart

We hope these Tamilnadu State Board Samacheer Kalvi Class 12th Computer Science Book Solutions Answers Guide Pdf Free Download in English Medium and Tamil Medium will help you get through your subjective questions in the exam.

Let us know if you have any concerns regarding TN State Board New Syllabus Samacheer Kalvi 12th Standard Computer Science Guide Pdf Text Book Back Questions and Answers, Notes, Chapter Wise Important Questions, Model Question Papers with Answers, Study Material, Question Bank, Formulas, drop a comment below and we will get back to you as soon as possible.