单选题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
多选题Which two options describe how MySQL Server allocates memory?()AThread memory is pre-allocated up to thread_cache_size for performanceBEach connection may have its own per-thread memory allocationsCGlobal memory resources are allocated at server startu...
Friday, December 15, 2023
多选题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...
Monday, February 12, 2024
单选题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...
Thursday, May 2, 2024
单选题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 connectio...
Monday, April 8, 2024
单选题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...
多选题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...
Monday, May 29, 2023
多选题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
多选题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 ...
单选题ROW-based replication has stopped working. You investigate the error log file and find the following entries: 2013-08-27 14:15:47 9056 [ERROR] Slave SQL: Could not execute Delete_rows event on table test.t1; Can't find record in 't1', Error_code: 1032;...
单选题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...
单选题Which High Availability solution can provide a consistent, time-delayed (for example, one hour) snapshot of the live production database?()A MySQL ReplicationB Distributed Replication Block DeviceC Windows Server Failover ClusteringD MySQL Cluster...
单选题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...
多选题You want to shutdown a running Mysql Server cleanly. Which three commands that are valid on either Windows or Linux will achieve this?()AShell> mysqladmin –u root –p shutdownBShell> nmc mysql shutdownCMysql> STOP PROCESS mysqldDShell> /etc/init.d/mysql...
Tuesday, April 9, 2024
单选题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 ...
多选题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...
单选题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