Oracle MySQL 5 Database Administrator Certified Professional Set 2

1.

When working with InnoDB, which of the following is true when trying to create foreign key references?

Only the child column must be indexed. Only the parent column must be indexed. Both the parent & child columns must be indexed. InnoDB will not create an index automatically. InnoDB may create an index automatically.

2.

Which of the following statements are true for InnoDB?

InnoDB is enabled by default. Tablespace and log files have to be configured explicitly to be created. InnoDB is not enabled by default. Tablespace and log files will be created even if not configured explicitly.

3.

The my.cnf file contains the following entries:
innodb_data_home_dir =
innodb_data_file_path = /ibdata/ibdata1:50M;/disk2/ibdata2:50M:autoextend
Which of the following statements are true?

The initial size of the InnoDB data files on server startup will be set to 50MB. If more space is needed,another 50MB will be allocated. There are two InnoDB data files There are three InnoDB data files The total minimum size of the InnoDB data files is 100MB The total maximum size of the InnoDB data files is 100MB

4.

Which of the following are some general characteristics of the MEMORY storage engine?

Each table is represented on disk as a .frm file. They can support transactions. They can support foreign keys. They can not contain TEXT or BLOB columns Table contents will not be saved if the server is restarted.

5.

Which of the following are true for how BTREE and HASH index types should be used for MEMORY tables?

HASH index types are only for use with equality comparisions such as those using the = and <=> operators. BTREE index types are preferable for use with comparisons that do not just use equality operators such as= and <=> BTREE index types are only for use with equality comparisons such as those using the = and <=>operators. HASH index types are preferable for use with comparisons that do not just use equality operators such as =and <=>

6.

Which of the following statements are true for tables using the FEDERATED storage engine?

Each FEDERATED table is represented on disk by a .frm format file in the database directory of the local
server. For each FEDERATED table, the content of the referenced table is stored in a .FED file on the local server. The FEDERATED storage engine does not support transactions. The FEDERATED storage engine supports transaction if the storage engine of the referenced tablesupports transactions. The FEDERATED storage engine supports SELECT statements.

7.

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

The name and database of the referenced table The host name of the server where the referenced table is located The user name and password to be used to connect the remote server The compression method to be used The operating system of the remote server

8.

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

Create and Drop databases. Display replication server status. Create, Drop, and modify tables and indexes. Shutdown the server. Create users.

9.

Which of the following are some general capabilities of the mysqladmin client program?

Ping the server Shutdown the server. Create users. Create and drop databases. Dump the contents of a table.

10.

Which of the following are some general properties of the mysqlimport client program?

It loads data files into tables. It can load files only on the server host. It provides a command-line interface to the LOAD DATA INFILE. It can load files both on the client and server host. It bypasses the server and writes directly to the corresponding data files.

Oracle MySQL 5 Database Administrator Certified Professional Set 2

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 2

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