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@%’);
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements What is the cause of the error?()
A.The password is eight characters long, but needs to exceed validate_password_length to be valid
B.All of the MEDIUM password policy requirements have not been honored
C.The password matches a substring Hover as a dictionary word
D.The password does not match the validate_passoword_number_count requirement
E.There is no dictionary file defined, so password validation cannot work as expected
您可能感兴趣的试卷
你可能感兴趣的试题
A.By enabling the Slow Query Log because all queries that are not using indexes will be logged automatically
B.By enabling the Error Log because not using indexes is an error
C.By enabling the Slow Query Log and using the – log-queries-not-using-indexes option
D.By enabling the Error Log and using the – log-queries-not-using-indexes option
Full Atomicity, Consistency, Isolation, Durability (ACID) compliance is a necessity for a new application, which heavily reads and writes data.
This requires the following config file options: Sync_binlog=1 Innodb_flush_log_at_trx_commit=1 Innodb_doublewrite=1 However, this configuration is expected to introduce disk I/O overhead.
What three changes will reduce disk I/O overheads?()
A.Use of soft links for database directories on the same physical disk
B.Use of delay_key_write=ON for batch index update
C.Allocation of RAM to the buffer pool such that more of the data can fit in RAM
D.Placement of InnoDB log files and datadir on separate physical disks
E.Use of separate directories on the same physical disk for log files and data files
Consider the following table:
Which method should used to add a new g201305 partition to the table?()
A.A
B.B
C.C
D.D
E.E
A.File system snapshots
B.Mysqldumpslow
C.Mysqlhotcopy
D.Mysqldump with – binary-data option
E.Mysql Enterprise Backup
A.Shell> mysqladmin –u root –p shutdown
B.Shell> nmc mysql shutdown
C.Mysql> STOP PROCESS mysqld
D.Shell> /etc/init.d/mysql stop
E.Shell> service mysql safe_exit
F.Shell> pkill –u mysql mysqld_safe
G.Shell> net stop mysql
A.The master.info and relay.info files
B.The relay log files
C.The relay index file
D.Mysql.slave_master_info table
E.Mysql.slave_relay_log_info table
F.Mysql.slave_worker_info table
A.UPDATE pets…
B.SELECT….FROM pets
C.INSERT INTO pets…
D.ALTER TABLE pets…
A.STOP SLAVE; SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; START SLAVE
B.STOP SLAVE; BEGIN; SET GTID_IGNORE="aaa-bbb-ccc-ddd-eee: 3"; COMMIT; START SLAVE
C.STOP SLAVE; SETGTID_NEXT="aaa-bbb-ccc-ddd-eee: 3"; BEGIN; COMMIT; SET GTID_NEXT="AUTOMATIC"; START SLAVE
D.STOP SLAVE; RESET SLAVE; BEGIN; SKIP NEXT GTID; COMMIT; START SLAVE
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
A.RAID 5
B.iSCSI
C.SAN (Storage Area Network)
D.NFS (Networked File System)
最新试题
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;
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?()
Which two capabilities are granted with the SUPER privilege?()
Which two statements describe the behavior of the server's SQL mode?()
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=1Which three statements are true()。
You are investigating the performance of the server and see the following information: Events_waits_summary_global_by_event_name in the performance schema shows that the wait/synch/mutex/sql/LOCK_table_cache event is dominating other wait events. The table_open_cache_overflows status variable is 0.Which action should be taken to remove the performance bottleneck described here?()
You adjust a default configuration to the following /etc/my.cnf on a Linux installation:[mysqld] Loq-bin Binrylog_format=ROW You do not notice the spelling error in binrylog_format and restart your production server. How does the MySQL server behave with incorrectly spelled options?()
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?()
Which three tasks can be performed by using the performance Schema?()
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?()