单项选择题
Which hardware storage option, when set up with redundant disks, offers the least stability,availability, and reliability for Mysql data?（）
A.RAID 5
B.iSCSI
C.SAN (Storage Area Network)
D.NFS (Networked File System)
相关考题
-
多项选择题
A Mysql instance is running on a dedicated server. Developers access the server from the same network subnet. Users access the database through an application that is running on a separate server in a DMZ. Which two will optimize the security of this setup?（）
A.Disabling connections from named pipes or socket files (depending on the operating system of the server)
B.Enabling and using SSL for connections to the Mysql database
C.Installing Mysql on the application server, and running the database and application on the same server
D.Starting the server with – bind- address=0.0.0.0 specified
E.Running the server with – skip-networking specified
F.Limiting logins to originate from the application server or the server's subnet' -
多项选择题
The InnoDB engine has a feature known as clustered indexes. Which three statements are true about clustered indexes as used in InnoDB?（）
A.A primary key must exist for creation of a clustered index
B.A clustered index allows fulltext searching within InnoDB
C.The first unique index is always used as a clustered index and not a primary key
D.A clustered index provides direct access to a page containing row data
E.If no indexes exist, a hidden clustered index is generated based on row IDs
F.A primary key is used as a clustered index
G.A clustered index is a grouping of indexes from different tables into a global index for faster searching -
多项选择题
Which two events will cause a slave server to create a new relay log file?（）
A.Execution of the FLUSH LOGS statement
B.Starting of the SQL thread
C.Reaching the slave_pendign _jobs_size_max limit
D.Execution of FULSH TABLES WITH READ LOCK
E.Starting of the I/O thread
