最新的MYSQL-Certifications認證 1Z0-873考試題庫

問題1

Which of the following are some general capabilites of the mysql client program?

A. Create, Drop, and modify tables and indexes.

B. Display replication server status.

C. Create users.

D. Ping the server.

E. Create and Drop databases.

F. Shutdown the server.

正確答案: A,B,C,E

說明：（僅 VCESoft 成員可見）

問題2

Which of the following correctly defines the general difference between a read lock and a write lock?

A. A read lock prevents any other client from reading the same data, until the lock is released.

B. A write lock only prevents any other client from modifying the locked data until the lock is released.

C. A write lock prevents any other client from reading or writing the locked data until the lock is released.

D. A read lock allows other clients to read the same data, however will prevent any modification of the data until the lock is released.

正確答案: C,D

說明：（僅 VCESoft 成員可見）

問題3

Besides specifying the column names and data types, which connection parameters may be defined when defining a FEDERATED table?

A. The host name of the server where the referenced table is located

B. The operating system of the remote server

C. The compression method to be used

D. The user name and password to be used to connect the remote server

E. The name and database of the referenced table

正確答案: A,D,E

說明：（僅 VCESoft 成員可見）

問題4

Of the following mechanisms available to connect a MySQL client to a MySQL database server, which types of connections are only available on Windows based systems?

A. TCP/IP

B. Named Pipes

C. Sockets

D. Shared Memory

正確答案: B,D

問題5

Assume you created a backup of the world database by the following statement.
shell> mysqldump --opt world > dump.sql
How can you import the data from this dumped file into the test database?

A. shell> mysql test < dump.sql

B. mysql> RECOVER test dump.sql;

C. mysql> USE test;mysql> SOURCE dump.sql;

D. shell> mysqladmin recover test dump.sql

正確答案: A,C

說明：（僅 VCESoft 成員可見）

問題6

Isolation levels can be set...

A. Per session

B. Per user name

C. Globally

D. Per transaction

正確答案: A,C,D

說明：（僅 VCESoft 成員可見）

問題7

mysqldump can be instructed to include commands to drop and recreate tables before trying to create or load data.

A. False

B. True

正確答案: B

說明：（僅 VCESoft 成員可見）

問題8

When will you be able to copy InnoDB table space files to other systems and use the data there?

A. Both systems need to be either 32 Bit or 64 Bit platforms.

B. Both systems must be either little endian or big endian architecture.

C. You can always use them, because InnoDB files are platform independent.

D. Both systems need to run the same operating system.

正確答案: C

說明：（僅 VCESoft 成員可見）

最新的MYSQL MySQL 5.0 Database Administrator Certified Professional Exam, Part I - 1Z0-873免費考試真題

最新更新

站內鏈接

聯系我們