SAMPLE PAPER OF IP

SET-I

PART A

Section I

(Attempt any 15 questions out of Question No 1 to 21)

What do you understand by cache memory?

Make difference between RAM and ROM.

Give two examples of system software.

How many bytes are there in 1 TB.

What is the function of motherboard?

Define the term software.

Give the full form of ENIAC.

What will be the output of

x = 73

y = x%9

print(y)

Write the difference between compiler and interpreter.

Give two examples of Immutable data types.

Give one example of data type conversion in python.

Define the term debugging.

Enumerate various data types in python.

Identify the valid identifier out of following:

_xyz (ii) 3xz

Explain in brief the need of DBMS systems.

A table has 6 rows and 5 columns. What is the degree of table?

Define the term ‘Candidate Key’ in a database system.

Define Primary key ?

What is the full form of RDBMS?

What is cardinality?

Define Domain?

Section II

Read the code below carefully and answer any four questions out of the questions

Sum = 0

for i in range(1, 101):

if i % 20 == 0:

Sum = Sum + i

print(Sum)

(i) What will be the output of above code?

What will be the value of ‘i’ after completion of loop.
How many times the loop will get executed?
What is the ‘step’ in range() here?
What will be the output if i%20== 0 is replaced by i%10==0

You are to collect data of students of your class as follows:

Student Roll number 2 Name of the Student

3. DOB 4. Contact No

On the basis of above answer any four

Suggest suitable data types for the above fields in the table.
Write SQL command to create database STUDENT.
Write SQL command to use the created database.
Write SQL command to describe the table STU_DATA.
Write SQL query to insert one row in the table STU_DATA.

PART B

Section I

Name the software required to make a computer functional. Write down its two primary functions.

Rewrite the following code after removing syntax errors :

name = input(Enter Name : )

age = int(input("Enter Age: ")

if (age >=18)

Print(Name,"is eligible for driving licence")

else:

Print(name, "is not eligible for driving licence")

What will be the output of the following code snippet?

a=[1,2,3,4,5]

print(a[3:0:-1])

What will be the output of below Python code?

list1=[8,0,9,5]
print(list1[::-1])

What will be the output of following:

for i in range(1,11):

if (i%3==0):

break

else:

print(i, end=' ')

What will be the output of the following Python code?

a={1:"A",2:"B",3:"C"}

b={4:"D",5:"E"}

a.update(b)

print(a)

What is Like operator in sql? Give one example

Make difference between DDL and DML commands. Give one example of each.

What are integrity constraints? Give one example to explain.

What is the use of ‘distinct’ in MySQL. Explain with one example.

The data types of char(m) and varchar(n) are used ot create ______ and ____ types of string/text fields in database.

Define the term Database. Name any two database management software

Section II

Draw the block diagram of a computer system. Briefly write about the functionality of each component.

What are various categories of softwares?

Write a python code to print the factorial of the number entered by the user?

Write a python code to enter a number and print the reverse of the number?

Consider the following table Doctor as given below

Table : Doctor
DID	DName	Age	Department	Date_of_join	Salary	Gender
1	Rakesh	34	General	10/01/2017	120000	M
2	Parveen	31	Ortho	24/03/2008	200000	F
3	Satyajeet	32	ENT	12/12/2016	300000	M
4	Yogita	35	Heart	01/07/2015	400000	F
5	Chirag	42	General	05/09/2007	250000	M
6	Vijay	50	ENT	27/06/2008	300000	M
7	Kamlesh	44	Ortho	25/02/2017	210000	M
8	Seema	33	Heart	31/07/2018	200000	F

Write output of SQL queries fired on the table Doctor:

Select * from Doctor where salary > 120000 and salary < 250000;
Select DID, DName from Doctor where Department = ‘ENT’;
Select DName from Doctor where Age between 31 and 35

Given a table ‘Place’ as below:

Table : Place
PID	Department	City
1	General	Ajmer
2	Heart	Udaipur
3	Ortho	Jodhpur
4	ENT	NULL

Write SQL queries for the following:

Create the table ‘Place’ and set PID as primary key.
Aman is writing query select * from Place where City=NULL which is raising an error. Write the correct query for Aman.
What is the degree and cardinality of the above table?

Section III

Program to calculate the mean of given list of numbers

Program to search for an element in a given list of numbers

Write the SQL command for the following on the basis of given table.

TABLE NAME : GAME

StudentNo	Class	Name	Game1	Grade1	Game2	Grade2
10	7	Sammer	Cricket	B	Swimming	A
11	8	Sujit	Tennis	A	Skating	C
12	7	Kamal	Swimming	B	Football	B
13	7	Venna	Tennis	C	Tennis	A
14	9	Archana	Basketball	A	Cricket	A
15	10	Arpit	Cricket	A	Athletics	C

(1) Display the number of students having game ‘Cricket’.

(2) Display the names of students who have same game for both Game1 and Game2.

(3) Display the games taken by the students whose name starts with ‘A’.

(4) Display the names of students of 7th class participated in tennis as Game1.

(5) Display the names of the students who have grade ‘A’ in either Game1 or Game2 or both.

Answer the following questions:

What is cloud Computing. (1)
What is AI (Artificial Intelligence)? Explain it’s any two goals. (2)
Explain any two applications of IoT (Internet of Things). (2)

*End of Paper*

ANSWER KEY

MARKING SCHEME

PART A

Section I

1 mark for correct definition

1 Mark for correct difference

½ mark for each correct example

1 mark for correct answer

1 mark for correct definition

1 mark for correct full form

1 mark for correct answer

1 mark for correct difference

½ mark for each correct example

1 mark for correct example

1 mark for correct definition

1 mark for correct answer, ½ mark for partial answer

1 mark for correct identification

1 mark for correct answer

1 mark for correct definition

1 mark for correct full form

1 mark for correct answer

Section II

(i)	300 (1 mark for correct answer)
(ii)	101 (1 mark for correct answer)
(iii)	100 (1 mark for correct answer)
(iv)	1 (1 mark for correct answer)
(v)	550 (1 mark for correct answer)

(i)		integer, Varchar(SIZE), date, bigint
	(ii)	Create database STUDENT;
	(iii)	Use STUDENT;
	(iv)	Desc STU_DATA;
	(v)	Insert into STU_DATA values(101, ‘Ramesh’, ‘2004-09-14’, 1234567890)

PART B

Section I

1 mark for correct name of software (OS) and ½ mark for each correct function.

½ mark for each correction

Incorrect Code

Correct Code

name = input(Enter Name : )

age = int(input("Enter Age: ")

if (age >=18)

Print(Name,"is eligible for driving licence")

else:

Print(name, "is not eligible for driving licence")

name = input("Enter Name :" )

age = int(input("Enter Age: "))

if age >=18:

print(name,"is eligible for driving licence")

else:

print(name, "is not eligible for driving licence")

2 marks for complete output, 1 mark for partial

CODE

OUTPUT

a=[1,2,3,4,5]

print(a[3:0:-1])

[4,3,2]

list1=[8,0,9,5]
print(list1[::-1])

[5,9,0,8]

1 2

2 marks for correct output

{1: 'A', 2: 'B', 3: 'C', 4: 'D', 5: 'E'}

2 marks for correct output

1 mark for correct explaination and 1 mark for example.

1 mark for correct difference and ½ mark for each example.

1 mark for correct answer and 1 mark for explanation.

1 mark for correct use and 1 mark for explanation.

Fixed, variable 1 marks for each

1 marks for each

Section II

1 mark for diagram and 2 mark for description

1 marks for types 1 marks for each definition

1 mark for input and output list 2 marks for correct code

1 mark for each correct output of query

Create table Place ( PID integer primary key, Department varchar(20), City varchar(20));

select * from Place where City is NULL

(1 mark for each correct answer)

Section III

lst=eval(input(“Enter the list”))

length=len(lst)

mean=sum=0

for i in range(0,length):

sum+=lst[i]

mean=sum/length

print(mean)

(5 marks for correct program, partial marks may be given for partially correct program)

lst=eval(input(“Enter the list”))

length=len(lst)

x=int(input(“enter the element to search”))

for i in range(0,length):

if x==lst[i]:

print(“Element found at index”,i)

break;

(5 marks for correct program, partial marks may be given for partially correct program)

Write the SQL command for the following on the basis of given table.

TABLE NAME : GAME

StudentNo	Class	Name	Game1	Grade1	Game2	Grade2
10	7	Sammer	Cricket	B	Swimming	A
11	8	Sujit	Tennis	A	Skating	C
12	7	Kamal	Swimming	B	Football	B
13	7	Venna	Tennis	C	Tennis	A
14	9	Archana	Basketball	A	Cricket	A
15	10	Arpit	Cricket	A	Athletics	C

(1) Select count(*) from GAME where Game1 = ‘Cricket’ or Game2 = ‘Cricket’;

(2) Select Name from GAME where Game1 = Game2;

(3) Select Game1, Game2 from GAME where Name like “A%”;

(4) Select Name form GAME where Class = 7 and Game1 = ‘Tennis’;

(5) Select Name from GAME where Grade1 = ‘A’ or Grade2 = ‘A’;

1 mark for correct definition.
1 mark for definition and ½ mark for explanation of each goal.
1 mark for each application of IOT.

SET-II

PART-A

SECTION-I (Short Answer Questions)

Question No. 1-21 carries 1 mark each. Attempt any 15 questions from questions 1 to 21.

Which are valid and Invalid identifiers?

a)kv#038 b)@month12 c)_param4 d)const_num

Write the output of the print statement:

my_p=[‘w’,’e’,’L’,’c’,’o’,’m’,’e’]

print(my_p[2:4:2])

Name any one function of python list.

In SQL, which clause is used to prevent displaying the duplicate tuples of a relation?

Out of the following terms, which is the biggest unit of data transfer rate?

Mbps, Tbps, Kbps, Gbps, bps

Which of the following is not a DDL Command?

a)DROP b)ALTER c)INSERT d)CREATE

