Oracle MySQL 5 Database Administrator Certified Professional Set 1

1.

In a standard MySQL installation which of following files are stored below the data directory?

Format files for all the tables Data and index files for MyISAM tables InnoDB tablespace files General server logs MySQL upgrade script files

2.

Where is the data stored for a table that is defined as using the FEDERATED Storage Engine?

The data will always be stored on the local host. The data will always be stored on a remote host. The data can be stored on any host depending on the definition of the table. The data will always be stored on disk. The data will always be stored in memory.

3.

Which of the following statements are true regarding the data directory on a Windows binary installation?

A script needs to be run to initialize it after installation. It comes pre-initialized. You can choose to pre-initialize it or initialize it manually during the installation.

4.

Which of the following are requirements for InnoDB binary portability?

Both machines must use the same operating system. Database and table names must use lowercase format. Both machines must use two's-complement integer arithmetic. Both machines must use IEEE floating-point format or contain no floating-point columns.

5.

Which of the following package types are provided specifically for UNIX-style OS installations?

Essentials RPM Source tar-packaged binary

6.

Which of the following are some benefits of using MySQL built binaries over binaries built by yourself?

They are highly optimized. They are cross-platform. Many are built using commercial compilers that produce a better quality build than with freely availablecompilers. They will work with tools such as MySQL Administrator and MySQL Query Browser. They may include libraries not available in the standard operating system library.

7.

A windows binary installation includes several servers in the MySQL installation directory. What is the purpose of the mysqld-nt server?

It is the standard server with no extra features It is the standard server with additional support for named pipes. It is the standard server with additional support for named pipes and extra storage engines. It is a debug-version of the server with named pipes and error reporting facilities to help track down errors inthe server. It is the standard server, compiled to be optimized forWindows NT 4.0 (but not otherWindows versions).

8.

When running the MySQL server under Windows, the --console option is used to display server errors in the console window.

1

9.

What will the following statement do in a Windows environment? Assume that there are no conflicts in the pathname definitions.

C:\> mysqld --install MySQL50 --defaults-file=C:\my-opts.cnf

MySQL 5.0 will be installed using default configuration file C:\my-opts.cnf. MySQL will be installed as Windows service name MySQL50 and will use C:\my-opts.cnf aswww.cramguides.com 8
configuration file. An error message will be issued as --install is not a valid option for mysqld.

10.

Suppose you install a server with a service name of "MySQL5" rather than the default.What sections in the option files will the server use for configuration?

[service] [MySQL5] [service MySQL5] [mysqld] [mysqld MySQL5]

Oracle MySQL 5 Database Administrator Certified Professional Set 1

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

COMPANY

Products

OTHERS

Partner

Oracle MySQL 5 Database Administrator Certified Professional Set 1

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

Detail Form

COMPANY

Products

OTHERS

Partner