31.
GRANT SELECT, UPDATE, DELETE ON world.* TO 'joe'@'example.com' IDENTIFIED BY
'akila' WITH GRANT OPTION
- A.Nothing; WITH GRANT OPTION is not a valid clause in GRANT commands.
- B.The account 'joe'@'example.com' may grant SELECT, UPDATE and DELETE privileges on tables in the world database to other users
- C.The account 'joe'@'example.com' may grant any type of privilege on tables in the world database to other users.
- D.The account 'joe'@'example.com' becomes an administrator account.
- Answer
- Report
Answer : [B]
32.
What will be the results of the following query? mysql> SELECT * FROM CountryLanguage
PROCEDURE ANALYSE(10, 256)
- A.For each column of theCountryLanguage table, the minimum and maximum values will be listed.
- B.For each column of theCountryLanguage table, the average value or average length will be listed.
- C.For each column of theCountryLanguage table, a data type will be suggested that is just large enough to hold the data.
- D.For each column of theCountryLanguage table, the data type will be changed to one that is just large enough to hold the data.
- E.It will result in an error.
- Answer
- Report
Answer : [A, B, C]
33.
Can you have several MySQL servers running on the same computer, using the same InnoDB
tablespace files?
- A.No
- B.Yes, always
- C.Yes, provided their permissions are set to read-only
- Answer
- Report
Answer : [A]
34.
Which of the following best describes the table cache in MySQL and some of its properties?
- A.The table cache is a global cache for all open tables.
- B.Separate table caches are created for data in each open table.
- C.It is used to cache frequently used table indexes.
- D.It is used to cache the status of individual tables.
- Answer
- Report
Answer : [A, D]
35.
Which of the following best describes what may limit the number of simultaneous connections to
the server? What are possible ways to increase it?
- A.It is limited by the maximum size of the table cache.
- B.The --key_cache option may be used to increase the limit.
- C.The maximum number of threads per-process of the operating system.
- D.The operating system may be able to be reconfigured to increase this limit.
- Answer
- Report
Answer : [C, D]
|
|
||||||||||||||||||||||||||||
