최신 1Z1-888 무료덤프 - Oracle MySQL 5.7 Database Administrator
You have a MySQL instance with the following variables in the /etc/my.cnf file:
You issue these statements:
USE prices;
UPDATE sales.january SET amount=amount+1000;
An hour after excluding the statements, you realize that you made a mistake and you want to go to the binary log and look at the statements again.
Which statement is true? (Choose two.)
You issue these statements:
USE prices;
UPDATE sales.january SET amount=amount+1000;
An hour after excluding the statements, you realize that you made a mistake and you want to go to the binary log and look at the statements again.
Which statement is true? (Choose two.)
정답: C,E
To query two system variables, you execute this statement and get the results shown:
When you execute the following two statements, only the first one succeeds:
SET @@autocommit=0;
SET @@max_connections=200;
Why does the second statement fail?
When you execute the following two statements, only the first one succeeds:
SET @@autocommit=0;
SET @@max_connections=200;
Why does the second statement fail?
정답: B
The following grants were executed:
GRANT CREATE ROUTING ON sales.* TO `webadmin'@'%';
GRANT ALTER ON PROCEDURE sales.myproc TO `webadmin'@'%';
A user successfully connects to the database as webadmin and created a stored procedure named get_reports. The next day, the user logs in again as webadmin and wants to delete the stored procedure named get_reports, and therefore, issues the following statement:
USE sales;
DROP PROCEDURE IF EXISTS get_reports;
What is the result of executing the statement?
GRANT CREATE ROUTING ON sales.* TO `webadmin'@'%';
GRANT ALTER ON PROCEDURE sales.myproc TO `webadmin'@'%';
A user successfully connects to the database as webadmin and created a stored procedure named get_reports. The next day, the user logs in again as webadmin and wants to delete the stored procedure named get_reports, and therefore, issues the following statement:
USE sales;
DROP PROCEDURE IF EXISTS get_reports;
What is the result of executing the statement?
정답: C
You have a config file for a running DB with this excerpt:
[mysqld]
tmp_table_size=16M
sort_buffer_size=256k
To address a query performance problem of connecting to the DB from an application on another host, you log in and make these changes to the DB:
mysql> SET GLOBAL tmp_table_size=32000000;
mysql> SET sort_buffer_size=2000000;
This solves the problem with your queries. However, later the DB instance is restarted and the performance problem returns.
Which three best describe this scenario? (Choose three.)
[mysqld]
tmp_table_size=16M
sort_buffer_size=256k
To address a query performance problem of connecting to the DB from an application on another host, you log in and make these changes to the DB:
mysql> SET GLOBAL tmp_table_size=32000000;
mysql> SET sort_buffer_size=2000000;
This solves the problem with your queries. However, later the DB instance is restarted and the performance problem returns.
Which three best describe this scenario? (Choose three.)
정답: A,B,E
Group Replication uses global transaction identifiers to track executed transactions and are fundamental in avoiding transaction conflict. Which additional three steps help in avoiding conflicts in group replication?
정답: A,C,D
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?
정답: A,E
You are looking at these details:
Why does the message "Waiting for an event from Coordinator" show up on the slave_worker threads?
Why does the message "Waiting for an event from Coordinator" show up on the slave_worker threads?
정답: A
설명: (DumpTOP 회원만 볼 수 있음)
Which statement best describes the purpose of the InnoDB buffer pool?
정답: A
설명: (DumpTOP 회원만 볼 수 있음)
One of your colleagues is trying to make a change using the mysql command-line client for his or her application session.
The colleague instant messages you this command:
mysql> SET SESSION max_connections = 200;
Why does the command fail?
The colleague instant messages you this command:
mysql> SET SESSION max_connections = 200;
Why does the command fail?
정답: A
You have created a new user with this statement:
CREATE USER `erika'@'localhost' IDENTIFIED BY `first#1Pass' PASSWORD EXPIRE; What is the outcome?
CREATE USER `erika'@'localhost' IDENTIFIED BY `first#1Pass' PASSWORD EXPIRE; What is the outcome?
정답: A
설명: (DumpTOP 회원만 볼 수 있음)