wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

KFIN_Tech_Screening_Test_Python_103_Jan'24

Total questions: 60

Worksheet time: 3600secs

Name
Class
Date
1.
Which SQL function is used to count the number of rows in a SQL query?
a)
COUNT()
b)
NUMBER()
c)
SUM()
d)
COUNT(*)
2.
Which of the following statement is true?
a)
DELETE does not free the space containing the table and TRUNCATE free the space containing the table
b)
Both DELETE and TRUNCATE free the space containing the table
c)
Both DELETE and TRUNCATE does not free the space containing the table
d)
DELETE free the space containing the table and TRUNCATE does not free the space containing the table
3.
What does the ALTER TABLE clause do?
a)
The SQL ALTER TABLE clause modifies a table definition by altering, adding, or deleting table columns and/or constraints
b)
The SQL ALTER TABLE clause is used to insert data into database table
c)
THE SQL ALTER TABLE deletes data from database table
d)
The SQL ALTER TABLE clause is used to delete a database table
4.
The UNION SQL clause can be used with _____________
a)
SELECT clause only
b)
DELETE and UPDATE clauses
c)
UPDATE clause only
d)
All of the mentioned
5.
How can you change “Hansen” into “Nilsen” in the “LastName” column in the Persons table?
a)
UPDATE Persons SET LastName=’Hansen’ INTO LastName=’Nilsen’
b)
MODIFY Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’
c)
MODIFY Persons SET LastName=’Hansen’ INTO LastName=’Nilsen’
d)
UPDATE Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’
6.
SQL query to find the temperature in increasing order of all cities.
a)
SELECT city FROM weather ORDER BY temperature
b)
SELECT city, temperature FROM weather
c)
SELECT city, temperature FROM weather ORDER BY temperature
d)
SELECT city, temperature FROM weather ORDER BY city
7.
What is the meaning of LIKE ‘%0%0%’?
a)
Feature begins with two 0’s
b)
Feature ends with two 0’s
c)
Feature has more than two 0’s
d)
Feature has two 0’s in it, at any position
8.
_______ allow us to identify uniquely a tuple in the relation.
a)
schema
b)
superkey
c)
domain
d)
attribute
9.
Logical design of database is called
a)
all of the options
b)
database schema
c)
database instance
d)
database snapshot
10.
Which of the following is correct regarding Aggregate functions?
a)
it takes a single value and returns a single value as result
b)
it takes a list of values and return a single values as result
c)
it takes a list of values and return a list of values as result
d)
it takes a single value and returns a list of values as result
11.
The attribute that can be divided into other attributes is called
a)
composite attribute
b)
derived attribute
c)
simple attribute
d)
multi-valued attribute
12.
_____________ refers to the correctness and completeness of the data in a database?
a)
data independence
b)
data integrity
c)
data security
d)
data constraint
13.
A table that displays data redundancies yields ____________ anomalies
a)
insertion
b)
deletion
c)
update
d)
all of the options
14.
A type of query that is placed within a WHERE or HAVING clause of another query is called
a)
multi-query
b)
sub query
c)
super query
d)
master query
15.
If a piece of data is stored in two places in the database, then
a)
in can be more easily accessed
b)
both storage space is wasted and changing the data in one spot will cause data inconsistency
c)
storage space is wasted
d)
changing the data in one spot will cause data inconsistency
16.
Which of the following functions can help us to find the version of python that we are currently working on?
a)
sys.version(1)
b)
sys.version(0)
c)
sys.version()
d)
sys.version
17.
What is the order of precedence in python?
a)
Exponential, Parentheses, Multiplication, Division, Addition, Subtraction
b)
Exponential, Parentheses, Division, Multiplication, Addition, Subtraction
c)
Parentheses, Exponential, Multiplication, Division, Subtraction, Addition
d)
Parentheses, Exponential, Multiplication, Division, Addition, Subtraction
18.
What will be the output of the following Python code snippet if x=1? x << 2
a)
4
b)
2
c)
1
d)
8
19.
Which of the following is true for variable names in Python?
a)
underscore and ampersand are the only two special characters allowed
b)
unlimited length
c)
all private members must have leading and trailing underscores
d)
none of the mentioned
20.
What is the order of namespaces in which Python looks for an identifier?
a)
Python first searches the built-in namespace, then the global namespace and finally the local namespace
b)
Python first searches the built-in namespace, then the local namespace and finally the global namespace
c)
Python first searches the local namespace, then the global namespace and finally the built-in namespace
d)
Python first searches the global namespace, then the local namespace and finally the built-in namespace
21.
What will be the output of the following Python code snippet? for i in [1, 2, 3, 4][::-1]: print(i, end=' ')
a)
4 3 2 1
b)
Error
c)
1 2 3 4
d)
none of the mentioned
22.
Which of the following is a feature of Python DocString?
a)
In Python all functions should have a docstring
b)
Docstrings can be accessed by the __doc__ attribute on objects
c)
It provides a convenient way of associating documentation with Python modules, functions, classes, and methods
d)
All of the mentioned
23.
What will be the output of the following Python code? print("Hello {0[0]} and {0[1]}".format(('foo', 'bin')))
a)
Hello (‘foo’, ‘bin’) and (‘foo’, ‘bin’)
b)
Error
c)
Hello foo and bin
d)
None of the mentioned
e)
Hello f and o
24.
What will be the output of the following Python code? l=list('HELLO') p=l[0], l[-1], l[1:3] 'a={0}, b={1}, c={2}'.format(*p)
a)
Error
b)
“a=’H’, b=’O’, c=(E, L)”
c)
“a=H, b=O, c=[‘E’, ‘L’]”
d)
Junk value
25.
What will be the output of the following Python code? m=reduce(lambda x: x-3 in range(4, 10)) print(list(m))
a)
[1, 2, 3, 4, 5, 6, 7]
b)
No output
c)
[1, 2, 3, 4, 5, 6]
d)
Error
26.
Write a list comprehension for number and its cube for l=[1, 2, 3, 4, 5, 6, 7, 8, 9].
a)
[x**3 for x in l]
b)
[x^3 for x in l]
c)
[x**3 in l]
d)
[x^3 in l]
27.
Which of the following is used to read an HTML page and render it?
a)
Web server
b)
Web network
c)
Web browser
d)
Web matrix
28.
What is DOM in HTML?
a)
Language dependent application programming
b)
Hierarchy of objects in ASP.NET
c)
Application programming interface
d)
Convention for representing and interacting with objects in html documents
29.
Which of the following is not the element associated with the HTML table layout?
a)
alignment
b)
color
c)
size
d)
spanning
30.
HTML is a subset of ___________
a)
SGMT
b)
SGML
c)
SGME
d)
XHTML
31.
Which of the following tag is used to embed css in html page?
a)
<css>
b)
<!DOCTYPE html>
c)
<script>
d)
<style>
32.
Which of the following CSS property sets the shadow for a box element?
a)
set-shadow
b)
box-shadow
c)
shadow
d)
canvas-shadow
33.
Which of the following CSS Property sets the stacking order of positioned elements?
a)
y-index
b)
z-index
c)
x-index
d)
all of the mentioned
34.
A similar rule called the ____________ is specified using the plus sign (+) and is used to select elements that would be siblings of each other.
a)
class selectors
b)
attribute selectors
c)
adjacent-sibling selector
d)
none of the mentioned
35.
Which of the following is correct about JavaScript?
a)
JavaScript is an Object-Based language
b)
JavaScript is Assembly-language
c)
JavaScript is an Object-Oriented language
d)
JavaScript is a High-level language
36.
Arrays in JavaScript are defined by which of the following statements?
a)
It is an ordered list of values
b)
It is an ordered list of objects
c)
It is an ordered list of string
d)
It is an ordered list of functions
37.
Which of the following is not javascript data types?
a)
Null type
b)
Undefined type
c)
Number type
d)
All of the mentioned
38.
Where is Client-side JavaScript code is embedded within HTML documents?
a)
A URL that uses the special javascript:code
b)
A URL that uses the special javascript:protocol
c)
A URL that uses the special javascript:encoding
d)
A URL that uses the special javascript:stack
39.
Which of the following is not an error in JavaScript?
a)
Missing of Bracket
b)
Division by zero
c)
Syntax error
d)
Missing of semicolons
40.

