Databases - Upwork

  1. Question: Which of the following is an alternative to Subquery Factoring (ex. the 'WITH' clause in MS SQL Server)?

    A
    The 'IN' clause

    B
    Using temporary tables and inline views

    C
    The 'INNER JOIN' clause

    D
    Using subqueries

    Note: Not available
    1. Report

  2. Question: Suppose a table has the following records: +--------------+-------------+----------------+ | Item | Price | Brand | +--------------+-------------+----------------+ | Watch | 100 | abc | | Watch | 200 | xyz | | Glasses | 300 | bcd | | Watch | 500 | def | | Glasses | 600 | fgh | +--------------+-------------+----------------+ Which of the following will select the highest-priced record per item?

    A
    select item, brand, price from items where max(price) order by item

    B
    select * from items where price = max group by item

    C
    select item, brand, max(price) from items group by item

    D
    select * from items where price > 200 order by item

    Note: Not available
    1. Report

  3. Question: Which of the following will restore a MySQL DB from a .dump file?

    A
    mysql -u<user> -p < db_backup.dump

    B
    mysql -u<user> -p<password> < db_backup.dump

    C
    mysql -u<user> -p <password> < db_backup.dump

    D
    mysql -u<user> -p<password> > db_backup.dump

    Note: Not available
    1. Report

  4. Question: Which of the following will show when a table in a MySQL database was last updated?

    A
    Using the following query: SELECT UPDATE_TIME FROM information_schema.tables WHERE TABLE_SCHEMA = 'database_name' AND TABLE_NAME = 'table_name'

    B
    Creating an on-update trigger to write timestamp in a custom table, then querying the custom table

    C
    Getting the "last modified" timestamp of the corresponding database file in the file system

    D
    None

    Note: Not available
    1. Report

  5. Question: Which of the following results in 0 (false)?

    A
    "EXPERTRATING" LIKE "EXP%"

    B
    "EXPERTRATING" LIKE "Exp%"

    C
    BINARY "EXPERTRATING" LIKE "EXP%"

    D
    BINARY "EXPERTRATING" LIKE "Exp%"

    E
    All will result in 1 (true)

    Note: Not available
    1. Report

  6. Question: Which of the following relational database management systems is simple to embed in a larger program?

    A
    MySQL

    B
    SQLite

    C
    Both

    D
    None

    Note: Not available
    1. Report

  7. Question: What is true about the ENUM data type?

    A
    An enum value may be a user variable

    B
    An enum may contain number enclosed in quotes

    C
    An enum cannot contain an empty string

    D
    An enum value may be NULL

    E
    None of is true

    Note: Not available
    1. Report

  8. Question: What will happen if two tables in a database are named rating and RATING?

    A
    This is not possible as table names are case in-sensitive (rating and RATING are treated as same name)

    B
    This is possible as table names are case sensitive (rating and RATING are treated as different names)

    C
    This is possible on UNIX/LINUX and not on Windows platform

    D
    This is possible on Windows and not on UNIX/LINUX platforms

    E
    This depends on lower_case_table_names system variable

    Note: Not available
    1. Report

  9. Question: How can a InnoDB database be backed up without locking the tables?

    A
    mysqldump --single-transaction db_name

    B
    mysqldump --force db_name

    C
    mysqldump --quick db_name

    D
    mysqldump --no-tablespaces db_name

    Note: Not available
    1. Report

  10. Question: What does the term "overhead" mean in MySQL?

    A
    Temporary diskspace that the database uses to run some of the queries

    B
    The size of a table

    C
    A tablespace name

    D
    None

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