NAME

Question types


Start with


Question limit

of 130 available terms

Print test

130 Multiple choice questions

  1. field
  2. ORDER BY
  3. index
  4. You can use the INSERT INTO with a SELECT FROM clause.
  5. tree data structure
  6. stored in memory
  7. ensures and restricts
  8. DELETE FROM
  9. A primary key
  10. Data integrity
  11. The Second Normal Form (2NF)
  12. UNION combines the results of two SQL queries when there is the same number of columns and data types; JOIN returns rows when there is at least one column match
  13. view
  14. row
  15. non-clustered
  16. single value
  17. extracting/selecting particular data
  18. clustered index
  19. b-tree
  20. ELSE
  21. DELETE removes all (or a subset of) records from the table only; it does not remove the table
  22. full
  23. INTERSECT
  24. WHERE
  25. list of entries
  26. The Third Normal Form (3NF)
  27. order
  28. ALTER TABLE Cycle ADD photo _ file _ name CHAR (30) NULL
  29. object-oriented and drag-and-drop driven
  30. security
  31. it must be numeric
  32. User-defined functions
  33. INSERT INTO
  34. Data type
  35. uses extended logical constructs in the WHERE clause using AND, OR, LIKE, BETWEEN, AS, and TOP
  36. ORDER BY column _ name (either ASC or DESC)
  37. fields
  38. The data from the table is deleted
  39. consistent, correct, and usable
  40. a relational database language used in querying, updating, and managing relational databases and is the de facto standard for database products
  41. the rows to update
  42. object-oriented and drag-and-drop driven
  43. A schema
  44. whole numbers
  45. virtual
  46. access to the database
  47. selecting the data from the database
  48. or the second conditions are true
  49. location of servers with restricted access
  50. Normal Form
  51. false
  52. VALUES clause
  53. removing columns
  54. attribute
  55. UPDATE RENTALS SET kayak = RENTALS.kayak + EQUIPMENT.kayak
    FROM RENTALS, EQUIPMENT
  56. The First Normal Form (1NF)
  57. table
  58. grammar and rules
  59. eliminate duplicative columns from the same table.
  60. related table
  61. The INSERT statement uses the default value for the column.
  62. new row
  63. entities, attributes, views, and indexes
  64. full or incremental
  65. redundancy and inconsistency
  66. unique identifier
  67. To return only the rows that appear in both tables, similar to a Boolean AND
  68. Boolean logical operators
  69. DISTINCT
  70. distinct (unique) values.
  71. OR function
  72. Normalization
  73. physical security
  74. INSERT INTO with SELECT
  75. rows to retrieve
  76. The database must be available 24 hours a day, 7 days a week
  77. OR operator and at least one field = TRUE
  78. A-Z or 0-9
  79. SELECT
  80. SELECT DISTINCT
  81. Backup
  82. in a column
  83. ANSI SQL
  84. relations (tables)
  85. single unit
  86. key
  87. real numbers
  88. They allows multiple statements to be grouped together to avoid data integrity errors
  89. Truth tables
  90. UPDATE RENTALS SET value _ added _ tax = .10
  91. grant permissions
  92. reverses
  93. record
  94. changes databases objects
  95. When all statements in a transaction have successfully completed, issue a commit statement
  96. JOIN
  97. virtual table from the result set of the query
  98. adds databases objects
  99. Indexed data for easy retrieval
  100. first WHEN clause
  101. WHERE
  102. minimize the inclusion of duplicate information
  103. removes databases objects
  104. differential
  105. single value written in the command set of SQL.
  106. Transact-SQL (T-SQL)
  107. separate tables
  108. Relational Data Base Management System
  109. UNION
  110. unique data identifiers
  111. permissions
  112. CASE statement
  113. two or more tables
  114. many-to-many
  115. incremental
  116. foreign key
  117. when-then-else
  118. and the second condition are true
  119. create, modify, or drop relational databases, entities, attributes, and other objects (e.g. views)
  120. UPDATE
  121. efficient maintenance, storage, and updating
  122. in a table
  123. Data manipulation language (DML)
  124. precompiled groups of SQL statements
  125. primary key in another table
  126. deletes rows
  127. ROLLBACK
  128. another query
  129. TRANSACTIONS
  130. rows and columns