Props are __________ into other components

a)

Injected

b)

Methods

c)

Both A and B

d)

All of these

41.

Keys are given to a list of elements in react. These keys should be -

a)

Unique in the DOM

b)

Do not requires to be unique

c)

Unique among the siblings only

d)

All of the above

42.

How do you access a function fetch() from a h1 element in JSX?

a)

<h1>{fetch()}</h1> 

b)

<h1>${fetch()}</h1> 

c)

<h1>{fetch}</h1> 

d)

<h1>${fetch}</h1>

43.

Which of the following is NOT a rule for React Hooks?

a)

Hooks cannot be conditional

b)

Hooks can only be called at the top level of a component

c)

Hooks can be called in class or function components

d)

Hooks can only be called in inside React function components

44.

Which one is valid for inline styling in reactjs

a)

<div style={{ backgroundColor: 'red', fontSize: '16px' }} > Hello World! </div>

b)

<div style={{ background-color: 'red', font-size: '16px' }} > Hello World! </div>

c)

<div style="background-color: red; font-size: 16px" > Hello World! </div>

d)

all of the above

45.

Choose the functionality of setState?

a)

Access the previous state before the setState operation.

b)

invoke code after the setState  operation is done

c)

replace this date completely instead of the default merge action

d)

none of the above

46.

