NAME

Question types


Start with


Question limit

of 130 available terms

Print test

128 Matching questions

  1. Data integrity ensures that data is ___ throughout the database.
  2. When should the INTERSECT query be used?
  3. What is the main difference between the DML command DELETE and the DDL command DROP? ___
  4. A ___ is a saved query that creates a virtual table from the result set of the query.
  5. A parent/child relationship is a relationship between nodes in a ___ in which the parent is one step closer to the root (that is, one level higher) than the child.
  6. SELECT is the most-used SQL command for ___ .
  7. What is not a rule for the primary key? ___
  8. ___ is used to update existing records in a table.
  9. A ___ is a record within a table.
  10. To update all records in a database to reflect an increase in the provincial value-added tax from 8 percent to 10 percent the developer should use: ___
  11. Data definition language (DDL) defines database objects including ___ .
  12. The First Normal Form (1NF) sets a few basic rules for a database: ___
  13. Functions are one-word commands that return a ___ .
  14. DROP ___.
  15. ___ returns only distinct (unique) values.
  16. ___ combines two or more SELECT statements with an OR function.
  17. Boolean logical operators : AND displays a record if both the first condition ___ .
  18. Floating-point data types store any ___ .
  19. In a ___ backup only files that have been changed since the last full_backup are copied.
  20. The value of the case expression is the value of the first WHEN clause that is true. If none is true, the result is the ___
  21. ___ is a description of a database to a database management system (DBMS) in the language provided by the DBMS.
  22. Normal Form is the result of structuring (organizing) information to avoid redundancy and inconsistency and to promote ___ .
  23. What is the difference between UNION and JOIN?
  24. The Third Normal Form (3NF) = 2NF + ___ that are not dependent upon the primary key.
  25. For some of the reports it will be useful to see the results in alphabetical order. Which command will produce an alphabetical list? ___
  26. DELETE FROM ___ in a table.
  27. ___ reverses changes.
  28. An identifier for a record in a data file that is unique and found in only one record is called a ___ . A Social Security number may serve as a ___ in an database of employees.
  29. ___ involves applying a body of techniques to a relational database to minimize the inclusion of duplicate information.
  30. Subqueries nest inside ___ .
  31. ___ ensures that data is consistent, correct, and usable throughout the database.
  32. A record is a data structure that is a collection of ___ (elements), each with its own name and type that appear in a table as group of ___ across one row.
  33. Boolean stores 1 or 0, true or ___ .
  34. ___ is used to query data from two or more tables.
  35. In an ___ backup only files that have been changed since the last backup are copied.
  36. ___ specify the possible range of values of the set, the operations that can be performed on the values, and the way in which the values are stored in memory.
  37. The ___ statement is used to insert a new row in a table.
  38. The WHERE clause in an UPDATE statement specifies ___ .
  39. How can a programmer enforce data integrity rules when making changes to the records in a database? ___
  40. ___ specifies an order in which to return the rows.
  41. Aggregate functions return a single value, calculated from values ___ .
  42. Transact-SQL (T-SQL) is a sophisticated query language with additional features beyond what is defined in the ___ .
  43. Scalar functions return a ___ , based on the input value of a single field.
  44. ____ is a sophisticated query language with additional features beyond what is defined in the ANSI SQL.
  45. Stored procedures are ___ saved to the database.
  46. Structured query language (SQL) is ___ .
  47. ANSI SQL syntax is the ___ governing the structure and content of statements.
  48. ___ deletes rows in a table.
  49. Replication services are recommended when: ___
  50. Which command would ensure that return visitors are only counted once when running a query against the reservation system? ___
  51. ___ serves as the unique identifier of a specific row and uniquely defines a relationship within a database.
  52. Which DDL command can Raj use to add a new field to the Cycle table to store the filename of the photo? ___
  53. What is the name of the data located at the intersection of a row and column?
  54. Truth tables show the relationships of the ___ .
  55. A one-to-one relationship is an association between two tables in which the primary key value of each record in the primary table corresponds to the value in the matching field of one, and only one, record in the ___ .
  56. RDBMS is the acronym for ___ .
  57. A graphical designer is an application, such as Microsoft Access, that is ___ .
  58. CREATE ___ .
  59. ORDER BY specifies an ___ in which to return the rows.
  60. A ___ references the primary key in another table.
  61. When designing the INSERT SQL, what happens if data is missing for a particular column? ___
  62. In a ___ structure for storing database indexes, each node in the tree contains a sorted list of key values and links that correspond to ranges of key values between the listed values.
  63. A ___ plan identifies which users can do what action(s) to data in the database.
  64. A table is a data structure usually consisting of a ___ .
  65. Data definition language (DDL) is used to ___ .
  66. ___ = 1NF + removing subsets of data that apply to multiple rows of a table and place them in separate tables.
  67. ___ show the relationships of the Boolean logical operators.
  68. ___ specifies which rows to retrieve.
  69. Normal Form is the result of structuring (organizing) information to avoid ___ and to promote efficient maintenance, storage, and updating.
  70. A column is an ___ for a row or record.
  71. ROLLBACK ___ changes.
  72. A field is a location in a ___ in which a particular type of data is stored.
  73. Data types specify the possible range of values of the set, the operations that can be performed on the values, and the way in which the values are ___.
  74. How can you set up the INSERT to allow copy rows from other tables? ___
  75. WHERE specifies which ___ .
  76. ___ are compact segments of user-written SQL code that can accept parameters and return either a value or a table.
  77. Which statement best defines a predicate subquery?
  78. ___ is the result of structuring (organizing) information to avoid redundancy and inconsistency and to promote efficient maintenance, storage, and updating.
  79. One of the developers mentioned that sometimes he needs to update data in one table from another table. Which of the following is the correct syntax for this type of update?
  80. Access control ___ who can connect and what they can do.
  81. The INSERT INTO statement is used to insert a ___ in a table.
  82. UPDATE is used to update existing records ___ .
  83. What should be included in the physical security plan? ___
  84. ___ is a process of saving all critical data to re-create the database in useful form in a relatively short
  85. A table is a database object consisting of ___.
  86. ALTER ___.
  87. What is not a benefit of enforcing Second and Third Normal Forms? ___
  88. A user account provides users with ___ .
  89. A ___ is arranged in a special order to make retrieval of information faster with direct access to the information.
  90. A view is a saved query that creates a ___ .
  91. The goal of First Normal Form is: ___
  92. Primary Keys are ___ .
  93. ___ sets a few basic rules for a database: eliminate duplicative columns from the same table.
  94. A ___ plan addresses the safety of the actual location of the database.
  95. Most modern database management systems implement a relational model in which the data is organized in ___ .
  96. A ___ index is arranged similarly to the index of a book, where the index value points to the actual information.
  97. JOIN is used to query data from ___ .
  98. The value of the case expression is the value of the ___ that is true. If none is true, the result is the ELSE.
  99. A primary key serves as the ___ of a specific row and uniquely defines a relationship within a database.
  100. Boolean logical operators : OR displays a record if either the first condition ___ .
  101. A truth table is helpful in visualizing the results of logical operators. When comparing two fields, which condition always results in TRUE? ___
  102. The INSERT INTO with SELECT statement is used to insert a new row in a table when a sub-select is used instead of the ___ .
  103. How are transactions useful when updating/deleting/adding records to a database? ___
  104. Replicated services re-create a ___ reproduction of the database.
  105. Integer data types store ___ .
  106. A record is a data structure that is a collection of fields (elements), each with its own name and type that appear in a ___ as group of fields across one row.
  107. An ___ contains keywords and associated data that point to the location of more comprehensive information, such as files and records on a disk or record keys in a database.
  108. A view is a saved query that creates a ___ table from the result set of the query.
  109. You want to update data if a condition is true and perform an alternative update if the condition is false. Which of the following is the best choice? ___
  110. CASE creates ___ functionality (WHEN this condition is met THEN do this).
  111. Roles ___ to the database. Defined roles give all users within a group the same permissions.
  112. ___ are a set of two or more statements grouped into a single unit.
  113. ___ = 2NF + removing columns that are not dependent upon the primary key.
  114. Character stores ___ (any digit or letter that math functions will not be applied to).
  115. A ___ relationship is a complex association between two sets of parameters in which many parameters of each set can relate to many others in the second set.
  116. Roles grant permissions to the database. Defined roles give all users within a group the same ___ .
  117. ___ is used to insert, update, and delete data and to query a database.
  118. A foreign key references the ___ .
  119. The Second Normal Form (2NF) = 1NF + removing subsets of data that apply to multiple rows of a table and place them in ___ .
  120. DISTINCT returns only ___
  121. In a ___ backup all files are copied for possible future retrieval.
  122. TRANSACTIONS are a set of two or more statements grouped into a ___ .
  123. ___ is the most-used SQL command for selecting the data from the database.
  124. A query is a specific set of instructions for ___ .
  125. ___ combines two or more SELECT statements with an AND function.
  126. UNION combines two or more SELECT statements with an ___ .
  127. What happens if a WHERE statement is not included with the DELETE statement? ___
  128. The ___ statement is used to insert a new row in a table when a sub-select is used instead of the VALUES clause.
  1. a precompiled groups of SQL statements
  2. b TRANSACTIONS
  3. c table
  4. d view
  5. e first WHEN clause
  6. f rows to retrieve
  7. g A schema
  8. h separate tables
  9. i incremental
  10. j access to the database
  11. k redundancy and inconsistency
  12. l The First Normal Form (1NF)
  13. m ELSE
  14. n adds databases objects
  15. o false
  16. p field
  17. q removes databases objects
  18. r single value written in the command set of SQL.
  19. s OR function
  20. t single unit
  21. u Boolean logical operators
  22. v non-clustered
  23. w stored in memory
  24. x unique identifier
  25. y foreign key
  26. z ALTER TABLE Cycle ADD photo _ file _ name CHAR (30) NULL
  27. aa entities, attributes, views, and indexes
  28. ab in a table
  29. ac ORDER BY
  30. ad UPDATE
  31. ae changes databases objects
  32. af The Second Normal Form (2NF)
  33. ag two or more tables
  34. ah related table
  35. ai virtual
  36. aj or the second conditions are true
  37. ak A primary key
  38. al another query
  39. am User-defined functions
  40. an the rows to update
  41. ao key
  42. ap full
  43. aq virtual table from the result set of the query
  44. ar To return only the rows that appear in both tables, similar to a Boolean AND
  45. as Normalization
  46. at The database must be available 24 hours a day, 7 days a week
  47. au deletes rows
  48. av WHERE
  49. aw ORDER BY column _ name (either ASC or DESC)
  50. ax UNION
  51. ay when-then-else
  52. az differential
  53. ba INSERT INTO
  54. bb DELETE removes all (or a subset of) records from the table only; it does not remove the table
  55. bc Data integrity
  56. bd The Third Normal Form (3NF)
  57. be record
  58. bf ANSI SQL
  59. bg uses extended logical constructs in the WHERE clause using AND, OR, LIKE, BETWEEN, AS, and TOP
  60. bh create, modify, or drop relational databases, entities, attributes, and other objects (e.g. views)
  61. bi grant permissions
  62. bj A-Z or 0-9
  63. bk When all statements in a transaction have successfully completed, issue a commit statement
  64. bl clustered index
  65. bm DELETE FROM
  66. bn a relational database language used in querying, updating, and managing relational databases and is the de facto standard for database products
  67. bo 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
  68. bp in a column
  69. bq single value
  70. br INTERSECT
  71. bs CASE statement
  72. bt rows and columns
  73. bu selecting the data from the database
  74. bv They allows multiple statements to be grouped together to avoid data integrity errors
  75. bw location of servers with restricted access
  76. bx Data manipulation language (DML)
  77. by object-oriented and drag-and-drop driven
  78. bz real numbers
  79. ca The INSERT statement uses the default value for the column.
  80. cb grammar and rules
  81. cc reverses
  82. cd removing columns
  83. ce ROLLBACK
  84. cf distinct (unique) values.
  85. cg whole numbers
  86. ch permissions
  87. ci SELECT DISTINCT
  88. cj UPDATE RENTALS SET value _ added _ tax = .10
  89. ck UPDATE RENTALS SET kayak = RENTALS.kayak + EQUIPMENT.kayak
    FROM RENTALS, EQUIPMENT
  90. cl it must be numeric
  91. cm Normal Form
  92. cn VALUES clause
  93. co JOIN
  94. cp new row
  95. cq attribute
  96. cr Truth tables
  97. cs Backup
  98. ct OR operator and at least one field = TRUE
  99. cu security
  100. cv ensures and restricts
  101. cw SELECT
  102. cx efficient maintenance, storage, and updating
  103. cy DISTINCT
  104. cz physical security
  105. da consistent, correct, and usable
  106. db b-tree
  107. dc tree data structure
  108. dd Indexed data for easy retrieval
  109. de primary key in another table
  110. df Relational Data Base Management System
  111. dg Data type
  112. dh extracting/selecting particular data
  113. di Transact-SQL (T-SQL)
  114. dj and the second condition are true
  115. dk many-to-many
  116. dl order
  117. dm index
  118. dn list of entries
  119. do row
  120. dp full or incremental
  121. dq You can use the INSERT INTO with a SELECT FROM clause.
  122. dr fields
  123. ds minimize the inclusion of duplicate information
  124. dt unique data identifiers
  125. du eliminate duplicative columns from the same table.
  126. dv INSERT INTO with SELECT
  127. dw relations (tables)
  128. dx The data from the table is deleted