310-810 braindumps materials
310-810 Braindumps Description
Exam Number/Code: 310-810
Questions and Answers:139 Q&As
Updated: 2009-09-11
Exam Name: Sun Certified MySQL 5.0 Database Administrator Part 1
examsoon professional IT Q&As vendors, offer well after-sale service for 310-810 braindumps. To all the customers buy the real 310-810 questions and answers, examsoon provide track service for 310-810 study guides. when you buy the Q&As with in 3 months. you can enjoy the upgrade Q&As service for free with 310-810 practice exam. If in this period, the certified test center change the SUN 310-810 braindumps Q&As, we will update the 310-810 simulations Q&A in the first time, and provide you the download update for free
Exam : SUN 310-810
Title : Sun Certified MySQL 5.0 Database Administrator Part 1
1. Which of the following statements are true for locks established by the InnoDB storage engine?
A. It sometimes escalates locks to page level.
B. It sometimes escalates locks to table level.
C. It sometimes escalates locks to page or table level.
D. It never escalates locks to page or table level.
Answer: D
2. Which of the following is true for the command-line programs mysqlcheck and myisamchk?
A. mysqlcheck must run on the server to perform checks and repairs and myisamchk can perform checks and repairs on a remote server.
B. mysqlcheck can perform checks and repairs on a remote server, and myisamchk must run on the server.
C. Both mysqlcheck and myisamchk can perform checks and repairs on a remote server.
D. Neither mysqlcheck or myisamchk can perform checks and repairs on a remote server.
Answer: B
3. Another user has issued LOCK TABLES pets READ You can…
A. Update table pets
B. SELECT from table pets
C. UPDATE and SELECT from table pets
D. None of the above
Answer: B
4. Which of the following is true for how the InnoDB storage engine uses diskspace?
A. It stores its data, index and undo information all in its own tablespace.
B. It stores its data in .MYD files, in the respective database directory, and its index and undo information in its own tablespace.
C. It stores its data and index in .MYD and .MYI files, in the respective database directory, and undo information in its own tablespace.
D. It stores its data, index and undo information in .MYD and .MYI files, in the respective database directory.
Answer: A
5. Which one of the following statements can be used to start MySQL 5.0 manually from the command line on windows?
A. C:> C:Program FilesMySQLMySQL Server 5.0binmysqladmin -u root start
B. C:> C:Program FilesMySQLMySQL Server 5.0binmysqld
C. C:> C:Program FilesMySQLMySQL Server 5.0binmysql_start
Answer: B
310-810 Free Demo Download
examsoon offers free demo for 310-810 braindumps with 139 Q & As . You can check out the interface,310-810 question quality and usability of our practice 310-810 braindumps before you decide to buy it.
Download 310-810 Exam Pdf Demo
Download 310-810 Exam iEngine Demo
No related posts.
Related posts brought to you by Yet Another Related Posts Plugin.
Leave a Reply
You must be logged in to post a comment.
