First123Last
1 of 4 pages
  1. Answer
    Query caching, available with the version 4.0.1 release, greatly improves the performace of selection queries by storing query results in memory and retrieving those results directly, rather than repeatedly querying the database for the same result set.

    Explanation: Not available 


    1. Forum
  2. Answer
    1. MyISAM
    2. IBMDB2I
    3. InnoDB
    4. MEMORY
    5. MERGE
    6. FEDERATED
    7. ARCHIVE
    8. CSV
    9. EXAMPLE
    10. BLACKHOLE

    Explanation: Not available 


    1. Forum
  3. Answer
    MyISAM:
    1. MyISAM become MYSQL's default storage engine as of version 3.23. 
    2. MyISAM tables are operating system independent.
    3. Capable of sorting more data, but at a cost of less storage space than counterpart.
    4. Three MyISAM formats: static, dynamic, and compress are available.
    
    InnoDB
    1. Robust transactional storage engine
    2. Working with large data stores.
    3. It has been available to MySQL users since version 3.23 and effective solution for transactional applications
    
    MEMORY:
    1. To attain the fastest response time possible, the logical storage media is system memory.
    2. Sorting table data in memory does indeed offer impressive performance.
    3. If the mysqld daemon crashes, all MEMORY data will be lost.

    Explanation: Not available 


    1. Forum
  4. Answer
    MySQL broken down datatypes in three broad categories: a) Date and time b) Numeric data types c) String data types
    
    a) Data types in Date and time  category:
    1. DATE
    2. DATETIME
    3. TIME
    4. TIMESTAMP
    5. YEAR
    
    b) Data types in Numeric  category:
    1. BOOL, BOOLEAN
    2. BIGINT
    3. INT
    4. MEDIUMINT
    5. SMALLINT
    6. TINYINT
    7. DECIMAL
    8. DOUBLE
    9. FLOAT ([M,D])
    10. FLOAT (precision)
    
    c) Data types in String category:
    1. CHAR
    2. VARCHAR
    3. LONGBLOB
    4. LONGTEXT
    5. MEDIUMBLOB
    6. MEDIUMTEXT
    7. BLOB
    8. TEXT
    9.TINYBLOB
    10. TINYTEXT
    11. ENUM
    12. SET

    Explanation: Not available 


    1. Forum
  5. Answer
    MySQL supported data type attributes are:
    1. AUTO_INCREMENT
    2. BINARY
    3. DEFAULT
    4. INDEX
    5. NATIONAL
    6. NOT NULL
    7. NULL
    8. PRIMARY KEY
    9. UNIQUE
    10. ZEROFILL

    Explanation: Not available 


    1. Forum
First123Last
1 of 4 pages