Mysql Setup


  1. The character that the mysql client program recognizes as a statement delimiter is ______________.











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: B

    By default, mysql itself recognizes the semicolon as a statement delimiter, so the delimiter must be redefined temporarily to cause mysql to pass the entire stored program definition to the server.


  1. Stored programs degrade database security.











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: A

    Stored programs improve database security because controlled access can be enabled to sensitive data by appropriate selection of the privileges a program has when it executes.



  1. Execution on a time activated basis according to a schedule is done by _____________.











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: D

    In MySQL, the events execute on a time activated basis according to a schedule. Triggers are defined to execute when the table is modified via INSERT, DELETE or UPDATE statements.


  1. What is the synonym for REAL?











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: C

    The REAL datatype, by default, is for the DOUBLE type. Floating point types can be defined as UNSIGNED. This eliminates the negative end of the type ranges. MySQL has a variety of default types.



  1. What is the size of the BIT type?











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: A

    All the numeric datatypes used in MySQL vary over the fields. However the maximum size is fixed. Unlike the other numeric types the size of the BIT datatype depends on the length of the field.