Mysql Setup


  1. There can be more than one column per table with the AUTO_INCREMENT attribute.











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: B

    In MySQL, there can only be one column per table with the AUTO_INCREMENT attribute. It should also have an integer data type. The AUTO_INCREMENT is also allowed for floating point types.


  1. CGI.pm also supports an object oriented style of use.











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: B

    ‘CGI.pm’ supports an object oriented style of use which allows to invoke its functions without importing the names. To do this, a use statement is included and a CGI object is created.



  1. The line which is written at the top of the script to write a Perl script using CGI.pm is ______________.











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: D

    In order to write a Perl script that uses the ‘CGI.pm’ module, a ‘use CGI’ statement is included near the beginning of the script that imports the function names of the module.


  1. What is a synonym for CHARACTER SET?











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: B

    ‘CHARACTER SET’ can be abbreviated into ‘CHARSET’ and can be used in the same contexts and statements where ‘CHARACTER SET’ is used. ‘charset’ is the server-supported character set.



  1. What is the maximum collations a character set can have?











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: A

    The MySQL server allows simultaneous use of multiple character sets. A given character set is allowed to have one or more collations. It can be chosen according to the need of the database.