Online Access Free 1z1-882 Practice Test

An application packs several fields of information into the details column of the table sensors. The first six characters
of that data represent a location code.
Example: "ABCDEFOO -ooozzz comments will be here FIELDS----FIELD64"
Given the query pattern:
SELECT ... FROM sensors WHERE details LIKE 'ABCDEF%'
Which three ALTER TABLE commands enable the optimizer to user an index for this WHERE patterns?

• A.ALTER TABLE sensors ADD KEY (details (8) ) USING HASH
• B.ALTER TABLE sensors ADD FULLTEX (details)
• C.ALTER TABLE sensors ADD KEY (details (8)) USING BTREE
• D.ALTER TABLE sensors ADD KEY (details) USING HASH
• E.ALTER TABLE sensors ADD KEY (details ) USING BTREE

Which two can be used to obtain information stored in the Diagnostics Area?

• A.SHOW WARNINGS
• B.SHOW GLOBAL STATUS LIKE 'Diagnostics'
• C.SELECT ERRNO, MESSAGE_TEXT FROM INFORMATION_SCHEMA.DIAGNOSTICS_AREA WHERE CONDITION=1
• D.GET DIAGNOSTICS CONDITION 1 @errno=MYSQL_ERRNO, @msg =MESSAGE_TEXT;
  SELECT @errno, @msg;

Which two Functions can be used in a C program to retrieve information about warning?

• A.mysql_error
• B.mysql_errno
• C.mysql_info
• D.mysql_warning_count

What are two ways in which normalizing your tables helps improve performance In MySQL?

• A.Normalizing Improves the performance of innodb_file_per _table.
• B.Fewer nullable column improve index usage.
• C.Smaller table sizes and row lengths improve sorting operations.
• D.Separate tables allow indexing more columns.

In MYSQL 5.6 you have the table t1:
CREATE TABLE t1 (
id int unsigned NOT NULL PRIMARY key) ENGINE = InnoDB;
There are two connections to the server. They execute in this order:
Connection 1> SET TRANSACTION ISOLATION LEVEL REPEATABLE READ;
Connection 1> START TRANSACTION;
Connection 1> SELECT * FROM t1 WHERE id =1;
Connection 2> TRUNCATE TABLE t1;
What happens to the TRUNCATE TABLE command in connection 2?

• A.It blocks waiting for a metadata lock until the transaction in connection 1 ends.
• B.It immediately proceeds and causes an implicit commit of the transaction in connection1.
• C.It runs concurrently with the transaction in connection 1 as each connection has its own view of the data in the t1
  table.
• D.It blocks waiting for a table lock until the transaction in connection 1 ends.