NAME

Question types


Start with


Question limit

of 130 available terms

Print test

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

          

  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

          

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

          

  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

          

  5. ROLLBACK ___ changes.reverses

          

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

          

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

          

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

          

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

          

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

          

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

          

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

          

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

          

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

          

  15. A foreign key references the ___ .another query

          

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

          

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

          

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

          

  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

          

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

          

  21. DISTINCT returns only ___distinct (unique) values.

          

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

          

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

          

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

          

  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

          

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

          

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

          

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

          

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

          

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

          

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

          

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

          

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

          

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

          

  35. DROP ___.adds databases objects

          

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

          

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

          

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

          

  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

          

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

          

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

          

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

          

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

          

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

          

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

          

  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

          

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

          

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

          

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

          

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

          

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

          

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

          

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

          

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

          

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

          

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

          

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

          

  58. The goal of First Normal Form is: ___distinct (unique) values.

          

  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

          

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

          

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

          

  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

          

  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

          

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

          

  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

          

  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

          

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

          

  68. What is not a rule for the primary key? ___it must be numeric

          

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

          

  70. Subqueries nest inside ___ .another query

          

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

          

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

          

  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

          

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

          

  75. ___ specifies which rows to retrieve.WHERE

          

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

          

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

          

  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

          

  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

          

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

          

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

          

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

          

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

          

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

          

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

          

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

          

  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

          

  88. ___ reverses changes.ROLLBACK

          

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

          

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

          

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

          

  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

          

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

          

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

          

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

          

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

          

  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

          

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

          

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

          

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

          

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

          

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

          

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

          

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

          

  105. DELETE FROM ___ in a table.DELETE FROM

          

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

          

  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

          

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

          

  109. Primary Keys are ___ .changes databases objects

          

  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.

          

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

          

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

          

  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

          

  114. WHERE specifies which ___ .rows to retrieve

          

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

          

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

          

  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

          

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

          

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

          

  120. ___ deletes rows in a table.DELETE FROM

          

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

          

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

          

  123. ALTER ___.changes databases objects

          

  124. CREATE ___ .removes databases objects

          

  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

          

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

          

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

          

  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

          

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

          

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