Scribd
Upload
21 views2 pages

Python and SQL Code Output Questions

Uploaded by

Vinoothitha - 9139
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
21 views2 pages

Python and SQL Code Output Questions

Uploaded by

Vinoothitha - 9139
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

State if the following statement is True or False:

Using the statistics module, the output of the below statements will be 20:
import statistics
[Link]([10, 20, 10, 30, 10, 20, 30])

What will be the output of the following code?


L = ["India", "Incredible", "Bharat"]
print(L[1][0] + L[2][-1])
a) IT b) it c) It d) iT

print(19<11 and 29>19 or not 75>30)


Which of the following will be the correct output of the given expression?
a) True b) False c) Null d) No output

In SQL, which type of Join(s) may contain duplicate column(s)?

What will be the output of the following Python code?


str= "Soft Skills"
print(str[-3::-3])
a) lSf b) Stkl c) StKi d) l

Write the output of the following Python code:


for k in range(7,40,6):
print(k + '-')

What will be the output of the following Python statement:


print(10-3**2**2+144/12)

Consider the given SQL Query:


SELECT department, COUNT(*) FROM employees HAVING COUNT(*) > 5 GROUP BY
department;

What will be the output of the following Python code?


try:
x = 10 / 0
except Exception:
print("Some other error!")
except ZeroDivisionError:
print("Division by zero error!")
a) Division by zero error! b) Some other error!
c) ZeroDivisionError d) Nothing is printed
What will be the output of the following Python code?
my_dict = {"name": "Alicia", "age": 27, "city": "DELHI"}
print(my_dict.get("profession", "Not Specified"))
a) Alicia b) DELHI c) None d) Not Specified

What possible output


import random
L=[10,30,50,70]
Lower=[Link](2,2)
Upper=[Link](2,3)
for K in range(Lower, Upper+1):
print(L[K], end="@")
a) 50@70@ b) 90@ c) 10@30@50@ d) 10@30@50@70@

What will be the output of the following Python code?


i=5
print(i,end='@@')
def add():
global i
i+=7
print(i,end='##')
add()
print(i,end='##')
a) 5@@12##15## b) 5@@5##12## c) 5@@12##12## d) 12@@12##12##

Which SQL command can change the cardinality of an existing relation?


a) Insert b) Delete c) Both a) & b) d) Drop

What is the output of the given Python code?


st='Waterskiing is thrilling!'
print([Link]("i"))
a) ['Watersk', 'ng ', 's thr', 'll', 'ng!'] b) ['Watersk', '', 'ng ', 's thr', 'll', 'ng!']
c) ['Watersk', 'i', 'ng ', 's thr', 'll', 'ng!'] d) Error

In SQL, a relation consists of 5 columns and 6 rows. If 2 columns and 3 rows are added
to the existing relation, what will be the updated degree of a relation?
a) Degree: 7 b) Degree: 8 c) Degree: 9 d) Degree: 6

Which SQL command is used to remove a column from a table in MySQL?


a) UPDATE b) ALTER c) DROP d) DELETE

Common questions

Powered by AI

The 'GROUP BY' clause in SQL groups rows that have the same values in specified columns into summary rows. Having COUNT(*) > 5 filters these groups, retaining only groups with more than 5 entries. Unlike WHERE, HAVING is applied after grouping, hence designed for filtered grouped operations.

The median of the list [10, 20, 10, 30, 10, 20, 30] is 20. This is because the list, when sorted, is [10, 10, 10, 20, 20, 30, 30], and the middle value is 20. Thus, the output is 20.

A 'LEFT JOIN' can result in duplicate columns if both joined tables have columns with the same name. This is resolved by specifically selecting columns or using aliases to distinguish between them.

The expression '3**2**2' is evaluated with right-to-left associativity, resulting in '3**4'=81. The 144/12 is evaluated as 12. Thus, the statement '10 - 81 + 12' simplifies to -59. So, the output is -59.

The expression L[1][0] accesses the first character of the second string, "Incredible", which is 'I'. L[2][-1] accesses the last character of the third string, "Bharat", which is 't'. Thus, concatenating these gives 'It'.

To remove a column from a table, the 'ALTER TABLE ... DROP COLUMN ...' command is used. Choosing the right command is crucial because operations like UPDATE modify data rather than the schema, and DELETE removes entire rows rather than specific columns. Accuracy prevents unwanted loss or changes.

In Python, when an exception occurs, the first 'except' block that matches the exception type is executed. In the provided code, although 'ZeroDivisionError' is derived from 'Exception', the presence of 'except Exception' before 'except ZeroDivisionError' causes the code to print 'Some other error!' when a ZeroDivisionError occurs, as 'except Exception' matches all exceptions before specific handler.

The 'global' keyword is used in Python to allow modifications of a variable that is defined at the module level (outside the function scope). In the code, 'global i' inside the function 'add' allows the modification of 'i' from 5 to 12 to be reflected globally. Later modifications without 'global' will reference this global 'i'.

Cardinality in SQL refers to the number of rows in a table. INSERT increases cardinality by adding rows, DELETE decreases it by removing rows. Both operations affect the table’s cardinality.

The slicing operation str[-3::-3] starts at index -3 ('i' in "Skills") and moves backwards in steps of 3, selecting 'S', and finally the first character, 'f'. This results in 'lSf'. This demonstrates reverse iteration with steps, useful for selecting specific patterns in a string.

You might also like