Question types

Start with

Question limit

of 75 available terms

Print test

74 Matching questions

  1. What is Transact-SQL (T-SQL)?
  2. What is a view?
  3. What is a user-defined function?
  4. What is a clustered index?
  5. What is a parent/child relationship?
  6. What does the INTERSECT function do?
  7. What is a floating point?
  8. What does the WHERE function do?
  9. What does the OR logical operator do?
  10. What does the SELECT function do?
  11. What are data types?
  12. What is a role?
  13. What is a graphical designer?
  14. What is third normal form?
  15. What is a foreign key?
  16. What does the UPDATE function do?
  17. What does the ALTER function do?
  18. What are subqueries?
  19. What is a one-to-one relationship?
  20. What is a truth table?
  21. What is first normal form?
  22. What is an incremental backup?
  23. What is a user account?
  24. What is a record?
  25. What are transactions?
  26. What is a backup?
  27. What does the DELETE FROM function do?
  28. What is second normal form?
  29. What is a stored procedure?
  30. What is access control?
  31. What is a character?
  32. What does RDBMS stand for?
  33. What does the DROP function do?
  34. What does the CASE function do?
  35. What is a relational model?
  36. What does the INSERT INTO function do?
  37. What is a boolean?
  38. What is an index?
  39. What does the DISTINCT function do?
  40. What function does INSERT INTO with SELECT perform?
  41. What is a many-to-many relationship?
  42. What is data definition language(DDL)?
  43. What is a function?
  44. What does the JOIN function do?
  45. What is ANSI SQL syntax?
  46. What does the UNION function do?
  47. What is a non-clustered index?
  48. What is a rollback?
  49. What is normalization?
  50. What is a field?
  51. What is an aggregate function?
  52. What is a query?
  53. What is a column?
  54. What is a differential backup?
  55. What does the CREATE function do?
  56. What is data manipulation language(DML)?
  57. What is normal form?
  58. What is a security plan?
  59. What is data integrity?
  60. What does the COMMIT command do?
  61. What is structured query language(SQL)?
  62. What does the ORDER BY function do?
  63. What is a full backup?
  64. What is a table?
  65. What is a b-tree structure?
  66. What is a scalar function?
  67. What is an integer?
  68. What are replicated services?
  69. What is a schema?
  70. What is a key?
  71. What does the AND logical operator do?
  72. What is a physical security plan?
  73. What is a primary key?
  74. What is a row?
  1. a Relational Data Base Management System
  2. b A sophisticated query language with additional features beyond what is defined in the ANSI SQL.
  3. c Reverses changes.
  4. d A data type that stores 1 or 0, true or false.
  5. e Removing subsets of data that apply to multiple rows of a table and place them in separate tables.
  6. f A relational database language used in querying, updating, and managing relational databases and is the de facto standard for database products.
  7. g Creates when-then-else functionality.
  8. h 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.
  9. i An application, such as Microsoft Access, that is object-oriented and drag-and-drop driven.
  10. j Used to query data from two or more tables.
  11. k Changes databases or objects.
  12. l Combines two or more SELECT statements with an OR function.
  13. m 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 related table.
  14. n Provides users with access to the database.
  15. o A unique data identifier.
  16. p Ensures and restricts who can connect and what they can do.
  17. q A data type that stores A-Z or 0-9, any digit or letter that math functions will not be applied to.
  18. r Arranged in a special order to make retrieval of information faster with direct access to the information.
  19. s Adds databases or objects.
  20. t A model for modern database management systems in which data is organized in relations (tables).
  21. u Only files that have been changed since the last FULL backup are copied.
  22. v Specifies an order in which to return the rows.
  23. w Returns a single value, based on the input value of a single field.
  24. x The data structure usually consisting of a list of entries.
  25. y Specifies which rows to retrieve.
  26. z A location in a record in which a particular type of data is stored.
  27. aa Shows the relationships between boolean logical operators.
  28. ab A process of saving all critical data to re-create the database in useful form in a relatively short time.
  29. ac A description of a database to a database management system (DBMS) in the language provided by the DMBS.
  30. ad Displays a record if both the first condition AND the second condition are true.
  31. ae Recreate a full or incremental reproduction of the database.
  32. af References the primary key in another table.
  33. ag A complex association between two sets of parameters in which many parameters of each set can relate to many others in the second set.
  34. ah The grammar and rules governing the structure and contents of statements.
  35. ai They 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.
  36. aj A saved query that creates a virtual table from the result set of the query.
  37. ak Data type that stores whole numbers.
  38. al Used to update existing records in a table.
  39. am Grants permissions to the database. Defined roles give all users within a group the same permissions.
  40. an An identifier for a record in a data file that is unique and found in only one record.
  41. ao Addresses the safety of the actual location of the database?
  42. ap Only files that have been changed since the last backup are copied.
  43. aq A data type that stores any real numbers.
  44. ar One-word commands that return a single value written in the command set of SQL.
  45. as A set of two or more statements grouped into a single unit.
  46. at Deletes rows in a table.
  47. au Eliminate duplicate columns from the same table.
  48. av An attribute for a row or record.
  49. aw If all statements are correct within a single transaction, it records the changes in the database.
  50. ax Used to insert a new row in a table when a sub-select is used instead of the VALUES clause.
  51. ay Returns a single value, calculated from values in a column.
  52. az Identifies which users can do what actions to data in a database.
  53. ba Used to insert a new row in a table.
  54. bb Returns only distinct(unique) values.
  55. bc A data structure that is a collection of fields (elements), each with its own name and type that appear in a table as a group of fields across one row.
  56. bd 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.
  57. be Selects data from the database.
  58. bf Combines two ore more SELECT statements with an AND function.
  59. bg Arranged similarly to the index of a book, where the index value points to the actual information.
  60. bh A relationship between nodes in a tree data structure in which the parent is one step closer to the root (that is, one level higher) than the child.
  61. bi removing columns that are not dependent upon the primary key.
  62. bj The result of structuring information to avoid redundancy and inconsistency and to promote efficient maintenance, storage, and updating.
  63. bk Involves applying a body of techniques to a relational database to minimize the inclusion of duplicate information.
  64. bl Precompiled groups of SQL statements saved to the database.
  65. bm Used to insert, update, and delete data and to query a database.
  66. bn A specific set of instructions for extracting/selecting particular data.
  67. bo Ensures that data is consistent, correct, and usable throughout the database.
  68. bp Compact segments of user-written SQL code that can accept parameters and return either a value or a table.
  69. bq Displays a record if either the first OR the second conditions are true.
  70. br Used to create, modify, or drop relational databases, entities, attributes, and other objects (e.g. views).
  71. bs All files are copied for possible future retrieval.
  72. bt A record within a table.
  73. bu Removes databases or objects.
  74. bv Queries nested inside another query.