SUN Certification
310-810 exam is an important Sun certification which can test your professional skills. Candidates want to pass the exam successfully to prove their competence.
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 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
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
SUN Certification exam got your attention? Do you want to pass your SUN exams on your first try! Do you want a 100% Money Back Guarantee on your purchase of SUN training products? Do you want to practice your SUN exams online? Then you just hit a jackpot! We provide nothing but leading edge SUN exam resources covering all types of SUN exam questions, and providing all correct answers.
TestInside Sun technical experts have collected and certified 139 questions and answers of 310-810 exam which are designed to cover the knowledge points of the Sun Certified MySQL 5.0 Database Administrator Part I and enhance candidates abilities. With TestInside 310-810 preparation tests you can pass the SUN Certification 310-810 exam easily, get the Sun Mysql certification and go further on Sun career path.
Hot Exams:
000-994 Test994,IBM WebSphere MQ V6.0,System Administration
190-956 IBM Lotus Notes Domino 8.5 System Administration Update
BH0-006 ITIL V3 Foundation Certificate in IT Service Management
