当前分类： 1z0-883
问题：多选题What are three actions performed by the mysql_secure_installation tool?（）AIt prompts you to set the root user account passwordBIt checks whether file permissions are appropriate within datadirCIt asks to remove the test database, which is generated at ...
查看答案
问题：单选题Your developers have created table to store some of their program's data. After examining the slow Query Log, you see that they are using the LIKE operator and SUBSTER （ ） functions against a VARCHAR (10000) column quite often. An example of the start ...
问题：单选题The following commands are available in the Linux binary distributions of Mysql: Mysqld Mysqld_safe Mysql.server What is the correct description of each of these commands?（）A AB BC CD D...
问题：单选题You need to dump the data from the master server and import it into a new slave server. Which mysqldump option can be used when dumping data from the master server in order to include the master server's binary log information?（）A Include-master-infoB ...
问题：单选题You have a server that has very limited memory but has a very large table. You will use mysqldump to back up this table. Which option will ensure mysqldump will process a row at a time instead of buffering a set of rows?（）A — quickB — skip-bufferC — si...
问题：单选题The validate_password plugin is loaded and displays the following settings in global variables: Mysql＞ SHOW VARIABLES LIKE ‘validate_password%’; When attempting to set your password, you get the following error: Mysql＞ SET PASSWORD = PASSWORD (‘Hoverl@...
问题：多选题Which two options describe how MySQL Server allocates memory?（）AThread memory is pre-allocated up to thread_cache_size for performanceBEach connection may have its own per-thread memory allocationsCGlobal memory resources are allocated at server startu...
问题：单选题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?（）A A syntax error will result as you cannot specify more than one partition in the same state...
问题：多选题The InnoDB engine has a feature known as clustered indexes. Which three statements are true about clustered indexes as used in InnoDB?（）AA primary key must exist for creation of a clustered indexBA clustered index allows fulltext searching within InnoD...
问题：多选题Which two statements describe the behavior of the server's SQL mode?（）AThe server's SQL mode determines how the server should behave when performing data validation check and interpreting different forms of syntaxBThe server's SQL mode determines wheth...
问题：单选题Following a server crash, the automatic recovery of InnoDB fails. How would you begin to manually repair the InnoDB tables?（）A Start the server with the – innodb_recover_options option set to FORCEB Start the server with the – innodb_force_recovery opt...
问题：多选题In a design situation, there are multiple character sets that can properly encode your data. Which three should influence your choice of character set?（）ASyntax when writing queries involving JOINSBMemory usage when working with the dataCCharacter set ...
问题：单选题A database exists as a read-intensive server that is operating with query_cachek_type =DEMAND. The database is refreshed periodically, but the resultset size of the queries does not fluctuate. Note the following details about this environment: A web ap...
问题：单选题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 th...
问题：多选题Mysqldump was used to create a single schema backup; Shell mysqldump –u root –p sakila sakila2013.sql Which two commands will restore the sakila database without interfering with other running database?（）AMysql＞ USE sakila; LOAD DATA INFILE 'sakila201...
问题：单选题You are attempting to secure a MySQL server by using SSL encryption. On starting MySQL, you get this error: 130123 10:38:02 [ERROR] mysqld: unknown option '—ssl' What is the cause of the error?（）A The — ssl level was not specifiedB The server was not s...
问题：单选题Which High Availability solution can provide a consistent, time-delayed (for example, one hour) snapshot of the live production database?（）A MySQL ReplicationB Distributed Replication Block DeviceC Windows Server Failover ClusteringD MySQL Cluster...
问题：单选题Consider the Mysql Enterprise Audit plugin. Which statement is true when you identify a connection event that has used external authentication?（）A The attribute STATUS is set to the string EXTERNAL_AUTHB The attribute PRIV_USER contains the usernameC T...
问题：多选题A general purpose MySQL instance is configured with the following options: —log-slow-queries —long-query-time=,0001 —log-slow-admin-queries —general-log —log-bin —binlog-format=STATEMENT —innodb-flush-log-at-trx-commit=1 Which three statements are true...
