130 True/False questions

1. The ___ statement is used to insert a new row in a table when a sub-select is used instead of the VALUES clause. → VALUES clause

   True        False

2. A truth table is helpful in visualizing the results of logical operators. When comparing two fields, which condition always results in TRUE? ___ → Truth tables

   True        False

3. Stored procedures are ___ saved to the database. → deletes rows

   True        False

4. Which DDL command can Raj use to add a new field to the Cycle table to store the filename of the photo? ___ → ALTER TABLE Cycle ADD photo _ file _ name CHAR (30) NULL

   True        False

5. ROLLBACK ___ changes. → reverses

   True        False

6. Data definition language (DDL) defines database objects including ___ . → the rows to update

   True        False

7. A column is an ___ for a row or record. → false

   True        False

8. Normal Form is the result of structuring (organizing) information to avoid ___ and to promote efficient maintenance, storage, and updating. → field

   True        False

9. What is not a benefit of enforcing Second and Third Normal Forms? ___ → Indexed data for easy retrieval

   True        False

10. JOIN is used to query data from ___ . → two or more tables

    True        False

11. Functions are one-word commands that return a ___ . → single value written in the command set of SQL.

    True        False

12. Most modern database management systems implement a relational model in which the data is organized in ___ . → relations (tables)

    True        False

13. Which statement best defines a predicate subquery? → another query

    True        False

14. SELECT is the most-used SQL command for ___ . → selecting the data from the database

    True        False

15. A foreign key references the ___ . → another query

    True        False

16. TRANSACTIONS are a set of two or more statements grouped into a ___ . → single unit

    True        False

17. The INSERT INTO statement is used to insert a ___ in a table. → INSERT INTO

    True        False

18. ANSI SQL syntax is the ___ governing the structure and content of statements. → grammar and rules

    True        False

19. 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 ___ . → VALUES clause

    True        False

20. ORDER BY specifies an ___ in which to return the rows. → WHERE

    True        False

21. DISTINCT returns only ___ → distinct (unique) values.

    True        False

22. ___ combines two or more SELECT statements with an AND function. → UPDATE

    True        False

23. How can you set up the INSERT to allow copy rows from other tables? ___ → INSERT INTO

    True        False

24. A view is a saved query that creates a ___ . → virtual table from the result set of the query

    True        False

25. For some of the reports it will be useful to see the results in alphabetical order. Which command will produce an alphabetical list? ___ → Truth tables

    True        False

26. ___ sets a few basic rules for a database: eliminate duplicative columns from the same table. → JOIN

    True        False

27. In an ___ backup only files that have been changed since the last backup are copied. → differential

    True        False

28. A ___ references the primary key in another table. → row

    True        False

29. Roles ___ to the database. Defined roles give all users within a group the same permissions. → grant permissions

    True        False

30. ___ show the relationships of the Boolean logical operators. → JOIN

    True        False

31. ___ is the result of structuring (organizing) information to avoid redundancy and inconsistency and to promote efficient maintenance, storage, and updating. → Normal Form

    True        False

32. Which command would ensure that return visitors are only counted once when running a query against the reservation system? ___ → consistent, correct, and usable

    True        False

33. ___ returns only distinct (unique) values. → another query

    True        False

34. ___ = 1NF + removing subsets of data that apply to multiple rows of a table and place them in separate tables. → UPDATE

    True        False

35. DROP ___. → adds databases objects

    True        False

36. A ___ index is arranged similarly to the index of a book, where the index value points to the actual information. → foreign key

    True        False

37. A ___ plan identifies which users can do what action(s) to data in the database. → consistent, correct, and usable

    True        False

38. In a ___ backup only files that have been changed since the last full_backup are copied. → differential

    True        False

39. 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. → UPDATE RENTALS SET value _ added _ tax = .10

    True        False

40. Data integrity ensures that data is ___ throughout the database. → full or incremental

    True        False

