PLAY READ BLOG

Assess your experience with MySQL

I estimate it would take you 39 steps in 9 minutes to Assess your experience with MySQL.
Which of the following is a Spatial Data Type?
  • Date
  • GEOMETRY
  • DOT
  • CIRCLE
How can you make an UPDATE?
1. UPDATE tab.f1=1 , tab.f2=2;

2. UPDATE tab SET f1=1 , f2=2;

3. UPDATE tab.f1=1 AND tab.f2=2;

4. UPDATE tab SET f1=1 AND f2=2;
  • 1.
  • 2.
  • 3.
  • 4.
Which statement is required to add a column to an existing table?
  • CREATE
  • UPDATE
  • ALTER
  • NEW
  • APPEND
Which function calculates an MD5 128-bit checksum for the string?
  • COMPRESS
  • MD128
  • MD5
  • DECODE
What is a stored program that is attached to a table or a view?
  • Trigger
  • Embedded SELECT statement
  • Pseudofile
Which is a valid storage engine for MySQL?
  • ANSI
  • MyISAM
  • UTF-8
  • LocalDB
How would you select the first non-null value from either column B or column A (in that order)?
  • COALESCE(B, A)
  • COALESCE(A, B )
  • B IF A IS NOT NULL
  • A IF B IS NOT NULL
What does BLOB stand for?
  • Binary List Object
  • Binary Large Object
  • Big List Object
Which global system variable is set to indicate to where logging will be written?
  • general_log
  • log_output
  • general_log_file
  • slow_query_log_file
Which port is MySQL Server configured to listen on by default?
  • 8080
  • 3306
  • 80
  • 443
💡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.
Which function returns the first non-NULL value in a list?
  • LEAST
  • GREATEST
  • CONCAT
  • COALESCE
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.
  • 1.
  • 2.
  • 3.
  • 4.
Which SQL function returns the current date and time?
  • CURTIME()
  • DATE()
  • CURDATE()
  • NOW()
What does the following command output? SELECT 1;
  • Error
  • '1'
  • "1"
  • 1
Which of the following is a synonym for INDEX in MySQL?
  • UNIQUE
  • STORE
  • POINTER
  • CURSOR
  • KEY
Which counts the number of unique values in a column?
  • COUNT(<column name>)
  • DISTINCT COUNT(column_name)
  • COUNT(DISTINCT column_name)
  • COUNT(*)
Which clause is used in combination with the HAVING clause?
  • GROUP BY
  • FROM
  • SELECT
  • WHERE
InnoDB follows the ACID model. What does 'I' stand for in the acronym ACID?
  • Innovation
  • Isolation
  • Inside
  • Ingres
95% of all 125 users completed this intention.
Get Started   

Or consider 73 other intentions.