SQL & PANDAS Quiz
Authored by Data Alpha
Business
Professional Development
Used 1+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
12 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 4 pts
SQL: which keyword is used to read /query value from a table in a database?
SELECT
UPDATE
DELETE
JOIN
2.
MULTIPLE CHOICE QUESTION
30 sec • 4 pts
Which of the following statements is true about the SELECT statement in Google BigQuery?
It specifies the tables to be included in the query
It specifies the columns to be included in the query result
It specifies the conditions for filtering the query result
3.
MULTIPLE CHOICE QUESTION
30 sec • 5 pts
In Google BigQuery, which keyword is used to specify the table or tables from which you want to retrieve data?
WHERE
GROUP
FROM
Setting
4.
MULTIPLE CHOICE QUESTION
30 sec • 5 pts
Which of the following statements is true about the WHERE clause in Google BigQuery?
It specifies the columns to be included in the query result
It specifies the tables to be included in the query
It specifies the conditions for filtering the query result
5.
MULTIPLE CHOICE QUESTION
30 sec • 5 pts
Which of the following methods is used to create an empty DataFrame in Pandas?
pd.empty()
pd.DataFrame()
pd.zeros()
pd.ones()
6.
MULTIPLE CHOICE QUESTION
30 sec • 2 pts
What is the Pandas method used to merge two DataFrames based on a common column?
df.merge()
df.plus()
df + df
7.
MULTIPLE CHOICE QUESTION
30 sec • 5 pts
Which method is used to remove columns from a Pandas DataFrame?
df - column name
df.remove()
df.erase()
df.drop()
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
%20(1).png)
Apple
Others
Already have an account?
