You have installed MySQL Server for

单选题 You have installed MySQL Server for the first time on your system. However, the data
Directory along with the tables in the mysql system database are missing. Which step do you perform to create the contents of the data directory?

A、 Run the create_system_tables.sql file

B、 Run the mysql_unpack.sql file

C、 Invoke mysqld with the --initialize option.

D、 Invoke mysql with the --initialize option.

查看答案

下载APP答题

由4l***tl提供分享举报纠错

相关试题

单选题 You have just executed a manual backup by using this command:
Mysqlbackup -u root -p --socket=/tmp/my.sock --backup-dir=/my/backup/ backup
The operation completed without error.
What is the state of this backup and operation required before it is ready to be restored?

A、 Backup State = Compressed Backup; Operation = copy-back

B、 Backup State = Raw Backup; Operation = apply-log

C、 Backup State = Prepared Backup; Operation = validate

D、 Backup State = Prepared Backup; Operation = apply-log

E、 Backup State = Raw Backup; Operation = backup-dir-to-image

查看答案

单选题 Host slave1 has ip address 192.0.2.10.
Host slave2 has ip address 203.0.113.50
Examine these commands:
Why did this error occur?

A、 The host on the command line is not defined in the login path.

B、 The mysqld instance has not been restarted after creating the login path.

C、 There is no password defined in the login path.

D、 The DNS is not configured correctly for slave1 host.

E、 The mylogin.cnf file is not readable.

查看答案

单选题 How does the InnoDB storage engine handle deadlocks when they are detected?

A、 Both the affected transactions will be rolled back.

B、 The affected transactions wait for innodb_lock_wait_timeout seconds, and then roll back.

C、 One of the affected transactions will be rolled back, the other is allowed to proceed.

D、 The transaction isolation level determines which transaction is rolled back.

E、 The innodb_locks_unsafe_for_binlog setting determines which transaction is rolled back.

查看答案

单选题 What is the best method for monitoring Group Replication conflict resolution?

A、 the PERFORMANCE_SCHEMA tables

B、 the SHOW PROCESSLIST command

C、 the INNODB Lock Monitor details

D、 the SHOW STATUS command

E、 the INFORMATION_SCHEMA tables

查看答案

单选题 The following grants were executed:
GRANT CREATE ROUTING ON sales.* TO ‘webadmin’@’%’;
GRANT ALTER ON PROCEDURE sales.myproc TO ‘webadmin’@’%’;
A user successfully connects to the database as webadmin and created a stored procedure named get_reports.
The next day, the user logs in again as webadmin and wants to delete the stored procedure named get_reports, and therefore, issues the following statement:
USE sales;
DROP PROCEDURE IF EXISTS get_reports;
What is the result of executing the statement?

A、 The user will get an error because he or she did not use the ALTER statement to drop the stored procedure.

B、 The user will get an error because he or she did not put the database name in front of the stored procedure name.

C、 The stored procedure named get_reports will be dropped.

D、 The user will get an error because he or she does not have the permission to drop stored procedures.

查看答案

单选题 You are setting up a new installation of MySQL Server 5.7 (a GA release. You have used a ZIP or TAR package to ensure that the mysqld binary, along with its support files, such as plug-ins and error messages, now exist on the host.
Assume that the default datadir exists on the host. You installed the binary in the default location (the default --basedir value for your operating system.
Which step should you perform before defining your own databases and database tables?

A、 Execute a command with a minimal form of: mysqld --initialize

B、 Register mysqld as a service that will start automatically on this host machine.

C、 Create a configuration file containing default-storage-engine=InnoDB.

D、 Set an exception in the host machine’s firewall to allow external users to talk to mysqld.

E、 Create additional login accounts (so that everyone does not need to log in as root and assign them appropriate privileges.

查看答案

单选题 There are multiple instances of MySQL Server running on a single OS that is backed up using the mysqlbackup command.
The /etc/my/cnf contains default values, for example, datadir=/var/lib/mysql/, with extra instances having their own separate my.cnf file (for example /etc/mysql/instanceN.cnf overriding the defaults.
A restore of the second instance is attempted from the mysqlbackup archive using this command:
Mysqlbackup –backup-dir=/opt/backup/mysql/instance2 copy backup on starting the second MySQL instance, you notice that the data does not match the expected backup. Which command-line option is required to successfully update the second instance?

A、 –restore=2

B、 --copy-back-from-log

C、–--backup-instance=/var–ib/mysql/instance2

D、 --instance=/var/lib/my–l/instance2

E、 --defaults-file=/etc/m–ql/instance2.cnf

查看答案

单选题 Which statement best describes the purpose of the InnoDB buffer pool?

A、 It is amount of buffers available during a transaction.

B、 It caches only the indexes for InnoDB tables.

C、 It caches data and indexes for InnoDB tables.

D、 It holds changes made during a transaction before they are written to the log.

E、 It is a pool of memory for SQL query sort operations from within the InnoDB engine.

查看答案