<< Prev Question Next Question >>

Question 87/159

You want to create a temporary table named OLD_INVENTORY in the OLD_INVENTORY database on the master server. This table is not to be replicated to the slave server. Which two changes would ensure that the temporary table does not propagate to the slave?

LEAVE A REPLY

Your email address will not be published. Required fields are marked *

Question List (159q)
Question 1: You are using the Performance Schema to investigate replicat...
Question 2: You have just created a replication slave from a backup of t...
Question 3: Which command-line utility creates encrypted files that can ...
Question 4: Which two statements are true regarding the creating of new ...
Question 5: You have a MySQL replication setup and you intentionally sto...
Question 6: Examine the mysqldumpslow output: (Exhibit) Which two option...
Question 7: The MySQL installation includes the mysql_config_editorutili...
Question 8: After rebooting the host, you attempt to start the mysqld se...
Question 9: When you examine a new MySQL installation with default confi...
Question 10: You have a config file for a running DB with this excerpt: [...
Question 11: What are two benefits of using the --tab option with mysqldu...
Question 12: What does the Performance Schema provide?...
Question 13: Which statement is true about tablespaces?...
Question 14: You attempt to connect to a MySQL Server by using the mysql ...
Question 15: A master-slave replication setup has the slave showing this ...
Question 16: One of your colleagues is trying to make a change using the ...
Question 17: A MySQL Server has been running an existing application succ...
Question 18: Consider the join_buffer_sizeparameter in MySQL Server. Whic...
Question 19: Examine the mydata table and SELECT statements: (Exhibit) Yo...
Question 20: Given these table definitions and the explain plan: (Exhibit...
Question 21: These details are shown when logged in to an account: (Exhib...
Question 22: You have a MySQL instance with the following variables in th...
Question 23: Due to an authentication plug-in that is used on the server,...
Question 24: You inherited a busy InnoDB OLTP Instance with 100 schemas a...
Question 25: You have taken a Logical Volume Manager (LVM) snapshot backu...
Question 26: Consider: (Exhibit) Which statement best describes the meani...
Question 27: You want to immediately stop access to a database server for...
Question 28: What is the order of tables shown in an EXPLAINoutput?...
Question 29: You have installed the validate_password plug-in and set the...
Question 30: The MySQL installation includes the mysql_config_editorutili...
Question 31: These details are shown when logged in to an account: (Exhib...
Question 32: The 'applicationdb' is using InnoDB and consuming a large am...
Question 33: A MySQL replication slave is set up as follows: Uses all Inn...
Question 34: SQL injection is a common security threat. Which two methods...
Question 35: Consider: (Exhibit) Which statement best describes the meani...
Question 36: A MySQL replication slave is set up as follows: Uses all Inn...
Question 37: Consider: (Exhibit) Which statement best describes the meani...
Question 38: Consider the CHECK TABLE command. In which two situations sh...
Question 39: Consider the CHECK TABLE command. In which two situations sh...
Question 40: Which statement best describes the purpose of the InnoDB buf...
Question 41: Which statement is correct about how InnoDB storage engine u...
Question 42: Which two statements are true about InnoDB auto-increment lo...
Question 43: Which three allocate memory per thread in MySQL? (Choose thr...
Question 44: You are no longer able to log in to an existing MySQL Server...
Question 45: Consider: (Exhibit) Which statement best describes the meani...
Question 46: The MySQL error log shows: InnoDB: Warning: a long semaphore...
Question 47: You have the following in your my.cnf configuration file: [m...
Question 48: You have installed the validate_password plug-in and set the...
Question 49: You inherited a busy InnoDB OLTP Instance with 100 schemas a...
Question 50: Host slave1 has ip address 192.0.2.10. Host slave2 has ip ad...
Question 51: Suppose you are adding rows to a MyISAM table and the --data...
Question 52: A MySQL database uses all InnoDB tables and is configured as...
Question 53: You are setting up a new installation of MySQL Server 5.7 (a...
Question 54: You are creating a strategy for backing up MySQL using a col...
Question 55: Exhibit: (Exhibit) What does the possible_keys column in thi...
Question 56: Which MySQL utility copies the master instance to a slave in...
Question 57: You have installed MySQL Server for the first time on your s...
Question 58: Consider these global status variables: (Exhibit) Which two ...
Question 59: You have forgotten the rootuser account password. You decide...
Question 60: Due to an authentication plug-in that is used on the server,...
Question 61: Consider that local disk files are accessible via MySQL with...
Question 62: Consider the index information for the dept_emp table in the...
Question 63: The Performance Schema includes these tables related to stat...
Question 64: SQL injection is a common security threat. Which two methods...
Question 65: You have a MySQL replication setup and you intentionally sto...
Question 66: You back up by using mysqldump. Which configuration is requi...
Question 67: What three are correct statements about MySQL backups? (Choo...
Question 68: Examine the mydatatable and SELECTstatements: (Exhibit) You ...
Question 69: A MySQL replication slave is set up as follows: * Uses all I...
Question 70: An existing master-slave setup is currently using a delayed ...
Question 71: An employee cannot access the company database. You check th...
Question 72: To satisfy a security requirement, you have created or alter...
Question 73: When you examine a new MySQL installation with default confi...
Question 74: You will configure a MySQL Server to act as a replication ma...
Question 75: The MySQL instance is a default RPM installation on a Linux ...
Question 76: After rebooting the host, you attempt to start the mysqldser...
Question 77: You have installed MySQL Server for the first time on your s...
Question 78: There are multiple instances of MySQL Server running on a si...
Question 79: Due to an authentication plug-in that is used on the server,...
Question 80: You have just executed a manual backup by using this command...
Question 81: You are asked to examine user accounts and find: (Exhibit) W...
Question 82: You have a MySQL replication setup and you intentionally sto...
Question 83: A general purpose MySQL instance is configured with the foll...
Question 84: Which statement is true about tablespaces?...
Question 85: You have a scheduled task on Linux that executes mysqldumpag...
Question 86: You have a server that has very limited memory but has a ver...
Question 87: You want to create a temporary table named OLD_INVENTORY in ...
Question 88: The MySQL installation includes the mysql_config_editor util...
Question 89: Which two are considered good security practices when using ...
Question 90: You have a server that has very limited memory but has a ver...
Question 91: An admin attempts to enforce stronger security by using thes...
Question 92: A simple master-to-slave replication is currently being used...
Question 93: You are using replication and the binary log files on your m...
Question 94: Which two capabilities are granted with the SUPER privilege?...
Question 95: Consider a replication setup where a snapshot of the replica...
Question 96: The MySQL error log shows: InnoDB: Warning: a long semaphore...
Question 97: You have a MySQL instance with the following variables in th...
Question 98: Consider the table people with the definition: (Exhibit) The...
Question 99: Consider: (Exhibit) Which statement best describes the meani...
Question 100: The MySQL error log shows: InnoDB: Warning: a long semaphore...
Question 101: You want to create the first configuration file for a new in...
Question 102: You have a MySQL instance with the following variables in th...
Question 103: Consider the key buffer in a MySQL server. Which two stateme...
Question 104: You have issued this statement: GRANT PROXY ON 'a' FOR 'b'; ...
Question 105: How does the InnoDB storage engine handle deadlocks when the...
Question 106: An existing master-slave setup is currently using a delayed ...
Question 107: A MySQL replication slave is set up as follows: Uses all Inn...
Question 108: An existing master-slave setup is currently using a delayed ...
Question 109: A single InnoDB table has been dropped by accident. You are ...
Question 110: A MySQL database uses all InnoDB tables and is configured as...
Question 111: The Performance Schema includes these tables related to stat...
Question 112: These details are shown when logged in to an account: (Exhib...
Question 113: Which two methods accurately monitor the size of your total ...
Question 114: What is the order of tables shown in an EXPLAIN output?...
Question 115: A MySQL database uses all InnoDB tables and is configured as...
Question 116: Consider the join_buffer_sizeparameter in MySQL Server. Whic...
Question 117: You are no longer able to log in to an existing MySQL Server...
Question 118: You have a MySQL instance with the following variables in th...
Question 119: You have the following in your my.cnf configuration file: [m...
Question 120: You have the following in your my.cnf configuration file: [m...
Question 121: Consider that local disk files are accessible via MySQL with...
Question 122: After analysis on the slow query log on a high-end OLTP serv...
Question 123: On a master server that is using statement-based replication...
Question 124: What is the best method for monitoring Group Replication con...
Question 125: Why should you be selective when granting the PROCESSprivile...
Question 126: You created a backup of the worlddatabase with this command:...
Question 127: These details are shown when logged in to an account: (Exhib...
Question 128: You created a backup of the world database with this command...
Question 129: Examine the mysqldumpslow output: (Exhibit) Which two option...
Question 130: You have the following in your my.cnf configuration file: [ ...
Question 131: A particular government's security policy is to have very st...
Question 132: You will configure a MySQL Server to act as a replication ma...
Question 133: You are investigating the performance of the server and see ...
Question 134: An admin attempts to enforce stronger security by using thes...
Question 135: A MySQL replication slave is set up as follows: * Uses all I...
Question 136: Consider the index information for the dept_emptable in the ...
Question 137: A simple master-to-slave replication is currently being used...
Question 138: Multiversion Concurrency Control (MVCC) enables what type of...
Question 139: What two statements are true regarding FLUSH TABLES FOR EXPO...
Question 140: Consider that local disk files are accessible via MySQL with...
Question 141: You are asked to examine user accounts and find: (Exhibit) W...
Question 142: What are three typical causes of MySQL becoming suddenly slo...
Question 143: You have a consistent InnoDB backup created with mysqldump, ...
Question 144: After rebooting the host, you attempt to start the mysqldser...
Question 145: An administrator installs MySQL to run under a mysqlOS accou...
Question 146: You are investigating the performance of a query which selec...
Question 147: You are using GTIDS in replication. You need to skip a trans...
Question 148: Which three statements correctly describe MySQL InnoDB Clust...
Question 149: You have the following in your my.cnf configuration file: [m...
Question 150: Which three allocate memory per thread in MySQL?...
Question 151: An admin attempts to enforce stronger security by using thes...
Question 152: You are using replication and the binary log files on your m...
Question 153: A MySQL instance has this configuration values set: (Exhibit...
Question 154: You need to dump the data from the master server and import ...
Question 155: How does the InnoDB storage engine handle deadlocks when the...
Question 156: After analysis on the slow query log on a high-end OLTP serv...
Question 157: Consider the index information for the dept_emptable in the ...
Question 158: Which three allocate memory per thread in MySQL?...
Question 159: You have a MySQL replication setup and you intentionally sto...