×
Detail Form
We will send your result on your email id and phone no. please fill detail
1.
Consider the following:
mysql> EXPLAIN SELECT Name FROM City WHERE CountryCode = (SELECT Code FROM
Country WHERE Name = 'United States')\G
************************** 1. row ***************************
id: 1
select_type: PRIMARY
table: City
type: ALL
possible_keys: NULL
key: NULL
key_len: NULL
ref: NULL
rows: 4079
Extra: Using where
Which of the following best describes the meaning of the value of the select_type column?
2.
Can multi-column FULLTEXT indexes be used? If so, when?
3.
Which of the following best describes the purpose of the InnoDB buffer pool?
4.
When performing diagnostic functions on a server should excessive start and stop messages be
looked for in the error log, and why?
5.
Which of the following is true of the table cache if you mainly run simple queries on many tables?
6.
Does the ordering of tables shown in an EXPLAIN output have any significance? Why?
7.
Which of the following best describes the effect that the per-process limit of open file descriptors
in an operating system has on MySQL, and what can be done to increase it?
8.
Consider the following:
mysql> SELECT * FROM CountryLanguages;
+----+---------------+-------------+----------+
|ID | CountryName | CountryCode | Language |
+----+---------------+-------------+----------+
| 1 | United States | USA | English |
| 2 | United States | USA | Spanish |
| 3 | Mexico | MEX | Spanish |
| 4 | Canada | CAN | English |
| 5 | Canada | CAN | French |
+----+---------------+-------------+----------+
Which of the following describe how this table would look correctly normalized?
9.
Which of the following best describes the purpose of the join buffer, and when should you
increase the size of it?
10.
Which of the following best describe what could cause low utilization of query cache?