logo

CuriousTab

CuriousTab

Discussion


Home Database The Client-Server Database See What Others Are Saying!
  • Question
  • Stored procedures have which of the following advantages?


  • Options
  • A. It takes a longer time to write them as compared to writing Visual Basic.
  • B. Network traffic increases
  • C. Data integrity improves as multiple applications access the same stored procedure.
  • D. Result in thicker client and thinner database server.

  • Correct Answer
  • Data integrity improves as multiple applications access the same stored procedure. 


  • More questions

    • 1. Successful data warehousing requires that a formal program in total quality management (TQM) be implemented.

    • Options
    • A. True
    • B. False
    • Discuss
    • 2. The HAVING clause acts like a WHERE clause, but it identifies groups that meet a criterion, rather than rows.

    • Options
    • A. True
    • B. False
    • Discuss
    • 3. The source of the data is sometimes called the system of record.

    • Options
    • A. True
    • B. False
    • Discuss
    • 4. All primary keys are required.

    • Options
    • A. True
    • B. False
    • Discuss
    • 5. Entities use identifiers while tables use keys.

    • Options
    • A. True
    • B. False
    • Discuss
    • 6. SOAP is now just a name, not an acronym.

    • Options
    • A. True
    • B. False
    • Discuss
    • 7. A function returns one value and has only output parameters.

    • Options
    • A. True
    • B. False
    • Discuss
    • 8. Multiple and binary relationships are the same thing.

    • Options
    • A. True
    • B. False
    • Discuss
    • 9. Output reports should be included as part of an ERD.

    • Options
    • A. True
    • B. False
    • Discuss
    • 10. It is not easy to build a database correctly the first time.

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


    Comments

    There are no comments.

Enter a new Comment