Bluekey Technical Test Level 2

30 Questions | Total Attempts: 79

SettingsSettingsSettings
Bluekey Technical Test Level 2 - Quiz

.


Questions and Answers
  • 1. 
    You can add a row using SQL in a database with which of the following?
    • A. 

      ADD

    • B. 

      INSERT

    • C. 

      CREATE

    • D. 

      MAKE

  • 2. 
    The command to remove rows from a table 'CUSTOMER' is:
    • A. 

      REMOVE FROM CUSTOMER ...

    • B. 

      DROP FROM CUSTOMER ...

    • C. 

      UPDATE FROM CUSTOMER ...

    • D. 

      DELETE FROM CUSTOMER WHERE ...

  • 3. 
    The SQL WHERE clause:
    • A. 

      Limits the column data that are returned.

    • B. 

      Limits the row data are returned.

    • C. 

      Both A and B are correct.

    • D. 

      Neither A nor B are correct.

  • 4. 
    Which of the following is the original purpose of SQL?
    • A. 

      To specify the syntax and semantics of SQL data definition language

    • B. 

      To specify the syntax and semantics of SQL manipulation language

    • C. 

      To define the data structures

    • D. 

      All of the above.

  • 5. 
    The wildcard in a WHERE clause is useful when?
    • A. 

      An exact match is necessary in a SELECT statement.

    • B. 

      An exact match is not possible in a SELECT statement.

    • C. 

      An exact match is necessary in a CREATE statement.

    • D. 

      An exact match is not possible in a CREATE statement.

  • 6. 
    A view is which of the following?
    • A. 

      A virtual table that can be accessed via SQL commands

    • B. 

      A virtual table that cannot be accessed via SQL commands

    • C. 

      A base table that can be accessed via SQL commands

    • D. 

      A base table that cannot be accessed via SQL commands

  • 7. 
    The command to eliminate a table from a database is:
    • A. 

      REMOVE TABLE CUSTOMER;

    • B. 

      DROP TABLE CUSTOMER;

    • C. 

      DELETE TABLE CUSTOMER;

    • D. 

      UPDATE TABLE CUSTOMER;

  • 8. 
    ON UPDATE CASCADE ensures which of the following?
    • A. 

      Normalization

    • B. 

      Data Integrity

    • C. 

      Materialized Views

    • D. 

      All of the above.

  • 9. 
    SQL data definition commands make up a(n) ________ .
    • A. 

      DDL

    • B. 

      DML

    • C. 

      HTML

    • D. 

      XML

  • 10. 
    Which of the following is valid SQL for an Index?
    • A. 

      CREATE INDEX ID;

    • B. 

      CHANGE INDEX ID;

    • C. 

      ADD INDEX ID;

    • D. 

      REMOVE INDEX ID;

  • 11. 
    The SQL keyword(s) ________ is used with wildcards.
    • A. 

      LIKE only

    • B. 

      IN only

    • C. 

      NOT IN only

    • D. 

      IN and NOT IN

  • 12. 
    Which of the following is the correct order of keywords for SQL SELECT statements?
    • A. 

      SELECT, FROM, WHERE

    • B. 

      FROM, WHERE, SELECT

    • C. 

      WHERE, FROM,SELECT

    • D. 

      SELECT,WHERE,FROM

  • 13. 
     A subquery in an SQL SELECT statement is enclosed in:
    • A. 

      Braces -- {...}.

    • B. 

      CAPITAL LETTERS

    • C. 

      Parenthesis -- (...) .

    • D. 

      Brackets -- [...].

  • 14. 
    The result of a SQL SELECT statement is a(n) ________ .
    • A. 

      Report

    • B. 

      Form

    • C. 

      File

    • D. 

      Table

  • 15. 
    Which of the following are the five built-in functions provided by SQL?
    • A. 

      COUNT, SUM, AVG, MAX, MIN

    • B. 

      SUM, AVG, MIN, MAX, MULT

    • C. 

      SUM, AVG, MULT, DIV, MIN

    • D. 

      SUM, AVG, MIN, MAX, NAME

  • 16. 
    In an SQL SELECT statement querying a single table, according to the SQL-92 standard the asterisk (*) means that:
    • A. 

      All columns of the table are to be returned.

    • B. 

      All records meeting the full criteria are to be returned.

    • C. 

      All records with even partial criteria met are to be returned.

    • D. 

      None of the above is correct.

  • 17. 
     The HAVING clause does which of the following?
    • A. 

      Acts like a WHERE clause but is used for groups rather than rows.

    • B. 

      Acts like a WHERE clause but is used for rows rather than columns.

    • C. 

      Acts like a WHERE clause but is used for columns rather than groups.

    • D. 

      Acts EXACTLY like a WHERE clause.

  • 18. 
    The SQL -92 wildcards are ____ and ____ .
    • A. 

      Asterisk (*); percent sign (%)

    • B. 

      Percent sign (%); underscore (_)

    • C. 

      Underscore(_); question mark (?)

    • D. 

      Question mark (?); asterisk (*)

  • 19. 
    To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included.
    • A. 

      ONLY

    • B. 

      UNIQUE

    • C. 

      DISTINCT

    • D. 

      SINGLE

  • 20. 
    The benefits of a standard relational language include which of the following?
    • A. 

      Reduced training costs

    • B. 

      Increased dependence on a single vendor

    • C. 

      Applications are not needed.

    • D. 

      All of the above.

  • 21. 
    Which of the following do you need to consider when you make a table in SQL?
    • A. 

      Data types

    • B. 

      Primary keys

    • C. 

      Default values

    • D. 

      All of the above.

  • 22. 
    SQL query and modification commands make up a(n) ________ .
    • A. 

      DDL

    • B. 

      DML

    • C. 

      HTML

    • D. 

      XML

  • 23. 
    When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s):
    • A. 

      LIKE only.

    • B. 

      IN only.

    • C. 

      NOT IN only

    • D. 

      Both IN and NOT IN

  • 24. 
    The Microsoft Access wildcards are ____ and ____ .
    • A. 

      Asterisk (*); percent sign (%)

    • B. 

      Percent sign (%); underscore (_)

    • C. 

      Underscore(_); question mark (?)

    • D. 

      Question mark (?); asterisk (*)

  • 25. 
    Find the SQL statement below that is equal to the following: SELECT NAME FROM CUSTOMER WHERE STATE = 'VA';
    • A. 

      SELECT NAME IN CUSTOMER WHERE STATE IN ('VA');

    • B. 

      SELECT NAME IN CUSTOMER WHERE STATE = 'VA';

    • C. 

      SELECT NAME IN CUSTOMER WHERE STATE = 'V';

    • D. 

      SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA');

Back to Top Back to top