logo

CuriousTab

CuriousTab

Discussion

Home ‣ Database ‣ SQL Server 2000 See What Others Are Saying!
  • Question

  • By default, SQL Server will create one data file and one log file for each newly created database.


  • Options
  • A. True
  • B. False

  • Correct Answer
  • True 

    • More questions

    • 1. In a semijoin, only the joining attribute is sent from one site to another, and then only the required rows are returned.

    • Options
    • A. True
    • B. False
      • Discuss
    • 2. Even though Java is machine-independent, JSPs are not.

    • Options
    • A. True
    • B. False
      • Discuss
    • 3. The DTD begins with the word:

    • Options
    • A. #PCDATA.
    • B. XML.
    • C. DOCTYPE.
    • D. HTTPS.
      • Discuss
    • 4. If there are two entities with a relationship between them, and one of the entities is completely dependent on the other, then which of the following must exist?

    • Options
    • A. Derived attribute
    • B. Optional one cardinality
    • C. Multi-valued attribute
    • D. Weak entity
      • Discuss
    • 5. In a database, data is stored in spreadsheets which have rows and columns.

    • Options
    • A. True
    • B. False
      • Discuss
    • 6. ________ is a simple object model that is easier to understand and use than OLE DB, and is frequently used for database applications.

    • Options
    • A. ASP
    • B. XML
    • C. ODBC
    • D. ADO
      • Discuss
    • 7. A BI reporting system does not ________ .

    • Options
    • A. create meaningful information
    • B. deliver information to users on a timely basis
    • C. use statistical procedures to predict future events
    • D. use disparate data sources
      • Discuss
    • 8. When the parent entity is required, a new child row can always be inserted.

    • Options
    • A. True
    • B. False
      • Discuss
    • 9. Which of the following is true for a relational database?

    • Options
    • A. Data is represented by tables.
    • B. It is difficult to access data.
    • C. Complex programs have to be written for simple queries.
    • D. All of the above.
      • Discuss
    • 10. The expression FOR XML RAW tells SQL Server to:

    • Options
    • A. place the values of the columns as attributes in the resulting XML document.
    • B. place the values of the columns into elements rather than attributes.
    • C. place some columns into elements and others into attributes.
    • D. None of the above is correct.
      • Discuss

    Comments

    There are no comments.
Enter a new Comment




Aptitude

Engineering

Programming

Reasoning

Links

Copyright ©CuriousTab. All rights reserved.