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.
We provide accurate Certification Preparation Material for your best result in SUN certification Exam. You can download ExamSheets Cram Free Training Exam Materials anywhere anytime. We give you a bright career opportunity by providing Certification Preparation Products.
Exam : SUN 310-811
Title : Sun Certified MySQL 5.0 Database Administrator Part II
1. 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
2. How can the SHOW PROCESSLIST command be helpful when optimizing queries?
A. It shows if a query is using an index or not.
B. It shows how the server processes a query.
C. If checked periodically, it can reveal queries that cause other queries to hang.
D. It shows the percentage of processing power that each query is using on a server.
Answer: C
3. Which of the following best describes why InnoDB tables should always have primary keys and why they should be short?
A. Because InnoDB uses primary keys to locate tables, and shorter keys make quicker lookups.
B. Because InnoDB uses primary keys to locate table rows, and shorter keys make quicker lookups.
C. Because InnoDB stores pointers in a log to all the primary keys and shorter keys make this log smaller.
Answer: B
The related exams:
312-50 Ethical Hacking and Countermeasures (CEHv6)
350-001 CCIE Cisco Certified Internetworking Expert
350-018 CCIE Pre-Qualification Test for Security
350-030 CCIE Voice Written