1. Question: Which is the smallest integer range?

    A
    INT

    B
    TINYINT

    C
    SMALLINT

    D
    None of them

    Note: Not available
    1. Report
  2. Question: Triggers are made available since MySQL version 5.

    A
    True

    B
    False

    Note: Not available
    1. Report
  3. Question: Can I call a trigger directly called from an application?

    A
    No

    B
    Yes

    Note: Not available
    1. Report
  4. Question: Triggers are also referred to as database

    A
    function

    B
    event

    C
    procedure

    D
    datatype

    Note: Not available
    1. Report
  5. Question: Which is not the purpose of using triggers?

    A
    Audit trails

    B
    Validation

    C
    Referential integrity enforcement

    D
    Viewing data

    Note: Not available
    1. Report
  6. Question: Which of the following statement about limitations of MySQL triggers is incorrect?

    A
    TEMPORARY tables are not supported

    B
    Views are not supported

    C
    Result sets can't be returned from a trigger

    D
    Triggers must be unique

    E
    Error handling and reporting support is immature

    F
    Must use prefix (ad,ai,au,bd,bi,bu) of naming a trigger

    Note: Not available
    1. Report
  7. Question: There was no supported command or GUI application available for modifying an existing trigger. Therefor, perhaps the easiest strategy for modifying a trigger is to delete and subsequently re-create it.

    A
    True

    B
    False

    Note: Not available
    1. Report
  8. Question: Which is the correct syntax of displaying MySQL triggers vertically?

    A
    shell>show triggers \G

    B
    mysql>desc triggers \G

    C
    mysql>show triggers \G

    D
    mysql>show trigger \G

    E
    mysql>show triggers \G;

    Note: Not available
    1. Report
  9. Question: MySQL triggers are two kinds: before triggers and after triggers.

    A
    False

    B
    True

    Note: Not available
    1. Report
  10. Question: Triggers cannot be applied on SQL statement

    A
    SELECT

    B
    DELETE

    C
    INSERT

    D
    UPDATE

    Note: Not available
    1. Report