CBSE Computer Science and Informatics Practices Assignment/Worksheet

File Handling Test 6

2020-09-28T23:33:00.006+05:30

File Handling Test 6

Q1. Do we need to use the close() function when we use 'with' statement to open a file?

Q2. Which mode you will choose for the following situations:

1. For reading file

2. For creating new file if not existing

3. All previous data over written by new data.

4. All new data added at the end of the file

Q3. Write the code to open a file "try.txt" in write mode by using 'with' statement.

Q4. When we open a file in append mode. Write T/F for the following statements

New file created, if file does not exist.
Error comes, if file does not exist.
File open with no data, if file already exist and had some data.
New data will over wrie the existing data.
New data will add at the end of the existing data.

Q5. a ) Write a program to add the following data in a file named "data.txt"

Welcome to my Blog

This blog is for python learners

Q6. Write the output, if you execute the following program twice.

f = open("data.txt",'a')

f.write("Welcome to my Blog\n")

f.write("This blog is for python learners")

f.close()

Q7. Write the following code in one statement:

f = open("data.txt",'r')

f.read(10)

Q8. Write a program to read and display three lines(line by line) from file "data.txt"

Q9. Write the output if the file contains the following lines :

Welcome to my Blog

This blog is for python learners

f=open("data.txt", "r")

print(f.readline( ))

f=open("data.txt", "r")

print(f.readline( )end=' ')

Q10. Write a program to read entire file "data.txt" line by line.

SOLUTIONS

Q1. Do we need to use the close() function when we use 'with' statement to open a file?

Ans. No

Q2. Which mode you will choose for the following situations:

1. For reading file

2. For creating new file if not existing

3. All previous data over written by new data.

4. All new data added at the end of the file

Ans.

1. Read mode

2. Write mode/Append mode

3. Write mode

4. Append mode

Q3. Write the code to open a file "try.txt" in write mode by using 'with' statement.

Ans. with open("try.txt" , 'w') as f1

Q4. When we open a file in append mode. Write T/F for the following statements

New file created, if file does not exist.
Error comes, if file does not exist.
File open with no data, if file already exist and had some data.
New data will over wrie the existing data.
New data will add at the end of the existing data.

Ans.

True
False
False
False
True

Q5. a ) Write a program to add the following data in a file named "data.txt"

Welcome to my Blog

This blog is for python learners

Ans. f = open("data.txt",'a')

f.write("Welcome to my Blog\n")

f.write("This blog is for python learners")

f.close()

Q6. Write the output, if you execute the following program twice.

f = open("data.txt",'a')

f.write("Welcome to my Blog\n")

f.write("This blog is for python learners")

f.close()

Ans

Welcome to my Blog

This blog is for python learnersWelcome to my Blog

This blog is for python learners

Q7. Write the following code in one statement:

f = open("data.txt",'r')

f.read(10)

Ans. open("data.txt",'r').read(10)

Q8. Write a program to read and display three lines(line by line) from file "data.txt"

Ans.

f=open("data.txt", "r")

print(f.readline( ))

Q9. Write the output if the file contains the following lines :

Welcome to my Blog

This blog is for python learners

f=open("data.txt", "r")

print(f.readline( ))

f=open("data.txt", "r")

print(f.readline( )end=' ')

Ans a)

Welcome to my Blog

This blog is for python learners

Welcome to my Blog

This blog is for python learners

Q10. Write a program to read entire file "data.txt" line by line.

Ans.

f = open("data.txt", "r")

line=f.readlines( )

for i in line:

print(i, end = ' ')

f.close( )

Computer Science Class XII Python File Handling Test Series Part 5

2020-09-28T19:08:00.006+05:30

Computer Science Class XII Python File Handling Test Series Part 5

Q1. Reading and writing opeation can be done after close() function(T/F)

Q2. f = open("test.txt", "r")

Write the output f the following

1. print(f.name)

2. print(f.mode)

3. print(f.closed)

4. prin(f.readable())

Q3. Write a program to accept five numbers from the user and write in a file "num.txt"

Q4. What type of error is shown by the following line of code.

f.write(3)

where f is file handle associated with text file named "try.txt"

Q5. write() function takes integer argument. (T/F)

Q6. Write a proram to accept 10 numbers from the user. if the number is even than write that number in "even.txt", otherwise, write in file "odd.txt"

Q7. Write a program to create a list of five subjects and write them in a file named "subject.txt"

Q8. What type of error is shown by the following line of code?

f.write(try)

Where f is file object and try is a an object of list type.

Q9. What type of error is shown by the following line of code?

f.writeline(try)

Where f is file object and try is a an object of list type.

Q10. writelines() method does not add any EOL character to the end of String. (T/F)

SOLUTIONS

Q1. Reading and writing opeation can be done after close() function(T/F)

Ans. False

Q2. f = open("test.txt", "r")

Write the output f the following

1. print(f.name)

2. print(f.mode)

3. print(f.closed)

4. prin(f.readable())

Ans.

1. test.txt

2. r

3. False

4. True

Q3. Write a program to accept five numbers from the user and write in a file "num.txt"

Ans.

f=open("num.txt","w")

for i in range(5):

n=int(input("Enter number"))

f.write(str(n))

f.close()

Q4. What type of error is shown by the following line of code.

f.write(3)

where f is file handle associated with text file named "try.txt"

Ans. TypeError

Q5. write() function takes integer argument. (T/F)

Ans. False

Q6. Write a proram to accept 10 numbers from the user. if the number is even than write that number in "even.txt", otherwise, write in file "odd.txt"

Ans.

f=open("num.txt","w")

f1=open("odd.txt","w")

for i in range(10):

n=int(input("Enter number"))

if n%2==0:

f.write(str(n))

f.write("\n")

else:

f1.write(str(n))

f.write("\n")

f.close()

f1.close()

Q7. Write a program to create a list of five subjects and write them in a file named "subject.txt"

f=open("num.txt","w")

sub=["Englsh\n","Hindi\n","Math\n","Science\n",

"SST\n"]

f.writelines(sub)

f.close()

Q8. What type of error is shown by the following line of code?

f.write(try)

Where f is file object and try is a an object of list type.

Ans. TypeError: write() argument must be str, not list

Q9. What type of error is shown by the following line of code?

f.writeline(try)

Where f is file object and try is a an object of list type.

Ans. AttributeError

Q10. writelines() method does not add any EOL character to the end of String. (T/F)