If the following code is executed what will be the output of it?

name=[”LiveYourLife”,[4,5],9]

print(name[1][1])

Identify the valid relational operators in Python from the following:-

a)+ b)// c)and d) >

Write a statement in Python to declare a Dictionary KZ whose keys are 11,21,31 and values are ANT,CAT,DOG respectively.

In SQL what is correct order of the following keywords in a SQL statement?

Where, Select, Order By

In SQL, write a query to access a Database.

Anurag has data plan of 2 GB/day in is mobile network. It is equivalent to say ______ KB/day.

Expand the terms MU and ALU in context of computer system organization.

Who developed Python programming language?

What is concatenation in context of list?

Rewrite the following Python code after removing errors(if any) and also underline each correction:-

z=input(Enter an integer)

for i in range(z)

print(i)

Identify each one of the following as hardware and software:-

a)Microsoft Edge b)Hard Disk c)Unix d) Motherboard

If d1={1:10,2:20,3:30} then find the output of – print(d1.keys())

How is Null values related with the concept of Primary key and Unique constraints. Explain.

A data item may have multi valued information in a field.(True/False)

Is operating system is an application software or system software? Justify your answer

SECTION-II

Both the case study based questions (22 & 23 ) are compulsory. Attempt any four sub parts from each question. Each sub question carries 1 mark.

Ramesh has created an empty dictionary using the command k={ }. Now he has written following codes without knowing its result. Help him to know and understand the output of the following statements(i.e Dictionary status/items) he has written:-

k={ }

k[1]=1
k[‘1’]=2
k[1]=k[1]+1
k[‘A’]=23-2
k.pop(‘1’)

1x4=4

A company is building an e commerce website. The website will display the details of the products that the company sells and allow customer to place orders.Following are the Database tables used by the company to store the details of Product, Customer and Order details.

Product(ProductNo, ProductPrice,Quantity)

Order(OrderNo, OrderDate, OrderAmount)

Customer(CustomerID, CustomerName,Address,ContactNo)

Identify the Primary key of the given tables.
Write the SQL statement to create the table order. Make sure to add required constraints like Primary key, Not Null constraints on the required columns.
Write DML command to display only the unique Orderdate column values of Order table.
Write the degree of each of the tables listed above.
Write SQL command to display all the records of the table Product having Quantity value as Null.

1x4=4

PART-B

SECTION-I (Short Answer Questions)

Question No. 24-33 carries 2 mark each.

While studying Databases, Meera is confused with the meaning of the terms Data Inconsistency. Help her to understand the terms through definition as well as example.

Write a program to find cube of a number. Accept the number from the user.

Write a program in Python to find simple interest using principal, rate and time. Accept all data from the user.

Observe the following table and answer the following Questions:-

Table:Transactions

TNo	Type	Amount	CNo
T1	Credit	1000	C3
T2	Debit	1500	C1

Identify the Primary Key and Candidate Key from the table Transactions.
Identify Alternate Key from the Table Transactions.

Write the output of the following program on execution if x=50

if x>10:

if x>25:

