Data Types


  1. Which statement is used to select a default database?











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: B

    MySQL has the facility to use various statements specifically at the database level. For selecting a default database, the keyword or clause used is the ‘USE’ statement.


  1. What is a synonym for CHARACTER SET?











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: D

    ‘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.


  1. Which variable is a handle to a database object?











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: C

    The variable named ‘$dbh’ is a handle to an open file. ‘$h’ is a generic handle and the meaning depends on context. ‘$dbh’ is a handle to a database object. ‘$sth’ is a handle to a query object.


  1. The variable used as a handle to an open file is ______________.











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: D

    The variable named ‘$fh’ is a handle to an open file. ‘$h’ is a generic handle and the meaning depends on context. ‘$dbh’ is a handle to a database object. ‘$sth’ is a handle to a query object.