多选题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 ...
Sunday, June 2, 2024
单选题You use—login-path to access a MySQL server on a Linux installation. Which statement is true about the – login-path option that is created by using mysql_config_editor?()A All system users have access to the MySQL server via—login path localB login-pat...
单选题Review the definition of the phone_list view. CHEATE OR REPLACE ALGORITHM=MERGE DEFINER= 'root'@localhost' SQL SECURITY DEFINER VIEW 'phone_list' AS SELECT e . id as id 'e . first_name AS 'first_name' 'e . last_name AS 'last_name' 'coalesce ( ph1.phone...
Wednesday, December 20, 2023
单选题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...
Friday, December 15, 2023
单选题You have taken a Logical Volume Manager (LVM) snapshot backup of a volume that contains the MySQL data directory. Why is it important to remove snapshots after completing a RAW backup in this way?()A The snapshot size will continue to grow as changes t...
Monday, April 8, 2024
多选题Mysqldump was used to create a single schema backup; Shell mysqldump –u root –p sakila sakila2013.sql Which two commands will restore the sakila database without interfering with other running database?()AMysql> USE sakila; LOAD DATA INFILE 'sakila201...
Thursday, May 2, 2024
多选题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...
Thursday, January 4, 2024
单选题While reviewing the MySQL error log, you see occasions where MySQL has exceeded the number of file handles allowed to it by the operating system. Which method will reduce the number of file handles in use?()A Activating the MySQL Enterprise thread pool...
Tuesday, August 15, 2023
单选题The validate_password plugin is loaded and displays the following settings in global variables: Mysql> SHOW VARIABLES LIKE ‘validate_password%’; When attempting to set your password, you get the following error: Mysql> SET PASSWORD = PASSWORD (‘Hoverl@...
单选题You are attempting to secure a MySQL server by using SSL encryption. On starting MySQL, you get this error: 130123 10:38:02 [ERROR] mysqld: unknown option '—ssl' What is the cause of the error?()A The — ssl level was not specifiedB The server was not s...
Friday, May 24, 2024
单选题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...
单选题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...
单选题Your developers have created table to store some of their program's data. After examining the slow Query Log, you see that they are using the LIKE operator and SUBSTER ( ) functions against a VARCHAR (10000) column quite often. An example of the start ...
多选题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...
单选题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 ...
单选题Which statement is true about FLUSH LOGS command?()A It requires the RELOAD, FILE, and DROP privilegesB It closes and reopens all log filesC It closes and sends binary log files to slave serversD It flushes dirty pages in the buffer pool to the REDO lo...
单选题You have a login-path named "adamlocal" that was created by using the mysql_config_editor command. You need to check what is defined for this login_path to ensure that it is correct for you deployment. You execute this command: $mysql_config_editor pri...
多选题Which three data components are needed for point-in-time recovery?()AThe error logBThe backup logCThe general query logDBinary logsEThe data backupFConfiguration files...
单选题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 need to replicate a table from a master to a slave. The master and slave copies of the table will have different number of columns. Which two conditions must be true?()AEach extra column in the copy with more columns must not have a default valueBC...