print(‘ok’)

if x>60:

print(‘good’)

elif x>40:

print(‘average’)

else:

print(‘no output’)

Differentiate between Primary Memory and Secondary Memory.(Any two).

Differentiate between compiler and Interpreter(Any two).

State one similarity and one difference between Primary Key and Unique constraints.

What will be the output of the following program code:-

a,b=10,50

if b%a==0:

print(b//4)

print(a/2)

else:

print(a**2)

print(b%3)

A SQL relation “Flight” has 14 rows and 7 columns. Mohan deletes 3 rows and added 2 more columns. What will be the new degree and cardinality of the relation Flight.

Write the following arithmetic expressions using operators in Python:

Mr. Mittal is using a table with following columns : Name, Class, Streamed, Stream_name

He needs to display names of students who have not been assigned any stream or have been assigned stream_name that ends with "computers”. He wrote the following command, which did not give the desired result.

SELECT Name, Class FROM Students WHERE Stream_name = NULL OR Stream_name= “%computers” ;

Help Mr. Mittal to run the query by removing the error and write correct query .

SECTION-II (Long Answer Questions)

Question No. 34-37 carries 3 mark each.

Write a Python program to print the series 1 3 5 7 9 11 up to a given limit.

Write a Python program to find the product of the numbers up to a given limit.

Study the following tables SALARY and answer the following questions:-

TABLE : DOCTOR

ID	NAME	DEPT	SEX	EXPERIENCE
101	John	ENT	M	12
104	Smith	ORTHOPEDIC	M	5
107	George	CARDIOLOGY	M	10
114	Lara	SKIN	F	3
109	K George	MEDICINE	F	9
105	Johnson	ORTHOPEDIC	M	10
117	Lucy	ENT	F	3
111	Bill	MEDICINE	F	12
130	Sony	ORTHOPEDIC	M	15

Give the cardinality and degree of the table Doctor.
Write SQL Query to display the details of all those Doctors whose name either starts with ‘J’ or starts with ‘S’.
Write SQL Query to display the details of all female doctors having experience more than 5 years.

“Cache memory plays an important role in effective CPU utilization” . Justify the statement. Also arrange the following kinds of memory in ascending order of their accessing speeds:-

Secondary memory, Cache memory, Main Memory(RAM)

Brief the main functions of Operating System.(explain any 3)

2+1

Write SQL Queries for the following:-

Create a table ACCESSORIES with following structure

ID	Varchar(3)	Primary key
AName	Varchar(15)	Not Null
Price	Integer(5)

Insert 2 records in it.

SECTION III (Very Long Answer Questions)

Question No. 38-40 carries 5 mark each.

Consider the following tables Stationary and Consumer :

Table: Stationary

St_ID	StationaryName	Company	Price
DP01	Dot Pen	ABC	10
PL02	Pencil	XYZ	6
ER05	Eraser	XYZ	7
PL01	Pencil	CAM	5
GP02	Gel Pen	ABC	15

Table: Consumer

Cust_ID	ConsumerName	Address	S_ID
01	Good Learner	Delhi	PL01
06	Write Well	Mumbai	GP02
12	Topper	Delhi	DP01
15	Write & Draw	Delhi	PL02
16	Motivation	Banglore	PL01

Write SQL commands for the statement (i) to (iv).

(i) To create table Consumer having Cust_ID as Primary key, S_ID as Not Null constraints.

(ii) Insert first two records in the table Consumer.

iii) To display the details of those consumers whose Address is Delhi.

To display the details of Stationary whose Price is in the range of 8 to 15. (Both Values included).

Write output for SQL queries (v) to (viii):

v) SELECT DISTINCT Address FROM Consumer;

vi) Select StationaryName, Price*3 as “Three Times Price” From Stationary;

Write a Python program to find the Area and Perimeter of a rectangle based on the user choice.(If user enters 1 , area is displayed and if user enters 2 then perimeter is displayed).

Attempt anyone from A or B

Answer these questions(i to v):-

……………………. technology is able to take an existing environment and adds a layer of virtual information on top of it.
The “block” in block chain technology refers to …………………………………… stored in a data structure referred as “chain” which is called ……………………………………… .
State True/False

Natural Language processing(NLP) is a trait of deep learning(True/False).

Choose the Best option:-

A type of virtual environment in which subjects are visually isolated from the real environment.

Immersive b)Augmented c)Non Immersive d) Virtual Reality

Which one of these is not an area of Artificial intelligence(AI)?

Image recognition b)Voice Recognition c)Web designing d) Robotics

B. Answer these questions( i to iii):-

How does Natural Language Processing(NLP) helps differently abled persons?
Drone-a utility of Robotics can be helpful in the event of a natural calamity. How?
State the characteristics which distinguishes traditional data from Big data

*******************End of Question Paper*******************

ANSWER kEY

PART-A

SECTION-I (Short Answer Questions)

Question No. 1-21 carries 1 mark each. Attempt any 15 questions from questions 1 to 21.

Which are valid and Invalid identifiers?

a)kv#038 b)@month12 c)_param4 d)const_num

Ans:- c)_param4 d)const_num are valid identifiers.(1/2 mark for each correct answer)

Write the output of the print statement:

my_p=[‘w’,’e’,’L’,’c’,’o’,’m’,’e’]

print(my_p[2:4:2])

Ans:- ['L'] (1 mark for correct answer. No Marks for wrong/partial correct answer.)

Name any one function of python list.

Ans:-(Any one function of list)

append() or extend() or any function

In SQL, which clause is used to prevent displaying the duplicate tuples of a relation?

Ans:- DISTINCT. (1 mark for correct answer.)

Out of the following terms, which is the biggest unit of data transfer rate?

Mbps, Tbps, Kbps, Gbps, bps

Ans:- Tbps (1 mark for correct answer.)

Which of the following is not a DDL Command?

a)DROP b)ALTER c)INSERT d)CREATE

Ans:-INSERT (1 mark for correct answer.)

If the following code is executed what will be the output of it?

name=[”LiveYourLife”,[4,5],9]

print(name[1][1])

Ans:- 5 (1 mark for correct answer.)

Identify the valid relational operators in Python from the following:-

a)+ b)// c)and d) >

Ans:- > (1 mark for correct answer.)

Write a statement in Python to declare a Dictionary KZ whose keys are 11,21,31 and values are ANT,CAT,DOG respectively.

Ans:- KZ={11:’ANT’,21:’CAT’,31:’DOG’} (1 mark for correct answer.)

In SQL what is correct order of the following keywords in a SQL statement?

