logo

CuriousTab

CuriousTab

Discussion

Home ‣ Database ‣ Physical Database Design See What Others Are Saying!
  • Question

  • In general, larger block sizes are used for online transaction processing applications and smaller block sizes are used for databases with a decision support or data warehousing system.


  • Options
  • A. True
  • B. False

  • Correct Answer
  • False 

    • More questions

    • 1. Which of the following improves a query's processing time?

    • Options
    • A. Write complex queries.
    • B. Combine a table with itself.
    • C. Query one query within another.
    • D. Use compatible data types.
      • Discuss
    • 2. XML is which of the following?

    • Options
    • A. A scripting language that states the rules for tagging elements.
    • B. A programming language that states the rules for tagging elements.
    • C. A programming language that allows the creation of customized tags.
    • D. A scripting language that allows the creation of customized tags.
      • Discuss
    • 3. To define what columns should be displayed in an SQL SELECT statement:

    • Options
    • A. use FROM to name the source table(s) and list the columns to be shown after SELECT.
    • B. use USING to name the source table(s) and list the columns to be shown after SELECT.
    • C. use SELECT to name the source table(s) and list the columns to be shown after USING.
    • D. use USING to name the source table(s) and list the columns to be shown after WHERE.
      • Discuss
    • 4. Locking may cause which of the following problems?

    • Options
    • A. Erroneous updates
    • B. Deadlock
    • C. Versioning
    • D. All of the above.
      • Discuss
    • 5. It is usually not very important to design the physical database to minimize the time required by users to interact with the information systems.

    • Options
    • A. True
    • B. False
      • Discuss
    • 6. The UML notation is useful for graphically depicting an object-oriented analysis or design model.

    • Options
    • A. True
    • B. False
      • Discuss
    • 7. The driver manager processes ODBC requests and submits specific SQL statements to a given type of data source.

    • Options
    • A. True
    • B. False
      • Discuss
    • 8. Which of the following is true concerning the following statement: class Manager extends Employee

    • Options
    • A. Manager is a concrete class and a superclass.
    • B. Manager is a concrete class and a subclass.
    • C. Manager is an abstract class and a superclass.
    • D. Manager is an abstract class and a subclass.
      • Discuss
    • 9. Which of the following refers to the SQL Server transaction isolation level which places and holds locks on all rows that are read?

    • Options
    • A. REPEATABLE READ
    • B. SERIALIZABLE
    • C. READ COMMITTED
    • D. READ UNCOMMITTED
      • Discuss
    • 10. Data warehouse data are usually normalized.

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

    Comments

    There are no comments.
Enter a new Comment




Aptitude

Engineering

Programming

Reasoning

Links

Copyright ©CuriousTab. All rights reserved.