Which of the following is correct regarding Aggregate functions?

it takes a list of values and return a single values as result

it takes a single value and returns a single value as result

it takes a list of values and return a list of values as result

it takes a single value and returns a list of values as result

If a piece of data is stored in two places in the database, then

both storage space is wasted and changing the data in one spot will cause data inconsistency

changing the data in one spot will cause data inconsistency

What is the order of precedence in python?

Parentheses, Exponential, Multiplication, Division, Addition, Subtraction

Exponential, Parentheses, Multiplication, Division, Addition, Subtraction

Exponential, Parentheses, Division, Multiplication, Addition, Subtraction

Parentheses, Exponential, Multiplication, Division, Subtraction, Addition

Which of the following is true for variable names in Python?

underscore and ampersand are the only two special characters allowed

all private members must have leading and trailing underscores

What is the order of namespaces in which Python looks for an identifier?

Python first searches the local namespace, then the global namespace and finally the built-in namespace

Python first searches the built-in namespace, then the global namespace and finally the local namespace

Python first searches the built-in namespace, then the local namespace and finally the global namespace

Python first searches the global namespace, then the local namespace and finally the built-in namespace

Which of the following is a feature of Python DocString?

In Python all functions should have a docstring

Docstrings can be accessed by the __doc__ attribute on objects

It provides a convenient way of associating documentation with Python modules, functions, classes, and methods

What will be the output of the following Python code? print("Hello {0[0]} and {0[1]}".format(('foo', 'bin')))

Hello (‘foo’, ‘bin’) and (‘foo’, ‘bin’)

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=H, b=O, c=[‘E’, ‘L’]”

“a=’H’, b=’O’, c=(E, L)”

Convention for representing and interacting with objects in html documents

Language dependent application programming

Hierarchy of objects in ASP.NET

Application programming interface

Which of the following is correct about JavaScript?

JavaScript is an Object-Based language

JavaScript is Assembly-language

JavaScript is an Object-Oriented language

JavaScript is a High-level language

Arrays in JavaScript are defined by which of the following statements?

It is an ordered list of values

It is an ordered list of objects

It is an ordered list of string

It is an ordered list of functions

Where is Client-side JavaScript code is embedded within HTML documents?

A URL that uses the special javascript:protocol

A URL that uses the special javascript:code

A URL that uses the special javascript:encoding

A URL that uses the special javascript:stack

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

Hooks can be called in class or function components

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

Hooks can only be called in inside React function components

Which one is valid for inline styling in reactjs

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

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

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

Choose the functionality of setState?

invoke code after the setState operation is done

Access the previous state before the setState operation.

replace this date completely instead of the default merge action

A URL(Uniform Resource Locator) is ______

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

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

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

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

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

communicate and interact with each other

communicate and interact with the Graphical User Interfacer(GUI)

communicate and interact with the Command Line Interface(CLI)

communicate and interact with the binary executable file

KFIN_Tech_Screening_Test_Python_103_Jan'24

Authored by Lilesh Pathe

Computers

Professional Development

Used 1+ times

KFIN_Tech_Screening_Test_Python_103_Jan'24

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View
Student View

60 questions

Show all answers

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Which SQL function is used to count the number of rows in a SQL query?

COUNT()

NUMBER()

SUM()

COUNT(*)

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Which of the following statement is true?

DELETE does not free the space containing the table and TRUNCATE free the space containing the table

Both DELETE and TRUNCATE free the space containing the table

Both DELETE and TRUNCATE does not free the space containing the table

DELETE free the space containing the table and TRUNCATE does not free the space containing the table

MULTIPLE CHOICE QUESTION

1 min • 1 pt

What does the ALTER TABLE clause do?

The SQL ALTER TABLE clause modifies a table definition by altering, adding, or deleting table columns and/or constraints

The SQL ALTER TABLE clause is used to insert data into database table

THE SQL ALTER TABLE deletes data from database table

The SQL ALTER TABLE clause is used to delete a database table

MULTIPLE CHOICE QUESTION

1 min • 1 pt

The UNION SQL clause can be used with _____________

SELECT clause only

DELETE and UPDATE clauses

UPDATE clause only

All of the mentioned

MULTIPLE CHOICE QUESTION

1 min • 1 pt

How can you change “Hansen” into “Nilsen” in the “LastName” column in the Persons table?

UPDATE Persons SET LastName=’Hansen’ INTO LastName=’Nilsen’

MODIFY Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’

MODIFY Persons SET LastName=’Hansen’ INTO LastName=’Nilsen’

UPDATE Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’

MULTIPLE CHOICE QUESTION

1 min • 1 pt

SQL query to find the temperature in increasing order of all cities.

SELECT city FROM weather ORDER BY temperature

SELECT city, temperature FROM weather

SELECT city, temperature FROM weather ORDER BY temperature

SELECT city, temperature FROM weather ORDER BY city

MULTIPLE CHOICE QUESTION

1 min • 1 pt

What is the meaning of LIKE ‘%0%0%’?

Feature begins with two 0’s

Feature ends with two 0’s

Feature has more than two 0’s

Feature has two 0’s in it, at any position

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Microsoft

or continue with

Facebook

Apple

Others

By signing up, you agree to our Terms of Service & Privacy Policy

Already have an account?

Similar Resources on Wayground

56 questions

Manage the Application Life Cycle Lesson 1

Quiz

•

9th Grade - Professio...

61 questions

ITF+ Study Quiz 1

Quiz

•

Professional Development

55 questions

*Computer Science Test*

Quiz

•

KG - Professional Dev...

60 questions

Snow Test Question 60 6.0

Quiz

•

Professional Development

60 questions

Microprocessor 8085

Quiz

•

Professional Development

64 questions

CompTIA Security + : Architecture and Design

Quiz

•

Professional Development

55 questions

WP 11-15

Quiz

•

Professional Development

60 questions

ข้อสอบ ปลายภาค วิชาพื้นฐานธุรกิจดิจิทัล

Quiz

•

Professional Development

Popular Resources on Wayground

10 questions

How much do you know about our Portrait of an Eagle?

Quiz

•

10th Grade

10 questions

Fast Food Slogans

Quiz

•

6th - 8th Grade

21 questions

Continents and Oceans

Quiz

•

6th Grade

20 questions

Parts of Speech

Quiz

•

5th Grade

16 questions

Subject & Predicate

Quiz

•

5th Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

12 questions

Map Skills

Quiz

•

3rd Grade

22 questions

Continents and Oceans

Quiz

•

5th Grade

Discover more resources for Computers

10 questions

How to Email your Teacher

Quiz

•

Professional Development

11 questions

NFL Football logos

Quiz

•

KG - Professional Dev...

14 questions

Fall Trivia

Quiz

•

11th Grade - Professi...

20 questions

Sports trivia

Quiz

•

Professional Development

20 questions

90s Cartoons

Quiz

•

Professional Development

20 questions

Block Buster Movies

Quiz

•

10th Grade - Professi...

KFIN_Tech_Screening_Test_Python_103_Jan'24

Which SQL function is used to count the number of rows in a SQL query?

Which of the following statement is true?

What does the ALTER TABLE clause do?

The UNION SQL clause can be used with _____________

How can you change “Hansen” into “Nilsen” in the “LastName” column in the Persons table?

SQL query to find the temperature in increasing order of all cities.

What is the meaning of LIKE ‘%0%0%’?

_______ allow us to identify uniquely a tuple in the relation.

Logical design of database is called

Which of the following is correct regarding Aggregate functions?

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers