SQL & PANDAS Quiz

SQL: which keyword is used to read /query value from a table in a database?

• SELECT

• UPDATE

• DELETE

• JOIN

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

In Google BigQuery, which keyword is used to specify the table or tables from which you want to retrieve data?

• WHERE

• GROUP

• FROM

• Setting

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

Which of the following methods is used to create an empty DataFrame in Pandas?

• pd.empty()

• pd.DataFrame()

• pd.zeros()

• pd.ones()

What is the Pandas method used to merge two DataFrames based on a common column?

• df.merge()

• df.plus()

• df + df

Which method is used to remove columns from a Pandas DataFrame?

• df - column name

• df.remove()

• df.erase()

• df.drop()

What is the Pandas method used to group a DataFrame by a specific column or set of columns?

• df.group_by()

• df.groupby()

• df.segment()

• df.split()

Which method is used to select a single column from a Pandas DataFrame and return a Series object?

• df.select()

• df.get()

• df[] or df['column_name']

Which method is used to fill the missing values in a Pandas DataFrame with a specified value?

• df.fill_missing()

• df.fillna()

• df.replace_missing()

• df.replace_na()