logo

CuriousTab

CuriousTab

Discussion


Home Database Data and Database Administration See What Others Are Saying!
  • Question
  • Concurrency control is important for which of the following reasons?


  • Options
  • A. To ensure data integrity when updates occur to the database in a multiuser environment
  • B. To ensure data integrity when updates occur to the database in a single-user environment
  • C. To ensure data integrity while reading data occurs to the database in a multiuser environment
  • D. To ensure data integrity while reading data occurs to the database in a single-user environment

  • Correct Answer
  • To ensure data integrity when updates occur to the database in a multiuser environment 


  • More questions

    • 1. The functional dependency R ? S means that the value of S can be determined when we are given a value of R.

    • Options
    • A. True
    • B. False
    • Discuss
    • 2. A distributed database is which of the following?

    • Options
    • A. A single logical database that is spread to multiple locations and is interconnected by a network
    • B. A loose collection of file that is spread to multiple locations and is interconnected by a network
    • C. A single logical database that is limited to one location.
    • D. A loose collection of file that is limited to one location.
    • Discuss
    • 3. Which of the following is NOT an Oracle-supported trigger?

    • Options
    • A. BEFORE
    • B. DURING
    • C. AFTER
    • D. INSTEAD OF
    • Discuss
    • 4. A distributed database has which of the following advantages over a centralized database?

    • Options
    • A. Software cost
    • B. Software complexity
    • C. Slow Response
    • D. Modular growth
    • Discuss
    • 5. ________ is considered to be one of the foundations of data access in the Microsoft world.

    • Options
    • A. ODBC
    • B. OLE DB
    • C. JPCD
    • D. ADO
    • Discuss
    • 6. An ERD that has had the entities clustered will display more entities.

    • Options
    • A. True
    • B. False
    • Discuss
    • 7. A differential backup makes a copy of the entire database.

    • Options
    • A. True
    • B. False
    • Discuss
    • 8. Which is not true about surrogate keys?

    • Options
    • A. They are short.
    • B. They are fixed.
    • C. They have meaning to the user.
    • D. They are numeric.
    • Discuss
    • 9. OLAP uses measures, dimensions and associations.

    • Options
    • A. True
    • B. False
    • Discuss
    • 10. We use the SQL construct COUNT(*) to count the number of rows in a table.

    • Options
    • A. True
    • B. False
    • Discuss


    Comments

    There are no comments.

Enter a new Comment