logo

CuriousTab

CuriousTab

Discussion

Home ‣ Database ‣ SQL for Database Construction Comments
  • Question

  • A benefit of using a stored procedure is that it can be distributed to client computers.


  • Options
  • A. True
  • B. False

  • Correct Answer
  • False 

    • SQL for Database Construction problems

    Search Results

    • 1. SQL has a JOIN ON syntax that can be used to create inner joins and outer joins.

    • Options
    • A. True
    • B. False
      • Discuss
    • 2. A SQL view is a virtual table that is constructed from other tables or views.

    • Options
    • A. True
    • B. False
      • Discuss
    • 3. The SQL MAKE TABLE command is used to construct tables, define columns, define column constraints and create relationships.

    • Options
    • A. True
    • B. False
      • Discuss
    • 4. When a foreign key column is created without a corresponding foreign key constraint, we have created a "casual relationship" between the two tables.

    • Options
    • A. True
    • B. False
      • Discuss
    • 5. Standard SQL-92 views are constructed from SQL SELECT statements that do not contain the GROUP BY clause.

    • Options
    • A. True
    • B. False
      • Discuss
    • 6. Two transactions that run concurrently and generate results that are consistent with the results that would have occurred if they had run separately are referred to as serializable transactions.

    • Options
    • A. True
    • B. False
      • Discuss
    • 7. A point of synchronization between the database and the transaction log is generally referred to as a stop point.

    • Options
    • A. True
    • B. False
      • Discuss
    • 8. A phantom read occurs when a transaction rereads data it has previously read and finds modifications or deletions caused by a committed transaction.

    • Options
    • A. True
    • B. False
      • Discuss
    • 9. A transaction is a series of actions to be taken on the database so that either all of them are performed successfully or none of them are performed at all.

    • Options
    • A. True
    • B. False
      • Discuss
    • 10. The overall responsibility of the DBA is to facilitate the development and use of the database.

    • 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.