NAME

Question types


Start with


Question limit

of 123 available terms

Print test

123 True/False questions

  1. From all of the _______________ keys, one is chosen to be the primary key.rectangles

          

  2. Popular ____ include Access, Oracle, DB2, MySQL, and SQL Server.DBMSs (Data Base Management Systems)

          

  3. A(n) _____ is a constraint between two attributes.Well-Structured Relation

          

  4. A relation that contains minimal redundancy and allows easy use is considered to be:Well-Structured

          

  5. In a SELECT statement, the WHERE clause is mandatory.CREATE INDEX

          

  6. Physical-level designconsists of a column that uniquely identifies an entity
    -Also called a logical key or an intelligent key

          

  7. How many trips have a type of Hiking or Biking?create a new table whose primary key is the combination of the primary keys of the original tables

          

  8. A relation that contains no multivalued attributes, and has nonkey attributes solely dependent on the primary key, but contains transitive dependencies is in which normal form?Second

          

  9. Alternate keyconsists of a column that uniquely identifies an entity
    -Also called a logical key or an intelligent key

          

  10. Cumulative designexists to implement a many-to-many relationship

          

  11. In order to make changes to existing data in a table, you would use the ________ command.UPDATE

          

  12. A primary key whose value is unique across all relations is called a:true

          

  13. A nonkey attribute is also called a(n):Descriptor

          

  14. In SQL, you can use the CHECK clause to enforce _____________________ integrity.CREATE INDEX

          

  15. Existence dependencyexists to implement a many-to-many relationship

          

  16. Indexes are most useful for columns that frequently appear in WHERE clauses of SQL commands, either to qualify the rows to select or for linking.True

          

  17. A person's name, birthday, and social security number are all examples of:attributes

          

  18. Database design decisions must be made carefully because of impacts on:Data accessibility
    Response times
    Security

          

  19. In 1:M relationships, the entity on the one-side of the relationship becomes a foreign key in the table of the many-side of the relationshipno primary key attribute can be null

          

  20. You use the SQL _______ command to create a table by describing its layoutCREATE TABLE

          

  21. A person, place, an object , an event or concept about which the organization wishes to maintain data is called a:DROP INDEX

          

  22. Customer ( CustomerNum, CustomerName, Street, City, State, Zip, Balance, CreditLimit, RepNum )

    Based on the code above, list the number, name, credit limit, and balance for all customers with credit limits that exceed their balances.
    entities

          

  23. When rows are grouped, one row of output is produced for each group.Each attribute has a unique name
    No two rows in a relation are identical
    There are no multivalued attributes in a relation
    (All the above)

          

  24. A recursive foreign key is used in a unary relationship.include primary key of the "one" table as a foreign key in the "many" table

          

  25. If B (an attribute) is functionally dependent on A, we can also say that _________.A -> B

          

  26. In an E-R diagram, _________ represent entititesthe subquery query

          

  27. Foreign keysystem-generated; usually hidden from users
    Also called a synthetic key

          

  28. 1:MOne-To-Many

          

  29. ____ is the prevention of unauthorized access to the database.attributes

          

  30. If the primary key of a table contains only a single column, the table is automatically in 3rd normal form.Systables

          

  31. User view:set of requirements necessary to support operations of a particular database user

          

  32. The ________ states that no primary key attribute may be null.entity integrity rule

          

  33. A database has ____ if the data in it satisfies all established integrity constraints.data Independence

          

  34. The SQL statement used to delete an index that is no longer needed isFalse

          

  35. An integrity constraint is a rule that ____.Well-Structured Relation

          

  36. Customers, cars, and parts are examples of:entities

          

  37. Based on the statement below, which of the following is the primary key?

    Part (PartNum, Description, OnHand, Class, Warehouse, Price)
    PartNum

          

  38. One-to-many relationshipinclude primary key of the "one" table as a foreign key in the "many" table

          

  39. ____ are screen objects used to maintain, view, and print data from a database.attributes

          

  40. A determinant is an attribute or combination of attributes that uniquely identifies a row in a relation.False

          

  41. Entitiesdrawn as rectangles

          

  42. A rule that states that each foreign key value must match a primary key value in the other relation is called the:referential integrity constraint.

          

  43. A(n) _____ contains minimal data redundancy.Well-Structured Relation

          

  44. A form of database specification that indicates all the parameters for data storage that are then input to a database implementation is:Physical

          

  45. Relationshipsdrawn as rectangles

          

  46. Storing the same data in more than one place is called ____.False

          

  47. One-to-one relationshipsimplest implementation is to treat it as a one-to-many relationship

          

  48. When used after the word SELECT, the ____ symbol indicates that you want to include all fields in the query results in the order in which you described them to the DBMS when you created the table.LIKE

          

  49. In an E-R diagram, ________ represent relatinshipsrectangles

          

  50. By including the word ______ in a query after a computation , you can assign a name to the computed field.AS

          

  51. __________ is the prevention of unauthorized access to the database.Security

          

  52. Information-level designcompleted independently of any particular DBMS

          

  53. In _____ normal form, any transitive dependencies have been removed.Third

          

  54. _________ dependencies are dependencies on only a portion of the primary key.Partial

          

  55. When a subquery is used, _________ is(are) evaluated first.rectangles

          

  56. A ____ is a column or collection of columns on which all columns in the table are functionally dependent.candidate key

          

  57. What type of relationship exists between this pair of related entities?

    BOOK and BOOK COPY (books have copies)
    SMALLINT

          

  58. Secondary keyssystem-generated; usually hidden from users
    Also called a synthetic key

          

  59. Surrogate keysystem-generated; usually hidden from users
    Also called a synthetic key

          

  60. In a relation, the order of the rows is important.no primary key attribute can be null.

          

  61. Composite entitydepends on another entity for its own existence

          

  62. The entity integrity rule states that:create a new table whose primary key is the combination of the primary keys of the original tables

          

  63. A functional dependency in which one or more nonkey attributes are functionally dependent on part but not all of the primary key is called a _____ dependency.Partial functional

          

  64. Which might be a subtype under the supertype entity STUDENT?False

          

  65. Which of the following are properties of relations?Each attribute has a unique name
    No two rows in a relation are identical
    There are no multivalued attributes in a relation
    (All the above)

          

  66. A(n) _____ is an attribute in a relation that serves as a primary key of another relation in the same database.False

          

  67. Which of the following is NOT a reason to create an instance of a relational schema with sample data?Insertion
    Deletion
    Modification

          

  68. The entity integrity rule states thatno primary key attribute can be null

          

  69. Artificial key: column created for an entity to serve solely as the primary key and that is visible to users

          

  70. A relation that contains no multivalued attributes, but has nonkey attributes not dependent on the primary key is in which normal form?First

          

  71. Which of the following are anomalies that can be caused by redundancies in tables?Insertion
    Deletion
    Modification

          

  72. data type for fields that contain letters and other special characters, and for fields that contain numbers that will not be used for arithmetic.False

          

  73. A foreign key is a primary key of a relation that also is a primary key in another relation.False

          

  74. The ____ key of a table is the column or collection of columns that uniquely identifies a given row in that table.A -> B

          

  75. The attribute on the left-hand side of the arrow in a functional dependency is the:determinant

          

  76. When duplicate column names exist in a database and you need to indicate the column to which you are referring, ____.primary key

          

  77. Weak entitydrawn as rectangles

          

  78. CHAR data types are numbers without decimal points.SELECT COUNT (*)
    FROM Trip
    WHERE Type='Hiking' OR Type='Biking'

          

  79. A rule that states that each foreign key value must match a primary key value in the other relation is called the:Referential integrity contraint

          

  80. The ____ of an entity become the columns in the database table.Attribute

          

  81. The IN operator can be used instead of the OR operator in phrasing certain conditions.True

          

  82. Natural keyconsists of a column that uniquely identifies an entity
    -Also called a logical key or an intelligent key

          

  83. Which of the following are anomalies that can be caused by redundancies in tables?Insertion anomaly
    Deletion anomaly
    Modification anomaly
    (All the above)

          

  84. A column in a relation of a database that serves as the primary key of another relation in the same database is called a:foreign key

          

  85. Essentially, setting the value of a given field to ______________ is similar to not entering a value into it at all.legal-values

          

  86. Second normal form can be defined as a table that is in first normal form and contains no _________.partial dependencies

          

  87. An column (or columnss) that uniquely identifies each row in a relation is called a:Enterprise Key

          

  88. A table is in first normal form if it does not contain ________.repeating groups

          

  89. Many-to-many relationshipsimplest implementation is to treat it as a one-to-many relationship

          

  90. _____ entities are entities that cannot exist except with an identifying relationship with a regular entity type.Weak

          

  91. In _____ normal form, any multivalued attributes have been removedattributes

          

  92. To use a wildcard, include the _________ operator in the WHERE clause,LIKE

          

  93. List the name of each trip that does not start in New Hampshire (NH).entities

          

  94. The SQL command used to create an index isno primary key attribute can be null

          

  95. The fact that column B is functionally dependent on column A can be written asA -> B

          

  96. Once you add an index to a database, it cannot be deleted.False

          

  97. In SQL you specify referential integrity using a______ clause in either the CREATE TABLE or the ALTER TABLE commands.no primary key attribute can be null

          

  98. Redundancy wastes space because you are storing the same data in more than one place.True

          

  99. The attribute on the left-hand side of the arrow in a function dependency is the:Determinant

          

  100. Normalization is the process of decomposing relations to produce smaller, well- structured relationsdata Independence

          

  101. In a system catalog, the ________ table contains information about the tables known to SQL.False

          

  102. List the trip name and state for each trip that occurs during the Summer season. Sort the results by trip name within state.SELECT TripName
    FROM Trip
    WHERE Type='Hiking' AND Distance >6;

          

  103. When a regular entity type contains a multivalued attribute, one must:Functional Dependency

          

  104. Which of the following is a generic entity type that has a relationship with one or more subtypes?Supertype

          

  105. Understanding the steps involved in transforming EER diagrams into relations is important because:You must be able to check the output of a CASE tool

          

  106. The separation of the data description from programs is referred to asdata Independence

          

  107. The SELECT command that creates the view,indicates what to include in the query.True

          

  108. ________ is a property that lets you change the structure of the database without requiring you to change the programs that access the databaseData independence

          

  109. An association between entities is known as a ____.relationship

          

  110. ________ normal form has an additional condition hat the only determinants the table contains are candidate keys.Third

          

  111. A candidate key must satisfy all of the following conditions:a. each nonkey attribute is functionally dependent upon it.
    b. the key must be nonredundant.
    c. the key must uniquely identify the row.
    (All of the above)

          

  112. A domain definition consists of the following components EXCEPT:Integrity constaints

          

  113. The ____ is a column (or collection of columns) A such that all other columns are functionally dependent on A and no subcollection of the columns in A has this propertyprimary key

          

  114. ________ are established between entities in a well-structured database so that the desired information can be retrieved.attributes

          

  115. A visual way to represent a database is with a ____.data must follow in the database

          

  116. A ____ is a characteristic or property of an entity.Functional Dependency

          

  117. The basic form of an SQL retrieval command is ____.SELECT-FROM-WHERE

          

  118. A(n) _____ corresponds to a column in the relationAttribute

          

  119. This is similar to an object-oriented database's object identifier.Attribute

          

  120. data type stores integers, but uses less space than INTEGER.False

          

  121. List the name of each trip that has the type Hiking and that has a distance of greater than six miles.SELECT TripName
    FROM Trip
    WHERE Type='Hiking' AND Distance >6;

          

  122. Count, Sum, Avg, Max, and Min are a few of the built-in statistics or ____ functions that can be used in a query.Aggregate

          

  123. A determinant is a constraint between two attributes or sets of attributes.Functional Dependency