SQL contest

Which MySQL data type is used to store a fixed-length string, padded with spaces if necessary?

• Char

• Varchar

• Blob

• int

In MySQL, which keyword is used to create a new table? 

• Alter

• Create

• Insert

• modify

What is the purpose of the MySQL 'SHOW' command?

• To display the structure of a table

• To display the contents of a table

• To display a list of databases  

• To display the version of MySQL

Which MySQL clause is used to specify the sorting order of the result set?

• ORDER BY

• SORT BY

• GROUP BY

• HAVING

What does the MySQL function 'NOW()' return?

• The current date 

• The current Time

• The current date and time  

  
  

• The elapsed time since midnight 

In MySQL, what is the purpose of the "LIMIT" clause in a SELECT statement? 

• DROP DATABASE

• DELETE DATABASE

• REMOVE DATABASE

• ERASE DATABASE

Which MySQL command is used to delete a database?  

• DELETE DATABASE

• DROP DATABASE

• REMOVE DATABASE

• ERASE DATABASE

What is the purpose of the MySQL 'INNER JOIN' keyword?

• To return all rows from both tables that satisfy the join condition

• To return only the rows that have matching values in both tables  

• To return all rows from the right table and the matched rows from the left table

• To return all rows from the left table and the matched rows from the right table

Which MySQL function is used to count the number of rows returned by a query?

• SUM()

• AVG()

• COUNT()

• MAX()

What does the MySQL keyword "DISTINCT" do?  

• It filters rows based on a specified conditio

  
  

• It groups rows based on a specified condition  

  
  

• It retrieves only unique values from a specified column or columns  

  
  

• It orders the result set in ascending order