IP REVISION
1 What is a data base? What are the advantages of data bases
2 DESC command can be used in MySQL in two different contexts. Which are they?
3 Write a short note about pattern matching or wild card characters (% and -- )of MySQL
4 How modify command is different from change command. Give Examples
5 Define the term relation in the context of Database
6 Explain the following terms i) Degree ii) Cardinality
7 What is MySQL? Write any two features of MySQL.
8 Write a short note about constraints of MySQL.
9 Differentiate between primary key, Unique and candidate key of a table
10 Define the terms DBMS and RDBMS
11 Define the term query. How it is useful while manipulating a data base
12 Differentiate between Delete and drop commands of MySQL with suitable example
13 Write the use of ‘Distinct’ command. Explain with a suitable MySQL command
14 Write a short note about the term data type in MYSQL. Which are the available data types of
MySQL
15 Differentiate the terms Attribute, Field, Row, Record and Tuple.
16 Write a short note about logical operators of MySQL with suitable examples
17 According to the processing capabilities MySQL commands are classified into which all categories.
Explain each of them
18 How update command of MySQL is different from Alter command. Give Examples
19 Differentiate between DDL and DML
20 Explain if..else Statement with example in python.
21 Differentiate between volatile and nonvolatile memory
22 Write a short note about application software. How it is classified
23 Write a short note about System software. How it is classified
24 Explain Central Processing Unit (CPU) with help of a diagram (Block diagram of a computer).
25 Write the function of ALU in a computer System
26 What do you understand by the Internet of Things? List some of its potential applications.
27 What is List? How you add and delete from the list?
28 What are Relational operators in python? Give Examples
29 Explain the process of Data Storage, and Retrieval
30 Write a short note about the term Data Recovery
31 Explain the following along with their applications. a) Artificial Intelligence b) Machine Learning
c) Natural Language Processing (NLP)
32 How do we declare or create Dictionary in python?
33 Write one similarity and one difference between CHAR and VARCHAR data types in MYSQL.
34 Identify the category (Operating System, System Utilities, General Purpose Software, Customized
Software ) of the following software: a) school management software b) Mozilla web browser c)
Linux d) anti-virus software
35 Write any two built in functions used in python to manipulate the list
36 How dictionary in python is different from List. Explain with suitable examples
37 Write a short note about the following terms i. Natural Language processing ii. Augmented Reality
iii. Grid computing iv. Block chain technology
38 What is the role of Indentation in python
39 Python is a Free and Open Source Language. What do you understand by this feature
40 Differentiate between cloud computing and grid computing with suitable examples.
41 How IoT and WoT are related? Explain applications of each of them
42 Explain the operators available in Python
42 Explain the datatypes in python
43 Explain the types of errors in python with example code.
44 What is the importance of an Operating System?
45 What is the function of memory? What are its measuring units?
46 Explain what are device drivers.
47 Write MySql command to i) open an existing database ii) display the exisiting tables and databases
48 Explain the Decision making statement in python.
49 Explain for loop and while loop with examples
50 Write the statement in python that can be used to iterate over a range of values or a sequence. Give
Example.
51 Explain General Purpose Software and Customized Software with examples
52 Explain range function in for loop with example in python
53 Explain the following terms i) Degree and Cardinality
54 What are the rules for naming a valid Identifier in python? Give some example
55 Explain built in functions in List and Dictionaries any 4 each
56 Give example code for syntax error, logical error , runtime error
57 What is the need of RAM? How does it differ from ROM?
Find output
a)
n1 = '123' + '10'
print(n1)
n2 = 20+3*((3*2)-2)/10
print(n2)
b)
S={'RollNo':1,'Name':'Jewel',
'Class':'12f','Gender':'F','Fee':500.56}
print('Jewel' in S)
S ['DOB']='22-feb-2005'
del Student['Class']
Marks={'IP':70,'Eng':50, 'Bio':60 }
S.update(Marks)
print(len(S))
c)
ideal = {10: 'z10', 11: 'z11', 12: 'z12'}
for y in d.keys():
print(ideal[y])
d)
z = ["x100", "y100", "z100", "z101"]
for x in [0, 2, 1]:
print(z[x], end=" ")
e) a,b=10,20
a,b,a=a+1, b+2, a+3
print(a+b)
f) a,b=[10,20], [30,40]
print(a+b)
G) Find x+y , if x=[10,20,30] and y=50:
h) D1={31:"x",32:"y",33:"z",40:"s"}
for x in D1:
print(x, end=" ")
print(D1[x],end=" ")
i) a = 3 + 11//2
print(a)
j) a1 = 10
n2 = 20
z3 = 30
a1 += n2 + z3
print(a1)
h) A=[ 10,20,30,40,50,60,]
print(A[1:-3]); print(A[2,-4]);
#Find the output of the following python code.
Employee={'Empno':21,'Name':'Vettel','Salary':9345.56}
print('salary' in Employee)
print('Salary' in Employee)
print(Employee.get('Name'))
print(Employee.keys())
print(Employee.values())
#Find the output
P=24
Q=25
if(P%8==0):
P +=Q #P=P+Q
if(Q%6==0):
Q+=P
else:
P-=Q #P=P-Q
print(P)
print(Q)
#Find the output
for i in range (20,40,4):
print("i=",i)
print("i=",i)
print("i=",i+2)
#Find the output
a=50
b=60
c=70
print(a!=b and b!=c)
print(a==b or b==c)
print(a!=b and b>=c)
print(a<=b or b!=c)
#Find the output
Employee=[ 21, 'Vettel', 'M', 'Doha', '23-feb-2000', 6700.80,
66720345]
print(Employee[1:2])
print(Employee[5:])
print(Employee[-4:-1])
print(Employee[::-1])
print(Employee[::3])
print(Employee[::-3])
#Find the output
a,b=30,50
a,b=a,b+3
print(a,b)
#Find the output
L={1:"Aleena",2:"Albeena",3:'Aishath',4:"Vibha"}
for x in L:
print(x,end="")
print(L[x],end="")
#Find the output
list1=list(range(-1,5,2))
print(list1)
#Find the output
list1=['xx','yy','zz','pp','qq']
for i in [4,1,2]:
print(list1[i],end=" ")
MYSQL Table: Schooldata
231233654 Saniya Null Null Null Female
FIND THE OUTPUT
i. SELECT NAME, CLUB FROM SCHOOLDATA WHERE NAME LIKE “_o%” AND MARKS>75;
ii. SELECT CLUB, MARKS, MARKS + GRADE AS “FEES” FROM SCHOOLDATA WHERE
CLUB=”STEM” OR CLUB=”SPACE”;
iii. SELECT DISTINCT CLUB FROM SCHOOLDATA;
iv. SELECT * FROM SCHOOLDATA WHERE MARKS>75 AND GRADE<12;
v. SELECT * FROM SCHOOLDATA WHERE NAME LIKE “_o%” ORDER BY MARKS DESC;
Write MYSQL Query
a) To Create the above table with PK,UK and not null constraint
b) To Insert 2 records
c) To display stem and space club students who is not from grade 10
d) To Display Name contains letter “m” in descending order of their name
e) To display all Students who have Marks.
f) To display all Students who don’t have Marks.
g) To display Name and Gneder whose club is READER OR SPACE
h) Increase the marks of all students from STEM and SPACE club by 5%
i) To Display Name , Marks and Extra_marks for all students whose Marks above 70.
Extra_Marks is 3% of Marks
j) TO Display Different Genders without repeating.
k) Change the Club of Romil to SPACE.
l) Remove the record of Alok.
m) Insert a new column Fee of integer type.
n) Rename the "Fee" column to change its data type to Float.
o) Modify the name of the Grade column to Class.
p) Delete the column Fee
Programs
1. Odd/even
2. SI/CI
3. Rectangle , circle, Triangle
4. Largest of 2 or 3 numbers
5. Natural numbers and sum between 2 limits
6. Even/odd numbers and sum between 2 limits
7. Factorial
8. List 3rd largest and 3rd smallest
9. Dictionary addition and deletion
10. Concatenation of strings
11. List/dictionary methods