41. A primary key serves as the ___ of a specific row and uniquely defines a relationship within a database. → unique identifier

    True        False

42. How are transactions useful when updating/deleting/adding records to a database? ___ → UPDATE

    True        False

43. ____ is a sophisticated query language with additional features beyond what is defined in the ANSI SQL. → Backup

    True        False

44. Transact-SQL (T-SQL) is a sophisticated query language with additional features beyond what is defined in the ___ . → ANSI SQL

    True        False

45. Roles grant permissions to the database. Defined roles give all users within a group the same ___ . → grant permissions

    True        False

46. 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? → SELECT

    True        False

47. ___ specifies an order in which to return the rows. → ORDER BY

    True        False

48. A table is a database object consisting of ___. → rows and columns

    True        False

49. RDBMS is the acronym for ___ . → Relational Data Base Management System

    True        False

50. ___ are compact segments of user-written SQL code that can accept parameters and return either a value or a table. → User-defined functions

    True        False

51. Aggregate functions return a single value, calculated from values ___ . → in a column

    True        False

52. ___ is the most-used SQL command for selecting the data from the database. → physical security

    True        False

53. A graphical designer is an application, such as Microsoft Access, that is ___ . → object-oriented and drag-and-drop driven

    True        False

54. UNION combines two or more SELECT statements with an ___ . → Boolean logical operators

    True        False

55. Graphical designers include applications such as Microsoft Access, which are ___ . → object-oriented and drag-and-drop driven

    True        False

56. ___ is used to update existing records in a table. → in a table

    True        False

57. Normal Form is the result of structuring (organizing) information to avoid redundancy and inconsistency and to promote ___ . → efficient maintenance, storage, and updating

    True        False

58. The goal of First Normal Form is: ___ → distinct (unique) values.

    True        False

59. 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 ___ . → related table

    True        False

60. A user account provides users with ___ . → rows to retrieve

    True        False

61. When should the INTERSECT query be used? → To return only the rows that appear in both tables, similar to a Boolean AND

    True        False

62. 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. → Truth tables

    True        False

63. The Second Normal Form (2NF) = 1NF + removing subsets of data that apply to multiple rows of a table and place them in ___ . → separate tables

    True        False

64. ___ serves as the unique identifier of a specific row and uniquely defines a relationship within a database. → A primary key

    True        False

65. 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. → b-tree

    True        False

66. 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. → related table

    True        False

67. The WHERE clause in an UPDATE statement specifies ___ . → WHERE

    True        False

68. What is not a rule for the primary key? ___ → it must be numeric

    True        False

69. The Third Normal Form (3NF) = 2NF + ___ that are not dependent upon the primary key. → removing columns

    True        False

70. Subqueries nest inside ___ . → another query

    True        False

71. Character stores ___ (any digit or letter that math functions will not be applied to). → extracting/selecting particular data

    True        False

72. Replication services are recommended when: ___ → The database must be available 24 hours a day, 7 days a week

    True        False

73. 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? ___ → INSERT INTO

    True        False

74. What is the main difference between the DML command DELETE and the DDL command DROP? ___ → Indexed data for easy retrieval

    True        False

75. ___ specifies which rows to retrieve. → WHERE

    True        False

76. In a ___ backup all files are copied for possible future retrieval. → full

    True        False

77. A table is a data structure usually consisting of a ___ . → list of entries

    True        False

78. 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 ___ → ELSE

    True        False

79. 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 ___. → stored in memory

    True        False

80. Boolean stores 1 or 0, true or ___ . → Relational Data Base Management System

    True        False

81. ___ = 2NF + removing columns that are not dependent upon the primary key. → removing columns

    True        False

82. Boolean logical operators : AND displays a record if both the first condition ___ . → false

    True        False

83. ___ involves applying a body of techniques to a relational database to minimize the inclusion of duplicate information. → Normalization

    True        False

84. How can a programmer enforce data integrity rules when making changes to the records in a database? ___ → foreign key

    True        False

