최신 MYSQL-Certifications 1Z0-873 무료샘플문제:
1. Which of the following statements are true regarding the data directory on a Windows binary installation?
A) You can choose to pre-initialize it or initialize it manually during the installation.
B) A script needs to be run to initialize it after installation.
C) It comes pre-initialized.
2. Which of the following is true for the command-line programs mysqlcheck and myisamchk?
A) mysqlcheck must run on the server to perform checks and repairs and myisamchk can perform checks and repairs on a remote server.
B) Both mysqlcheck and myisamchk can perform checks and repairs on a remote server.
C) mysqlcheck can perform checks and repairs on a remote server, and myisamchk must run on the server.
D) Neither mysqlcheck or myisamchk can perform checks and repairs on a remote server.
3. When working with MyISAM tables, which of the following statements are true regarding deadlocks?
A) Deadlocks are possible because of the MyISAM-specific method of row-level locking.
B) Deadlocks are not possible because of the MyISAM-specific method of table-level locking.
C) Deadlocks are possible because of the MyISAM-specific method of table-level locking.
D) Deadlocks are not possible because of the MyISAM-specific method of row-level locking.
4. When installing a RPM based distribution, the data directory will be set to which of the following locations?
A) /var/mysql/data
B) /usr/mysql/data
C) /usr/local/mysql/data
D) /var/lib/mysql
5. Which of the following describes how READ LOCAL locking works?
A) It locks a table for writing, preventing reads until it is released.
B) It locks a table for reading but allows concurrent inserts.
C) It locks a table for reading only by connections on localhost.
질문과 대답:
질문 # 1 정답: C | 질문 # 2 정답: C | 질문 # 3 정답: B | 질문 # 4 정답: D | 질문 # 5 정답: B |