NAME

Question types


Start with


Question limit

of 75 available terms

Print test

75 True/False questions

  1. What does the CASE function do?Adds databases or objects.

          

  2. What is data integrity?Ensures that data is consistent, correct, and usable throughout the database.

          

  3. What is a stored procedure?Precompiled groups of SQL statements saved to the database.

          

  4. What is a field?A location in a record in which a particular type of data is stored.

          

  5. What does the DROP function do?Removes databases or objects.

          

  6. What does the COMMIT command do?Used to query data from two or more tables.

          

  7. What is a differential backup?Only files that have been changed since the last backup are copied.

          

  8. What is an incremental backup?Only files that have been changed since the last backup are copied.

          

  9. What is data definition language(DDL)?Used to insert, update, and delete data and to query a database.

          

  10. What is a boolean?A data type that stores 1 or 0, true or false.

          

  11. What is normal form?The result of structuring information to avoid redundancy and inconsistency and to promote efficient maintenance, storage, and updating.

          

  12. What does the AND logical operator do?Displays a record if both the first condition AND the second condition are true.

          

  13. What are replicated services?Queries nested inside another query.

          

  14. What does the JOIN function do?Combines two or more SELECT statements with an OR function.

          

  15. What is access control?Grants permissions to the database. Defined roles give all users within a group the same permissions.

          

  16. What is data manipulation language(DML)?Used to insert, update, and delete data and to query a database.

          

  17. What is second normal form?Removing subsets of data that apply to multiple rows of a table and place them in separate tables.

          

  18. What is a primary key?An identifier for a record in a data file that is unique and found in only one record.

          

  19. What is a non-clustered index?Arranged similarly to the index of a book, where the index value points to the actual information.

          

  20. What function does INSERT INTO with SELECT perform?Used to insert a new row in a table.

          

  21. What is a view?A saved query that creates a virtual table from the result set of the query.

          

  22. What does the OR logical operator do?Used to query data from two or more tables.

          

  23. What is a floating point?A data type that stores any real numbers.

          

  24. What is a clustered index?Arranged in a special order to make retrieval of information faster with direct access to the information.

          

  25. What is a one-to-one relationship?A complex association between two sets of parameters in which many parameters of each set can relate to many others in the second set.

          

  26. What is a b-tree structure?Precompiled groups of SQL statements saved to the database.

          

  27. What is an index?Grants permissions to the database. Defined roles give all users within a group the same permissions.

          

  28. What does the CREATE function do?Used to update existing records in a table.

          

  29. What does the SELECT function do?Creates when-then-else functionality.

          

  30. What is a user-defined function?Compact segments of user-written SQL code that can accept parameters and return either a value or a table.

          

  31. What is a security plan?Identifies which users can do what actions to data in a database.

          

  32. What are transactions?A set of two or more statements grouped into a single unit.

          

  33. What does the INSERT INTO function do?Used to insert a new row in a table.

          

  34. What does the ALTER function do?Creates when-then-else functionality.

          

  35. What does the DELETE FROM function do?Removes databases or objects.

          

  36. What is third normal form?Removing subsets of data that apply to multiple rows of a table and place them in separate tables.

          

  37. What is a truth table?The data structure usually consisting of a list of entries.

          

  38. What is a record?A record within a table.

          

  39. What is a graphical designer?An application, such as Microsoft Access, that is object-oriented and drag-and-drop driven.

          

  40. What is a row?Grants permissions to the database. Defined roles give all users within a group the same permissions.

          

  41. What is an integer?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.

          

  42. What does RDBMS stand for?Relational Data Base Management System

          

  43. What is first normal form?Eliminate duplicate columns from the same table.

          

  44. What is ANSI SQL syntax?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.

          

  45. What is an aggregate function?Returns a single value, calculated from values in a column.

          

  46. What is a parent/child relationship?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.

          

  47. What is a primary key?References the primary key in another table.

          

  48. What is a key?A specific set of instructions for extracting/selecting particular data.

          

  49. What is a schema?A description of a database to a database management system (DBMS) in the language provided by the DMBS.

          

  50. What does the WHERE function do?Changes databases or objects.

          

  51. What is a function?A process of saving all critical data to re-create the database in useful form in a relatively short time.

          

  52. What does the DISTINCT function do?Used to query data from two or more tables.

          

  53. What is a scalar function?Returns a single value, based on the input value of a single field.

          

  54. What is a user account?Provides users with access to the database.

          

  55. What is a rollback?Reverses changes.

          

  56. What are subqueries?A specific set of instructions for extracting/selecting particular data.

          

  57. What is a physical security plan?Addresses the safety of the actual location of the database?

          

  58. What is a many-to-many relationship?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.

          

  59. What does the INTERSECT function do?Selects data from the database.

          

  60. What is a foreign key?References the primary key in another table.

          

  61. What does the UNION function do?Combines two or more SELECT statements with an OR function.

          

  62. What is a character?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.

          

  63. What is structured query language(SQL)?A relational database language used in querying, updating, and managing relational databases and is the de facto standard for database products.

          

  64. What is a full backup?Provides users with access to the database.

          

  65. What is a table?The data structure usually consisting of a list of entries.

          

  66. What are data types?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.

          

  67. What is normalization?Involves applying a body of techniques to a relational database to minimize the inclusion of duplicate information.

          

  68. What is a column?Grants permissions to the database. Defined roles give all users within a group the same permissions.

          

  69. What does the UPDATE function do?Removes databases or objects.

          

  70. What is a relational model?A model for modern database management systems in which data is organized in relations (tables).

          

  71. What is Transact-SQL (T-SQL)?The grammar and rules governing the structure and contents of statements.

          

  72. What is a role?A record within a table.

          

  73. What is a backup?The data structure usually consisting of a list of entries.

          

  74. What does the ORDER BY function do?Specifies an order in which to return the rows.

          

  75. What is a query?A specific set of instructions for extracting/selecting particular data.