This MySQL 5.7 test is designed to assess the knowledge of test takers concerning the basics of the MySQL database management system. The topics covered include commands, queries, statements, data types, errors and various other features. It is appropriate to administer this assessment to test takers with beginner and intermediate level knowledge of MySQL 5.7. Total Questions 38 Question Types Multiple Choice Competencies Tested SQL StatementsData TypesMySQL FeatureMySQL Query Tasks Tested CursorsREPLACELocal Variables in Stored ProceduresCurrent DateRenaming TablesANALYZE TABLE StatementMatching Value in Tables JoinTables and ViewsPrepared StatementsRange QueriesTemporary Tables and Committing TransactionsAutocommitSystem PrivilegesDELETE TriggerTable OperationsCHAR and VARCHARZEROFILLControl Flow OperatorsJSON ColumnsPrimary and Unique KeySystem VariablesRedHat Linux MySQL ServiceMySQL CommentsNot Found Error CodeSys SchemaMEMORY Storage EngineMySQL Storage EngineStorage EnginesNative MySQL FunctionsConcatenate ValuesLEFT JOINSQL Query CodeTable IndexEliminate Duplicate RowsCorrelated SubqueryUNION QueryEmbedded SQL QueryLogging Information
