Loading ...
Global Do...
News & Politics
2
0
Try Now
Log In
Pricing
Exam4Test 310-811 Braindumps Exam4Test 310-811 Exams SUN Sun Certified MySQL 5.0 Database Administrator Part II O rder : 310-811 Exam Practice Exam: 310-811 Exam Number/Code: 310-811 Exam Name: Sun Certified MySQL 5.0 Database Administrator Part II Questions and Answers: 138 Q&As Exam Description 1. Exam4Test offer free update service for three month. After you purchase our product, we will offer free update in time for three month. 2. High quality and Value for the 310-811 Exam. Exam4Test Practice Exams for 310-811 are written to the highest standards of technical accuracy, provided by our certified subject matter experts and published authors for development. 3. 100% Guarantee to Pass Your exam and get your Certification. We guarantee your success in the first attempt. If you do not pass the "310-811" (Sun Certified MySQL 5.0 Database Administrator Part II on your first attempt, send us the official result. We will give you a FULLY REFUND of your purchasing fee and send you another same value product for free. 4. Exam4Test 310-811 Exam Downloadable. Our PDF or Testing Engine Preparation Material of 310-811 exam provides everything which you need to pass your exam. The Certification details are researched and produced by our Professional Certification Experts who are constantly using industry experience to produce precise, and logical. You may get "310-811 exam" questions from different websites or books, but logic is the key. Our Product will help you not only pass in the first Sun Certified MySQL 5.0 Database Administrator Part II( ) exam try, but also save your valuable time. Comprehensive questions with complete details about 310-811 exam. 310-811 exam questions accompanied by exhibits. Verified Answers Researched by Industry Experts and almost 100% correct. Drag and Drop questions as experienced in the Real exam. 310-811 exam questions updated on regular basis. Like actual Certification exams, 310-811 exam preparation is in multiple-choice questions (MCQs). Tested by many real exams before publishing. Try free exam demo before you decide to buy it in http://www.Exam4Test.com High quality and Valued for the 310-811 Exam: 100% Guarantee to Pass Your 310-811 exam and get your Certification. Come to http://www.Exam4Test.com The easiest and quickest way to get your Certification. Exam4Test professional provides 310-811 the newest Q&A, completely covers 310-811 test original topic. With our completed resources, you will minimize your cost and be ready to pass your 310-811 test on Your First Try, 100% Money Back Guarantee included! Page 1 of 5 310-811 Exam Study Guide 310-811 exam is regarded as one of the most favourite Certifications. Many IT professionals prefer to add 310-811 exam among their credentials. Exam4Test not only caters you all the information regarding the 310-811 exam but also provides you the excellent 310-811 study guide which makes the certification exam easy for you. Exam4Test Engine Features Comprehensive questions and answers about 310-811 exam 310-811 exam questions accompanied by exhibits Verified Answers Researched by Industry Experts and almost 100% correct 310-811 exam questions updated on regular basis Same type as the certification exams, 310-811 exam preparation is in multiple-choice questions (MCQs). Tested by multiple times before publishing Try free 310-811 exam demo before you decide to buy it in Exam4Test.com Exam4Test Help You Pass Any IT Exam Exam4Test.com offers incredib le career enhancing opportunities. We are a team of IT professionals that focus on providing our customers with the most up to date material for any IT certification exam. This material is so effective that we Guarantee you will pass the exam or your money back. 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. When working with stored routines, which of the following are true in regards to the effect on the amount of data exchanged between client and server? A. They may increase the amount of data exchanged. B. They can help reduce the amount of data exchanged. C. They have no effect on the amount of data exchanged. Answer: B 3. Which of the following best describes how the relay log works? A. It records the times when the slave connects to the master. B. When a slave receives a change from the master, it is recorded in the relay log first and processed later. C. When a slave receives a change from the master, it is processed first and then recorded in the relay log. Answer: B 4. Which of the following statements are true of how access control is based? A. It is based off of an access control table in the mysql database. B. It is based off of grant tables in the mysql database. C. It is based off of an access control list stored in the data directory. D. It is based off of an access control list stored inside the .frm files of each table. Answer: B Page 2 of 5 5. 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 6. Given the following MyISAM table structure: mysql> desc city; +-------------+----------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+----------+------+-----+---------+----------------+ | ID | int(11) | | PRI | NULL | auto_increment | | Name | char(35) | | | | | | CountryCode | char(3) | | | | | | District | char(20) | | | | | | Population | int(11) | | MUL | 0 | | +-------------+----------+------+-----+---------+----------------+ and the following SQL statement: SELECT Population FROM city WHERE Population = 10000 ORDER BY Population LIMIT 5; which of the following statements best describes how MySQL optimizer executes the query? A. The optimizer uses the primary key column ID to read the index values, then uses the index on Population to filter the results. The optimizer will always choose to use a unique index first, then use a secondary index if available. B. The optimizer uses the index on the Population column to search and filter the WHERE clause. A temporary table is used to perform a filesort on the results, and then only 5 records are returned to the client. C. The optimizer uses the index on the Population column to search, filter and sort the Population column, then returns 5 records to the client. The optimizer does not need to read the data rows, and can return values from the index only, because the index contains just integer values that form a leftmost prefix for the key. D. The optimizer uses the index on the Population column to search, filter and sort the Population column, and returns 5 records to the client. The optimizer does not need to read the data rows, and can return values from the index only because only those columns where specified in the SELECT statement. E. The optimizer will never read data from disk, since MySQL caches both data and index in the key buffer. Answer: D 7. 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; Page 3 of 5 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 8. Which of the following statements about the slow query log is true? A. The slow query log will always contain just slow queries. B. The slow query log may not always contain just slow queries. C. The slow query log always logs more than just slow queries. Answer: B 9. 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 10. The stored function year_to_date is created by the 'root'@'localhost' account as follows: CREATE FUNCTION year_to_date () RETURNS DECIMAL(10,2) SQL SECURITY DEFINER BEGIN ... END; Within the routine body, a number of calculations are made on data in the financials table and the calculated value is returned. The only account which can access the financials table is 'root'@'localhost'. If a client connects with the account 'joe'@'localhost' and calls the year_to_date function, what will happen? A. The function will always execute as if it was 'root'@'localhost' that invoked it since SQL SECURITY DEFINER has been specified. B. The function will not execute, as 'joe'@'localhost' does not have access to the financials table C. The function will not execute as SQL SECURITY DEFINER has been specified. It would execute if instead SQL SECURITY INVOKER had been specified D. If the account 'joe'@'localhost' has the EXECUTE privilege on year_to_date, the function will complete successfully Answer: D 11. How can stored routines be used to check for constraints or legality of incoming data? A. They can make use of the VALIDATE DEFINER setting. B. They can not be used to check for constraints or legality of data. C. They can check and only perform an action if the incoming values match a specified value. Answer: C 12. With replication, what on the master is used to send commands to the slave? A. The relay log. B. The binary log. C. The SQL Thread. Answer: B 13. 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. Page 4 of 5 D. It shows the percentage of processing power that each query is using on a server. Answer: C 14. 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 15. Consider the following GRANT statement: GRANT USAGE ON *.* TO 'kofi'@'localhost' IDENTIFIED BY 'password' What is the implications of executing that statement? A. Kofi can access all database objects. B. Kofi can access all his tables. C. Kofi can display server system and status variables. D. Kofi can grant privileges to others. E. Kofi can access all database objects belonging to localhost. Answer: C More 310-811 Information 310-230 Sun Certified Developer for Java Web Services 310-345 Sun Certified System Administrator for Sun Cluster 3.2 310-600 SUN SIGMA BLACK BELT CERTIFICATION 310-810 Sun Certified MySQL 5.0 Database Administrator Part 1 310-811 Sun Certified MySQL 5.0 Database Administrator Part II 310-400 Sun Certified Integrator for Indentity Manager 7.1 310-051 SUN CERTIFIED ENITRPRISE ARCHITECT FOR J2EE(tm)TECHNOLOGY 310-231 Sun Certified Developer for Java Web Services 5 310-052 Sun Certified Enterprise Architect for J2EE 5 412-600 SUN Certified OpenOffice.org Writer Specialist 310-019 Sun Certified Associate.Java Platform.Se. Exam Version 1.0 310-330 Sun Certified Systems Installer for Sun Cluster 3.X 310-105 Sun Certified Solaris Associate 310-062 Sun Certified Enterprise Architect for the Java Platform, Enterprise Edition 5 310-876 LEVEL2 SYSTEM SUPPORT ENGINEER EXAMINATION 310-620 EDS Certified Sun Enterprise 10K Server Administrator 310-012 SUN CERTIFIED SYSTEM ADMINISTRATOR FOR SOLARIS 8 PART 2 310-131 SUN CERTIFIED STORAGE ARCHITECT (SUN EMPLOYEES ONLY) 310-203 Sun Certified System Amin for Solaris 10 OS Upgrade 310-066 Upgrade EXAM for the Sun Certified for Java Programmer.SE6.0 Related 310-811 Exams Other SUN Exams 310-560 310-090 310-877 310-625 310-081 310-025 310-875 310-044 310-615 310-230 310-016 310-011 310-083 310-203 310-878 310-202 310-880 310-062 310-220 310-027 Page 5 of 5
