SHARE
TWEET

Untitled

a guest Jul 17th, 2017 55 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SQL 2011 Quiz
  2. John Duncan
  3.  
  4.  
  5. 1. What does SQL stand for?
  6.     A)Structured Question Language
  7.     B)Strong Question Language
  8.     C)Structured Query Language
  9.     D)Structured Queue Language
  10.  
  11. 2. What does the SQL FROM clause do?
  12.     A)Specifies a search condition.
  13.     B)Specifies the tables to retrieve rows from.
  14.     C)Specifies the columns we are retrieving
  15.     D)Specifies the attributes to retrieve rows from.
  16.  
  17. 3. Which of the following SQL clauses is used to enter data into a SQL table?
  18.     A)INSERT INTO
  19.     B)WRITE
  20.     C)ENTER
  21.     D)SELECT
  22.  
  23. 4. Which 2 SQL keywords specify the sorting direction of the result set retrieved with ORDER BY clause.
  24.     A)ASC and DESC
  25.     B)HIGH and LOW
  26.     C)UP and DOWN
  27.     D)Top and Bottom
  28.  
  29. 5. We refer to a join as a self-join when…
  30.     A)we are using left and right join together
  31.     B)We are joining two tables only
  32.     C)we are joining more than 2 tables
  33.     D)we are joining table to itself
  34.  
  35. 6. RDBMS stands for…
  36.     A)Real Database Management System
  37.     B)Relational Database Management System
  38.     C)Read Database Master System
  39.     D)Realtime Database Management System
  40.  
  41. 7. The table rows are also known as…
  42.     A)Attributes
  43.     B)Fields
  44.     C)Records
  45.     D)Entity
  46.  
  47. 8. If you join a table to itself, what kind of join are you using?
  48.     A)Selective Join.
  49.     B)Natural Joun
  50.     C)You can't join a table to itself.
  51.     D)Self Join
  52.  
  53. 9. The UPDATE SQL clause can…
  54.     A)update only one row at a time.
  55.     B)update more than one row at a time.
  56.     C)delete more than one row at a time.
  57.     D)delete only one row at a time.
  58.  
  59. 10. Which SQL statement selects all rows from table called Contest, with column ContestDate having values greater or equal to May 25, 20006?
  60.     A)SELECT * FROM Contest HAVING ContestDate >= '05/25/2006'
  61.     B)SELECT * FROM Contest WHERE ContestDate < '05/25/2006'
  62.     C)SELECT * FROM Contest GROUPBY ContestDate >= '05/25/2006'
  63.     D)SELECT * FROM Contest WHERE ContestDate >= '05/25/2006'
  64.  
  65. 11. Which SQL keyword is used to retrieve a minimum value?
  66.     A)DOWN
  67.     B)LOW
  68.     C)MIN
  69.     D)LOWER
  70.  
  71. 12. The INNER JOIN clause…
  72.     A)returns all rows that have matching value in the field on which the 2 tables are joined.
  73.     B)returns only the rows from the first table, which have non-matching values with the second table in the field on which the 2 tables are joined.
  74.     C)returns all rows from 2 tables.
  75.     D)returns all the matching rows from 2 tables.
  76.  
  77. 13. Which SQL keyword is used to retrieve only unique values?
  78.     A)DISTINCTIVE
  79.     B)DIFFERENT
  80.     C)DISTINCT
  81.     D)UNIQUE
  82.  
  83. 14. If you don't specify ASC or DESC after a SQL ORDER BY clause, the following is used by default:
  84.     A)There is no default value.
  85.     B)DESC
  86.     C)ASC
  87.     D)Random
  88.  
  89. 15. What is an index?
  90.     A)An index is a database table attribute, which speeds-up data search within a table.
  91.     B)An index is the same as alias.
  92.     C)An index is a special way to join 2 or more tables.
  93.     D)An index is a database row attribute, which speeds-up data search within a table.
  94.  
  95. 16. What does ACID stand for?
  96.     A)Access. Consistency. Isolation. Data.
  97.     B)Access. Constraint. Index. Data.
  98.     C)Access. Constant. Information. Data.
  99.     D)Atomicity. Consistency. Isolation. Durability.
  100.  
  101. 17. Which of the following SQL statements is correct?
  102.     A)TRUNCATE Sales TABLE
  103.     B)TRUNCATE * FROM TABLE Sales
  104.     C)TRUNCATE TABLE Sales
  105.     D)TRUNCATE * FROM COLUMN Sales
  106.  
  107. 18. The IN SQL keyword
  108.     A)Is used with the DISTINCT SQL keyword only.
  109.     B)Is used with the INSERT SQL keyword only.
  110.     C)Determines if a value matches any of the values in a list or a sub-query.
  111.     D)Defines the tables we are selecting or deleting data from.
  112.  
  113. 19. Sub-queries can be nested in…
  114.     A)UPDATE statements only.
  115.     B)INSERT statements only.
  116.     C)DELETE statements only.
  117.     D)UPDATE, DELETE, INSERT and SELECT statements.
  118.  
  119. 20. The LIKE SQL keyword is used along with ..
  120.     A)WHERE clause.
  121.     B)ORDER BY clause.
  122.     C)JOIN clause.
  123.     D)GROUP BY clause.
RAW Paste Data
Top