View the step-by-step solution to:

Question

Question 37

  1. One strategy to manage deadlocks is to let them occur and then have the DBMS detect and

break any deadlock.

  • True
  • False

  • 1 points 

    Question 38

    1. ____ is the ability of a computer system to continue to function well as utilization of the system increases.
    2. a. Data mining
    3. b. Scalability
    4. c. Polymorphism
    5. d. Data fragmentation

    1 points 

    Question 39

    1. A set of requirements that is necessary to support the operations of a particular database user is known as a(n) ____.
    2. a. user system
    3. b. user snapshot
    4. c. user view
    5. d. user window

    1 points 

    Question 40

    1. 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 property.
    2. a. functional key
    3. b. composite key
    4. c. primary key
    5. d. declared key

    1 points 

    Question 41

    1. In two-phase locking, the second phase is the shrinking phase.
    2. True
    3. False

    1 points 

    Question 42

    1. A column is a nonkey column if it is ____.
    2. a. a part of the primary key
    3. b. in second normal form
    4. c. not a part of the primary key
    5. d. in first normal form

    1 points 

    Question 43

    1. A(n) ____ is a column or collection of columns on which all columns in the table are functionally dependent.
    2. a. special key
    3. b. candidate key
    4. c. index key
    5. d. major key

    1 points 

    Question 44

    1. If there is more than one possible choice for the primary key, and one of the possibilities is chosen to be the primary key, the other choices are referred to as ____.
    2. a. contributory keys
    3. b. surrogate keys
    4. c. alternate keys
    5. d. intelligent keys

    1 points 

    Question 45

    1. When designing a database, you might find it helpful to design a(n) ____ to obtain the required information from users.
    2. a. survey form
    3. b. report
    4. c. IDEF1X diagram
    5. d. E-R diagram

    1 points 

    Question 46

    1. When a centralized database becomes unavailable for any reason, no users can continue processing. In contrast, if a local database in a distributed database becomes unavailable, only users who need that data are affected. Because of this, distributed databases have a(n) ____ advantage over a centralized database.
    2. a. increasing database capacity
    3. b. system availability
    4. c. local control of data
    5. d. added efficiency

    1 points 

    Question 47

    1. The properties of the entities you choose as you design the user view will become the ____ in the appropriate tables.
    2. a. rows
    3. b. records
    4. c. tuples
    5. d. columns

    1 points 

    Question 48

    1. When you use an E-R diagram to represent a database, it visually illustrates all the information listed in the DBDL.
    2. True
    3. False

    1 points 

    Question 49

    1. Computers in a network communicate through ____.
    2. a. notes
    3. b. messages
    4. c. tokens
    5. d. letters

    1 points 

    Question 50

    1. A distributed database is a single logical database that is physically divided among computers at several sites on a network.
    2. True
    3. False

    1 points 

    Question 51

    1. ____ implies that users should not need to be concerned with the location of any specific data in the database.
    2. a. Fragmentation transparency
    3. b. Update transparency
    4. c. Replication transparency
    5. d. Location transparency

    1 points 

    Question 52

    1. The basic relationships among entities are: one-to-many, many-to-many, and one-to-one.
    2. True
    3. False

    1 points 

    Question 53

    1. A(n) ____ is a snapshot of certain data in a database at a given moment in time.
    2. a. encryption
    3. b. authentication
    4. c. authorization
    5. d. view

    1 points 

    Question 54

    1. Each user transaction requires only one lock.
    2. True
    3. False

    1 points 

    Question 55

    1. If the primary key of a table contains only a single column, the table is automatically in third normal form.
    2. True
    3. False

    1 points 

    Question 56

    1. The fact that column B is functionally dependent on column A can be written as ____.
    2. a. B ® A
    3. b. B ® ® A
    4. c. A ® B
    5. d. A ® ® B

    1 points 

    Question 57

    1. A DDBMS that has at least two sites at which the local DBMSs are different is known as a ____.
    2. a. homogeneous DDBMS
    3. b. heterogeneous DDBMS
    4. c. holistic DDBMS
    5. d. heuristic DDBMS

    1 points 

    Question 58

    1. A global deadlock occurs at a single site in a distributed database.
    2. True
    3. False

    1 points 

    Question 59

    1. ____ implies that no site should depend on another site to perform its database functions.
    2. a. Continuous operation
    3. b. Local autonomy
    4. c. No reliance on a central site
    5. d. Fragmentation transparency

    1 points 

    Question 60

    1. Convert the following table to first normal form:
    2. Branch (BranchNum, BranchName, (BookCode, Title, CopyNum, Quality, Price) )
    3. a. Branch (BranchNum, BranchName, BookCode, Title, CopyNum, Quality, Price)
    4. b. Branch (BranchNum, BranchName)
    5. Book (BookCode, Title, CopyNum)
    6. c. Branch (BranchNum, BranchName)
    7. d. Book (BookCode, Title, Copynum)

    1 points 

    Question 61

    1. If users are unaware of fragmentation, the DDBMS has fragmentation transparency.
    2. True

    False

    Top Answer

    Solution: 37.True 38.b. Scalability 39.c. user view 40.c. primary key 41.True 42.c.not a part of the primary key 43.b.... View the full answer

    Sign up to view the full answer

    Why Join Course Hero?

    Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

    • -

      Study Documents

      Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

      Browse Documents
    • -

      Question & Answers

      Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

      Ask a Question