85. Boolean logical operators : OR displays a record if either the first condition ___ . → or the second conditions are true

    True        False

86. ___ is used to query data from two or more tables. → row

    True        False

87. ___ 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. → Data type

    True        False

88. ___ reverses changes. → ROLLBACK

    True        False

89. A ___ is arranged in a special order to make retrieval of information faster with direct access to the information. → clustered index

    True        False

90. Replicated services re-create a ___ reproduction of the database. → precompiled groups of SQL statements

    True        False

91. A query is a specific set of instructions for ___ . → virtual table from the result set of the query

    True        False

92. 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. → table

    True        False

93. A view is a saved query that creates a ___ table from the result set of the query. → virtual

    True        False

94. A ___ plan addresses the safety of the actual location of the database. → physical security

    True        False

95. What happens if a WHERE statement is not included with the DELETE statement? ___ → The data from the table is deleted

    True        False

96. ___ is a description of a database to a database management system (DBMS) in the language provided by the DBMS. → A schema

    True        False

97. 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: ___ → b-tree

    True        False

98. Floating-point data types store any ___ . → real numbers

    True        False

99. Integer data types store ___ . → distinct (unique) values.

    True        False

100. ___ is a process of saving all critical data to re-create the database in useful form in a relatively short → Backup

     True        False

101. Truth tables show the relationships of the ___ . → Relational Data Base Management System

     True        False

102. ___ ensures that data is consistent, correct, and usable throughout the database. → Data integrity

     True        False

103. What is the difference between UNION and JOIN? → it must be numeric

     True        False

104. What should be included in the physical security plan? ___ → location of servers with restricted access

     True        False

105. DELETE FROM ___ in a table. → DELETE FROM

     True        False

106. Scalar functions return a ___ , based on the input value of a single field. → precompiled groups of SQL statements

     True        False

107. 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. → table

     True        False

108. A ___ is a record within a table. → ROLLBACK

     True        False

109. Primary Keys are ___ . → changes databases objects

     True        False

110. When designing the INSERT SQL, what happens if data is missing for a particular column? ___ → The INSERT statement uses the default value for the column.

     True        False

111. Data definition language (DDL) is used to ___ . → create, modify, or drop relational databases, entities, attributes, and other objects (e.g. views)

     True        False

112. The First Normal Form (1NF) sets a few basic rules for a database: ___ → eliminate duplicative columns from the same table.

     True        False

113. A field is a location in a ___ in which a particular type of data is stored. → virtual table from the result set of the query

     True        False

114. WHERE specifies which ___ . → rows to retrieve

     True        False

115. What is the name of the data located at the intersection of a row and column? → field

     True        False

116. The ___ statement is used to insert a new row in a table. → new row

     True        False

117. 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. → physical security

     True        False

118. A ___ is a saved query that creates a virtual table from the result set of the query. → Data manipulation language (DML)

     True        False

119. CASE creates ___ functionality (WHEN this condition is met THEN do this). → ensures and restricts

     True        False

120. ___ deletes rows in a table. → DELETE FROM

     True        False

121. UPDATE is used to update existing records ___ . → UPDATE

     True        False

122. ___ combines two or more SELECT statements with an OR function. → UNION

     True        False

123. ALTER ___. → changes databases objects

     True        False

124. CREATE ___ . → removes databases objects

     True        False

125. Structured query language (SQL) is ___ . → a relational database language used in querying, updating, and managing relational databases and is the de facto standard for database products

     True        False

126. The ___ clause in an UPDATE statement specifies the rows to update. → WHERE

     True        False

127. Access control ___ who can connect and what they can do. → attribute

     True        False

128. The value of the case expression is the value of the ___ that is true. If none is true, the result is the ELSE. → Data type

     True        False

129. ___ are a set of two or more statements grouped into a single unit. → UPDATE

     True        False

130. ___ is used to insert, update, and delete data and to query a database. → Data manipulation language (DML)

     True        False