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

• Answer
• Report

Report

Name Email

• A.
  Less work is required by the server to acquire and release locks.
• B.
  It can only be used with the MyISAM storage engine.
• C.
  Using LOCK TABLE sometimes decreases the amount disk reads and writes needed for a group of statements.
• D.
  All tables must be locked in a single statement.
• E.
  It creates more disk activity.

• Answer
• Report

Report

Name Email

• A.
  It uses multiversioning to isolate transactions.
• B.
  It is not possible for deadlocks to occur.
• C.
  It does not isolate transactions.
• D.
  It is possible for deadlocks to occur.

• Answer
• Report

Report

Name Email

• A.
  When you need to find out why a query is taking a long time to execute.
• B.
  To improve performance by updating index distribution statistics.
• C.
  After large amounts of table data have changed.
• D.
  To check a tables structure to see if it may have been damaged and needs repair.

• Answer
• Report

Report

Name Email

• A.
  It is used to cache row data in open tables
• B.
  It holds file descriptors for open tables
• C.
  It holds file descriptors for open tables
• D.
  Each connection has its own table cache. They are of equal size, set globally.
• E.
  There is one table cache, shared among all sessions.
• F.
  Increasing the size of the variable table_cache allows mysqld to keep more tables open simultaneously

• Answer
• Report

Report

Name Email

• Pages
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• 21