Question types

Start with

Question limit

of 123 available terms

Print test

100 Matching questions

  1. 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.
  2. List the trip name and state for each trip that occurs during the Summer season. Sort the results by trip name within state.
  3. Surrogate key
  4. If B (an attribute) is functionally dependent on A, we can also say that _________.
  5. When a subquery is used, _________ is(are) evaluated first.
  6. Normalization is the process of decomposing relations to produce smaller, well- structured relations
  7. Which might be a subtype under the supertype entity STUDENT?
  8. A foreign key is a primary key of a relation that also is a primary key in another relation.
  9. A(n) _____ corresponds to a column in the relation
  10. What type of relationship exists between this pair of related entities?

    BOOK and BOOK COPY (books have copies)
  11. One-to-many relationship
  12. Understanding the steps involved in transforming EER diagrams into relations is important because:
  13. Which of the following are anomalies that can be caused by redundancies in tables?
  14. An association between entities is known as a ____.
  15. A primary key whose value is unique across all relations is called a:
  16. The attribute on the left-hand side of the arrow in a functional dependency is the:
  17. The attribute on the left-hand side of the arrow in a function dependency is the:
  18. In an E-R diagram, _________ represent entitites
  19. To use a wildcard, include the _________ operator in the WHERE clause,
  20. 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.
  21. Popular ____ include Access, Oracle, DB2, MySQL, and SQL Server.
  22. Many-to-many relationship
  23. A person, place, an object , an event or concept about which the organization wishes to maintain data is called a:
  24. Storing the same data in more than one place is called ____.
  25. Second normal form can be defined as a table that is in first normal form and contains no _________.
  26. The ____ of an entity become the columns in the database table.
  27. Database design decisions must be made carefully because of impacts on:
  28. data type for fields that contain letters and other special characters, and for fields that contain numbers that will not be used for arithmetic.
  29. List the name of each trip that does not start in New Hampshire (NH).
  30. Essentially, setting the value of a given field to ______________ is similar to not entering a value into it at all.
  31. The SQL command used to create an index is
  32. Based on the statement below, which of the following is the primary key?

    Part (PartNum, Description, OnHand, Class, Warehouse, Price)
  33. 1:M
  34. ________ are established between entities in a well-structured database so that the desired information can be retrieved.
  35. In _____ normal form, any multivalued attributes have been removed
  36. data type stores integers, but uses less space than INTEGER.
  37. Which of the following are properties of relations?
  38. In an E-R diagram, ________ represent relatinships
  39. The basic form of an SQL retrieval command is ____.
  40. 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.
  41. A nonkey attribute is also called a(n):
  42. ____ are screen objects used to maintain, view, and print data from a database.
  43. List the name of each trip that has the type Hiking and that has a distance of greater than six miles.
  44. A ____ is a column or collection of columns on which all columns in the table are functionally dependent.
  45. Customers, cars, and parts are examples of:
  46. A rule that states that each foreign key value must match a primary key value in the other relation is called the:
  47. Artificial key
  48. The ____ key of a table is the column or collection of columns that uniquely identifies a given row in that table.
  49. Alternate key
  50. In SQL, you can use the CHECK clause to enforce _____________________ integrity.
  51. In a system catalog, the ________ table contains information about the tables known to SQL.
  52. A candidate key must satisfy all of the following conditions:
  53. User view:
  54. Natural key
  55. Which of the following is a generic entity type that has a relationship with one or more subtypes?
  56. The fact that column B is functionally dependent on column A can be written as
  57. Cumulative design
  58. The SQL statement used to delete an index that is no longer needed is
  59. The ________ states that no primary key attribute may be null.
  60. Secondary keys
  61. The separation of the data description from programs is referred to as
  62. 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?
  63. A relation that contains minimal redundancy and allows easy use is considered to be:
  64. The entity integrity rule states that:
  65. A form of database specification that indicates all the parameters for data storage that are then input to a database implementation is:
  66. Information-level design
  67. _____ entities are entities that cannot exist except with an identifying relationship with a regular entity type.
  68. An integrity constraint is a rule that ____.
  69. A database has ____ if the data in it satisfies all established integrity constraints.
  70. An column (or columnss) that uniquely identifies each row in a relation is called a:
  71. In order to make changes to existing data in a table, you would use the ________ command.
  72. From all of the _______________ keys, one is chosen to be the primary key.
  73. A(n) _____ is a constraint between two attributes.
  74. Weak entity
  75. When a regular entity type contains a multivalued attribute, one must:
  76. A column in a relation of a database that serves as the primary key of another relation in the same database is called a:
  77. You use the SQL _______ command to create a table by describing its layout
  78. Count, Sum, Avg, Max, and Min are a few of the built-in statistics or ____ functions that can be used in a query.
  79. Entities
  80. How many trips have a type of Hiking or Biking?
  81. A table is in first normal form if it does not contain ________.
  82. ________ is a property that lets you change the structure of the database without requiring you to change the programs that access the database
  83. One-to-one relationship
  84. When duplicate column names exist in a database and you need to indicate the column to which you are referring, ____.
  85. A(n) _____ is an attribute in a relation that serves as a primary key of another relation in the same database.
  86. Foreign key
  87. A recursive foreign key is used in a unary relationship.
  88. By including the word ______ in a query after a computation , you can assign a name to the computed field.
  89. The entity integrity rule states that
  90. __________ is the prevention of unauthorized access to the database.
  91. _________ dependencies are dependencies on only a portion of the primary key.
  92. In _____ normal form, any transitive dependencies have been removed.
  93. Physical-level design
  94. A domain definition consists of the following components EXCEPT:
  95. A visual way to represent a database is with a ____.
  96. Relationships
  97. Composite entity
  98. Which of the following is NOT a reason to create an instance of a relational schema with sample data?
  99. A(n) _____ contains minimal data redundancy.
  100. Existence dependency
  1. a no primary key attribute can be null.
  2. b Security
  3. c Aggregate
  4. d attributes
  5. e Relationships
  6. f relationship
  7. g the subquery query
  8. h no primary key attribute can be null
  9. i primary key
  10. j Well-Structured
  11. k data Independence
  13. m DBMSs (Data Base Management Systems)
  14. n Third
  15. o DROP INDEX
  16. p Attribute
  17. q False
  18. r Foreign Key
  19. s Forms
  20. t column(s) in one table that is required to match value of the primary key for some row in another table or is required to be null
  21. u True
  22. v Partial
  23. w AS
  24. x columns of interest strictly for retrieval purposes
  26. z null
  27. aa information-level design adapted for the specific DBMS that will be used
    Must consider characteristics of the particular DBMS
  28. ab Integrity
  29. ac Partial functional
  30. ad rectangles
  31. ae column(s) that could have been chosen as a primary key but was not
  32. af Data accessibility
    Response times
  33. ag First
  34. ah SELECT CustomerNum, CustomerName, CreditLimit, Balance FROM Customer WHERE CreditLimit>Balance;
  35. ai Entity
  36. aj Systables
  37. ak supports all user views encountered during design process
  38. al SMALLINT
  39. am SELECT TripName
    FROM Trip
    WHERE Type='Hiking' AND Distance >6;
  40. an candidate
  41. ao Physical
  42. ap simplest implementation is to treat it as a one-to-many relationship
  43. aq true
  44. ar Referential integrity contraint
  45. as Primary
  46. at Functional Dependency
  47. au PartNum
  48. av write both the table name and the column name, separated by a period
  49. aw data must follow in the database
  50. ax Create two new relation
  51. ay Determinant
  52. az SELECT COUNT (*)
    FROM Trip
    WHERE Type='Hiking' OR Type='Biking'
  53. ba set of requirements necessary to support operations of a particular database user
  54. bb *
  55. bc Enterprise Key
  56. bd entity integrity rule
  57. be Second
  58. bf redundancy
  59. bg SELECT TripName, State
    FROM Trip
    WHERE Season='Summer'
    ORDER BY State, TripName;
  60. bh A -> B
  61. bi Descriptor
  62. bj entities
  63. bk UPDATE
  64. bl legal-values
  65. bm partial dependencies
  66. bn system-generated; usually hidden from users
    Also called a synthetic key
  67. bo LIKE
  68. bp foreign key
  69. bq CHAR
  70. br Data independence
  71. bs depends on another entity for its own existence
  72. bt Insertion
  73. bu consists of a column that uniquely identifies an entity
    -Also called a logical key or an intelligent key
  74. bv include primary key of the "one" table as a foreign key in the "many" table
  75. bw You must be able to check the output of a CASE tool
  76. bx candidate key
  77. by lines
  78. bz : column created for an entity to serve solely as the primary key and that is visible to users
  79. ca one-to-many
  80. cb Integrity constaints
  82. cd create a new table whose primary key is the combination of the primary keys of the original tables
  83. ce 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)
  84. cf Well-Structured Relation
  85. cg drawn as rectangles
  86. ch existence of one entity depends on the existence of another related entity
  87. ci exists to implement a many-to-many relationship
  88. cj are drawn as diamonds with lines connecting the entities involved in relationships
  89. ck Weak
  90. cl repeating groups
  92. cn SELECT TripName
    FROM Trip
    WHERE State !='NH';
  93. co Supertype
  94. cp 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)
  95. cq completed independently of any particular DBMS
  96. cr One-To-Many
  97. cs A functionally determines B
  98. ct Sample data can reverse database implementation errors
  99. cu determinant
  100. cv entry-relationship diagram