SUN\u8a8d\u8b49\u4e3b\u8981\u5c0d\u8c61\u662f\u7a0b\u5f0f\u4eba\u54e1\u3002SUN\u81ea\u5f9e\u88aboracle\u516c\u53f8\u6536\u8cfc\u4ee5\u4f86\uff0c\u6210\u70ba\u8a8d\u8b49\u8003\u8a66\u7684\u71b1\u9ede\uff0cSCJP, SCJD\u8207Oracle\u7684OCP, OCA\u8b49\u7167\u5e76\u67b6\u9f4a\u5c45\u3002310-811\u9019\u4e00\u9580\u8003\u8a66\u662fSUN\u8a8d\u8b49\u525b\u63a8\u51fa\u7684\u4e00\u9805\u8b49\u7167\u8003\u8a66\u3002SUN Other Certifications 310-811\u8003\u8a66\u8003\u53e4\u984c\u7531\u201cKillTest\u8a8d\u8b49\u984c\u5eab\u7db2\u201d\u8cc7\u6df1IT\u8a8d\u8b49\u8b1b\u5e2b\u548cSUN Other Certifications\u7522\u54c1\u5c08\u5bb6\u7d50\u5408Prometric\u6216VUE\u7684\u771f\u5be6\u8003\u8a66\u74b0\u5883\u6700\u65b0\u539f\u984c\u7cbe\u5fc3\u6253\u9020\u3002Sun 310-810 \u8003\u984c DEMO \u5982\u4e0b\uff1a<\/p>\n
1.Is the following statement true or false? The username you use to connect to MySQL must be the same
\nas the login used to access the operating system.
\nA.true
\nB.false
\nAnswer:B
\n2.Which of the following statements are required to create a key cache of 4 MB, assign the MyISAM table
\nworld.City to it and preload the index?
\nA. mysql> SET GLOBAL city_cache.key_buffer_size = 4194304;mysql> CACHE INDEX world.City IN
\ncity_cache;mysql> LOAD INDEX INTO CACHE world.City;
\nB. mysql> ALTER TABLE world.city KEY_CACHE = 4194304;
\nC. mysql> CREATE CACHE FOR world.City SIZE = 4194304;
\nD. It is not possible to create a key cache for a specific MyISAM table, only the global key cache can be
\nused.
\nAnswer:A
\n3.How can the SHOW PROCESSLIST command be helpful when optimizing queries?
\nA.It shows if a query is using an index or not.
\nB.It shows how the server processes a query.
\nC.If checked periodically, it can reveal queries that cause other queries to hang.
\nD.It shows the percentage of processing power that each query is using on a server.
\nAnswer:C
\n4. Consider the following:
\nmysql> EXPLAIN SELECT Name FROM Country WHERE Code = ‘CAN’\\G
\n*************************** 1. row ***************************
\nid:1
\nselect_type: SIMPLE
\ntable: Country
\ntype: const
\npossible_keys: PRIMARY
\nkey: PRIMARY
\nkey_len: 3
\nref: const
\nrows:1
\nExtra:
\nWhich of the following best describes the meaning of the value of the type column?
\nA.The table has exactly one row.
\nB.Several rows may be read from the table.
\nC.Only one row of all its rows need to be read.
\nAnswer:C<\/p>\n","protected":false},"excerpt":{"rendered":"
SUN\u8a8d\u8b49\u4e3b\u8981\u5c0d\u8c61\u662f\u7a0b\u5f0f\u4eba\u54e1\u3002SUN\u81ea\u5f9e\u88aboracle\u516c\u53f8\u6536\u8cfc\u4ee5\u4f86\uff0c\u6210\u70ba\u8a8d\u8b49\u8003\u8a66\u7684\u71b1\u9ede\uff0cSCJP, SCJD\u8207 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[80],"tags":[387,2784,379],"class_list":["post-1022","post","type-post","status-publish","format-standard","hentry","category-sun","tag-310-811-test","tag-sun","tag-sun-310-811-exam"],"_links":{"self":[{"href":"https:\/\/www.killtest.hk\/index.php\/wp-json\/wp\/v2\/posts\/1022","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.killtest.hk\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.killtest.hk\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.killtest.hk\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.killtest.hk\/index.php\/wp-json\/wp\/v2\/comments?post=1022"}],"version-history":[{"count":0,"href":"https:\/\/www.killtest.hk\/index.php\/wp-json\/wp\/v2\/posts\/1022\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.killtest.hk\/index.php\/wp-json\/wp\/v2\/media?parent=1022"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.killtest.hk\/index.php\/wp-json\/wp\/v2\/categories?post=1022"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.killtest.hk\/index.php\/wp-json\/wp\/v2\/tags?post=1022"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}