logo

CuriousTab

CuriousTab

Discussion

Home ‣ Database ‣ The Database Development Process See What Others Are Saying!
  • Question

  • Which of the following database activities require a specific knowledge of a DBMS?


  • Options
  • A. Enterprise modeling
  • B. Conceptual data modeling
  • C. Logical database design
  • D. Physical database design and definition

  • Correct Answer
  • Physical database design and definition 

    • More questions

    • 1. 1:1, 1:N and N:M relationships are also known as HAS-A relationships.

    • Options
    • A. True
    • B. False
      • Discuss
    • 2. A user data source is one that can be shared among database users.

    • Options
    • A. True
    • B. False
      • Discuss
    • 3. When a business rule involves three or more graphical symbols, you can show the constraint as a note and attach the note to each of the symbols by a dashed line.

    • Options
    • A. True
    • B. False
      • Discuss
    • 4. An exclusive lock locks the item from change but not from read.

    • Options
    • A. True
    • B. False
      • Discuss
    • 5. Which of the following refers to an entity in which the identifier of one entity includes the identifier of another entity?

    • Options
    • A. Weak entity
    • B. Strong entity
    • C. ID-dependent entity
    • D. ID-independent entity
      • Discuss
    • 6. Authorization tables contain highly sensitive data and should be protected by stringent security rules.

    • Options
    • A. True
    • B. False
      • Discuss
    • 7. Poor data administration can lead to which of the following?

    • Options
    • A. A single definition of the same data entity
    • B. Familiarity with existing data
    • C. Missing data elements
    • D. All of the above.
      • Discuss
    • 8. Needing to using more complicated SQL in database applications is a(n) ________ of normalization.

    • Options
    • A. advantage
    • B. disadvantage
    • C. either an advantage or disadvantage
    • D. neither an advantage nor disadvantage
      • Discuss
    • 9. Which type of SQL Server cursor concurrency places an update lock on a row when the row is read?

    • Options
    • A. READ_ONLY
    • B. SCROLL_LOCK
    • C. OPTIMISTIC
    • D. READCOMMITTED
      • Discuss
    • 10. XML Schemas consist of:

    • Options
    • A. properties and methods.
    • B. elements and attributes.
    • C. structure and data.
    • D. tables and relationships.
      • Discuss

    Comments

    There are no comments.
Enter a new Comment




Aptitude

Engineering

Programming

Reasoning

Links

Copyright ©CuriousTab. All rights reserved.