File Info
| Exam | MySQL 5.7 Database Administrator |
| Number | 1z0-888 |
| File Name | Oracle.1z0-888.SelfTestEngine.2018-10-29.50q.tqb |
| Size | 1 MB |
| Posted | Oct 29, 2018 |
| Download | Oracle.1z0-888.SelfTestEngine.2018-10-29.50q.tqb |
How to open VCEX & EXAM Files?
Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.
Coupon: MASTEREXAM
With discount: 20%
Demo Questions
Question 1
Which two statements are true about InnoDB auto-increment locking? (Choose two.)
- InnoDB never uses table_level locks.
- InnoDB always protects auto-increment updates with a table-level lock
- InnoDB does not use locks to enforce auto-increment uniqueness.
- The auto-increment lock can be a table-level lock.
- Some settings for innodb_autoinc_lock_mode can help reduce locking.
Correct answer: DE
Question 2
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? (Choose two.)
- Set binlog_format=MIXED with the --replicate-ignore-temp-table option.
- Use the --replicate-do-db, --replicate-do-table, or --replicate-wild-do-table option with the value equal to OLD_INVENTORY.
- Change the binlog_format option to ROW and restart mysqld before you create the OLD_INVENTORY table.
- Stop SQL_THREAD on the slave until you have finished using the OLD_INVENTORY temporary table.
- Use the --replicate-ignore-table option with the value equal to OLD_INVENTORY.OLD_INVENTORY and restart mysqld before creating the temporary table.
Correct answer: BE
Question 3
Which three allocate memory per thread in MySQL? (Choose three.)
- query cache
- thread cache
- read buffer
- internal temporary table
- sort buffer
- InnoDB buffer pool instance
Correct answer: CEF
Explanation:
Reference: https://dev.mysql.com/doc/refman/5.6/en/memory-use.html Reference: https://dev.mysql.com/doc/refman/5.6/en/memory-use.html
