CoSci 186 Chapter 1 & 2

Home > Preview

The flashcards below were created by user Lencha on FreezingBlue Flashcards.


  1. Combining the contents of two or more columns is known as projection.
    False
  2. Transitive dependency can only exist if the data is uniquely identified by a composite primary key.
    False
  3. The optional keyword AS can be used to indicate that the subsequent string of characters is a column alias.
    True
  4. A string literal must be enclosed in double quotation marks.
    False
  5. A one-to-many relationship means that an occurrence of a specific entity can only exist once in each table.
    False
  6. Parentheses can be used to override the order of operations in an arithmetic expression.
    True
  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.
    True
  8. An entity is represented by a column in the Entity-Relationship Model.
    False
  9. A field in the logical design of a database corresponds to a row in the physical table of a relational database.
    False
  10. The SELECT command can be used to display the structure of a database table.
    False
  11. Data is in second normal form (2NF) if it contains no repeating groups and has a primary key to uniquely identify each record.
    False
  12. A collection of fields is a file.
    False
  13. A record in the logical design of a database corresponds to a row in the physical table of a relational database.
    True
  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.
    False
  15. The ALL option can be used in the SELECT clause to indicate that all columns should be retrieved.
    False
  16. The following types of relationships can be included in an Entity-Relationship Model: one-to-one, one-to-many, many-to-many.
    True
  17. Column headings may be truncated in the results of a SELECT statement.
    True
  18. In a(n) SELECT statement, keywords, table names, and column names are not case sensitive.
    True
  19. The majority of operations performed on a typical database table utilize the SELECT statement.
    True
  20. Choosing specific columns to be displayed by a SELECT statement is known as projection.
    True
  21. Two tables can be linked or joined together through a common field.
    True
  22. A database is a physical storage device for data.
    False
  23. A foreign key uniquely identifies each row in a table.
    False
  24. When listing more than one column name in the SELECT clause of a SELECT statement, the column names must be separated by semicolons.
    False
  25. A double backslash () is used to indicate concatenation in a SELECT statement.
    False
  26. Which of the following is used to create and maintain the physical database?
    A. Data mining
    B. E-R Model
    C. Systems Development Life Cycle (SDLC)
    D. Database Management System (DBMS)
    D. Database Management System (DBMS)
    (this multiple choice question has been scrambled)
  27. The ____ for a SQL statement gives the basic structure, or rules, required to execute the statement.
    A. keywords
    B. sequence
    C. syntax
    D. clauses
    B. sequence
    (this multiple choice question has been scrambled)
  28. In which step of the Systems Development Life Cycle (SDLC) is the system actually used by the end-user on a regular basis?
    A. systems implementation and review
    B. systems deployment
    C. systems investigation
    D. systems analysis
    B. systems deployment
    (this multiple choice question has been scrambled)
  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
    B. 10
    C. 12
    D. 31
    A. 13
    (this multiple choice question has been scrambled)
  30. Combining the contents of two or more columns is known as ____.
    A. suppression
    B. selection
    C. concatenation
    D. projection
    C. concatenation
    (this multiple choice question has been scrambled)
  31. Which of the following can lead to partial dependencies?
    A. common fields
    B. normalization
    C. composite primary key
    D. foreign keys
    C. composite primary key
    (this multiple choice question has been scrambled)
  32. A DBMS includes which of the following capabilities?
    A. security
    B. data dictionary
    C. multiuser access
    D. all of the above
    D. all of the above
  33. Which of the following does not contain repeating groups, but has a primary key and possibly partial dependencies?
    A. unnormalized data
    B. first normal form (1NF)
    C. second normal form (2NF)
    D. third normal form (3NF)
    B. first normal form (1NF)
    (this multiple choice question has been scrambled)
  34. Which of the following are case sensitive in Oracle 12c?
    A. none of the above
    B. table names
    C. keywords
    D. column names
    A. none of the above
    (this multiple choice question has been scrambled)
  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?
    A. field
    B. record
    C. file
    D. database
    A. field
    (this multiple choice question has been scrambled)
  36. What is used to indicate the end of an SQL statement?
    A. :
    B. ;
    C. *
    D. /
    D. /
    (this multiple choice question has been scrambled)
  37. Partial dependency exists if what conditions exist?
    A. the table is not in first normal form (1NF)
    B. the data contains repeating groups
    C. a column is dependent on a portion of the table that is not identified as the primary key
    D. a column is dependent only on a portion of a composite primary key
    D. a column is dependent only on a portion of a composite primary key
    (this multiple choice question has been scrambled)
  38. Data mining refers to ____.
    A. discovering new data to include in the database
    B. selling data to other organizations
    C. analyzing data already stored in a database
    D. all of the above
    C. analyzing data already stored in a database
    (this multiple choice question has been scrambled)
  39. A(n) ____ has a predefined meaning in Oracle 12c.
    A. syntax
    B. statement
    C. clause
    D. keyword
    B. statement
    (this multiple choice question has been scrambled)
  40. In an E-R Model a person, place, or thing with characteristics to be stored in the database are referred to as?
    A. attribute
    B. file
    C. entity
    D. row
    C. entity
    (this multiple choice question has been scrambled)
  41. Which of the following committees are responsible for establishing SQL guidelines?
    A. ANSI and ASCII
    B. OSI and ASCII
    C. IEEE and OSI
    D. ANSI and ISO
    D. ANSI and ISO
    (this multiple choice question has been scrambled)
  42. If uncontrolled, what can lead to data anomalies?
    A. data correlation
    B. data normalization
    C. data redundancy
    D. data suppression
    C. data redundancy
    (this multiple choice question has been scrambled)

Card Set Information

Author:
Lencha
ID:
324558
Filename:
CoSci 186 Chapter 1 & 2
Updated:
2016-11-18 09:14:33
Tags:
SQL Joan Casteel
Folders:
Co Sci 186
Description:
Chapter 1 & 2
Show Answers:

Home > Flashcards > Print Preview