Online Access Free 1Z0-874 Exam Questions

Which of the following are reasons you would want to normalize your data? (Choose three)

• A.It removes redundant data.
• B.It makes data access more flexible.
• C.It is the only way to make your data internationalized.
• D.It helps eliminate possible data inconsistencies.
• E.It makes backups more efficient.

Consider the following EXPLAIN of a simple Join:
mysql> EXPLAIN SELECT CountryList.Name, CityList.Name, CityList.Population
-> FROM CountryList JOIN CityList ON CountryList.Code = CityList.Country
-> WHERE CityList.Population > 8000000 *************************** 1. row *************************** id: 1 select_type: SIMPLE table: CountryList type: ALL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: 239 Extra: *************************** 2. row *************************** id: 1 select_type: SIMPLE table: CityList type: ALL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: 4079 Extra:
Using where How many rows need to be examined to perform the join?

• A.4318, the sum of both numbers
• B.239, the number of rows in the first table
• C.974881, the product of both numbers
• D.4079, the number of rows in the second table
• E.2159, the average of both numbers

Consider the following:
mysql> SELECT * FROM CountryLanguages;
+----+---------------+-------------+----------+
| ID | CountryName | CountryCode | Language |
+----+---------------+-------------+---------+
| 1 | United States | USA | English |
| 2 | United States | USA | Spanish |
| 3 | Mexico | MEX | Spanish |
| 4 | Canada | CAN | English |
| 5 | Canada | CAN | French |
+----+---------------+-------------+----------+
Which of the following describe how this table would look correctly normalized?

• A.Table Countries: CountryCode, CountryName
  Table Languages: LanguageID, CountryCode Table CountryLanguage: LanguageID,
  CountryCode,
  Language
• B.Table Countries: CountryCode, CountryName Table Languages: LanguageID, Language
  Table CountryLanguage: CountryCode, LanguageID
• C.Table Countries: CountryCode, CountryName
  Table Languages: LanguageID, CountryCode, Language
• D.Table Countries: CountryCode, CountryName, LanguageID
  Table Languages: LanguageID, Language

In order to create an account where no username is needed for login, ...

• A.The account should be created with a username consisting of the empty string
• B.Accounts cannot be specified in a way such that no username is required
• C.The account should be created with the username "%"
• D.None of the above
• E.The account should be created with the username "anon"

In which ways can you set the query_cache_type option? (Choose three)

• A.You can set it at runtime for the entire server with the following statement: SET GLOBAL query_cache_type=[0|1|2]
• B.You can set it in the configuration file and restart the server.
• C.You can set it at runtime for the current connection with the following statement: SET SESSION query_cache_type=[0|1|2]