Oracle MySQL 5 Database Administrator Certified Professional Set 2

1.

Another user has issued the statement LOCK TABLE pets FOR WRITE You can...

Update table pets SELECT from table pets UPDATE and SELECT from table pets None of the above

2.

Index analysis and optimization using ANALYZE and OPTIMIZE statements should...

generally never be run manually be run once the table reaches 100,000 rows or above be run when more than 5% of the rows are changed by a single statement be run when EXPLAIN SELECT shows that an inordinate amount of rows is expected to be read duringquery execution be run when you suspect that a table is heavily fragmented

3.

Which of the following best describes the scope of explicitly and implicitly set locks?

Explicitly set locks may span several commands. Implicitly set locks may span several commands. Implicitly set locks will span only one statement or transaction. Explicitly set locks will span only one statement or transaction.

4.

When you acquire an advisory lock using GET_LOCK(), the lock is released if

You issue another GET_LOCK() statement You issue a RELEASE_LOCK() statement Your connection to the server terminates None of the above

5.

Which of the following best describes why table locking is often not desirable compared to page or row locking?

Table locks can have deadlocks. Table locks create concurrency issues. Table locks prevent other clients from making any changes to the table until released. Table locks can cause data corruption issues if more than one client tries to make changes while locked.

6.

With MyISAM table locking, deadlocks do not occur because:

All tables to be locked are sorted in an internally defined order If a table is locked with a read lock and a write lock, the write lock is set before the read lock Tables are locked one table at a time until the thread gets all the locks None of the above

7.

Which of the following (series of) statements will leave the three tables A, B and C locked for reading, writing and reading respectively once all statements have been executed?

mysql> LOCK TABLES A;mysql> LOCK TABLES B;mysql> LOCK TABLES C; mysql> LOCK TABLES A READ;mysql> LOCK TABLES B WRITE;mysql> LOCK TABLES C READ; mysql> LOCK TABLES A READ, B WRITE, C READ; LOCK TABLES A, B, C READ, WRITE, READ;

8.

You want to lock the three tables a, b and c, and issue the following statements:

mysql> LOCK TABLES a READ;
mysql> LOCK TABLES b READ;
mysql> LOCK TABLES c READ;

Which tables are now locked?

Tables a, b and c Table a only Table c only None of the tables are locked

9.

When choosing a storage engine for each of your tables, which things are to consider?

Locking Characteristics: Some storage engines lock on row level, some on page level, some on table level. Transactions support: Some storage engines support transactions, some don't. Storage media: Some storage engines store data on disk, some in memory. Licenses: Some storage engines cannot be used in commercial environments, others can. Backup methods: Some storage engines support online backup and point in time recovery, some don't.

10.

Which of the following variables specify the default storage engine to use if no storage engine is specified when creating a table?

default_engine storage_default storage_engine default_storage_engine

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