Indexes


  1. Suppose Person is a table consisting of 8 rows and Employee is a table consisting of 6 rows, the number of combinations through which the search is performed is __________.
    SELECT Person.i1, Employee.i2
    FROM Person INNER JOIN Employee
    WHERE Person.i1 = Employee.i2;











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: C

    In MySQL, when the tables are unindexed, the searches are run through all the possible combinations. In this case, the search space is 8 x 6 = 48, the product of the number of rows.


  1. In a single table (with 10 columns) join query the number of values needed to examine per column is __________.












  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: A

    For indexing in the context of performing joins, in a single table query, the number of values that are needed to be examined per column is the number of rows in the table.



  1. The data rows of a MyISAM table are stored in __________.











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: C

    The data rows of the MyISAM table are stored in a data file and the index values are stored in a separate index file. In MySQL, for a MyISAM table, there can be more than one indexes.


  1. The maximum number of indexes on MyISAM table is __________.











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: A

    In MySQL, for a MyISAM table, there can be more than one indexes. The data rows of the MyISAM table are stored in a data file and the index values are stored in a separate index file.



  1. Using indexes optimizes query performance.











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: B

    In MySQL, there are many techniques available for optimizing queries. Indexing is the most useful. Generally the one thing that makes the most difference is the proper use of indexes.