你可能喜欢
单项选择题
A.The attribute "STATUS" is set to the string EXTERNAL_AUTH
B.The attribute "PRIV_USER" contains the username
C.The event type that is given in the attribute "NAME" is EXTERNAL_AUTH
D.There is no differentiation between native and external authentication events
E.External authentication is managed through external auditing logs
F.The "PROXY_PRIV" user shows a username if external authentication is used
多项选择题
A.A connection as the user kate was successful
B.A connection failed due to authentication being unsuccessful
C.A connection was attempted via socket rather than TCP
D.A connection was blocked by a firewall or a similar security mechanism
E.A connection failed because the proxy user privileges did not match the login user
多项选择题
A.It can support transactions
B.Table contents are not saved if the server is restarted
C.It cannot contain text or BLOB columns
D.It can support foreign keys
E.Each table is represented on disk as an.frm file
F.Each table has a corresponding.MYI and .MYD file
多项选择题
A.Mysql NDB Cluster
B.Mysql Replication
C.Distributed Replicated Block Device (DRBD) and Mysql
D.Windows Cluster and Mysql
E.Solaris Cluster and Mysql
单项选择题
A.Do not pass a user variable in the WHERE clause because it limits the ability of the optimizer to use indexes
B.Add an index on the objective column so that is can be used in both the WHERE and GROUP BY operations
C.Drop the run_2 index because it has caused a conflict in the choice of key for this query
D.Execute the run_2 index because it has caused a conflict in the choice of key for this query
E.Add a composite index on (run,objective,stage) to allow the query to fully utilize an index
多项选择题
A.It prompts you to set the root user account password
B.It checks whether file permissions are appropriate within datadir
C.It asks to remove the test database, which is generated at installation time
D.It can delete any anonymous accounts
E.It verifies that all users are configuration with the longer password hash
多项选择题
A.Syntax when writing queries involving JOINS
B.Memory usage when working with the data
C.Character set mapping index hash size
D.Disk usage when storing data
单项选择题
A.The RPM installation script sets a default password of password for new installations
B.The local root user must log in with a blank password initially: mysql –u root –p
C.New security measures mean that the mysql_secure_installation script must be run first on all new installations
D.The mysql_install_bd post-installation script used – random-password
多项选择题
A.Creating, dropping, and modifying tables and indexes
B.Initiating a binary backup of the database by using the START BACKUP command
C.Displaying replication status information
D.Shutting down the server by using the SHUTDOWN command
E.Creating and dropping databases
F.Creating and administering users
多项选择题
A.Using DELETE statements, for example, DELETE FROM performance_schema.events_watis_current
B.Using the statement RESET PERFORMANCE CACHE
C.Using the statement FLUSH PERFORMANCE CACHE
D.Using TRUNCATE statements, for example, TRUNATE TABLE performance_schema.events_waits_current
E.Disabling and re-enabling all instruments
F.Restarting Mysql