Where, Select, Order by

Ans:-Select, where,Order by (1 mark for correct answer.)

In SQL, write a query to access a Database.

Ans:-use <database> (1 mark for correct answer.)

Anurag has data plan of 2 GB/day in is mobile network. It is equivalent to say ______ KB/day.

Ans:- 2x1024x1024 KB/Day or 2x220 KB/day. (1 mark for correct answer.)

Expand the terms MU and ALU in context of computer system organization.

Ans:-Memory Unit, Arithematic and Logical Unit (1 mark for correct answer.1/2 for partial)

Who developed Python programming language?

Ans:- Guido Van Rossum (1 mark for correct answer.)

What is concatenation in context of list?

Ans:- (1 mark for correct answer.1/2 for partial)

Rewrite the following Python code after removing errors(if any) and also underline each correction:-

z=input(Enter an integer)

for i in range(z)

print(i)

z= int(input(Enter an integer))

for i in range(z):

print(i)

(1/2 mark for each correct error).

Identify each one of the following as hardware and software:-

a)Microsoft Edge b)Hard Disk c)Unix d) Motherboard

Ans:- Hardware:- HardDisk, Motherboard

Software:-Microsoft Edge,Unix. (1 mark for correct answer.1/2 for partial)

If d1={1:10,2:20,3:30} then find the output of – print(d1.keys())

Ans dict_keys([1, 2, 3])

How is Null values related with the concept of Primary key and Unique constraints.Explain.

Ans:-In Primary key Null values are not allowed whereas it is allowed in Unique constraints.

(1 mark for correct answer)

A data item in a Database table may have multi valued information in a field.(True/False)

Ans:- False (1 mark for correct answer)

Is operating system is an application software or system software? Justify your answer.

Ans:-Operating System is a system software as it is necessary for user’s interaction with the hardware and it controls and runs all the activities of computer system.Also because of it we are able to use application softwares. (1 mark for correct answer.1/2 mark for partial)

SECTION-II

Both the case study based questions (22 & 23 ) are compulsory. Attempt any four sub parts from each question. Each sub question carries 1 mark.

k={ }

k[1]=1
k[‘1’]=2
k[1]=k[1]+1
k[‘A’]=23-2
k.pop(‘1’)

{1: 1}
{1: 1, '1': 2}
{1: 2, '1': 2}
{1: 2, '1': 2, 'A': 21}
{1: 2, 'A': 21}

(1 mark each for correct answer only.Maximum marks is 4 )

1x4=4

Product(ProductNo, ProductPrice,Quantity)

Order(OrderNo, OrderDate, OrderAmount)

Customer(CustomerID, CustomerName,Address,ContactNo)

Identify the Primary key of the given tables.
Write the SQL statement to create the table order. Make sure to add required constraints like Primary key, Not Null constraints on the required columns.
Write DML command to display only the unique Orderdate column values of Order table.
Write the degree of each of the tables listed above.
Write SQL command to display all the records of the table Product having Quantity value as Null.

(1 mark each for correct answer.1/2 mark for partial correct answer.Maximum marks is 4 ).

1x4=4

PART-B

SECTION-I (Short Answer Questions)

Question No. 24-33 carries 2 mark each.

While studying Databases, Meera is confused with the meaning of the terms Data Inconsistency. Help her to understand the terms through definition as well as example.

Ans:- ( 1 mark for definition of data redundancy and 1 mark for example.)

Write a program to find cube of a number. Accept the number from the user.

Write a program in Python to find simple interest using principal, rate and time. Accept all data from the user.

(Full marks for correct program. Partial marks for Partial correct answers)

Observe the following table and answer the following Questions:-

Table:Transactions

TNo	Type	Amount	CNo
T1	Credit	1000	C3
T2	Debit	1500	C1

Identify the Primary Key and Candidate Key from the table Transactions.
Identify Alternate Key from the Table Transactions.

Ans:- Primary Key:-TNo (or CNo ) Candidate Key:-TNo,CNo,Type,Amount

Alternate Key(CNo/TNo,Type,Amount).

( 2 marks for all correct. 1 mark for partial correct answer)

Write the output of the following program on execution if x=50

if x>10:

if x>25:

print(‘ok’)

if x>60:

print(‘good’)

elif x>40:

print(‘average’)

else:

print(‘no output’)

Ans

average

( 2 marks for all correct. 1 mark for partial correct answer)

Differentiate between Primary Memory and Secondary Memory(Any two).

Differentiate between compiler and Interpreter(Any two). (1 maks for each point).

State one similarity and one difference between Primary Key and Unique constraints.

Similarity:- Both can identify the records uniquely.

Difference:- Primary Key cannot accept Null values whereas Unique can accept it.

(1 mark for each similarity and difference).

What will be the output of the following program code:-

a,b=10,50

if b%a==0:

print(b//4)

print(a/2)

else:

print(a**2)

print(b%3)

Ans:-

5.0

(1 Mark for each correct line of output)

A SQL relation “Flight” has 14 rows and 7 columns. Mohan deletes 3 rows and added 2 more columns. What will be the new degree and cardinality of the relation Flight.

Ans:-Degree:- 9, Cardinality:-11 (1 Mark each for correct Degree or cardinality).

Write the following arithmetic expressions using operators in Python:

Ans:- a) (a+b)/2*a b)x=pow(a,3)+pow(b,3)+pow(c,3)

c)math.pi*r*pow((r+h),2) d)z= [-b + sqrt(b*b-4*a*c)]/2*a

(1/2 mark for each correct part).

Mr. Mittal is using a table with following columns : Name, Class, Streamed, Stream_name .He needs to display names of students who have not been assigned any stream or have been assigned stream_name that ends with "computers”. He wrote the following command, which did not give the desired result.

SELECT Name, Class FROM Students WHERE Stream_name = NULL OR Stream_name= “%computers” ;

Help Mr. Mittal to run the query by removing the error and write correct query .

Ans:- SELECT Name, Class FROM Students WHERE Stream_name IS NULL OR Stream_name = “%computers” ; (1 mark for each correct Keyword- IS, LIKE).

SECTION-II (Long Answer Questions)

Question No. 34-37 carries 3 mark each.

Write a Python program to print the series 1 3 5 7 9 11 up to a given limit.

Write a Python program to find the product of the numbers up to a given limit.

(Full marks for correct answer. Partial marks may be awarded for partial correct answers. Deduct 1 mark if limit is not accepted from the user.)

Study the following tables SALARY and answer the following questions:-

TABLE : DOCTOR

