Apply for Zend Framework Certification Training

Mysql Questions

<strong>21. How do you control the max size of a HEAP table?
Maximum size of Heal table can be controlled by MySQL config variable 
called max_heap_table_size.

22. What is the difference between MyISAM Static and MyISAM Dynamic?
In MyISAM static all the fields will have fixed width. The Dynamic MyISAM table will have 
fields like TEXT, BLOB, etc. to accommodate the data types with various lengths.
MyISAM Static would be easier to restore in case of corruption.

23. What are federated tables?
Federated tables which allow access to the tables located on other databases 
on other servers.

24. What, if a table has one column defined as TIMESTAMP?
Timestamp field gets the current timestamp whenever the row gets altered.

25. What happens when the column is set to AUTO INCREMENT and if you
reach maximum value in the table?
It stops incrementing. Any further inserts are going to produce an error, 
since the key has been used already.

26. How can we find out which auto increment was assigned on Last insert?
LAST_INSERT_ID will return the last value assigned by Auto_increment 
and it is not required to specify the table name.

27. How can you see all indexes defined for a table?
Indexes are defined for the table by:
SHOW INDEX FROM &lt;tablename&gt;;

28. What do you mean by % and _ in the LIKE statement?
% corresponds to 0 or more characters, _ is exactly one character in the 
LIKE statement.

29. How can we convert between Unix &amp; MySQL timestamps?
UNIX_TIMESTAMP is the command which converts from MySQL
timestamp to Unix timestamp FROM_UNIXTIME is the command which
 converts from Unix timestamp to MySQL timestamp.

30. What are the column comparisons operators?
The = , &lt;&gt;, &lt;=, &lt;, &gt;=, &gt;,&lt;&lt;,&gt;&gt;, &lt;=&gt;, AND, OR, or LIKE operators are 
used in column comparisons in SELECT statements.                        </strong></pre>

< Mysql Questions Part 2 Mysql Questions Part 4 >

Ask a question

  • Question:
    • Answer:
      {{answer.blog_answer_description  }}
    Replay to Question

Back to Top