Ans. True

Computer Science Class XII Python File Handling Test Series Part 4

2020-09-28T19:08:00.005+05:30

Computer Science Class XII Python File Handling Test Series Part 4

Q1. Write a program in python to read entire content of file ("data.txt")

Q2. Write a program in python to read first 5 characters from the file("data.txt")

Q3. Write a program in python to read first line from the file("data.txt")

Q4. Write a program in python to display number of lines in a file("data.txt").

Q5. Write a program in python to display first line from the file("data.txt") using readlines().

Q6. readlines() function returns the entire data in the form of list of _____

Q7. Name two functions which are used to write data into file.

Q8. Accept five names from the user and write in a file "name.txt"

Q9. Accept five sports names from the user and write in a file "sport.txt" (each name should write in separate line)

Q10. Accept five hobbies from the user and write in a file "hobby.txt" (each hobby should write in separate line) without using write() function.

SOLUTIONS

Q1. Write a program in python to read entire content of file ("data.txt")

Q2. Write a program in python to read first 5 characters from the file("data.txt")

Q3. Write a program in python to read first line from the file("data.txt")

Q4. Write a program in python to display number of lines in a file("data.txt").

Q5. Write a program in python to display first line from the file("data.txt") using readlines().

Q6. readlines() function returns the entire data in the form of list of _____

Ans. String

Q7. Name two functions which are used to write data into file.

Ans. write() and writelines()

Q8. Accept five names from the user and write in a file "name.txt"

Ans.

f = open("name.txt","w")

for i in range(5):

n = input("Enter name")

f.write(n)

f.close()

Q9. Accept five sports names from the user and write in a file "sport.txt" (each name should write in separate line)

f = open("name.txt","w")

for i in range(5):

n = input("Enter sport name")

f.write(n)

f.write('\n')

f.close()

Q10. Accept five hobbies from the user and write in a file "hobby.txt" (each hobby should write in separate line) without using write() function.

Ans.

f = open("hobby.txt","w")

h = [ ]

for i in range(5):

n = input("Enter hobby name")

h.append(n,'\n')

f.writelines(h)

f.close()

Computer Science Class XII Python File Handling Test Series Part 3

2020-09-28T19:07:00.009+05:30

Computer Science Class XII Python File Handling Test Series Part 3

Q1. What is the difference between r+ and w+ mode?

Q2. What is the difference between write and append mode?

Q3. Which method is used to close the file in python?

Q4. Write the statement to close the file "test.txt" which is associated with file object named "fo".

Q5. Write one similarity and one difference between a+ and w+.

Q6. What is the difference between read() and read(n) functions?

Q7. What is the difference between readline() and readlines() ?

Q8. Write a program to read first 10 characters from a file named "data.txt"

Q9. Write a program to read entire content from the file named "test.txt"

Q10. Write the output of the following, if the data stored in file "try.txt" is given below. ("f" is the file object associated with file)

Try Try but never cry

print(f.read(4))

print(f.read(5))

print(f.read())

SOLUTIONS

Q1. What is the difference between r+ and w+ mode?

Ans. r+ mode will return error if file does not exist while w+ mode will create a new file if file does not exist.

Q2. What is the difference between write and append mode?

Ans. Write mode over writes the existing data while append mode add the new data at the end of the file.

Q3. Which method is used to close the file in python?

Ans. close()

Q4. Write the statement to close the file "test.txt" which is associated with file object named "fo".

Ans. fo.close()

Q5. Write one similarity and one difference between a+ and w+.

Ans. Similarity : In both the modes, we can do read and write operations.

Difference : In w+ mode file will be truncated (previous data lost) while in a+ mode, file's existing data will not be deleted and new data will be added at the end of the file.

Q6. What is the difference between read() and read(n) functions?

Ans. read() : will read entire data from the file.

read(n) : will read first n characters/bytes from the file.

Q7. What is the difference between readline() and readlines() ?

Ans. readline() :This function will read one line from the file.

readlines() : This function will read all the lines from the files.

Q8. Write a program to read first 10 characters from a file named "data.txt"

Ans.

f = open("data.txt","r")

data = f.read(10)

print(data)

Q9. Write a program to read entire content from the file named "test.txt"

Ans.

