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 row
B.It shows how many columns in the index are examined
C.It shows the number of characters indexed in the key
D.It shows how many bytes will be used from each index row
您可能感兴趣的试卷
你可能感兴趣的试题
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 connections
B.Joe has exceeded the max_user_connections global limit
C.All users are blocked because max_user_connections is accumulated over the host account information
D.Kay is already connected elsewhere and attempting to log in again
E.Connect_timeout is too small to allow a connection to occur
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 of one row of data: 'GREEN01020495888331993-12-10/2…'
What should you do to improve the overall performance?()
A.Convert the column to TEXT and add a fulltext index to the table
B.Create multiple prefix indexes of differing lengths
C.Convert their column to BINARY
D.Redesign the table so that the most commonly searched for string patterns are in their own columns
A.Transaction support
B.FULLTEXT indexing for text matching
C.Table and page level locking support
D.Foreign key support
E.Geospatial indexing
F.HASH index support
G.Table level locking only
You need to replicate a table from a master to a slave. The master and slave copies of the table will have different number of columns.
Which two conditions must be true?()
A.Each extra column in the copy with more columns must not have a default value
B.Columns that are common to both versions of the table must be defined in the same order on the master and the slave
C.The slave database cannot have more columns than the master. Only the master database can have more columns
D.Columns that are common to both versions of the table must come first in the table definition, before any additional columns are additional columns are defined on either server
E.The master database cannot have more columns than the slave. Only the slave deatbase can have more columns
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 specified
B.The server was not started with the – enable–ssl-plugin option
C.— ssl is not a valid server option
D.The mysqld binary was not compiled with SSL support
E.The server's SSL certificate was invalid
You examine the output of SHOW GLOBAL STATUS and notice that the value of Created_tmp_disk_tables is consistently increasing.
Which two variables would likely fix this issue?()
A.Table_open_cache
B.Table_open_cache_instancs
C.Table_definition_cache
D.Tmp_table_size
E.Max_heap_table_size
F.Max_tmp_tables
Which three methods will show the storage engine for the Country table?()
A.A
B.B
C.C
D.D
E.E
Consider the MySQL Enterprise Audit plugin, You add the following lines to the my.cnf configuration tile: [mysqld] Plugin-load=audit_log.so Audit-log=FORCE_PLUS_PERMANENT You attempt to start up the MySQL service and notice that it fails to start.
Which two statements would explain why the service did not start?()
A.FORCE_PLUS_PERMANENT is not valid for the audit-log option
B.The audit_log.so library does not exist
C.The audit_log.so library is in a location that is different from that defined by the plugin_dir option
D.The audit plugin must be loaded dynamically by using the INSTALL PLUGIN command
E.The audit log file does not exist in which to write audit events
F.The audit_log.so library is not an executable file
You use—login-path to access a MySQL server on a Linux installation.
Which statement is true about the – login-path option that is created by using mysql_config_editor?()
A.All system users have access to the MySQL server via—login path local
B.login-path can be used only for MySQL servers running on a local machine
C.login-path allows you to provide login credentials without passing clear text passwords on the command line
D.When using – login-path to connect to a remote MySQL server, the remote server version must be 5.6 or later
A.Allowing a client to kill other client connections
B.Allowing a client to shut down the server
C.Allowing change of the server runtime configuration
D.Allowing client accounts to take over the account of another user
最新试题
Which three statements are true about memory buffer allocation by a MySQL Server?()
A user executes the statement;PURGE BINARY LOGS TO 'mysql-bin.010';What is the result?()
Which three are properties of the MyISAM storage engine?()
You have taken a Logical Volume Manager (LVM) snapshot backup of a volume that contains the MySQL data directory. Why is it important to remove snapshots after completing a RAW backup in this way?()
Which three tasks can be performed by using the performance Schema?()
In a test database, you issue the SELECT … INTO OUTFILE statement to create a file with your t1 table data. You then TRUNCATE this table to empty it.()Mysql> SELECT * INTO OUTFILE '/tmp/t1.sql' from t1;mysql> TRUNCATE t1;
Consider the following:Which statement best describes the meaning of the value for the key_len column?()
You examine the output of SHOW GLOBAL STATUS and notice that the value of Created_tmp_disk_tables is consistently increasing.Which two variables would likely fix this issue?()
Which statement is true about the log-output variable?()
Which two statements are true about setting the per-thread buffers higher than required?()