MySQL DB Test

Linux ✘ Solaris ✘ Windows ✘ All of these ✔

The only functions available to a SQL Expression are database-specific functions ✘ Cannot use Crystal or Basic Syntax in a SQL Expression ✘ SQL Expressions are always handled on the database ✘ All of these ✔

table_count ✘ count_table ✘ counter ✘ table_cache ✔

-9.99 ✘ -999.99 ✘ -99.99 ✘ -9.999 ✔

Lexical analysis ✘ Syntactic analysis ✘ Semantic analysis ✘ Code generation ✔

CALL ✘ EXECUTE ✘ Both of these ✘ None of these ✔

max ✘ min ✘ avg ✘ convert ✔

Client program ✘ Non-client utility program ✘ MySQL Server ✘ None of these ✔

DEFRAG TABLE table_name ✘ OPTIMIZE TABLE table_name ✘ ANALYZE TABLE table_name ✘ CHECK TABLE table_name ✔

mysqld ✘ mysqld_safe ✘ mysql.server ✘ None of these ✔