CoSci 186 Chapter 1 & 2

  1. Combining the contents of two or more columns is known as projection.
  2. Transitive dependency can only exist if the data is uniquely identified by a composite primary key.
  3. The optional keyword AS can be used to indicate that the subsequent string of characters is a column alias.
  4. A string literal must be enclosed in double quotation marks.
  5. A one-to-many relationship means that an occurrence of a specific entity can only exist once in each table.
  6. Parentheses can be used to override the order of operations in an arithmetic expression.
  7. The Systems Development Life Cycle is a series of steps that can be used to guide the development process for a database management system.
  8. An entity is represented by a column in the Entity-Relationship Model.
  9. A field in the logical design of a database corresponds to a row in the physical table of a relational database.
  10. The SELECT command can be used to display the structure of a database table.
  11. Data is in second normal form (2NF) if it contains no repeating groups and has a primary key to uniquely identify each record.
  12. A collection of fields is a file.
  13. A record in the logical design of a database corresponds to a row in the physical table of a relational database.
  14. A column heading that is longer than the width of a column will not be truncated for a column that is defined to store character data.
  15. The ALL option can be used in the SELECT clause to indicate that all columns should be retrieved.
  16. The following types of relationships can be included in an Entity-Relationship Model: one-to-one, one-to-many, many-to-many.
  17. Column headings may be truncated in the results of a SELECT statement.
  18. In a(n) SELECT statement, keywords, table names, and column names are not case sensitive.
  19. The majority of operations performed on a typical database table utilize the SELECT statement.
  20. Choosing specific columns to be displayed by a SELECT statement is known as projection.
  21. Two tables can be linked or joined together through a common field.
  22. A database is a physical storage device for data.
  23. A foreign key uniquely identifies each row in a table.
  24. When listing more than one column name in the SELECT clause of a SELECT statement, the column names must be separated by semicolons.
  25. A double backslash () is used to indicate concatenation in a SELECT statement.
  26. Which of the following is used to create and maintain the physical database?

    C. Database Management System (DBMS)
  27. The ____ for a SQL statement gives the basic structure, or rules, required to execute the statement.

    D. sequence
  28. In which step of the Systems Development Life Cycle (SDLC) is the system actually used by the end-user on a regular basis?

    D. systems deployment
  29. What is the correct answer for the arithmetic expression 9+2*3-2 using the order of operations employed by Oracle 12c when solving equations?

    A. 13
  30. Combining the contents of two or more columns is known as ____.

    B. concatenation
  31. Which of the following can lead to partial dependencies?

    D. composite primary key
  32. A DBMS includes which of the following capabilities?

    D. all of the above
  33. Which of the following does not contain repeating groups, but has a primary key and possibly partial dependencies?

    C. first normal form (1NF)
  34. Which of the following are case sensitive in Oracle 12c?

    A. none of the above
  35. Which of the following terms best describes where a group of characters that represents a customer’s address would be stored in the logical design?

    B. field
  36. What is used to indicate the end of an SQL statement?

    B. /
  37. Partial dependency exists if what conditions exist?

    D. a column is dependent only on a portion of a composite primary key
  38. Data mining refers to ____.

    B. analyzing data already stored in a database
  39. A(n) ____ has a predefined meaning in Oracle 12c.

    A. statement
  40. In an E-R Model a person, place, or thing with characteristics to be stored in the database are referred to as?

    D. entity
  41. Which of the following committees are responsible for establishing SQL guidelines?

    B. ANSI and ISO
  42. If uncontrolled, what can lead to data anomalies?

    A. data redundancy
Card Set
CoSci 186 Chapter 1 & 2
Chapter 1 & 2