Question 131
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?
Question 132
Which three allocate memory per thread in MySQL? (Choose three.)
Question 133
Which two statements are true regarding the creating of new MySQL physical and logical backups?
Question 134
Which two statements are true about InnoDB auto-increment locking? (Choose two.)
Question 135
You inherited a busy InnoDB OLTP Instance with 100 schemas and 100 active users per schema.
* Total dataset size is 200G with an average schema size of 2G.
* The data is transient and is not backed up and can be repopulated easily.
* Performance and responsiveness of the DB is paramount.
* The query pattern for the DB instance is split 90/10 read/write.
* DB host is dedicated server with 256G RAM and 64 cores.
One of your colleagues made some recent changes to the system and users are now complaining of performance impacts.
Which four configuration file edits might your colleague have performed to cause the negative DB performance? (Choose four.)
* Total dataset size is 200G with an average schema size of 2G.
* The data is transient and is not backed up and can be repopulated easily.
* Performance and responsiveness of the DB is paramount.
* The query pattern for the DB instance is split 90/10 read/write.
* DB host is dedicated server with 256G RAM and 64 cores.
One of your colleagues made some recent changes to the system and users are now complaining of performance impacts.
Which four configuration file edits might your colleague have performed to cause the negative DB performance? (Choose four.)