logo

CuriousTab

CuriousTab

Discussion


Home Database Advanced SQL Comments

  • Question
  • A transaction is the complete set of closely related update commands that must all be done, or none of them done, for the database to remain valid.


  • Options
  • A. True
  • B. False

  • Correct Answer
  • True 


  • Advanced SQL problems


    Search Results


    • 1. There should be one condition within the WHERE clause for each pair of tables being joined.

    • Options
    • A. True
    • B. False
    • Discuss
    • 2. The joining technique is useful when data from several relations are to be retrieved and displayed and the relationships are not necessarily nested.

    • Options
    • A. True
    • B. False
    • Discuss
    • 3. The primary key in a relation does not need to be underlined.

    • Options
    • A. True
    • B. False
    • Discuss
    • 4. A foreign key may be null and still adhere to the referential integrity constraint.

    • Options
    • A. True
    • B. False
    • Discuss
    • 5. Well-structured relations encourage anomalies of data.

    • Options
    • A. True
    • B. False
    • Discuss
    • 6. A correlated subquery is where the outer query depends on data from the inner query.

    • Options
    • A. True
    • B. False
    • Discuss
    • 7. The code to create triggers and routines is stored in only one location and is administered centrally.

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

    • Options
    • A. True
    • B. False
    • Discuss
    • 9. When AUTOCOMMIT is set on, changes will be made automatically at the end of each SQL statement.

    • Options
    • A. True
    • B. False
    • Discuss
    • 10. With the UNION clause, each query involved must output the same number of columns, and they must be UNION compatible.

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


    Comments

    There are no comments.

Enter a new Comment