f = open("test.txt, "r")

d = f.read()

print(d)

Q10. Write the output of the following, if the data stored in file "try.txt" is given below. ("f" is the file object associated with file)

Try Try but never cry

print(f.read(4))

print(f.read(5))

print(f.read())

Ans.

Try

Try b

ut never cry

Computer Science Class XII Python File Handling Test Series Part 2

2020-09-28T19:07:00.008+05:30

Computer Science Class XII Python File Handling Test Series Part 2

Q1. f = open("data.txt")

Identify name of file.
Identify name of function.
What if 'f' in above code?
The above statement will __________ file in ________ mode.

Q2. What is the default mode of opening a file?

Q3. Write a statement in python to open a file named "data.txt" stored in folder "content" in D drive.

Q4. What error is returned by following statement, if file "try.txt" does not exist?

f = open("try.txt")

Q5. Name the three modes in which file can be opened in python.

Q6. What is the purpose of 'r' as prefix in the given statement?

f = open(r, "d:\color\flower.txt")

Q7. What do you mean by file object in python?

Q8. Another name of file object is _______

Q9. Write the symbols used in place of 'x' to open text file for the following operations.

f = open("name.txt", 'x')

Read Only
Write only
Read and Write
Write and Read

Q10. Write the symbols used in place of 'x' to open binary file for the following operations.

f = open("name.dat", 'x')

Read Only
Write only
Read and Write
Write and Read

SOLUTIONS

Q1. f = open("data.txt")

Identify name of file.
Identify name of function.
What if 'f' in above code?
The above statement will __________ file in ________ mode.

Ans.

data.txt
open()
file object
open, read

Q2. What is the default mode of opening a file?

Ans. read mode

Q3. Write a statement in python to open a file named "data.txt" stored in folder "content" in D drive.

Ans. f = open("d:\\content\\data.txt")

f = open(r, "d:\content\data.txt")

Q4. What error is returned by following statement, if file "try.txt" does not exist?

f = open("try.txt")

Ans. FileNotFoundError

Q5. Name the three modes in which file can be opened in python.

Ans. Read, Write and Append

Q6. What is the purpose of 'r' as prefix in the given statement?

f = open(r, "d:\color\flower.txt")

Ans. 'r' makes the string as raw string, means there is no special character in string.

Q7. What do you mean by file object in python?

Ans. File object is reference to a file. It is used to read and write data to a file.

Q8. Another name of file object is _______

Ans. File Handle

Q9. Write the symbols used in text file mode for the following operations.

Read Only
Write only
Read and Write
Write and Read

Ans.

Q10. Write the symbols used in binary file mode for the following operations.

Read Only
Write only
Read and Write
Write and Read

Ans.

Computer Science Class XII Python File Handling Test Series Part 1

2020-09-28T19:07:00.007+05:30

Computer Science Class XII Python File Handling Test Series Part 1

Q1. Name two types of data files available in python.

Q2. In text file each line is terminated by a special character called _______

Q3. In python, default EOL character is _______

Q4. Is there any delimiter of line in binary File?

Q5. In binary files, data stored in the same format as it is stored in computer memory. (T/F)

Q6. Processing of binary file is faster than text file (T/F)

Q7. Writing data is same as appending data in file. (T/F)

Q8. Can we read file without opening. (T/F)

Q9. Which function is used to open a file?

Q10. Write the code in python to open a file named "try.txt"

SOLUTIONS

Q1. Name two types of data files available in python.

Ans. Text File and Binary File

Q2. In text file each line is terminated by a special character called _______

Ans. EOL (End of Line)

Q3. In python, default EOL character is _______

Ans. \n

Q4. Is there any delimiter of line in binary File?

Ans. No

Q5. In binary files, data stored in the same format as it is stored in computer memory. (T/F)

Ans. True

Q6. Processing of binary file is faster than text file (T/F)

Ans. True

Q7. Writing data is same as appending data in file. (T/F)

Ans. False

Q8. Can we read file without opening. (T/F)

Ans. False

Q9. Which function is used to open a file?

Ans. open()

Q10. Write the code in python to open a file named "try.txt"

Ans. f = open("try.txt")

Computer Science - Informatics Practices Class XI/XII MySQL Test Series Part 12

2020-09-28T14:09:00.003+05:30

Computer Science - Informatics Practices Class XI/XII MySQL Test Series Part 12

Q1. Write the output of the following on the basis of given table : Product

1. Select max(price) from product;

2. Select avg(price) from product;

3. Select min(qty) from product;

4. Select count(*) from product;

5. Select count(Qty) from product;

6. Select distinct(price) from product;

7. Select count(distinct(price)) from product;

8. Select price * Qty from product;

9. Select sum(price) from product;

10. Select sum(price) where Qty > 30;

SOLUTIONS

Q1. Write the output of the following on the basis of given table : Product

1. Select max(price) from product;

Ans. 320

2. Select avg(price) from product;

Ans. 218

3. Select min(qty) from product;

Ans. 17

4. Select count(*) from product;

Ans. 5

5. Select count(Qty) from product;

Ans. 5

6. Select distinct(price) from product;

Ans.

240

300

320

130

100

7. Select count(distinct(price)) from product;

Ans. 5

8. Select price * Qty from product;

Ans.

5520

7200

13760

4160

1700

9. Select sum(price) from product;

Ans. 1090

10. Select sum(price) where Qty > 30;

Ans. Error

Data Structure Test 4

2020-09-23T14:45:00.000+05:30

Data Structure Test 4

Q1. A linear stack called "List" contain the following information:
a. Roll Number of student
b. Name of student
Write add(List) and pop(List) methods in python to add and remove from the stack.

Ans.

List=[]
def add(List):
  rno=int(input("Enter roll number"))
  name=input("Enter name")
  item=[rno,name]
  List.append(item)
def pop(List):
  if len(List)>0:
    List.pop()
  else:
    print("Stack is empty")
#Call add and pop function to verify the code
add(List)
add(List)
pop(List)
print(List)

Q2. Write push(edetail) and pop(edetail) in python to add and remove the employee detail in a stack called "edetail".

"edetail" stack store the following details:

a. Name of employee

b. Salary of employee

Ans.

edetail = []
def push(edetail):
    name = input("Enter name")
    sal = int(input("Enter Salary"))
    item = [name, sal]
    edetail.append(item)
def pop(edetail):
    if len(edetail) > 0:
        edetail.pop()
    else:
        print("Stack is empty")

#Call push and pop function to verify the code
push(edetail)
push(edetail)
pop(edetail)
print(edetail)

Q3. Write addscore(game) and delscore(game) methods in python to add and remove score from a list "game", considering these methods to act as push and pop operations of data structure stack.

Ans.

game = []
def addscore(game):
    sc=int(input("Enter Score"))
    game.append(sc)
def pop(ed):#in place of 'ed' we can use 'game'also
    if len(ed) > 0:
        ed.pop()
    else:
        print("Stack is empty")
#Call functions to verify the code
addscore(game)
addscore(game)
pop(game)
print(game)

OR (When we don't want to accept value from
   the user)

game = []
def addscore(sc):
    game.append(sc)
def pop():
    if len(game) > 0:
        game.pop()
    else:
        print("Stack is empty")
#Call functions to verify the code
addscore(23)
addscore(54)
pop()
print(game)

Q4. Write addsal(sal) and removesal(sal) functions in python to add and remove salary from a list of salary in a list "sal", considering these methods to act as push and pop operations of data structure stack.

Ans.

sal = []

def addsal(sc):

    sal.append(sc)

def pop():

    if len(sal) > 0:

        sal.pop()

    else:

        print("Stack is empty")

#Call functions to verify the code

addsal(23)

addsal(54)

pop()

print(sal)

Q5. Write addfee() function in python to add the following detail in list named "fee".

        feeamount
        feemonth
Considering this as push function of stack
Ans.
fee=[]
def addfee(fee):
    fa=int(input("Enter the fee amount"))
    fm = input("Enter the fee month")
    item = [fa,fm]
    fee.append(item)
addfee(fee)

Data Structure Test 5

2020-09-23T14:05:00.004+05:30

Data Structure Test 5

Q1. Write queueadd(clientname) and queuedel(clientname) methods in python to add a new client and delete a client from a list of Client Names, considering them to act as an insert and delete operations of the queue data structure.

Ans.

cn=[]
def queueadd(cn):
  cname=input("Enter Client Name")
  cn.append(cname)
def queuedel(cn):
  if(len(cn)==0):
    print("Queue is Empty")
  else:
    print("Deleted element is", cn[0])
    del cn[0]
#you can call the following functions to verify
the above code
queueadd(cn)
queueadd(cn)
queueadd(cn)
queuedel(cn)
print(cn)

Q2. Write queueadd(pid) and queuedel(pid) methods in python to add a new product  and delete a product  from a list of product id, considering them to act as an insert and delete operations of the queue data structure. (Consider product id of integer type)
Ans.
pid=[]
def queueadd(cn):
  prid=int(input("Enter Product id"))
  cn.append(prid)
def queuedel(pid):
  if(len(pid)==0):
    print("Queue is Empty")
  else:
    print("Deleted element is", pid[0])
    del pid[0]
#you can call the following functions to verify
the above code
queueadd(pid)
queueadd(pid)
queueadd(pid)
queuedel(pid)
print(pid)


Q3. Write add(book) and del1(book) methods in python to add a new book and delete a book  from a list of book name, considering them to act as an insert and delete operations of the queue data structure. 
Ans. 
book=[]
def add(book):
  bn=input("Enter book name")
  book.append(bn)
def del1(book):
  if(len(book)==0):
    print("Queue is Empty")
  else:
    print("Deleted element is", book[0])
    del book[0]
#you can call the following functions to verify
#the above code
add(book)
add(book)
add(book)
del1(book)
print(book)

Q4. Write addq(Employee) and delq(Employee) methods in python to add a new Employee Name  and delete an Employee  from a list of Employee name, considering them to act as an insert and delete operations of the queue data structure. 
Ans. 
emp=[]
def addq(emp):
  en=input("Enter employee name")
  emp.append(en)
def delq(emp):
  if(len(emp)==0):
    print("Queue is Empty")
  else:
    print("Deleted element is", emp[0])
    del emp[0]
#you can call the following functions to verify
#the above code
addq(emp)
addq(emp)
addq(emp)
delq(emp)
print(emp)

Q5. Write adding(Rollno) and deleting(Rollno) methods in python to add a new Roll Number and delete Roll Number  from a list of Roll Number, considering them to act as an insert and delete operations of the queue data structure. (Roll number is of type integer
Ans. 

rno=[]
def adding(rno):
  rn=int(input("Enter Roll Number"))
  rno.append(rn)
def deleting(rno):
  if(len(rno)==0):
    print("Queue is Empty")
  else:
    print("Deleted element is", rno[0])
    del rno[0]
#you can call the following functions to verify
#the above code
adding(rno)
adding(rno)
adding(rno)
deleting(rno)
print(rno)

Data Structure Test 3

2020-09-22T09:47:00.000+05:30

Data Structure Test 3

Q1. Write a function Push() which takes number as

argument and add in a stack "MyValue"

Q2. Write a function Push that takes "name" as

argument and add in a stack named "MyStack"

Q3. Write a function Push() which takes "name" as

argument and add in a stack named "MyStack".

After calling push() three times, a message
should be displayed "Stack is Full"

Q4. Write a function pop() which remove name

from stack named "MyStack".

Q5. Write push(rollno) and pop() method in python:
    push(rollno) --add roll number in Stack
    pop() --- remove roll number from Stack.

Q6. Write add(bookname) and delete() method in

python to add bookname and remove bookname

considering them to act as push() and pop()

operations in stack.

Q7. Write addclient(clientname) and remove()

methods in python to add new client and delete
existing client from a list "clientdetail",
considering them to act as push and pop
operations of the stack.

SOLUTIONS

Q1. Write a function Push() which takes number as argument and add in a stack "MyValue"

Ans.

MyValue=[]

def Push(value):

MyValue.append(value)

Q2. Write a function Push that takes "name" as argument and add in a stack named

"MyStack"
Mynames=[]
def Push(Value):
   Mynames.append(Value)
Push("Amit")

Q3. Write a function Push() which takes "name" as
argument and add in a stack named "MyStack".
After calling push() three times, a message
should be displayed "Stack is Full"
Ans.
MyStack=[]
StackSize=3
def Push(Value):
   if len(MyStack) < StackSize:
       MyStack.append(Value)
   else:
       print("Stack is full!")

Q4. Write a function pop() which remove name
from stack named "MyStack".
Ans.
def Pop(MyStack):
if len(MyStack) > 0:
  MyStack.pop()
else:
  print("Stack is empty.")

Q5. Write push(rollno) and pop() method in python:
    push(rollno) --add roll number in Stack
    pop() --- remove roll number from Stack.

Ans.
MyStack=[]
def Push(rollno):
   MyStack.append(rollno)
def Pop(MyStack):
if len(MyStack) > 0:
  MyStack.pop()
else:
  print("Stack is empty.")

Q6. Write add(bookname) and delete() method in python
to add bookname and remove bookname considering
them to act as push() and pop() operations in stack.
Ans.
MyStack=[]
def add(bname):
   MyStack.append(bname)
def delete(MyStack):
if len(MyStack) > 0:
  MyStack.pop()
else:
  print("Stack is empty. There is no book name")

Q7. Write addclient(clientname) and remove()
methods in python to add new client and delete
existing client from a list "clientdetail",
considering them to act as push and pop
operations of the stack.

Ans.

clientdetail=[]

def addclient(cn):

clientdetail.append(cn)

def remove():

if len(clientdetail)>0:

clientdetail.pop()

else:

print("Stack is empty")

Data Structure Test 2

2020-09-21T20:04:00.007+05:30

Data Structure Test 2
Q1. Organization of data means ______.
Q2. Write the full form of the following:
a. LIFO
b. FIFO
Q3. Which data structure is represented as FIFO?
Q4. Insertion into stack is called ______ (push/pop)
Q5. Giving printing command to printer is an example of _____

(stack/queue)
Q6. Reversing a number or a word/string is an example of

______(stack or queue)
Q7. In stack addition or removal of elements takes place at ___
(one/both) end of the list.
Q8. In queue, addition of elements take place at one end and

removal of elements takes place at other end. (T/F)
Q9. If the elements "A", "B", "C" are added in the queue in the

following order,
first A then B and in last C.
In what order, it will come out of
queue?
Q10. _________ function is used to add an element in stack.

SOLUTIONS

Ans 1. Data Structure

Ans 2.

a. Last In First Out

b. First In First Out

Ans 3. Queue

Ans 4. Push

Ans 5. Queue

Ans 6. Stack

Ans 7. One

Ans 8. True

Ans 9. A, B, C

Ans 10. Append

Computer Science - Informatics Practices Class XI/XII MySQL Test Series Part 11

2020-09-20T02:48:00.003+05:30

Computer Science - Informatics Practices Class XI/XII MySQL Test Series Part 11

Q1. What is the degree and cardinalty of table who has 6 columns and 10 rows?

Q2. Identify the errors in the following query

a. Select * from Student where Name = NULL;

b. Select max(salary) from employee group by designation where DOJ > "2020-02-02";

c. Select * from student where name is = "Amit";

d. Select * from employee where salary between 1000, 2000;

e. Select * from employee where name = "A%";

f. Select Name , Subject from student where average >20 and < 30;

g. Select * from Student where Name = "Amit" and Name ="Sumit";

h. Select highest(Salary) from employee;

i. Select all from student;

j. Update table student set Name = "Sunita" where admno = 1234;

SOLUTIONS

Q1. What is the degree and cardinalty of table who has 6 columns and 10 rows?

Ans. Degree - 6 and Cardinality - 10

Q2. Identify the errors in the following query

a. Select * from Student where Name = NULL;

Ans. Select * from Student where Name is NULL;

b. Select max(salary) from employee group by designation where DOJ > "2020-02-02";

Ans. Select max(salary) from employee group by designation having DOJ > "2020-02-02";

c. Select * from student where name is = "Amit";

Ans. Select * from student where name = "Amit";

d. Select * from employee where salary between 1000, 2000;

Ans. Select * from employee where salary between 1000 and 2000;

e. Select * from employee where name = "A%";

Ans. Select * from employee where name like "A%";

f. Select Name , Subject from student where average >20 and < 30;

Ans. Select Name , Subject from student where average >20 and average < 30;

g. Select * from Student where Name = "Amit" and Name ="Sumit";

Ans. Select * from Student where Name = "Amit" or Name = "Sumit";

h. Select highest(Salary) from employee;

Ans. Select max(Salary) from employee;

i. Select all from student;

Ans. Select * from Student;

j. Update table student set Name = "Sunita" where admno = 1234;

Ans. Update student set Name = "Sunita" where admno = 1234;

Computer Science - Informatics Practices Class XI/XII MySQL Test Series Part 10

2020-09-20T02:13:00.003+05:30

Computer Science - Informatics Practices Class XI/XII MySQL Test Series Part 10

Q1. What is the difference between drop and delete command?

Q2. Differentiate between Alter and Update command.

Q3. What is group by clause?

Q4. Write the output of the following:

Select 75 + 3*2
Select 23 + 56%5
Select power(2,3)
Select round(10.237,2)
Select round(12.3454,2)
Select round(12.3444,2)

Q5. Write the query on the basis of the following table :STUDENT

Name, Admno, Subject, Average, Position

Display all records in ascending order by name

2. Display details of students whose position is "First" and average greater than 70

3. Display details of "Amit", "Sumit" and "Ashish" (using IN operator)

4. Display Name and Subject of student whose position is "First"

5. Display the total number of records present in above table.

6. Display the maximum average.

7. Display name of student who got maximum average.

8. Insert he following record:

"Shikha", 1221, "Physics", 70, "Second"

SOLUTIONS

Q1. What is the difference between drop and delete command?

Ans. Drop command delete the data as well as structure of table permanently from database

while delete command delete only the data from the table.

Q2. Differentiate between Alter and Update command.

Ans. Alter command is used to change the structure of table and Update command is used

to modify the data of table.

Q3. What is group by clause?

Ans. This clause is used to arrange same data in groups using some group functions

like Sum, average etc.

Q4. Write the output of the following:

Select 75 + 3*2 ------------------------------------Ans. 81
Select 23 + 56%5----------------------------------Ans. 24
Select power(2,3)----------------------------------Ans. 8
Select round(10.237,2)----------------------------Ans. 10.24
Select round(12.3454,2)---------------------------Ans. 12.35
Select round(12.3444,2)---------------------------Ans. 12.34

Q5. Write the query on the basis of the following table :STUDENT

Name, Admno, Subject, Average, Position

Display all records in ascending order by name

Ans. Select * from Student order by Name;

2. Display details of students whose position is "First" and average greater than 70

Ans. Select * from student where position ="First" and Average >70;

3. Display details of "Amit", "Sumit" and "Ashish" (using IN operator)

Ans. Select * from Student where Name IN("Amit", "Sumit", "Ashish");

4. Display Name and Subject of student whose position is "First"

Ans. Select Name, Subject from student where position = "First";

5. Display the total number of records present in above table.

Ans. Select count(*) from Student.

6. Display the maximum average.

Ans. Select max(Average) from Student;

7. Display name of student who got maximum average.

Ans. Select Name, max(Average) from Student;

8. Insert he following record:

"Shikha", 1221, "Physics", 70, "Second"

Ans. Insert into student values ("Shikha", 1221, "Physics", 70, "Second");

Computer Science - Informatics Practices Class XI/XII MySQL Test Series Part 9

2020-09-19T02:07:00.003+05:30

Computer Science - Informatics Practices Class XI/XII MySQL Test Series Part 9

Q1. What do you mean by aggregate function?

Q2. Which keyword is used to arrange records in increasing or decreasing order?

Q3. Which function returns the total number of records in a table?

Q4. Select count( * ) from student; return 5

Select count(fee) from student; return 4

why different output in above two queries?

Q5. ____________ function return the average value of a numeric column.

Q6. Which function returns the sum of numeric column?

Q7. _______ keywords removes duplicates records from the table.

Q8. Write a query to display all the records of table student whose name starts from "A"

Q9. Identify the error in the following statement.

Select * from student where name = null

Q10. Which function return the minimum value from column fee of table student?

SOLUTIONS

Q1. What do you mean by aggregate function?

Ans. A function which work on multiple values and return a single value.

Q2. Which keyword is used to arrange records in increasing or decreasing order?

Ans. Order by

Q3. Which function returns the total number of records in a table?

Ans. Count( )

Q4. Select count( * ) from student; return 5

Select count(fee) from student; return 4

why different output in above two queries?

Ans. Different output shows that there must be one null value in column fee.

Q5. ____________ function return the average value of a numeric column.

Ans. avg( )

Q6. Which function returns the sum of numeric column?

Ans. sum( )

Q7. _______ keywords removes duplicates records from the table.

Ans. distinct

Q8. Write a query to display all the records of table student whose name starts from "A"

Ans. Select * from student where name like "A%";

Q9. Identify the error in the following statement.

Select * from student where name = null

Ans. Select * from student where name is null;

Q10. Which function return the minimum value from column fee of table student?

Ans. min( )

Computer Science - Informatics Practices Class XI/XII MySQL Test Series Part 8

2020-09-19T00:54:00.003+05:30

Computer Science - Informatics Practices Class XI/XII MySQL Test Series Part 8

Q1. Write the output of the following:

Select 76 + 75%4 from dual;

Q2. Write the queries of the following:

Table : Student

Display all the records of table student.
Display Roll Number, Name and Class of table Student
Display records of students of class X.
Display details of Sumit.
Display records of student paying fees less than 3000.
Display fee of Amit
Display Class and percentage of Pushkar.
Delete record of Amit
Display the structure of table student
Insert the following record in table student

5, "Suman", 'X', 3000, 70

SOLUTIONS

Ans 1. 79

Ans 2.

Select * from student;
Select RollNo, Name , Class from student;
Select * from student where class = 'X';
Select * from student where Name = 'Sumit';
Select * from students where fee < 3000;
Select fee from student where name = "Amit";
Select class, percentage from student where name = "Pushkar"
Delete from student where name = "Amit"
Desc student;
Insert into student values(5, "Suman", "X", 3000, 70);

Computer Science - Informatics Practices Class XI/XII MySQL Test Series Part 7

2020-09-18T23:56:00.009+05:30

Computer Science - Informatics Practices Class XI/XII MySQL Test Series Part 7

Q1. Which command is used to delete data from the table?

Q2. Which command is used to add column in a table?

Q3. Write a query to add the column DOB of data type date in table Student.

Q4. Write a query to add new column "Grade" of data type varchar(2) in table 'Student'

with default value "A".

Q5. Write a query to change the data type of above added column (Grade) to varchar(4).

Q6. Write a query to delete column Grade from table student.

Q7. ___________Command is used to delete table completely/permanently.

Q8. Write a query to delete the table "Emp" permanently.

Q9. Delete from emp;

The above command will delete all the records from table "emp". (True/False)

Q10. Write a query to display all the records from table "Student"

SOLUTIONS

Q1. Which command is used to delete data from the table?

Ans. Delete

Q2. Which command is used to add column in a table?

Ans. Alter

Q3. Write a query to add the column DOB of data type date in table Student.

Ans. Alter table student add DOB date;

Q4. Write a query to add new column "Grade" of data type varchar(2) in table 'Student'

with default value "A".

Ans. Alter table student add( Grade char(2) default "A");

Q5. Write a query to change the data type of above added column (Grade) to varchar(4).

Ans. Alter table student modify (Grade varchar(4));

Q6. Write a query to delete column Grade from table student.

Ans. Alter table Student drop Grade;

Q7. ___________Command is used to delete table completely/permanently.

Ans. Drop table

Q8. Write a query to delete the table "Emp" permanently.

Ans. Drop table Emp;

Q9. Delete from emp;

The above command will delete all the records from table "emp". (True/False)

Ans. True

Q10. Write a query to display all the records from table "Student"

Ans. Select * from Student;

Computer Science - Informatics Practices Class XI/XII MySQL Test Series Part 6

2020-09-18T22:57:00.006+05:30

Computer Science - Informatics Practices Class XI/XII MySQL Test Series Part 6

Q1. ___________ command is used to remove database completely.

Q2. Which command is used to show the structure of the table.

Q3. Name the columns which are visible when we execute the following command.

desc book;

Q4. Write the command to create the following table : "Student"

Field Name Data type Constraint

Rollno Integer (5) Primary Key

Sname Varchar(30)

Contactno Char(10) Not Null

Q5. Write query to insert the following record in above created table.

Roll number -- 1, Name--Amit, Contact number-- 1234567890

Q6. Write a query to insert the following values only.

Roll number -- 2 , Contact number-- 11111111

Q7. Is Null value is equivalent to Zero?

Q8. What do you mean by Null in MySQL?

Q9. Which command is used to modify data in table?

Q10. Write a query to modify the Contactno to 98789878 whose roll number is 1

in table student.(given above)

SOLUTIONS

Q1. ___________ command is used to remove database completely.

Ans. Drop

Q2. Which command is used to show the structure of the table.

Ans. desc or describe.

Q3. Name the columns which are visiblewhen we execute the following command.

desc book;

Ans. Columns are:

Field, Type Null, Key, Default, Extra

Q4. Write the command to create the following table : "Student"

Field Name Data type Constraint

Rollno Integer (5) Primary Key

Sname Varchar(30)

Contactno Char(10) Not Null

Ans. Create table student(Rollno integer(5) not null primary key, Sname varchar(30), Contactno char(10) not null);

Q5. Write query to insert the following record in above created table.

Roll number -- 1, Name--Amit, Contact number-- 1234567890

Ans. Insert into student values(1, "Amit", "123456780");

Q6. Write a query to insert the following values only.

Roll number -- 2 , Contact number-- 11111111

Ans. Insert into student(Rollno, Contactno) values(2,'1111111');

Q7. Is Null value is equivalent to Zero?

Ans. No

Q8. What do you mean by Null in MySQL?

Ans. Null means a value which is unavailable or in other words

we can say Null means no value.

Q9. Which command is used to modify data in table?

Ans. Update

Q10. Write a query to modify the Contactno to 98789878 whose roll number is 1

in table student.(given above)

Ans. Update student set Contactno='98789878' where Rollno = 1;

Computer Science - Informatics Practices Class XI/XII MySQL Test Series Part 5

2020-09-18T14:38:00.010+05:30

Computer Science - Informatics Practices Class XI/XII MySQL Test Series Part 5

Q1. What do you mean by keyword in MySQL?

Q2. Identify the keyword from the following query.

Select * from book;

Q3. All statements in MySQL are terminated by __________.

Q4. We can create ____________ (database/tables)inside ___________(database/tables).

Q5. SQL is a case sensitive language(T/F)

Q6. _________ statement is used to show all the existing databases in server.

Q7. Which statement is used to show all existing table in database.

Q8. Write statement to open a database named "student".

Q9. Name the command used to create database.

Q10. Write statement to create database named "book"

SOLUTION

Q1. What do you mean by keyword in MySQL?
Ans. Keyword refers to a word which has special meaning in MySQL.

Q2. Identy the keyword from the following query.
Select * from book;
Ans. Keywords are : select and from

Q3. All statements in MySQL is terminated by __________.
Ans. Semicolon(;)

Q4. We can create ____________ (database/tables)inside ___________(database/tables).

Ans. tables, database

Q5. SQL is a case sensitive language(T/F)

Ans. False

Q6. _________ statement is used to show all the existing databases in server.

Ans. Show databases;

Q7. Which statement is used to show all existing table in database.

Ans. Show tables;

Q8. Write statement to open a database named "student".

Ans. use student;

Q9. Name the command used to create database.

Ans. Create database

Q10. Write statement to create database named "book"

Ans. create database book;

Computer Science - Informatics Practices Class XI/XII MySQL Test Series Part 4

2020-09-18T00:54:00.006+05:30

Computer Science - Informatics Practices Class XI/XII MySQL Test Series Part 4

Q1. In MySQL, date values to be enclosed in { } or in single quotation

marks(True/False)

Q2. ______________ is the format of date in MySQL.

Q3. Data type of "name" field in a table is char(25). How many bytes will be

occupied by values "Ram" and "Rohan Kumar"?

Q4. Time data type is used to store time in ________ format.

Q5. Varchar is a fixed length data type.(True/False)

Q6. Name the command which is used to close MySQL.

Q7. Which data type in MySQL is used to store logical values?

Q8. Out of char, varchar and memo, which data type is used to store large

amount of data?

Q9. Which data type in MySQL is used to store images, animations,

clips etc.

Q10. Write the appropriate data types for the following fields.

DateofBirth
Salary
Name
Address
Phonenumber

SOLUTIONS

Q1. In MySQL, date values to be enclosed in { } or in single quotation

marks(True/False)

Ans. True

Q2. ______________ is the format of date in MySQL.

Ans. yyyy/mm/dd

Q3. Data type of "name" field in a table is char(25). How many bytes will be

occupied by values "Ram" and "Rohan Kumar"?

Ans. 25

Q4. Time data type is used to store time in ________ format.

Ans. hh:mm:ss

Q5. Varchar is a fixed length data type.(True/False)

Ans. False

Q6. Name the command which is used to close MySQL.

Ans. quit

Q7. Which data type in MySQL is used to store logical values?

Ans. Boolean

Q8. Out of char, varchar and memo, which data type is used to store large

amount of data?

Ans. memo

Q9. Which data type in MySQL is used to store images, animations,

clips etc.

Ans. BLOB or RAW

Q10. Write the appropriate data types for the following fields.

DateofBirth
Salary
Name
Address
Phonenumber

Ans.

Date
Any numeric data type preferable numeric or decimal.
Char or Varchar
Char or Varchar
Char or Numeric

Computer Science - Informatics Practices Class XI/XII MySQL Test Series Part 3

2020-09-17T10:31:00.006+05:30

Computer Science - Informatics Practices Class XI/XII MySQL Test Series Part 3

Q1. Write two advantages of SQL.

Q2. MySQL is an ___________Software. (open source/Proprietary)

Q3. Name two types of SQL commands.

Q4. What is the difference between DDL and DML Commands?

Q5. Identify the DDL and DML commands from the following.

Create
Alter
Insert
Update
Drop
Delete
Select
Grant
Revoke

Q6. What do you mean by data type?

Q7. Name two numeric data type in MySQL.

Q8. Name two String Data type in MySQL.

Q9. Which data type is used for "Date of birth" field in Student table.

Q10. What is the difference between Char and Varchar.

SOLUTIONS:

Q1. Write two advantages of SQL.

Ans.

It is very easy to learn
It is not a case sensitive language.

Q2. MySQL is an ___________Software. (open source/Proprietary)

Ans. open source

Q3. Name two types of SQL commands.

Ans

Q4. What is the difference between DDL and DML Commands?

Ans.

DDL

DML

It stands for Data Definition Language

These commands allow to perform tasks related to the structure of the table

These commands are used to manipulate data

Q5. Identify the DDL and DML commands from the following.

Create
Alter
Insert
Update
Drop
Delete
Select
Grant
Revoke

Ans

Q6. What do you mean by data type?

Ans. Data type refers to the type of data we are entering in the column of the table.

Q7. Name two numeric data type in MySQL.

Ans. Integer and Smallint

Q8. Name two String Data type in MySQL.

Ans. Char and Varchar

Q9. Which data type is used for "Date of birth" field in Student table.

Ans. Date

Q10. What is the difference between Char and Varchar.

Ans. Char is fixed length data type while Varchar is variable length data type.

Computer Science - Informatics Practices Class XI/XII MySQL Test Series Part 2

2020-09-16T23:55:00.003+05:30

Computer Science - Informatics Practices Class XI/XII MySQL Test Series Part 2

Q1. What do you mean by data redundancy?

Q2. What do you mean by data inconsistency?

Q3. Define the term data model.

Q4. Name 3 types of data models.

Q5. A ___________ is a collection of logically related data.

Q6. Answer the following questions on the basis the given table.

a. How many attributes are there in above table?

b. How many tuples are there in above table?

c. What is the degree of above table?

d. What is the cardinality of above table?

e. Name the primary key in the table.

Q7. Write any five attributes of book entity.

Q8. Write any two advantages of database.

Q9. What is the purpose of creating primary key in table.

Q10. Which field you choose as primary key out of following in "Employee" table

Emp_id
Emp_name
Emp_salary
Emp_desig

Ans 1.

Computer Science - Informatics Practices Class XI/XII MySQL Test Series Part 1

2020-09-16T23:54:00.001+05:30

Computer Science - Informatics Practices Class XI/XII MySQL Test Series Part 1

Q1. Write full form of DBMS.

Q2. Define the following term

Primary Key
Foreign Key
Candidate Key
Alternate Key

Q3. A group of rows and columns is called _______________

Q4. Candidate Key - Primary key = ___________________

Q5. Give two examples of DBMS software.

Q6. What is the difference between Data and Information?

Q7. A primary key is one of the candidate key. (True/False)

Q8. What do you mean by degree and cardinality in DBMS?

Q9. What is the alternate name of column in table?

Q10. What is the alternate name of row in table?

SOLUTIONS:

Q1. Write full form of DBMS.

Ans. Database Management System

Q2. Define the following term

Primary Key
Foreign Key
Candidate Key
Alternate Key

Ans.

A field which uniquely identifies each and every record.
A FOREIGN KEY is a field (or collection of fields) in one table that refers to the PRIMARY KEY in another table. It is used to link two tables.
Those fields which can act as a primary key are called candidates key

Q3. A group of rows and columns is called _______________

Ans Table

Q4. Candidate Key - Primary key = ___________________

Ans. Alternate Key

Q5. Give two examples of DBMS software.

Ans. Oracle, MS Access, MySQL

Q6. What is the difference between Data and Information?

Ans. Raw facts and figures is called Data.

Processed data is called information

Q7. A primary key is one of the candidate key. (True/False)

Ans. True

Q8. What do you mean by degree and cardinality in DBMS?

Ans. Number of rows in a table is called cardinality

Number of columns in a table is called degree.

Q9. What is the alternate name of column in table?

Ans. Attribute and Field

Q10. What is the alternate name of row in table?

Ans. Record and Tuple

Computer Science - Informatics Practices Class XI/XII Python Module Solved Test Part 7

2020-09-14T23:36:00.011+05:30

Computer Science - Informatics Practices Class XI/XII Python Module Solved Test Part 7

Q1. Write a function in python that takes a list of words and returns the

word of longest length.

Q2. Write a function in python that takes a list of words and returns the

word which are starting from capital alphabet.

Q3. Write a function in python that takes a list of words and returns all the

words with last character in upper case.

Q4. Write a function in python that takes a string and convert all lower case

alphabet to upper case and vice-versa.

Q5. Write a function in python that takes a string and replace all vowels by

symbol "?".

Q6. Write a function in python that takes a string and count the characters

in upper case.

Q7. Write a function in python that takes a string and count the number of

vowels.

Q8. Write a function in python that takes a string and count the number of

spaces.

Q9. Write a function in python that takes a string and count the number of

digits in a string.

Q10. Write a function in python that takes a string and sub string and check

whether a sub string is a part of string or not.

Solutions

Ans1:

def longword(a):
  ln=0
  for i in range(len(a)):
    if ln<len(a[i]):
      ln=len(a[i])
      lwrd=a[i]
  print("longest word is",lwrd)
longword(["Amit","Ashish","Anshuman"])

Output is : longest word is Anshuman

Ans 2
def capword(a):
  for i in range(len(a)):
    if a[i][0].isupper():
      print("Result is",a[i])
capword(["amit","Ashish","anshuman"])

Output is : Result is Ashish

Ans 3:
def capword(a):
  for i in range(len(a)):
    if a[i][-1].isupper():
      print("Result is",a[i])
capword(["amiT","Ashish","anshuman"])

Output is : Result is amiT

Ans 4:
def swapcase(a):
  ns=''
  l=len(a)
  for i in range(l):
    if a[i].isupper():
      ns=ns+a[i].lower()
    else:
      ns=ns+a[i].upper()
  print("Result is",ns)
swapcase("Subscribe to My Blog")

Output is: Result is sUBSCRIBE TO mY bLOG

Ans 5:

def swapvow(a):
  ns=''
  l=len(a)
  for i in range(l):
    if a[i] in "aeiouAEIOU":
      ns=ns+'?'
    else:
      ns=ns+a[i]
  print("Result is",ns)
swapvow("Subscribe to My Blog")

Output is : Result is S?bscr?b? t? My Bl?g

Ans 6:

def countupper(a):
  c=0
  l=len(a)
  for i in range(l):
    if a[i].isupper():
      c=c+1
  print("Result is",c)
countupper("Subscribe to My Blog")

Output is : Result is 3

Ans 7:
def countvowel(a):
  c=0
  l=len(a)
  for i in range(l):
    if a[i] in "aeiouAEIOU":
      c=c+1
  print("Result is",c)
countvowel("Subscribe to My Blog")

Output is : Result is 5

Ans 8:

def countspace(a):
  c=0
  l=len(a)
  for i in range(l):
    if a[i].isspace():
      c=c+1
  print("Result is",c)
countspace("Subscribe to My Blog")

Output is : Result is 3

Ans 9:
def countdigit(a):
  c=0
  l=len(a)
  for i in range(l):
    if a[i].isdigit():
      c=c+1
  print("Result is",c)
countdigit("Subscribe 2 My Blog 123")

Output is : Result is 4

Ans 10:

def checksub(a,b):
  if b in a:
    print("Result is","Present")
  else:
        print("Result is","not present")
checksub("Subscribe to My Blog",'to')

Output is : Result is Present

Computer Science - Informatics Practices Class XI/XII Python Module Solved Test Part 6

2020-09-14T00:12:00.005+05:30

Computer Science - Informatics Practices Class XI/XII Python Module Solved Test Part 6

Q1. Name the module to be imported for using mathematical functions.

Q2. Name the module to be imported for generating random numbers.

Q3. Name the module to be imported for text manipulation functions.

Q4. Write the value of the following (till 2 decimal places)

>>> import math

>>>print(math.pi)

>>>print(math.e)

Q5. Name two angle conversion methods of math module.

Q6. degree and radians are functions of _____________ module.

Q7. Write a program in python to find the roots of a quadratic equation.

A quadratic equation is of the form: ax² + bx + c

Accept values of a, b and c from user.

formula of finding root is: x = [-b +/- sqrt(b² - 4ac)]/2a

Q8. Write a program to accept angle in degree and convert it into radian.

Q9. Write a python program to convert binary number to decimal number

Q10. Write a python program to convert decimal number to binary.

Computer Science - Informatics Practices Class XI/XII Python Module Solved Test Part 5

2020-09-11T15:16:00.004+05:30

Computer Science - Informatics Practices Class XI/XII Python Module Solved Test Part 5

Q1. Name the library which is to be imported to use the following functions.

a. log() b. pow()

Q2. Create a module temp.py which contain the following functions.

a. ctk() #which converts degree celsius to kelvin.

b. ctf() #which converts degree celsius to fahrenheit.

Q3. Write a function in2f() in python which takes input in inches and display result in feet. [1feet = 15inches]

Q4. Write the output of the following:

import math

print(math.floor(7.2))

Q5. How modules and packages are related to each other?

Q6. Create a module vol.py which contains the following functions.

a. volcyl() # which calculates volume of cylinder.

b. volcube() # Which calculate volume of cube.

c. volcuboid() #Which calculates volume of cuboid

Q7. What is library in python?

Q8. State the difference between import math and from math import*