This set of MySQL Database Multiple Choice Questions & Answers (MCQs) focuses on “Status Variables”. 1. The statement that views status variables by aggregating the values over all connections is _____________ a) SHOW SESSION STATUS b) SHOW LOCAL STATUS c) SHOW GLOBAL STATUS d) SHOW STATUS 2. Which keyword inserted in the SHOW STATUS statement … Read more
This set of MySQL Database Multiple Choice Questions & Answers (MCQs) focuses on “Session-Only System Variables”. 1. Which of these is a read only variable? a) error_count b) big_tables c) autocommit d) foreign_key_checks 2. Which variable when set to 1 would enable foreign key checking for InnoDB tables? a) error_count b) identity c) foreign_key_checks d) … Read more
This set of MySQL Database Multiple Choice Questions & Answers (MCQs) focuses on “System Variables”. 1. Which system variable when set to 1, makes all temporary tables to get stored on disk rather than in memory? a) basedir b) back_log c) big_tables d) bind_address 2. The permitted value type for the variable ‘character_set_client’ is _____________ … Read more
This set of MySQL Database Multiple Choice Questions & Answers (MCQs) focuses on “Functions”. 1. The server is told to accept spaces after function names by _____________ a) –sql-mode=SKIP_SPACE b) –sql-mode=IGNORE_SPACE c) –sql-mode=SPACE_IGNORE d) –sql-mode=SPACE_SKIP 2. Which function returns NULL if expr1 = expr2? a) CASE b) IF() c) IFNULL() d) NULLIF() 3. The operator … Read more
This set of MySQL Database Multiple Choice Questions & Answers (MCQs) focuses on “Operators”. 1. Which operator is used to return value from JSON columns after evaluating the path and unquoting the result? a) -> b) ->> c) << d) >> 2. The right shift operator is _____________ a) >> b) << c) < d) … Read more
This set of MySQL Database Multiple Choice Questions & Answers (MCQs) focuses on “Spatial Data Types”. 1. Which classes does spatial data types in MySQL correspond to? a) OpenGSS b) OpenGIS c) ClosedGSS d) ClosedGIS 2. Which type can store a collection of objects of any type? a) GEOMETRYCOLLECTION b) MULTIPOINT c) MULTILINESTRING d) MULTIPOLYGON … Read more
This set of MySQL Database Multiple Choice Questions & Answers (MCQs) focuses on “Date and Time Data Types”. 1. Which of these has special automatic update behavior? a) DATE b) TIME c) TIMESTAMP d) YEAR 2. To disallow zero month or day parts in dates, the option used is _____________ a) NO_ZERO_IN_DATE b) NO_DATE_WITH_ZERO c) … Read more
This set of MySQL Database Multiple Choice Questions & Answers (MCQs) focuses on “String Data Types”. 1. The maximum value that can be specified to the size of VARCHAR is _____________ a) 0 b) 127 c) 1023 d) 65535 2. The storage in bytes required for VARCHAR(4) type ‘abcd’ is _____________ a) 1 b) 3 … Read more
This set of MySQL Database Multiple Choice Questions & Answers (MCQs) focuses on “Numeric Data Types”. 1. Which of these is not an exact numeric type? a) SMALLINT b) DECIMAL c) NUMERIC d) REAL 2. How many of the following do not support ‘BIT’ data type? MyISAM, MEMORY, NDB a) 0 b) 1 c) 2 … Read more
This set of MySQL Database Multiple Choice Questions & Answers (MCQs) focuses on “Setting Up Replication Servers”. 1. The slave stores the CHANGE MASTER parameters in the file _____________ a) slave.info b) slave.inf c) master.info d) master.inf 2. Which statement on the master expires binary log files? a) SHOW SLAVE STATUS b) PURGE MASTER c) … Read more
