单项选择题X 纠错
A.It exports tables with the most indexes first to assist with import speeds
B.It ensures that unique indexes have no conflicts when the data is dumped
C.It orders by primary key to assist in speeding up importing to InnoDB tables
D.It must be specified so index data is dumped correctly when –on-create-info is used
你可能喜欢
单项选择题
A.It deletes all binary log files, except 'mysql-in.010'
B.It deletes all binary log files up to and including 'mysql-bin.010'
C.It deletes all binary log files before 'mysql-bin.010'
D.It deletes all binary log files after 'mysql-bin.010'
单项选择题
A.The snapshot size will continue to grow as changes to the volume are made
B.The snapshots take a significant amount of disk space as they are a duplicate copy of the data
C.The system can only support one snapshot per volume, and you need to remove it to be able to take your next backup
D.The system keeps a copy of changes in memory and can cause an out of memory event
单项选择题
A.MySQL requires correct file ownership while remaining secure
B.MySQL needs to be run as the root user, but file cannot be owned by it
C.MySQL cannot be run as the root user
多项选择题
A.Thread memory is pre-allocated up to thread_cache_size for performance
B.Each connection may have its own per-thread memory allocations
C.Global memory resources are allocated at server startup
D.Each thread allocates memory from a global pool
多项选择题
A.The server's SQL mode determines how the server should behave when performing data validation check and interpreting different forms of syntax
B.The server's SQL mode determines whether the server should be read-only or should accept commands such as INSERT and UPDATE
C.The server's SQL mode can be changed at the session level with a SET SESSION sql_mode="new_value" command
D.The server's SQL mode, when globally set on a slave server, applies to events sent from the master
多项选择题
A.The slave was created with mysqldump –u root –p – skip-lock-table—all-databases > /data/data.sql
B.The slave user does have INSERT, UPDATE, or DELETE permission and cannot execute the write_rows function
C.For tables with UNIQUE keys, statement-based replication must be used maintain integrity
D.The root user on the slave has executed FLUSH LOGS, causing the relay-log to doublewrite
E.The applications have the SUPER privilege, which allows them to update rows
多项选择题
A.Both technologies guarantee an identical copy of data on the secondary node
B.Only MySQL can maintain a time-delayed copy of data on the secondary node
C.Both technologies use the TCP/IP stack as their primary transmission medium
D.DRBD uses shared-disk technology
多项选择题
A.The General Query Log records more data than the Binary Log
B.The binary Log records more data than the General Query Log
C.The Slow Query Log records more data than the General Query Log
D.The General Query Log records more data than the Slow Query Log
E.The Slow Query Log records more data than the Binary Log
F.The Binary Log records more data than the Slow Query Log
单项选择题
A.Re-install the audit plugin
B.Execute the command FLUSH LOGS
C.Execute the command SET GLOBAL audit_log_fiush= ON
D.Move or rename the existing audit.log file
单项选择题
A.InnoDB uses row and table-level locks, but row locks are not escalates
B.InnoDB locks only those rows that are updated
C.InnoDB only uses row locks, not page or table-level locks
D.InnoDB row locks may be escalated to page or table-level locks
E.InnoDB uses row-level or table-level locks depending on the number of rows affected