多选题Which two statements are true regarding partitioning in Mysql?（）ATables with BLOB and TEXT columns cannot be partitionedBPartitioning allows easier management of smaller data sets for certain queriesCPartitioning allows different columns to be stored in separate filesDThe partitioning expression is an integer or function that returns an integer value or NULL valueEPartitioning is only available for those storage engines that implements it natively
多选题
Which two statements are true regarding partitioning in Mysql?（）
A
Tables with BLOB and TEXT columns cannot be partitioned
B
Partitioning allows easier management of smaller data sets for certain queries
C
Partitioning allows different columns to be stored in separate files
D
The partitioning expression is an integer or function that returns an integer value or NULL value
E
Partitioning is only available for those storage engines that implements it natively
参考解析
解析：
暂无解析
相关考题：
单选题An existing master-slave setup is currently using a delayed replication of one hour. The master has crashed and the slave must be "rolled forward" to provide all the latest data. The SHOW SLAVE STATUS indicates the following values: RELAY_LOG_FILE =hostname-relay-bin.00004 RELAY_LOG_POS = 1383 Which command set would make the slave current?（）AGtid_mode must be set to AUTO during point in time recoveriesBMysqlbinlog ignores arguments to – exclude-gtids-it means ignore all events with GTIDsCThe server keeps track of which GTIDs have already been executed and skips thoseDEnforce_gtid_consistency is set to ON
多选题Which two statements are true about setting the per-thread buffers higher than required?（）AMore memory per thread is beneficial in all scenariosBIt causes increased overhead due to initial memory allocationCIt can affect system stability during peak load times, due to swappingDIt requires increasing the thread_cache_size variable
多选题Which three tasks can be performed by using the performance Schema?（）AFinding queries that are not using indexesBFinding rows that are locked by InnoDBCFinding client connection attributesDFinding the part of a code in which a single query is spending timeEFinding the size of each table
单选题An employee cannot access the company database. You check the connection variables: What is a valid explanation for why one of the users is unable to connect to the database?（）A Bob has max_user_connections set to zero, which blocks all his connectionsB Joe has exceeded the max_user_connections global limitC All users are blocked because max_user_connections is accumulated over the host account informationD Kay is already connected elsewhere and attempting to log in againE Connect_timeout is too small to allow a connection to occur
单选题You want a record of all queries that are not using indexes. How would you achieve this?（）ABy enabling the Slow Query Log because all queries that are not using indexes will be logged automaticallyBBy enabling the Error Log because not using indexes is an errorCBy enabling the Slow Query Log and using the – log-queries-not-using-indexes optionDBy enabling the Error Log and using the – log-queries-not-using-indexes option
单选题Consider the following statement on a RANGE partitioned table: ALTER TABLE orders DROP PARTITION p1, p3; What is the outcome of executing the above statement?（）AA syntax error will result as you cannot specify more than one partition in the same statementBAll data in p1 and p3 partitions are removed and the table definition is changedCAll data in p1 and p3 partitions are removed, but the table definition remains unchangedDOnly the first partition (p1) will be dropped as only one can be dropped at any time
单选题Consider the following: Which statement best describes the meaning of the value for the key_len column?（）A It shows the total size of the index rowB It shows how many columns in the index are examinedC It shows the number of characters indexed in the keyD It shows how many bytes will be used from each index row
多选题Which three tasks can be performed by using the performance Schema?（）AFinding queries that are not using indexesBFinding rows that are locked by InnoDBCFinding client connection attributesDFinding the part of a code in which a single query is spending timeEFinding the size of each table
多选题Which two requirements would lead towards a high availability solution?（）AWhen uptime is criticalBWhen data must be refactoredCWhen application concurrency is staticDWhen data loss is unacceptableEWhen application is a single point of failure
单选题Review the definition of the phone_list view. CHEATE OR REPLACE ALGORITHM=MERGE DEFINER= 'root'@localhost' SQL SECURITY DEFINER VIEW 'phone_list' AS SELECT e . id as id 'e . first_name AS 'first_name' 'e . last_name AS 'last_name' 'coalesce ( ph1.phone_no, ' – ') AS 'office_no' 'coalesce (ph2 .phone_no, ' – ') AS 'cell_no' FROM employees e LEFT JOIN employee_phone ph1 ON ph1.emp_id = e.id AND ph1.type = 'office' LEFT JOIN employee_phone ph2 ON ph2 .emp_id = e.id AND ph2 .type = 'mobile' The tables employees and employee_phone are InnoDB tables; all columns are used in this view. The contents of the phone_list view are as follows: Mysql select * from phone_list; 1 row in set (0.00 sec) Which method can you use to change the cell_no value to '555-8888' for John Doe?（）AINSERT INTO employee_phone (emp_id, phone_no, type) VALUES (1, '555-8888','mobile')BUPDATE phone_list SET cell_name '555-8888' WHERE first_name= 'John' and last_name= 'Doe'CDELETE FROM phone_list WHERE first_name= 'John' and last_name= 'Doe'; INSERT INTO phone_list (first_name, last_name, office_no, cell_no) VALUES ('John' , 'Doe' , 'x1234' , '555-8888)DUPDATE employee_phone SET phone_no= '555-8888' where emp_id=1