Free Printable infytq sample test 2

Worksheets

infytq sample test 2

Total questions: 60

Worksheet time: 3600secs

Name

Class

Date

What is Python?

text based programming language

word processor

spreadsheet

block based programming language

Чему равно "a" после выполнения программы?

a = 2

If a<3:

print(a+1)

else:

print(a-1)

x = 3

c = 0

while x > 1:

c = c +1

x = x -1

Which one will display when this code is run?

What letter will be printed on the screen after running this code:

Nothing prints

What is the output from this program?

5
7
9
A python is a non-venomous snake
done

A python is a non-venomous snake
A python is a non-venomous snake
A python is a non-venomous snake
done

A python is a non-venomous snake
A python is a non-venomous snake
A python is a non-venomous snake
A python is a non-venomous snake
done

done

What output will this code produce?

blue

green

red

error

What output will this code produce?

red

['blue', 'green', 'red']

['red', 'green', 'blue']

error

What will the output be from the following code?
print("3*4+5")

SyntaxErrror

3*4+5

10.

cakeAmount = raw_input()

print "We have", cakeAmount, " cakes"

The above code is run. You type:

six

Select the correct output.

We have six cakes

We have 6 cakes

We havesix cakes

Syntax Error

11.

age = input("Enter Age (as integer): ")

newAge = age + 20

print ("your age in 20 years is:", newAge)

you enter

value of age is 15

value of newAge is 35

output is: your age in 20 years is: 35

value of age is 15

value of newAge is 20

output is: your age in 20 years is: 20

value of age is 15

value of newAge is "age + 20"

output is: your age in 20 years is: 35

value of age is 15

value of newAge is 35

output is: your age in 20 years is:35

12.

Let x= "Python", the output of

print(x[0])

print(x[-1])

print(x[-2])

13.

What will this code print?

Print the word 'letter'.

Print a user input on one line.

Print a user input one letter at a time.

Print an Error.

14.

What will be the output of this code?

1,2,3,4,5,6,7,8,9,10,11,12

0,2,4,6,8,10

2,4,6,8,10,12

2,4,6,8,10

15.

Look at this code, what shape will it make?

Square

Triangle

Rectangle

Hexagon

16.

What is the output from this code?

A sequence of four orange triangles

An orange triangle and an orange square

A sequence of three orange squares

Error

17.

What output will this code produce?

['France', 'Wales', 'England']
France

['France', 'Wales', 'England']
Wales

France, Wales, England
Wales

France Wales England
France

18.

What output will this code produce?

red

['blue', 'green', 'red']

['red', 'green', 'blue']

error

19.

How many times will Boo print?

none

20.

How many times will Boo print?

none

21.

What will print?

1 2

22.

Find the Output:

Item = {"ECE" , "CSE" , "EEE" , "CIVIL"}

Item.add (2,"MECH")

print(Item)

{ "ECE" , "MECH" , "CSE" , "EEE" , "CIVIL" }

{ "ECE" , "CSE" , "MECH" , "EEE" , "CIVIL" }

{ "ECE" , "CSE" , "EEE" , "CIVIL" }

{ "ECE" , "CSE" , "EEE" ,"MECH" , "CIVIL" }

23.

What is the output for the below code

a=b=c = 1,2,3

print(a,b,c)

1 2 3

(1, 2, 3) (1, 2, 3) (1, 2, 3)

Syntax Error

Logical Error

24.

Integrity constraints ensure that changes made to the database by authorized users do not result into loss of data consistency. Which of the following statement(s) is (are) true w.r.t. the examples of integrity constraints ?

(i) An instructor Id. No. cannot be null, provided Intructor Id No. being primary key.

(ii) No two citizens have same Adhar-Id.

(iii) Budget of a company must be zero.

(i), (ii) and (ii) are true.

(i) false, (ii) and (iii) are true.

(i) and (ii) are true; (iii) false.

25.

error

none of the mentioned

26.

[[[0]], [[[0]], [1]], [[[0]], [[[0]], [1]], [2]]]

[[0], [[0], 1], [[0], [[0], 1], 2]]

[0, None, 1, None, 2, None]

[[[0]], [[[0]], [1]], [[[0]], [[[0]], [1]], [2]]]

27.

Welcome# 111#924.66

Welcome#111#924.66

Welcome#111#.66

Welcome # 111#924.66

28.

To retrieve the character at index 3 from string s=”Hello” what command do we execute (multiple answers allowed)?

s[]

s.getitem(3)

s.__getitem__(3)

s.getItem(3)

29.

True False

True True

Run Time Error

False False

30.

What function do you use to read a string?

input(“Enter a string”)

eval(input(“Enter a string”))

enter(“Enter a string”)

eval(enter(“Enter a string”))

31.

Suppose list1 is [2, 33, 222, 14, 25], What is list1[:-1]?

[2, 33, 222, 14]

Error

[25, 14, 222, 33, 2]

32.

33.

Suppose listExample is [3, 4, 5, 20, 5, 25, 1, 3], what is list1 after listExample.pop()?

[3, 4, 5, 20, 5, 25, 1]

[1, 3, 3, 4, 5, 5, 20, 25]

[3, 5, 20, 5, 25, 1, 3]

[1, 3, 4, 5, 20, 5, 25]

34.

What will be the output of the following Python code?

"Welcome to Python".split()

[“Welcome”, “to”, “Python”]

(“Welcome”, “to”, “Python”)

{“Welcome”, “to”, “Python”}

“Welcome”, “to”, “Python”

35.

The program prints two rows 3 4 5 1 followed by 33 6 1 2

The program prints on row 3 4 5 1 33 6 1 2

The program prints two rows 3 4 5 1 followed by 33 6 1 2

The program prints two rows 1 3 4 5 followed by 1 2 6 33

