310-811 samples(31 to 40) for IT specialist: Aug 2016 Edition

It is impossible to pass SUN 310-811 exam without any help in the short term. Come to Testking soon and find the most advanced, correct and guaranteed SUN 310-811 practice questions. You will get a surprising result by our Regenerate Sun Certified MySQL 5.0 Database Administrator Part II practice guides.

2016 Aug 310-811 exam cost

Q31. What is the meaning of the range value of the type column? 

 

A. There is a range of indexes that can be used. 

B. The type of index uses the range algorithm. 

C. The index is used to select rows that fall between orange of index values. 

D. The optimizer has determined that only data from the very beginning or the very end of the table is needed

Answer: C


Q32. Consider the following query:

GRANT ALL ON world.* TO 'web'@'hostname'

What privileges would this give this user?

A. All privileges including GRANT.

B. All privileges except GRANT.

C. SELECT, INSERT, UPDATE and DELETE.

D. ALL can not be used when granting privileges.

Answer: B


Q33. Is it ever safe to start the MySQL server as root? 

A. No it is never safe to start it as root.

B. Yes it is always safe to start it as root. 

C. Yes provided you make it switch the effective user to mysql. 

D. No because you can not make it switch the effective user if started as root.

Answer: C


Q34. What does the possible_keys column in this output denote?


A. Whether there are any indexes on the table(s) you are querying. 

B. If there are any indexes you may be able to use.

C. Whether you are using any indexes in your query. 

D. If it is possible for you to include any indexes in your query.

Answer: B


Q35. Which of the following statements best describe the indexes supported by the MEMORY storage engine, and their general charactensbcs?

A. MEMORY tables only support HASH indexes which provide fast lookups that use a unique index.

B. MEMORY tables only support BTPEE which provide better performance with non-unique index values and other comparison operators. 

C. MEMORY tables support HASH indexes which provide fast lookups that use a unique index, and BTREE indexes which provide better performance with non-unique index values and other comparison operators.

D. MEMORY tables support HASH indexes which provide better performance with non-unique index values and other comparison operators, and BTREE indexes which provide fast lookups that use a unique index.

Answer: C


310-811 test preparation

Renewal 310-811 dumps:

Q36. When creating a new user account, which of the following are valid ways of specifying the hostname part of the account? 

A. Leaving it unspecified, allowing connections from any host 

B. Using localhost 

C. Using a hostname, such as agric.comp1.com 

D. Using an IP address, such as 100.160.1.47 

E. Using a hostname pattern with wildcards, such as %.comp1.com 

F. Using an IP number with wildcards, as 100 160.1.% 

G. Using an IP number/netmask combination such as 100.160.0.0/255.255.0.0

H. User accounts do not contain a hostname part

Answer: BCDEFG


Q37. What would be the effect of this statement?

 

A. Nothing as this is not a valid statement.

B. The table City is changed to a fixed row format 

C. The columns in the table City are changed from VARCHAR to CHAR. 

Answer: B


Q38. By default, mysqld's memory settings are... 

A. There are no default memory settings for mysqld.

B. Set to a median value good for overall general use. 

C. Rather consuming and should be decreased if possible.

D. Rather conservative and should be increased if possible. 

Answer: D


Q39. Which of the following statements are true regarding wildcards in the host name of an account specification? 

A. The '%' character is used to match any number of characters or numbers. 

B. The ‘*’ character is used to match any number of characters or numbers

C. The '_' character is used to match any number of characters or numbers. 

D. The '.' character is used to match any single character or number.

E. Wildcards may be used to match any number of characters at the beginning of the host name or IP address only

F. Wildcards may be used to match any number of characters at the end of the host name or IP address only

G. Wildcards may he used to match any number of characters anywhere in the host name or IP address

Answer: AG


Q40. Which of the following best describes why this table should be split into a part and location table? 


A. Because it has redundant location values 

B. Because it has multiple repeating groups in each row. 

C. This table should not be split as it is already in third normal form

Answer: A



see more 310-811 dumps