Q1
mcq
1 mark
Which of the following is a distinct syntactic block ?
- A. Subroutines
- B. Function
- C. Definition
- D. Modules
Solution hidden
Log in to view solution →
Q2
mcq
1 mark
Which of the following functions that build the abstract data type ?
- A. Constructors
- B. recursive
- C. Destructors
- D. Nested
Solution hidden
Log in to view solution →
Q3
mcq
1 mark
The __________ rule is used to decide the order in which the scopes are to be searched.
- A. LBEG
- B. LEGB
- C. GEBL
- D. GBLE
Solution hidden
Log in to view solution →
Q4
mcq
1 mark
Binary search is also called as __________.
- A. Random search
- B. Linear search
- C. Half-interval search
- D. Sequential search
Solution hidden
Log in to view solution →
Q5
mcq
1 mark
Which operator is also called as conditional operator ?
- A. Logical
- B. Ternary
- C. Assignment
- D. Relational
Solution hidden
Log in to view solution →
Q6
mcq
1 mark
Which of the following is known as definite loop ?
- A. for
- B. do...while
- C. if...else
- D. while
Solution hidden
Log in to view solution →
Q7
mcq
1 mark
Which of the following keyword is used to exit a function block ?
- A. finally
- B. define
- C. def
- D. return
Solution hidden
Log in to view solution →
Q8
mcq
1 mark
The subscript of a string may be :
- A. positive or negative numbers
- B. positive numbers
- C. both positive and negative numbers
- D. negative numbers
Solution hidden
Log in to view solution →
Q9
mcq
1 mark
Which of the following is the output of the given Python code ?
str1 = "Computer Science"
print(str1[::-1])
- A. ecneicS retupmoC
- B. Computer Science
- C. eniS eumC
- D. Cmue Sine
Solution hidden
Log in to view solution →
Q10
mcq
1 mark
Class members are accessed through which operator ?
- A. #
- B. &
- C. %
- D. .
Solution hidden
Log in to view solution →
Q11
mcq
1 mark
Who developed ER model ?
- A. Chend
- B. Chen
- C. Chand
- D. E F Codd
Solution hidden
Log in to view solution →
Q12
mcq
1 mark
Queries can be generated using :
- A. MODIFY
- B. SELECT
- C. ALTER
- D. ORDER BY
Solution hidden
Log in to view solution →
Q13
mcq
1 mark
Making some changes in the data of the existing file or adding more data is called :
- A. Modification
- B. Editing
- C. Alteration
- D. Appending
Solution hidden
Log in to view solution →
Q14
mcq
1 mark
The module which allows to interface with the Windows operating system is :
- A. csv module
- B. OS module
- C. getopt module
- D. sys module
Solution hidden
Log in to view solution →
Q15
mcq
1 mark
Which of the following keyword avoids the duplicate ?
- A. Where
- B. Distinct
- C. GroupBy
- D. Remove
Solution hidden
Log in to view solution →
Q18
short answer
What is the output of the following Python code ?
for x in range(5,20,5):
print(x, end = ' ')
Solution hidden
Log in to view solution →
Q21
short answer
2 marks
Which component of SQL lets insert values in tables and which lets to create a table ?
Solution hidden
Log in to view solution →
Q22
short answer
What is the use of cd command ? Give an example.
Solution hidden
Log in to view solution →
Q24
short answer
What is the output of the following Python code ?
str1=‘WELCOME’
print(str1.islower( ))
print(str1.lower( ))
Solution hidden
Log in to view solution →
Q25
short answer
What are the side effects of Impure function ? Give an example.
Solution hidden
Log in to view solution →
Q27
short answer
What are the assignment operators that can be used in Python ?
Solution hidden
Log in to view solution →
Q28
short answer
Differentiate ceil( ) and floor() functions.
Solution hidden
Log in to view solution →
Q29
short answer
Write the syntax of the following Python list functions.
(i)remove( )
(ii)pop( )
(iii)clear( )
Solution hidden
Log in to view solution →
Q30
short answer
Explain Cartesian product with a suitable example.
Solution hidden
Log in to view solution →
Q31
short answer
Write the difference between reader( ) and DictReader( ).
Solution hidden
Log in to view solution →
Q32
short answer
Mention the difference between fetchone( ) and fetchmany( ).
Solution hidden
Log in to view solution →
Q33
short answer
What will be the output of the following Python code ?
squares=[ ]
for x in range(1,6):
s=x**2
squares.append(s)
print(squares)
Solution hidden
Log in to view solution →
Q34
long answer
(a)Explain pure and impure functions with an example.
OR
(b)Explain the different types of data model.
Solution hidden
Log in to view solution →
Q35
long answer
(a)Explain the different types of operators in Python.
OR
(b)Write the different types of constraints and their functions.
Solution hidden
Log in to view solution →
Q36
long answer
(a)Explain While loop in Python with an example.
OR
(b)Tabulate the different Python file modes with description.
Solution hidden
Log in to view solution →
Q37
long answer
(a)Explain the recursive function with an example.
OR
(b)What is the purpose of sys, os, getopt, modules in Python ? Explain.
Solution hidden
Log in to view solution →
Q38
long answer
(a)Write the output of the following.
A={1,2,3,4,5}
B={4,5,6,7,8}
print(A|B)
print(A&B)
print(A-B)
print(B-A)
print(A^B)
OR
(b)Explain the following SQL aggregate functions with suitable Python statement with SQL query.
(i)AVG( )
(ii)COUNT( )
(iii)SUM( )
(iv)MAX( )
(v)MIN( )
Solution hidden
Log in to view solution →