36.

[[1, 2], [3, 1.5], [0.5, 0.5]]

[[3, 1.5], [1, 2], [0.5, 0.5]]

[[0.5, 0.5], [1, 2], [3, 1.5]]

[[0.5, 0.5], [3, 1.5], [1, 2]]

37.

What will be the output of the following Python code?

print("xyyzxyzxzxyy".count('xyy', -10, -1))

error

38.

Find the names of these cities with temperature and condition whose condition is neither sunny nor cloudy.

SELECT city, temperature, condition FROM weather WHERE condition NOT IN (‘sunny’, ‘cloudy’)

SELECT city, temperature, condition FROM weather WHERE condition NOT BETWEEN (‘sunny’, ‘cloudy’)

SELECT city, temperature, condition FROM weather WHERE condition IN (‘sunny’, ‘cloudy’)

SELECT city, temperature, condition FROM weather WHERE condition BETWEEN (‘sunny’, ‘cloudy’);

39.

With SQL how can I return all items in the Item table sorted from the lowest priced to the highest priced?

SELECT * FROM Items ORDER BY Price ASCENDING

SELECT * FROM Items ORDER BY Price ASC

SELECT * FROM Items BY Price LOWEST TO HIGHEST

SELECT * FROM Items ORDER BY Price DESC

40.

With SQL, how can you return the number of records in the "Persons" table?

SELECT NO(*) FROM Persons

SELECT COUNT(*) FROM Persons

SELECT LEN(*) FROM Persons

41.

Write a code for the following: Return the names and imdb_ratings of all movies with ‘day’ in the name.

SELECT * FROM movies WHERE name LIKE ‘day’;

RETURN name, imdb_rating FROM movies WHERE name LIKE '%day%';

SELECT name, imdb_rating FROM movies WHERE name LIKE '%day%';

SELECT * FROM movies WHERE imdb_rating AND name LIKE ‘%day%’;

42.

ANSWER: SELECT id, name, year FROM movies WHERE year > 2010;

ANSWER: SELECT id, name, year FROM movies WHERE year < 2010;

ANSWER: SELECT * FROM movies WHERE year > 2010;

ANSWER: SELECT id, name, year FROM movies WHERE YEAR > 2010;

43.

Return the name and genre of each movie with an imdb_rating greater than 5 and year greater than 2012.

SELECT * FROM movies WHERE imdb_rating > 5 AND year > 2012;

SELECT name, genre FROM movies WHERE imdb_rating < 5 AND year < 2012;

SELECT name, year FROM movies WHERE imdb_rating > 5 year > 2012;

SELECT name, genre FROM movies WHERE imdb_rating > 5 AND year > 2012;

44.

SELECT * FROM movies WHERE genre = 'horror' AND imdb_rating >= 7 LIMIT 8; ORDER BY ASC LIMIT 8;

SELECT * FROM movies WHERE genre = 'horror' AND imdb_rating >= 7 LIMIT 8;

SELECT * FROM movies WHERE imdb_rating >= 7 LIMIT 8;

SELECT * FROM movies WHERE genre = 'horror' AND imdb_rating >= 7;

45.

SELECT genre, year FROM movies WHERE genre = 'action' ORDER BY year ASC LIMIT 11;

SELECT genre, year FROM movies WHERE genre = action ORDER BY year DESC LIMIT 11;

none of these

SELECT genre, year FROM movies WHERE genre = 'action' ORDER BY year DESC LIMIT 11;

46.

SELECT * FROM movies WHERE genre = 'romance' AND imdb_rating > 7.5 ORDER BY year DESC LIMIT 4;

SELECT * FROM movies WHERE genre = 'romance' AND imdb_rating > 7.5 ORDER BY year ASC LIMIT 4;

SELECT * FROM movies WHERE genre = romance AND imdb_rating > 7.5 ORDER BY year DESC LIMIT 4;

SELECT * FROM movies WHERE genre = 'romance' AND imdb_rating < 7.5 ORDER BY year DESC LIMIT 4;

47.

v_num is not equal to v_char

compilation error

v_num is equal to v_char

runtime error

48.

Which choice shows what I will see on the screen after the following block is executed?

-1

VALUE_ERROR

-1

TOO_MANY_ROWS

NO ERROR

49.

Match SQL language with SQL commands

1)DDL i)Revok, Grant

2)DML ii)rename a table

3)TCL iii)insert, update

4)DCL iv)rollback , commit

1-iii,2-i,3-ii,4-iv

1-iii,2-ii,3-iv,4-i

1-ii,2-iii,3-iv,4-i

1-i,2-iii,3-ii,4-iv

50.

The Entity Customer has three candidate keys: a) CustId b) Email and c) ContactNo. Suggest the best primary key for this entity.

CustId

ContactNo

CustId and ContactNo

51.

Which of the following is spelled correctly?

recreation

rekreation

recreasion

recreetion

52.

Find the odd one out

53.

54.

The time of the watch is

2:31

3:13

3:55

4:37

What will be the next time?

5:25

5:00

5:19

5:05

55.

If 20% of a = b, then b% of 20 is same as

4% of a

5% of a

20% of a

None of these

56.

Accept means

consent to receive

natural ability

buy or obtain

to try

57.

if 15% of (A+B) = 25% of (A-B), then what percent of B is equal to A?

(a)

58.

A sum of money at simple interest doubles in 7 years. It will becomes four times in

18years

21years

38years

42years

59.

In how many ways can the letters of the word MACHINE be arranged so that the vowels may occupy the odd Positions

576

210

144

1024

60.

The small child does whatever his father was done.

has done

did

does

had done

No correction required

Reset

infytq sample test 2

Total questions: 60

Worksheet time: 3600secs

Similar Resources on Wayground