ID	NAME	DEPT	SEX	EXPERIENCE
101	John	ENT	M	12
104	Smith	ORTHOPEDIC	M	5
107	George	CARDIOLOGY	M	10
114	Lara	SKIN	F	3
109	K George	MEDICINE	F	9
105	Johnson	ORTHOPEDIC	M	10
117	Lucy	ENT	F	3
111	Bill	MEDICINE	F	12
130	Sony	ORTHOPEDIC	M	15

Give the cardinality and degree of the table Doctor.
Write SQL Query to display the details of all those Doctors whose name either starts with ‘J’ or starts with ‘S’.
Write SQL Query to display the details of all female doctors having experience more than 5 years.

Ans:- i) cardinality:-9 Degree 5

ii)Select * from Doctors where Name like ‘J%’ or Name like ‘S%’

iii) Select * from Doctors where sex=’F’and experience>5;

( 1 mark for each correct Query. ½ mark for correct where condition only).

“Cache memory plays an important role in effective CPU utilization” . Justify the statement. Also arrange the following kinds of memory in ascending order of their accessing speeds:-

Secondary memory, Cache memory, Main Memory(RAM)

(2+1 mark for correct explanation and answer of each part of the question.)

Write SQL Queries for the following:-

Create a table ACCESSORIES with following structure

ID	Varchar(3)	Primary key
AName	Varchar(15)	Not Null
Price	Integer(5)

Insert 2 records in it.

( 1 mark to be deducted if constraints are not applied in Create Query. ½ mark to be deducted ifonly one record is inserted )

SECTION III (Very Long Answer Questions)

Question No. 38-40 carries 5 mark each.

Consider the following tables Stationary and Consumer :

Table: Stationary

St_ID	StationaryName	Company	Price
DP01	Dot Pen	ABC	10
PL02	Pencil	XYZ	6
ER05	Eraser	XYZ	7
PL01	Pencil	CAM	5
GP02	Gel Pen	ABC	15

Table: Consumer

Cust_ID	ConsumerName	Address	S_ID
01	Good Learner	Delhi	PL01
06	Write Well	Mumbai	GP02
12	Topper	Delhi	DP01
15	Write & Draw	Delhi	PL02
16	Motivation	Banglore	PL01

Write SQL commands for the statement (i) to (iii).

(i) To create table Consumer having Cust_ID as Primary key, S_ID as Not Null constraints.

(ii) Insert first two records in the table Consumer.

iii) To display the details of those consumers whose Address is Delhi.

To display the details of Stationary whose Price is in the range of 8 to 15. (Both Values included).

Write output for SQL queries (v) to (viii):

SELECT DISTINCT Address FROM Consumer;
Select StationaryName, Price*3 as “Three Times Price” From Stationary;

Ans:-

Create table Customer (Cust_ID int(2) Primary Key, ConsumerName varchar(15), Address varchar(15), S_ID varchar(4) not null);
Insert into Consumer values(01,’Good Learner’, ‘Delhi’, ‘PL01’)….and similar for 2nd rec.
Select * from consumers where Address=”Delhi”;
Select * from stationary where price between 8 and 15;

v)	Distinct(Address)	vi)	StationaryName	Three Times Price
	Delhi		Dot Pen	30
	Mumbai		Pencil	18
	Banglore		Eraser	21
			Pencil	15
			Gel Pen	45

(For Query 1 mark for correct answer and ½ mark for partial correct Query)

(For Output, ½ mark for correct output. No marks for wrong output)

Write a Python program to find the Area and Perimeter of a rectangle based on the user choice.(If user enters 1 , area is displayed and if user enters 2 then perimeter is displayed).

(Full marks for correct solution. Logic may vary.Partial marks for partial correct answers)

Attempt anyone from A or B

Answer these questions(i to v):-

……………………. technology is able to take an existing environment and adds a layer of virtual information on top of it.
The “block” in block chain technology refers to …………………………………… stored in a data structure referred as “chain” which is called ……………………………………… .

State True/False

Natural Language processing(NLP) is a trait of deep learning(True/False).

Choose the Best option:-

A type of virtual environment in which subjects are visually isolated from the real environment.

Immersive b)Augmented c)Non Immersive d) Virtual Reality

Which one of these is not an area of Artificial intelligence(AI)?

Image recognition b)Voice Recognition c)Web designing d) Robotics

B. Answer these questions( i to iii):-

How does Natural Language Processing(NLP) helps differently abled persons?
Drone-a utility of Robotics can be helpful in the event of a natural calamity. How?

iii)State the characteristics which distinguishes traditional data from Big data.

Ans:- Part A

Augmented Reality
Digital Information, Public Database
True
Immersive
Web Designing

Ans:-PART-B

It may improve the reading and writing tasks of the visually handicapped. NLP helps machines to understand what people write or say, Using techniques like audio to text conversion, it gives computers the power to understand human speech. It also allows us to implement voice control over different systems.
Yes, they can locate survivors, help relief workers to understand the condition without physically reaching there, delivers supplies and equipment’s and may also evacuate survivors.
These characteristics are called 5 V’s namely Volume,Velocity,Variety, Veracity, Value.

SET-III

Question No.
Part A
Marks

Section-I
Select the most appropriate option out of the options given for each question. Attempt any 15 questions from question no 1 to 21.

1
One Megabyte is equivalent to __________bytes.
1
2
Combination of 4 bit is known as ________
1
3
Which of the following memory types cannot store data permanently?
(a) RAM             (b)  ROM      (c) CD    (d)  Hard disk
1
4
Full form of PDF is______
1
5
Compiler is a Translator, True or False. 
1
6
Which of the following language computer can understand?
(a) High level     (b) Low level    (c)  Middle level
1
7
Name any two Application software.
1
8
Which one is correct Identifier?
(a)  Data@2    (b) Hi there      (c)  _Myfile     (d) var-123
1
9
The keys of dictionary must be of____________types.
(a) Mutable       (b)    Immutable
1
10
Special meaning words of Python ,fixed for specific functionality are called_______
1
11
In Python, the comments begin with _______ character.
(a) &    (b)   #     (c)  @   (d) %
1
12
To give a different separator with print( ) which argument is used?
(a) end   (b) tab   (c) sep   (d)  \n
1
13
If L= [1,2] then L*2 will yield
(a) [1,2]*2     (b)  [1,2,2]   (c) [1,1,2,2]    (d) [1,2,1,2]
1
14
What will be the output produced by these
(i)  14%4      (ii)  100//25 
1
15
The row of a relation in relational database is called
(a) tuple    (b) Instance   (c) schema   (d)  Domain
1
16
What is data redundancy?
1
17
Which one of these is DML command?
(a) create    (b)   insert   (c)  Alter    (d) Revoke
1
18
Write full form of
(i) SQL     (ii)  DDL
1
19
What do you mean by cardinality of a relation?
1
20
What is alternate key.
1
21
Write SQL command to display the table structure.
1

