MYSQL MySQL 5.0 Database Administrator Certified Professional Exam, Part II 認定 1Z0-874 試験問題:
1. Consider the following: mysql> EXPLAIN SELECT * FROM City WHERE CountryCode = 'USA' *************************** 1. row *************************** id: 1 select_type: SIMPLE table: City type: ALL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: 4079
Extra: Using where
Which of the following best describes the meaning of the "id" column in the output from EXPLAIN?
A) Which SELECT the row refers to.
B) Which process it is running as.
C) It is just an incremental number to identify the rows from the output.
2. Why should you be selective when granting the SUPER privilege to an account? (Choose two)
A) Because it allows client accounts to takeover other client accounts.
B) Because it allows a client to kill other client connections.
C) Because it allows changing of the server runtime configuration.
D) Because it allows a client to shutdown the server.
3. Which factors can be considered in a stored routine to allow or disallow access or modification of data? (Choose two)
A) The number of current connections
B) The identity of the client user
C) The current date and time
D) The CPU load of the system
4. Which of the following best describes the relationship between MAX_ROWS, AVG_ROW_LENGTH and the max table size?
A) MAX_ROWS * AVG_ROW_LENGTH tells MySQL how large you expect the table to grow to.
B) Specifying MAX_ROWS and AVG_ROW_LENGTH will prevent MySQL from growing the table beyond that limit.
C) MAX_ROWS + AVG_ROW_LENGTH tells MySQL to not let the table grow past that size.
D) Specifying MAX_ROWS and AVG_ROW_LENGTH doesn't prevent MySQL from growing the table beyond that limit.
5. Consider a stored procedure or function that is going to be executed. Which of the following statements are true? (Choose two)
A) First, the global privileges are checked, then the database level privileges, then the stored routine level privileges.
B) If the stored routine contains commands that access other databases and tables, access control for these objects will also be processed.
C) First, the global privileges are checked, then the stored routine level privileges, then the database level privileges.
D) First, the database level privileges are checked, then the global privileges, then the stored routine level privileges.
質問と回答：
| 質問 # 1 正解： A | 質問 # 2 正解： B、C | 質問 # 3 正解： B、C | 質問 # 4 正解： D | 質問 # 5 正解： A、B |
1279 お客様のコメント
品質保証JPexamはIT認定試験のシラバスに従って、試験問題の範囲を正確に絞って、的中率が99％の最新問題集を捧げます。
1年間の無料更新サービスJPexamは1年以内に問題集の無料更新サービスを提供し、お客様がいつでも最新版の問題集を持つことを保証いたします。もし試験の内容が変更されたら、弊社は直ちにお客様にお知らせします。それに、弊社の問題集が更新されたら、早速メールで最新バージョンを送付いたします。
全額返金JPexamの問題集を利用すると、短時間で勉強しても試験に合格できるのを保証いたします。試験に不合格になってしまった場合、弊社は全額返金いたします。(
ご購入前のお試しJPexamは問題集のサンプルを無料で提供いたします。ご購入前にサンプルを試用して製品の品質を確認することができます。ご遠慮なく利用してください。
