單項(xiàng)選擇題

You execute the following statement in a Microsoft Windows environment. There are no conflicts in the path name definitions.
C: \＞ mysqld – install Mysql56 – defaults – file = C :\my –opts.cnf What is the expected outcome?（）

A.Mysql is installed as the Windows service name Mysql56, and uses c: \my-opts.cnf as the configuration file
B.An error message is issued because – install is not a valid option for mysqld
C.A running Mysql 5.6 installation has its runtime configuration updated with the server variables set in c: \my-opts.cnf
D.Mysqld acts as an MSI installer and installs the Mysql 5.6 version, with the c: \my-opts.cnf configuration file

你可能感興趣的試題

單項(xiàng)選擇題

Consider the Mysql Enterprise Audit plugin. A CSV file called data.csv has 100 rows of data. The stored procedure prepare_db ( ) has 10 auditable statements.
You run the following statements in the mydb database: Mysql＞ CALL prepare_db ( );
Mysql＞ LOAD DATA INFILE '/tmp/data.cav' INTO TABLE mytable; Mysql＞ SHOW TABLES;
How many events are added to the audit log as a result of the preceding statements?（）

A.12; only top-level statements and stored procedure events are logged
B.111; top-level statements and all lower-level statements are logged
C.3; only the top-level statements are logged
D.102; top-level statements are logged, but LOAD DATA INFILE is logged as a separate event

多項(xiàng)選擇題

Which two statements are true about InnoDB auto-increment locking?（）

A.The auto-increment lock can be a table-level lock
B.InnoDB never uses table-level locks
C.Some settings for innodb_autoinc_lock_mode can help reduce locking
D.InnoDB always protects auto-increment updates with a table-level lock

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美 国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

You execute the following statement in a Microsoft Windows environment. There are no conflicts in the path name definitions. C: \＞ mysqld – install Mysql56 – defaults – file = C :\my –opts.cnf What is the expected outcome?（）

你可能感興趣的試題

Which two statements are true about InnoDB auto-increment locking?（）

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

You execute the following statement in a Microsoft Windows environment. There are no conflicts in the path name definitions.
C: \＞ mysqld – install Mysql56 – defaults – file = C :\my –opts.cnf What is the expected outcome?（）