Section – II
 There are two case studies questions. Each case study has 5 case-based subparts. An 		     examinee is to attempt any 4 out of the 5 subparts.

22
 Write output for any four out of (i) to (v)
If L = [1,2,3,4,5,6,7,[8,9],10]  
L[2:7:2]
len(L)
L.append(10)
L[:2:-1]
L[1:9:3]
4
23
Write answers for any four questions out of these five subparts based on this Trainer table.

(i) What is degree of Trainer table?
(ii) What is Cardinality of Trainer table?
(iii) Which Attribute can be Primary key for Trainer table?
(iv) What is the data type for HIREDATE column?
(v) which command will be use to add a new record in the table Trainer
4

PART-B


SECTION I

24
Draw block diagram of computer system.briefly write about the functionality of each component.
2
25
Can you guess the output?
c= -11%4
d=-11/4
print(c,d)
2
26
Write two advantage and two disadvantage of Python programming language.
                                                   Or
What do you mean by Identifiers and what are the rules for valid Identifiers?
2
27
Rewrite the following code in python after removing all syntax error(s). Underline each correction done in the code.
30=To
for K in range(0,To) 
    IF k%4==0:
       print (K*4)
   Else:
      print (K+3)
2
28
What is primary key? Explain with example.
2
29
What is DBMS? Give two names of DBMS software.
2
30
Differentiate  between char and varchar with a suitable example in MYSql
2
31
What will be the output of following program?

aList=[1,2,3,5,6,1,5,6,1]
fDict={}
for i in aList:
   fDict[i]=aList.count(i)
print(fDict)
2
32
Ramesh created a table with 4 rows and 5 columns and then suresh add two more rows  and three columns in that table so what will be the degree and cardinality of updated table.
2
33
What is file based system? Give its disadvantage.
or
Differentiate between DDL and DML with suitable example.
2


SECTION II


34
Explain the following.
Hard Disk
Cache Memory
Operating System
Or
Name  input/output devices used to do the following
i) to enter audio based command
ii)to assist a visually impaired individual in entering data
iii) to build 3D models
3
35
Write a program to find the factorial of a number.
Or
Write a Program to find a number is Palindrome or not.
3
36
consider the following table name club  and find the output i) to iii)

i) Select * from club where age>=40
ii)Select  coach_id,coachname,sports  from club where name like ‘Z%’
iii)select Coachname,age from club where Pay in (10000 ,22000)
3
37
Define the following terms with respect to RDBMS
i)Relation      ii)Candidate Key           iii)Domain
3

SECTION III

38
(i) Write a program to find out a Year is Leap year or not.
(ii) WAP to find the sum of first n odd number where value of n is entered by user.
Or
Write a program to create a dictionary with the roll number, name and marks of n students in a class and display the names of students who have marks above 75.
2
3


5
39
(i) What is Artificial Intelligence? How has it impacted our lives?
(ii) What is Natural Language Processing? Name some applications of it.
(iii) What is Big Data?
2
2
1
40

Write answers for (i) to (v) on the basis of Faculty table.

(i) Write SQL command to create above tables structure.
(ii) Which column can be the primary key for faculty table.
(iii) What is Degree and Cardinality of above table.
(iv) Write SQL command to display the details of Faculty who has salary more than 10000.
(v) Write SQL command to display the details of Faculty with descending order of their Lname.
5

**************************************END OF PAPER***************

(Full marks for correct explanation. Half marks for partial correct answer).

*******************End of Marking Scheme*******************

ANSWER KEY

Question No.	Part A	Marks
1	(2)^20 or 1048576 bytes 1 marks for correct answer
2	Nibble 1 marks for correct answer
3	(a) RAM 1 marks for correct answer
4	Portable Document Format 1 marks for correct answer
5	1 mark for correct answer.
6	Low level (1 marks for correct answer)
7	Any two software name 1/2 marks for each correct answer
8	_Myfile 1 marks for correct answer
9	Immutable 1 marks for correct answer.
10	Keywords 1 marks for correct answer.
11	(b) # 1 marks for correct answer.
12	(c) sep 1 marks for correct answer
13	[1,2,1,2] 1 marks for correct answer
14	(i) 2 (ii) 4 ½ marks for each correct answer
15	(a) tuple 1 marks for correct answer
16	1 marks for correct answer.
17	(b) insert 1 marks for correct answer.
18	½ marks for each correct answer
19	1 marks for correct answer
20	1 marks for correct answer.
21	Describe table; 1 marks for correct answer
22	[3,5,7] 9 [1, 2, 3, 4, 5, 6, 7, [8, 9], 10, 10] [10, 10, [8, 9], 7, 6, 5, 4] [2, 5, [8, 9]] 1 marks for each correct answer
23	5 6 TID DATE insert 1 marks for each correct answer
24	1 Mark for diagram and 1 mark for explanation.
25	c=1 d=-2 (2 marks for correct Answer.)
26	2 marks for correct answer.
27	To=30 for K in range(0,To): if K%4==0: print(K*4) else: print(K+3) 2 marks for correct error detection
28	1 marks for defining primary key and 1 mark for example.
29	1 marks for defining DBMS and 1 mark for example.
30	1 marks for difference 1 for example
31	{1:3,2:1,3:1,5:2,6:2} 2 marks for correct output.
32	Degree 8 and cardinality 6 1 mark for degree and 1 marks for cardinality
33	1 mark for file system 1 for its disadvantages or 1 marks for 1 correct difference 1 marks for example.
34	1 mark for each correct answer answer.
35	(2 Marks for Logic 1 mark for correct syntax of programming)
36	(i) (ii) 5 ZUBIN SWIMMING 8 ZAREEN KARATE (iii) KUKREJA 35 ANKITA 39 1 mark for each correct output
37	1 marks for each correct definition.
38	1 mark for logic and 1 mark for correct syntax. 2 mark for logic and 1 mark for correct syntax. Or 3 Marks for correct logic and syntax and 2 marks for displaying students.
39	(i) 2 marks correct explaination. (ii) 1 mark for definition and 1 mark for application. (iii) 1 mark for correct answer
40	(i) create table faculty(FID int, Fname varchar(10), Lname varchar(10),Hire_date date, salary int); (ii) F_ID (iii) Degree=5 Cardinality =5 (iv) select * from faculty where salary>10000; (v) select * from faculty order by Lname desc; 1 mark for each correct answer.

