当前分类： 1z0-883
问题：多选题Which three statements are characteristic of the MEMORY storage engine?（）AIt can support transactionsBTable contents are not saved if the server is restartedCIt cannot contain text or BLOB columnsDIt can support foreign keysEEach table is represented o...
查看答案
问题：多选题Which two requirements would lead towards a high availability solution?（）AWhen uptime is criticalBWhen data must be refactoredCWhen application concurrency is staticDWhen data loss is unacceptableEWhen application is a single point of failure...
问题：多选题What are two methods of taking a binary backup of a Mysql Server using InnoDB storage engine?（）AFile system snapshotsBMysqldumpslowCMysqlhotcopyDMysqldump with – binary-data optionEMysql Enterprise Backup...
问题：多选题What are three facts about backups with mysqldump?（）ACan back up a remote database serverBAllow a consistent backup to be takenCAre always faster to restore than binary backupsDAre able to back up specific items within a databaseECreate automatically c...
问题：多选题Which three are properties of the MyISAM storage engine?（）ATransaction supportBFULLTEXT indexing for text matchingCTable and page level locking supportDForeign key supportEGeospatial indexingFHASH index supportGTable level locking only...
问题：多选题Which three tasks can be performed by using the performance Schema?（）AFinding queries that are not using indexesBFinding rows that are locked by InnoDBCFinding client connection attributesDFinding the part of a code in which a single query is spending ...
问题：多选题Which two statements describe the behavior of the server's SQL mode?（）AThe server's SQL mode determines how the server should behave when performing data validation check and interpreting different forms of syntaxBThe server's SQL mode determines wheth...
问题：多选题Compare a typical Distributed Replicated Block Device (DRBD) with MySQL Standard Replication using master-slave replication. Which two statements are correct?（）ABoth technologies guarantee an identical copy of data on the secondary nodeBOnly MySQL can ...
问题：多选题Which two capabilities are granted with the SUPER privilege?（）AAllowing a client to kill other client connectionsBAllowing a client to shut down the serverCAllowing change of the server runtime configurationDAllowing client accounts to take over the ac...
问题：单选题Consider the following: Which statement best describes the meaning of the value for the key_len column?（）A It shows the total size of the index rowB It shows how many columns in the index are examinedC It shows the number of characters indexed in th...
问题：单选题You want a record of all queries that are not using indexes. How would you achieve this?（）A By enabling the Slow Query Log because all queries that are not using indexes will be logged automaticallyB By enabling the Error Log because not using indexes ...
问题：多选题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 s...
问题：多选题When backing up a replication slave, which three should also be backed up in addition to data?（）AThe master.info and relay.info filesBThe relay log filesCThe relay index fileDMysql.slave_master_info tableEMysql.slave_relay_log_info tableFMysql.slave_wo...
问题：单选题You have a server that has very limited memory but has a very large table. You will use mysqldump to back up this table. Which option will ensure mysqldump will process a row at a time instead of buffering a set of rows?（）A — quickB — skip-bufferC — si...
问题：多选题Which two statements are true about InnoDB auto-increment locking?（）AThe auto-increment lock can be a table-level lockBInnoDB never uses table-level locksCSome settings for innodb_autoinc_lock_mode can help reduce lockingDInnoDB always protects auto-in...
问题：单选题A user executes the statement; PURGE BINARY LOGS TO 'mysql-bin.010'; What is the result?（）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 bef...
问题：单选题You want to start monitoring statistics on the distribution of storage engines that are being used and the average sizes of tables in the various databases. Some details are as follows: The Mysql instance has 400 databases. Each database on an average ...
问题：单选题You adjust a default configuration to the following /etc/my.cnf on a Linux installation:[mysqld] Loq-bin Binrylog_format=ROW You do not notice the spelling error in binrylog_format and restart your production server. How does the MySQL server behave wi...
