Are you ready and confident to pass the SUN Certification 310-811 exam? Visualexams 310-811 will be your favorable aid because its quality is wonderful enough to guarantee your pass. Even if you failed to pass, we will give you 100% REFUND or two other similar tests freely for compensation.
Our Free Training Exam Products are beneficial in your Exam and Practical life. With our Training Tools, your ultimate success in Visualexams SUN test Exam is no more a dream.
Our Interactive Engine is best in quality and accuracy. You won’t find any Exam Engine and sample 310-811 exam better then the one we are offering you at the lowest cost. sample exam training materials and Interactive Engine completes all the essential Exam Course requirements.
Exam : SUN 310-811
Title : Sun Certified MySQL 5.0 Database Administrator Part II
1. Consider the following:
mysql> EXPLAIN SELECT Name FROM Country WHERE Code = ‘CAN’G
*************************** 1. row ***************************
id: 1
select_type: SIMPLE
table: Country
type: const
possible_keys: PRIMARY
key: PRIMARY
key_len: 3
ref: const
rows: 1
Extra:
Which of the following best describes the meaning of the value of the type column?
A. The table has exactly one row.
B. Several rows may be read from the table.
C. Only one row of all its rows need to be read.
Answer: C
2. Which of the following statements are required to create a key cache of 4 MB, assign the MyISAM table world.City to it and preload the index?
A. mysql> SET GLOBAL city_cache.key_buffer_size = 4194304;mysql> CACHE INDEX world.City IN city_cache;mysql> LOAD INDEX INTO CACHE world.City;
B. mysql> ALTER TABLE world.city KEY_CACHE = 4194304;
C. mysql> CREATE CACHE FOR world.City SIZE = 4194304;
D. It is not possible to create a key cache for a specific MyISAM table, only the global key cache can be used.
Answer: A
3. Is the following statement true or false? The username you use to connect to MySQL must be the same as the login used to access the operating system.
A. true
B. false
Answer: B
The related exams:
642-654 WAASSE – Wide Area Application Services for System Engineers
642-655 WAASFE-Wide Area Application Services for Field Engineers
642-661 CCIP Configuring BGP on Cisco Routers (BGP)
642-681 Advanced Wireless LAN for System Engineers Exam