1. Question: Which of the following are true in case of Indexes for MYISAM Tables?

    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

    Note: Not available
    1. Report
  2. Question: Below is the table “messages,” please find proper query and result from the choices below. Id Name Other_Columns ------------------------- 1 A A_data_1 2 A A_data_2 3 A A_data_3 4 B B_data_1 5 B B_data_2 6 C C_data_1

    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

    Note: Not available
    1. Report
  3. Question: Consider the following tables: books ------ bookid bookname authorid subjectid popularityrating (the popularity of the book on a scale of 1 to 10) language (such as French, English, German etc) Subjects --------- subjectid subject (such as History, Geography, Mathematics etc) authors -------- authorid authorname country Which is the query to determine the Authors who have written at least 1 book with a popularity rating of less than 5?

    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

    Note: Not available
    1. Report
  4. Question: The Flush statement cannot be used for:

    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

    Note: Not available
    1. Report
  5. Question: Consider the query:
    SELECT name
    FROM Students
    WHERE name LIKE '_a%';
    Which names will be displayed?

    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

    Note: Not available
    1. Report
  6. Question: Which of the following is the best MySQL data type for currency values?

    A
    SMALLINT

    B
    DECIMAL(19,4)

    C
    VARCHAR(32)

    D
    BIGINT

    Note: Not available
    1. Report
  7. Question: What are MySQL Spatial Data Types in the following list?

    A
    GEOMETRY

    B
    CIRCLE

    C
    SQUARE

    D
    POINT

    E
    POLYGON

    Note: Not available
    1. Report
  8. Question: Examine the two SQL statements given below:
    SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY salary DESC
    
    SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY 2 DESC
    What is true about them?

    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

    Note: Not available
    1. Report
  9. Question: Which of the following will raise MySQL's version of an error?

    A
    SIGNAL

    B
    RAISE

    C
    ERROR

    D
    None

    Note: Not available
    1. Report
  10. Question: Which query will return values containing strings "Pizza", "Burger", or "Hotdog" in the database?

    A
    SELECT * FROM fiberbox WHERE field REGEXP 'Pizza|Burger|Hotdog';

    B
    SELECT * FROM fiberbox WHERE field LIKE '%Pizza%' OR field LIKE '%Burger%' OR field LIKE '%Hotdog%';

    C
    SELECT * FROM fiberbox WHERE field = '%Pizza%' OR field = '%Burger%' OR field = '%Hotdog%';

    D
    SELECT * FROM fiberbox WHERE field = '?Pizza?' OR field = '?Burger?' OR field = '?Hotdog?';

    Note: Not available
    1. Report
Copyright © 2024. Powered by Intellect Software Ltd