SET-IV

Part A

Section I

Attempt any 15 questions from questions 1 to 21

Which of the following are software:

Capacitor, Internet Explorer, Hard Disk, Unix

Which of the following Operating system is used in the Mobile Phones.

Unix, Windows, Android, Linux

Arrange the following in ascending order of memory capacity:

TB, Byte, KB, MB, GB

What is the difference between RAM and ROM?

Name any two utility software

What is the difference between interactive and script mode of python?

Identify the data types of the following values:

“215”
[8, 200, 47, 6]

Write following arithmetic expression using operators in python:

x = a3 (b2 + c2 )

Write a Python command to delete an item “Address” from the given dictionary ‘student’ ?

>>>student = {“Name”:”Surbhi”, “Roll No”:”11”, “Address”: “Sec-7 New Delhi”}

Identify invalid variable names from the following:

If, s.i , tot_strength , 9tag

State the use of Primary key in relational database.

Write the command to open an existing database STUDENT.

Out of rollno, name and marks, which column will you choose as primary key and why?

What is the difference between char and varchar data type?

What is the full form of DDL in MySQL?

The physical components of a computer are called______(software/hardware)

The ________ is responsible for carrying out arithmatic and logical operations

What is difference between / and // operators in python

Write the output of the following statement in python

A=23%4

print(“A=”,A)

A relation can contain more than one primary key(True/False)

1 nibble is equal to ____bits.

SECTION-II

Both the case study based questions (22 & 23 ) are compulsory. Attempt any four sub parts from each question. Each sub question carries 1 mark.

Consider the following list List1=[2,3,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19]

Write commands for any 4 out of 5 :

i. Insert 4 at third position

ii. Sort the elements of the list in ascending order.

iii. Delete all elements from 3rd to 9th position

iv. Search the position of 13 in the list

v. Find the maximum value of the list

Write SQL commands for any 6 out of 7 from the table OnlineClass

Meeting_Id	Application	Host_Name	Topic	Hours	Attendance
101	Meet	Tanish	Python	2	40
102	Webex	Ravi	MySQL	2	35
103	Zoom	Laxmi	Database	1	33
104	Zoom	Vinod	New Trends	1	25
105	Meet	Suman	Fundametals	2	41

(i) To display the details of classes having attendance more than 20 but less than 40.

(ii) To display Meeting_Id of all those classes who are using Zoom application.

(iii) To display Host_Name and Hours in decreasing order of attendance.

(iv) To display Meeting_Id, Host_Name and Application of those classes whose Topic is MySQL.

(v) To insert a row with the following data:

(106,”Webex”,”Alex”,”Lists and Dictioanries”,2,30)

PART-B

SECTION-I (Short Answer Questions)

Question No. 24-33 carries 2 mark each.

What is the difference between System Software and Application Software?

What is the difference between tuples and lists in Python? Give Example

What will be the output produced by the following code fragment-

w, x, y, z = 21, 2, 3, 21

print(w/4)