What is the communication protocol of Web and API servers

a)

IP

b)

HTML

c)

HTTP

d)

WebSocket

47.

A URL(Uniform Resource Locator) is ______

a)

a standardized address used to identify and locate resources on the internet.

b)

a standardized address used to identify and locate traffic on the internet.

c)

a standardized address used to identify and locate points on the internet.

d)

a standardized address used to identify and locate ports on the internet.

48.

What are the principles of REST API

a)

Resource-based

b)

Stateless

c)

Uniform Interface

d)

All of the options

49.

API(Application Programming Interface) is a general concept that referes to a set of rules and protocols that allow different software application to ______

a)

communicate and interact with each other

b)

communicate and interact with the Graphical User Interfacer(GUI)

c)

communicate and interact with the Command Line Interface(CLI)

d)

communicate and interact with the binary executable file

50.

To listen for connections, what function would you use?

a)

app.listen

b)

app.serve

c)

app.connect

d)

app.start

51.

One of these is used to send a JSON object to the client

a)

res.send()

b)

res.json()

c)

res.status()

d)

res.render()

52.

What method do we use to apply a middleware in express

a)

app.use(middleware)

b)

app.apply(middleware)

c)

app.config(middleware)

d)

app.render(middleware)

53.

Which component ends the request cycle provided all business logic are met?

a)

Middleware

b)

Controller

c)

Request Hanlder

d)

None of the options

54.

We want to get the records for all users, but we want only their names. Choose the right option?

a)

select * from users

b)

select id from users

c)

select from users where name

d)

select name from users

55.

Which MongoDB update method updates a single document matching the specified criteria

a)

updateOne()

b)

updateMany()

c)

update()

d)

findOneAndUpdate()

56.

What is the purpose of the find method in MongoDB?

a)

To update documents in a collection

b)

To delete documents from a collection

c)

To insert documents into a collection

d)

To query documents in a collection

57.

The analysis phase ____________________

a)

Determines what the program will do

b)

Determines how the program will work

c)

Determines whether or not the program works

d)

Adds new features to the delivered program

58.

Which of the following is not a software development process model

a)

Waterfall model

b)

Risk Identification model

c)

Spiral model

d)

Non of the above

59.

Fill in the blank.


We store all these information into something call _________ which has Tables that includes rows and columns.

a)

API

b)

database

c)

client

d)

JSON

60.

The software development approach that is characterised by distinct stages is the:

a)

waterfall approach.

b)

rapid application development approach.

c)

prototyping approach.

d)

end user approach.