-
What is the purpose of the DATE_FORMAT() function in MySQL?
- A) To calculate the difference between two dates
- B) To return the current date and time
- C) To format a date value according to a specified format
- D) To extract a part of a date value
Answer: C) To format a date value according to a specified format
-
Which SQL command is used to grant all privileges to a user in MySQL?
- A) GRANT ALL PRIVILEGES
- B) GRANT PRIVILEGES
- C) GRANT ALL
- D) GRANT FULL PRIVILEGES
Answer: A) GRANT ALL PRIVILEGES
-
What is the purpose of the DISTINCT keyword in conjunction with the COUNT() function in MySQL?
- A) To return the number of distinct values in a column
- B) To return the number of rows in a table
- C) To return the number of non-null values in a column
- D) To return the number of unique combinations of values in multiple columns
Answer: A) To return the number of distinct values in a column
-
Which SQL function is used to return the current time in MySQL?
- A) CURRENT_TIME()
- B) NOW()
- C) GETTIME()
- D) CURTIME()
Answer: A) CURRENT_TIME()
-
What is the purpose of the CHAR_LENGTH() function in MySQL?
- A) To return the length of a string in bytes
- B) To return the length of a string in characters
- C) To return the length of a string in bits
- D) To return the length of a string in words
Answer: B) To return the length of a string in characters
-
Which SQL command is used to rename a table in MySQL?
- A) RENAME TABLE
- B) ALTER TABLE
- C) MODIFY TABLE
- D) CHANGE TABLE
Answer: A) RENAME TABLE
-
What is the purpose of the ORDER BY clause in conjunction with the GROUP_CONCAT() function in MySQL?
- A) To order the result set by a specified column
- B) To group rows together based on a specified column
- C) To concatenate values from multiple rows into a single string
- D) To filter rows based on a specified condition
Answer: A) To order the result set by a specified column
-
Which SQL function is used to return the number of days between two dates in MySQL?
- A) DATEDIFF()
- B) DAYDIFF()
- C) DAYS()
- D) DATE_DAYS()
Answer: A) DATEDIFF()
-
What is the purpose of the ALL keyword in conjunction with the IN operator in MySQL?
- A) To specify that all values in a subquery must match
- B) To specify that any value in a subquery must match
- C) To specify that none of the values in a subquery must match
- D) To specify that some of the values in a subquery must match
Answer: A) To specify that all values in a subquery must match
-
Which SQL command is used to create an index on multiple columns in MySQL?
- A) CREATE INDEX
- B) ADD INDEX
- C) INDEX TABLE
- D) ALTER INDEX
Answer: A) CREATE INDEX
Comments