print(w//4)

print(x**y)

print(z%y)

Suppose Dic1={1:’south’,2:’point’,3:’school’}

Write the output of the following code:

i. print(Dic1.keys())

ii. print( len(Dic1))

What will be the output produced by the following code fragments-

(i) for k in range(13,3,-2):

print(k* 2)

(ii) m=2

n=0

while m<10:

n=n+m

m=m+2

print(n)

Rewrite the following program using while loop:

for i in range(1,10,2):

print(i)

Write python statement to create a dictionary named “Items” with the following data:

Ravi	89
Suman	95
Anil	70

Find the output of the queries based on the following relation STUDENT:

Roll	Name	Marks	Grade
1	Namit Sadhu	85	A+
2	Ritesh Sen	46	B+
3	Bibha Roy	73	A
4	Sumit Arora	65	B+
5	Soumya Singh	92	A+

SELECT NAME, GRADE FROM STUDENT WHERE MARKS BETWEEN 40 AND 75;

(ii) SELECT * FROM STUDENT WHERE GRADE = ‘A+’;

Write SQL command to create the Customer table:

Field	Type	Size	Key	Description
Custid	Int	4	Primary key	Customer Id
Custname	varchar	25		Name of Customer
Balance	Decimal	5,2		Balance Amount
Creditlimit	Int	8		Credit Limit

What is difference between DDL and DML commands? Give 1 example of each.

What are the various wild card characters used in SQL select queries for pattern matching? Give any one example.

Explain different feature of RDBMS.

SECTION-II (Long Answer Questions)

Question No. 34-37 carries 3 mark each.

(i) Convert 2 MB into bytes.

(ii) Write 2 functions of Operating System.

(iii) What is the difference between CU and ALU.

Write a python program to find greatest of 3 numbers entered by user.

Write a python program to accept a number and print its multiplication table

(i) Ms. Riya wants to display details of all those employees whose salary is in the range 30000 to 50000 from employee table. Write appropriate SQL query for it,

(ii) What is a candidate key? Give a suitable example.

(iii) What do you mean by domain in relational database?

(i) A table “Students” has 3 columns and 4 rows in it. What is its degree ? What is its cardinality? What will be its cardinality if 5 rows are added in the table?

(ii) Write any two advantages of database system.

Study the table ‘flight’ given below and answer the questions.

FL_No	Airlines	S_point	E_point	Fare
IC301	Indian Airlines	Mumbai	Delhi	6500
IC799	Sahara	Bengaluru	Kochi	9400
MC101	Jet Airways	Delhi	Kolkata	6500

(i) Name the key which can be act as Primary key in the above table.

(ii) What is the degree and cardinality of the above table?

(iii) What datatype will be used for FL_No?

SECTION III (Very Long Answer Questions)

Question No. 38-40 carries 5 mark each.

(i) Write a program to find the factorial of a number.

Write a program to enter 2 numbers and find the sum of all numbers in the range of 2 numbers. Eg. If 2 numbers entered are 3 and 7 then the sum should be 25 (3+4+5+6+7)

(ii) Write a program to accept a number and print its all factors. Eg. If number entered is 20. The program should print 1 2 4 5 10 20

Write a program to accept percentage of student and print grade as per criteria given below:

Percentage	Grade
>=80	A
60-79	B
40-59	C
<40	D

(iii) What are comments in python? How can we give comments in python?

What are keywords in python? Give example

Consider a table Voter with the columns as follows:

Voterno, Votername, Age, Address and Phone.

Write SQL queries for the following:

(i) To list Voterno, Votername and Age for all the voters. This information should be sorted on Age.

(ii) To display all details of the voters where address is “Guwahati”

(iii) To list voters where address is “Delhi” and age greater than 30.

(iv) To display Votername and Address of all voters whose name starts with ‘S’.

(v) To display the details of voters whose Address is “Delhi” or “Mumbai”

(i) What is cloud computing? Write its 2 advantages.

(ii) __________ refers to the ability of machines to perform cognitive tasks like thinking, perceiving, learning, problem-solving as decision making.

(iii) What is full form of IoT and VR?

(iv) What is block chain technology?

ANSWER KEY

Part A

Section I

Internet Explorer and Unix

½ mark for each correct answer

Android

1 mark for correct answer

Byte, KB, MB, GB, TB

1 mark for correct order

½ mark each for correct definition of RAM and ROM

½ mark for each correct utility software

½ mark each for correct definition of interactive and script mode

(i) String

(ii) List

½ mark for each correct data type

x=a*a*a(b*b+c*c*c)

1 mark for correct expression

del student['Address']

1 mark for correct statement

s.i and 9tag

½ mark for each correct answer

1 mark for correct definition of foreign key

Use Student;

1 mark for correct answer

Rollno will be set as primary key as it uniquely identify rows of table.

½ mark for correct primary key

½ mark for correct reason

Char – fixed length string

Varchar – variable length string

½ mark each for correct definition

1 marks for correct form.

1 marks for correct answer.

ALU

1 marks for correct answer.

A=3

1 marks for correct answer.

False

1 marks for correct answer.

4bit

1 marks for correct answer.

Section II

(i) List1.insert(3,4)

(ii) List1.sort()

(iii) del List1[2:9]

(iv) print(List1.index(13))

(v) print(max(List1))

1 mark for each correct answer

(i) Select * from OnlineClass where Attendance>20 and Attendance<40;

(ii) Select Meeting_Id from OnlineClass where Application=”Zoom”;

(iii) Select Host_Name, Hours from OnlineClass order by Attendance desc;

(iv) Select Meeting_Id, Host_Name, Application from OnlineClass where Topic=”MySQL”;

(v) insert into OnlineClass values(106,”Webex”,”Alex”,”Lists and Dictioanries”,2,30);

1 mark for each correct query

Part B

Section I

1 mark for correct definition of System Software

1 mark for correct definition of Application Software

½ mark for each correct definition of tuple and list

½ mark for each correct example

5.25

½ mark for each correct output

i. dict_keys([1, 2, 3])

ii. 3

1 mark for each correct output

What will be the output produced by the following code fragments-

(i)

1 mark for correct output

(ii) 20

1 mark for correct output

i=1

while i<10:

print(i)

i=i+2

½ mark for initialisation

1 mark for correct while loop

½ mark for increment

Items={'Ravi':89,'Suman':95,'Anil':70}

2 marks for correct declaring dictionary

Find the output of the queries based on the following relation STUDENT:

(i)

Name	Grade
Ritesh Sen	B+
Bibha Roy	A
Sumit Arora	B+

(ii)

Roll	Name	Marks	Grade
1	Namit Sadhu	85	A+
5	Soumya Singh	92	A+

1 mark for each correct output

Create table Customer

(

Custid int(4) Primary key,

Custname varchar(25),

Balance Decimal(5,2),

Creditlimit int(8)

);

½ mark for create table statement

½ mark for primary key constraint

1 mark for rest of correct table definition

½ mark for correct definition of DDL and DML

½ mark for example of DDL and DML

Wild card characters used in SQL select queries for pattern matching are % and _ .

Eg. Select * from student where name like “S%”;

Will show details of all students whose name starts with S.

1 mark for correct wild card characters

1 mark for any correct example.

2 marks for correct explaination.

Section II

(i) 2 MB= 2 * 1024 * 1024 bytes

1 mark for correct answer

(ii) ½ mark for each correct function of operating system

(iii) ½ mark for each correct definition of CU and ALU.

1 mark for accepting 3 numbers

1 marks for correct usage of if..elif..else statement

1 mark for correct indentation

½ mark for accepting number

1 mark for correct syntax of while / for loop

1 mark for multiplication

½ mark for indentation

(i) Select * from employee where salary between 30000 and 5000;

1 mark for correct query

(ii) ½ mark for correct definition of candidate key and ½ mark for correct example.

(iii) 1 mark for correct definition of domain

(i) degree=3 cardinality=4

After adding 5 rows, cardinality will be 9.

1 mark before adding rows

1 mark after adding rows

(ii) ½ mark for each correct advantage of database system.

(i) FL_No

(ii) Degree=5, Cardinality=3

(iii) Varchar

1 mark for each correct answer

Section III

(i) ½ mark for correct initialisation

1 mark for correct loop

1 mark for correct multiplication

½ mark for increment

½ mark for correct accepting 2 numbers

1 mark for correct loop

1 mark for summing numbers

½ mark for increment

(ii) ½ mark for accepting number

1 mark for correct loop

1 mark for checking remainder

½ mark for increment

½ mark for accepting percentage

2 marks for correct usage of if..elif..else statement

½ mark for correct indentation

(iii) ½ mark for correct definition of comments

½ mark for correct syntax

½ mark for correct definition of keywords

½ mark for correct example

(i) Select Voterno, Votername, Age from Voter order by Age;

(ii) Select * from Voter where Address=”Guwahati”;

(iii) Select * from Voter where Address=”Delhi” and Age>30;

(iv) Select Votername, Address from Voter where Votername like “S%”;

(v) Select * from Voter where Address=”Delhi” or Address=”Mumbai”

Select * from Voter where Address in(”Delhi”,”Mumbai”);

1 mark for each correct query.

(i) 1 mark for correct definition of cloud computing

½ mark for each correct advantage

(ii) Artificial Intelligence

1 mark for correct answer

(iii) IoT = Internet of Things

VR =Virtual Reality

½ mark for each correct expansion

(iv) 1 mark for correct definition of block chain technology

************** End of Paper **************

class11 sample paper of IP

SAMPLE PAPER OF IP

SET-I

SET-III

You May Also Like

No comments:

Materials

Popular Posts

Categories

Labels

Featured post

There are two arrays of integers,arr1,arr2.One move is defined as increment or decrement of one element to match in an array.Determine the minimu number of moves to match arr1 with arr2.No reordering of the digits is allowed.

Popular Post

Recent Posts