1Z1-888 考試範圍廣、題型靈活，不少考生第一次應考都低估了它的難度。KaoGuTi 的 Oracle MySQL 5.7 Database Administrator 題庫依據最新考試內容整理 155 道模擬試題，幫你提前熟悉出題方式。

Oracle 1Z1-888 考試概覽:

認證廠商:	Oracle
考試名稱:	Oracle MySQL 5.7 Database Administrator
考試代碼:	1Z0-888
考試形式:	複選題, 單選題
考試費用:	245 美元（可能因地區而異）
證照有效期限:	未明確定義（取決於 Oracle 認證政策）
及格分數:	未公開
支援語言:	English
相關認證:	Oracle Certified Associate, MySQL 5.7 Database Administrator
實際考試題數:	約 63 題單選與複選題
考試時間:	120 分鐘
推薦課程:	Oracle MySQL 培訓課程 MySQL 官方文件
考試報名:	Oracle 認證註冊 Pearson VUE Oracle 考試
範例考題:
考試方式:	透過 Pearson VUE 或 Oracle 測試夥伴進行線上監考考試
必備條件:	建議具備管理 MySQL 5.7 資料庫的實際操作經驗，並理解關聯式資料庫的概念
官方大綱網址:	https://education.oracle.com/mysql-dba-5-7/pexam_1Z0-888

Oracle 1Z1-888 考試大綱主題:

Oracle MySQL 5.7 Database Administrator 考試常見問題解答

最新的 MySQL Database Administration 1Z1-888 免費考試真題：

問題 #1

Due to an authentication plug-in that is used on the server, passwords are required to be sent as clear text as opposed to the usual encrypted format.
Which two methods would allow the mysql client to connect to the server and send clear text passwords?

A. INSTALL PLUGIN mysql_cleartext_password SONAME `mysql_cleartext_password.so';
B. mysql --enable-cleartext-plugin -uroot -p -h dbhost.example.com
C. export LIBMYSQL_ENABLE_CLEARTEXT_PLUGIN='Y'
D. SET GLOBAL mysql_cleartext_passwords=1;
E. mysql --protocol=PLAIN -uroot -p -h dbhost.example.com

問題 #2

You want to immediately stop access to a database server for remote user
'mike'@'client.example.com'. This user is currently not connected to the server.
Which two actions can you take to stop any access from the user? (Choose two.)

A. Use ALTER USER `mike'@'client.example.com' PASSWORD EXPIRE;
B. Execute the mysql_secure_installation command.
C. Use ALTER USER `mike'@'client.example.com' ACCOUNT LOCK;
D. Use GRANT USAGE ON *.* TO `mike'@'client.example.com' MAX_USER_CONNECTIONS=0;
E. Use DROP USER `mike'@'client.example.com';
F. Use REVOKE ALL PRIVILEGES FROM `mike'@'client.example.com';

問題 #3

What three are correct statements about MySQL backups? (Choose three.)

A. They are used to prevent data corruption.
B. They are used to set up the initial binary log files.
C. They are used to recover data.
D. They are used to prevent data theft.
E. They are used to set up a test system.
F. They are used to set up a replication slave.

問題 #4

An employee cannot access the company database. You check the connection variables:

A look at the user privileges shows:

What is a valid for why one of the users is unable to connect to the database?

A. All users are blocked because max_user_connections is accumulated over the host account information.
B. Joe has exceeded the max_user_connections global limit.
C. connect_timeout is too small to allow a connection to occur.
D. Kay is already connected elsewhere and attempting to log in again.
E. Bob has max_user_connections set to zero, which blocks all his connections.

問題 #5

Suppose you are adding rows to a MyISAM table and the --datadir location runs out of disk space.
What will happen when this occurs?

A. An error message will be returned to the client .Server Error: ER_IO
B. The server suspends operations for all storage engines until space becomes available.
C. The server will crash.
D. The server suspends that INSERT operation until space becomes available.

問題與答案：