Python and SQL Quiz

What will be the output of the following code? python CopyEdit import pandas as pd A = pd.Series(data=[35,45,55,40]) print(A == data)

• True

• False

• [35,45,55,40]

• Error

What will be the output of the following code? python CopyEdit s = pd.Series([1,2,3,4,5], index=['akram','brijesh','charu','deepika','era']) print(s['charu'])

• 1

• 2

• 3

• 4

Which clause is used to group result of an SQL query?

• Order by

• Group in

• Groups by

• Group by

Choose the correct code to print the shape of a Series S1. python CopyEdit S1 = pd.Series([5,6,7,8,10], index=['v','w','x','y','z'])

• print(S1.shape())

• print(S1.shape)

• print(S1.values)

• print(S1.size())

Which import statement is invalid in Python?

• import pandas as CLASS12

• import pandas as 1pd

• import pandas as pd1

• import pandas as pd

Command to install pandas library using pip:

• install pip pandas

• install pandas

• pip pandas

• pip install pandas

Purpose of the WHERE clause in SQL is to:

• Create a table

• Filter rows based on condition

• Specify columns to display

• Sort result

What does animal[::-3] return in Python Series?

• Reversed Series

• Every third item from end

• First 3 items

• Error

Which of the following defines a Series in Pandas?

• One-dimensional labeled array

• Two-dimensional array

• SQL table

• Column list only

Which Pandas structure holds rows and columns like an SQL table?

• Series

• DataList

• DataFrame

• FrameSeries