MYSQL MySQL 5.0 Database Administrator Certified Professional Exam, Part I 認定 1Z0-873 試験問題:
1. Which of the following statements are true regarding table locks?
A) They can be released by other connections than the client holding them.
B) They can only be released by the client holding them.
C) They are implicitly released when the connection is closed.
D) They are not released when the connection is closed
2. Another user has issued the statement LOCK TABLE pets FOR WRITE You can...
A) Update table pets
B) None of the above
C) SELECT from table pets
D) UPDATE and SELECT from table pets
3. Which of the following statements are true for InnoDB?
A) InnoDB is not enabled by default.
B) Tablespace and log files will be created even if not configured explicitly.
C) Tablespace and log files have to be configured explicitly to be created.
D) InnoDB is enabled by default.
4. Suppose you have a column in which most records are going to be between 30 and 32 characters. Which of the following column types would be most efficient?
A) TEXT
B) Either VARCHAR or CHAR
C) VARCHAR
D) CHAR
5. Which of the following statements correctly describes the way to enable and use shared memory connections to the MySQL database server?
A) Shared memory connections are supported on all windows binaries, and must be enabled by using the --shared-memory command line option.
B) Shared memory is not a supported communication method for the MySQL database server.
C) Shared memory connections are available by default on all platforms, but must have TCP/IP networking disabled by using the --skip-networking option.
D) Shared memory connections are supported on all windows binaries, and is enabled by default.
質問と回答：
| 質問 # 1 正解： B、C | 質問 # 2 正解： B | 質問 # 3 正解： B、D | 質問 # 4 正解： D | 質問 # 5 正解： A |
773 お客様のコメント
品質保証JPexamはIT認定試験のシラバスに従って、試験問題の範囲を正確に絞って、的中率が99％の最新問題集を捧げます。
1年間の無料更新サービスJPexamは1年以内に問題集の無料更新サービスを提供し、お客様がいつでも最新版の問題集を持つことを保証いたします。もし試験の内容が変更されたら、弊社は直ちにお客様にお知らせします。それに、弊社の問題集が更新されたら、早速メールで最新バージョンを送付いたします。
全額返金JPexamの問題集を利用すると、短時間で勉強しても試験に合格できるのを保証いたします。試験に不合格になってしまった場合、弊社は全額返金いたします。(
ご購入前のお試しJPexamは問題集のサンプルを無料で提供いたします。ご購入前にサンプルを試用して製品の品質を確認することができます。ご遠慮なく利用してください。
