当前分类: 1z0-883
问题:多选题In a design situation, there are multiple character sets that can properly encode your data. Which three should influence your choice of character set?()ASyntax when writing queries involving JOINSBMemory usage when working with the dataCCharacter set ...
查看答案
问题:多选题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...
问题:多选题What are three actions performed by the mysql_secure_installation tool?()AIt prompts you to set the root user account passwordBIt checks whether file permissions are appropriate within datadirCIt asks to remove the test database, which is generated at ...
问题:多选题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...
问题:多选题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 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 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...
问题:单选题A database exists as a read-intensive server that is operating with query_cachek_type =DEMAND. The database is refreshed periodically, but the resultset size of the queries does not fluctuate. Note the following details about this environment: A web ap...
问题:单选题Following a server crash, the automatic recovery of InnoDB fails. How would you begin to manually repair the InnoDB tables?()A Start the server with the – innodb_recover_options option set to FORCEB Start the server with the – innodb_force_recovery opt...
问题:多选题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...
问题:单选题An existing master-slave setup is currently using a delayed replication of one hour. The master has crashed and the slave must be "rolled forward" to provide all the latest data. The SHOW SLAVE STATUS indicates the following values: RELAY_LOG_FILE =hos...
问题:多选题Which two events will cause a slave server to create a new relay log file?()AExecution of the FLUSH LOGS statementBStarting of the SQL threadCReaching the slave_pendign _jobs_size_max limitDExecution of FULSH TABLES WITH READ LOCKEStarting of the I/O t...
问题:多选题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...
问题:单选题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 ...
问题:单选题An employee cannot access the company database. You check the connection variables: What is a valid explanation for why one of the users is unable to connect to the database?()A Bob has max_user_connections set to zero, which blocks all his connection...
问题:单选题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...
问题:多选题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...
问题:多选题Which two statements are true about setting the per-thread buffers higher than required?()AMore memory per thread is beneficial in all scenariosBIt causes increased overhead due to initial memory allocationCIt can affect system stability during peak lo...
问题:单选题Which MySQL utility program should you to process and sort the slow Query log based on query time or average query time?()A MysqlaccessB MysqldumpC MysqlshowD MysqlslowE Mysqldumpslow...