Which statement is required to add a column to an existing table?
Answer question #8645
Which function calculates an MD5 128-bit checksum for the string?
Answer question #8650
What is a stored program that is attached to a table or a view?
Answer question #8654
Which is a valid storage engine for MySQL?
Answer question #8659
How would you select the first non-null value from either column B or column A (in that order)?
Answer question #8664
What does BLOB stand for?
Answer question #8668
Which global system variable is set to indicate to where logging will be written?
Answer question #8673
Which port is MySQL Server configured to listen on by default?
Random fact about MySQL 💡
💡FUN FACT 💡The first version of MySQL appeared on 23 May 1995. Its name is a combination of "My", the name of co-founder Michael Widenius's daughter and "SQL", the abbreviation for Structured Query Language.
Answer question #8678
Which function returns the first non-NULL value in a list?
Answer question #8683
Which of the following is true concerning indexes?
1. Indexes can only be done on columns containing numerical data.
2. Indexes will slow down inserts, but speed up selects.
3. Indexes will slow down selects, but speed up inserts.
4. Indexes can only be done on primary key columns.
Answer question #8688
Which SQL function returns the current date and time?
Answer question #8693
What does the following command output? SELECT 1;
Answer question #8698
Which of the following is a synonym for INDEX in MySQL?
Answer question #8704
Which counts the number of unique values in a column?
Answer question #8709
Which clause is used in combination with the HAVING clause?
Answer question #8714
InnoDB follows the ACID model. What does 'I' stand for in the acronym ACID?