Data Analytics Internship Quiz 7

Which SQL function is used to extract the year from a date?

• YEAR()

• DATE_YEAR()

• EXTRACT_YEAR()

• GET_YEAR()

What does the SQL function DATEADD() do?

• Adds two dates together

• Adds a specified time interval to a date

• Compares two dates

• Retrieves the current date and time

In Python, which function is used to get the current date and time?

• datetime.now()

• current_datetime()

• get_date_time()

• today_datetime()

In SQL, what is the purpose of the GROUP BY clause?

• filter records based on a condition

• To sort records in ascending order

• To group rows that have the same values in specified columns

• To join multiple tables

Which of the following SQL functions is used to find the total number of rows in a table?

• COUNT()

• SUM()

• AVG()

• MAX()

What SQL keyword is used to filter the results of a query based on a specified condition?

• WHERE

• FILTER

• HAVING

• CONDITION

What is the purpose of the SQL JOIN clause?

• To combine rows from two or more tables based on a related column

• To filter records based on a condition

• To group rows that have the same values

• To sort records in descending order

Which SQL command is used to remove all records from a table without removing the table itself?

• delete

• truncate

• update

• select

Which of the following are some common RDBMS in use?

• Oracle

• Mysql

• HeidiSql

• All the above

What does the following statement in SQL do?

DROP TABLE student;

• Deletes a table called student

• creates a table called student

• check if there is a table called student

• None of the above