1z0-882 試験問題を無料オンラインアクセス

Given the table City:
SELECT Name
FROM City
WHERE CountryCode = 'USA" OR WHERE CountryCode= 'JPN'
What does this statement procedure?

• A.No result set is returned and an error message is given.
• B.A single result set with one column that contains the names of cities from country codes USA and JPN.
• C.A single result set with two columns containing the names from country codes USA and JPN.
• D.Two result sets each containing a single column with the names of cities from country codes USA and JPN.

The people table contains the data as shown:

Which two statements return two rows each?

• A.SELECT DISTINCT last_name, first_name FROM people
• B.SELECT 1,2 FROM people GROUP BY last_name
• C.SELECT first _name, last_name FROM people LIMIT 1, 2
• D.SELECT 1, 2 FROM people WHERE last _name ='smith'
• E.SELECT first_name, last _name FROM people WHERE age LIKE '2'

Your application is running slow.
Which two features provide information that help to identify problems?

• A.The GET DIAGNOSTICS statement
• B.The performance schema
• C.The MYSQL error log
• D.The slow query log

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

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

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

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