KFIN_Tech_Screening_Test_Python_103_Jan'24

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

• COUNT()
• NUMBER()
• SUM()
• COUNT(*)

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

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

The UNION SQL clause can be used with _____________

• SELECT clause only
• DELETE and UPDATE clauses
• UPDATE clause only
• All of the mentioned

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’

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

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

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

• schema
• superkey
• domain
• attribute

Logical design of database is called

• all of the options
• database schema
• database instance
• database snapshot

Which of the following is correct regarding Aggregate functions?

• it takes a single value and returns a single value as result
• it takes a list of values and return a single values 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