First123Last
1 of 90 pages
  1. A
    sp_helptext salary

    B
    sp_define salary

    C
    sp_help salary

    D
    define salary

    Explanation: Not available 

    1. Twitter
    2. Google+
  2. A
    Indexes can have NULL values

    B
    BLOB and TEXT columns can be indexed

    C
    Indexes per table cannot be more than 16

    D
    Columns per index cannot be more than 16

    E
    None

    Explanation: Not available 

    1. Twitter
    2. Google+
  3. A
    He cannot rename any MySQL database

    B
    By using: RENAME DATABASE db_old_name TO db_new_name

    C
    By using: RENAME DATABASE TO db_new_name

    D
    By creating the new empty database, then rename each table using: RENAME TABLE db_old_name.table_name TO db_new_name.table_name

    E
    None

    Explanation: Not available 

    1. Twitter
    2. Google+
  4. A
    select authorname from authors where authorid in (select authorid from books where popularityrating<5)

    B
    select authorname from authors where authorid in (select authorid from books where popularityrating<=5)

    C
    select authorname from authors where authorid in (select bookid from books where popularityrating<5)

    D
    select authorname from authors where authorid in (select authorid from books where popularityrating in (0,5))

    E
    None

    Explanation: Not available 

    1. Twitter
    2. Google+
  5. A
    Closing any open tables in the table cache

    B
    Closing open connections

    C
    Flushing the log file

    D
    Flushing the host cache

    E
    All

    Explanation: Not available 

    1. Twitter
    2. Google+
  6. A
    Names starting with "a"

    B
    Names containing "a" as the second lette

    C
    Names starting with "a" or "A"

    D
    Names containing "a" as any letter except the first

    Explanation: Not available 

    1. Twitter
    2. Google+
  7. A
    SMALLINT

    B
    DECIMAL(19,4)

    C
    VARCHAR(32)

    D
    BIGINT

    Explanation: Not available 

    1. Twitter
    2. Google+
  8. A
    GEOMETRY

    B
    CIRCLE

    C
    SQUARE

    D
    POINT

    E
    POLYGON

    Explanation: Not available 

    1. Twitter
    2. Google+
  9. A
    The two statements produce identical results

    B
    The second statement returns an error

    C
    There is no need to specify DESC because the results are sorted in descending order by default

    D
    None of the statments is correct

    Explanation: Not available 

    1. Twitter
    2. Google+
First123Last
1 of 90 pages