logo

CuriousTab

CuriousTab

Discussion


Home Computer Science Database Systems Comments

  • Question
  • In SQL, which command is used to make permanent changes made by statements issue since the beginning of a transaction?


  • Options
  • A. ZIP
  • B. PACK
  • C. COMMIT
  • D. SAVE
  • E. None of the above

  • Correct Answer
  • COMMIT 


  • Database Systems problems


    Search Results


    • 1. In SQL, which command is used to add new rows to a table?

    • Options
    • A. ALTER TABLE
    • B. ADD ROW
    • C. INSERT
    • D. APPEND
    • E. None of the above
    • Discuss
    • 2. In a _____ a parent record type can be linked to one or more "child" record types, but a child record type can have only one parent.

    • Options
    • A. Network database
    • B. Relational database
    • C. Distributed database
    • D. Hierarchical database
    • E. None of the above
    • Discuss
    • 3. Sort/report generators

    • Options
    • A. are faster than index/report generators
    • B. require more disk space than index/report generators
    • C. do not need to sort before generating a report
    • D. both (a) and (b)
    • E. None of the above
    • Discuss
    • 4. Primitive operations common to all record management systems include

    • Options
    • A. Print
    • B. Sort
    • C. Look-up
    • D. All of the above
    • E. None of the above
    • Discuss
    • 5. After you _____ a record, many data management the environments require you to issue a command to save the changes you made.

    • Options
    • A. Delete
    • B. Update
    • C. Sort key
    • D. Index
    • E. None of the above
    • Discuss
    • 6. The highest level in the hierarchy of data organization is called

    • Options
    • A. data bank
    • B. database
    • C. data file
    • D. data record
    • E. None of the above
    • Discuss
    • 7. A network schema

    • Options
    • A. restricts the structure to a one-to-many relationship
    • B. permits many-to-many relationŽships
    • C. stores data in tables
    • D. All of the above
    • E. None of the above
    • Discuss
    • 8. If you want to group the records in the abc database, you could use the Jobcode as the _____.

    • Options
    • A. Delete
    • B. Update
    • C. Sort Key
    • D. Index
    • E. None of the above
    • Discuss
    • 9. In SQL, which command(s) is(are) used to enable/disable all triggers on a table?

    • Options
    • A. ALTER TRIGGERS
    • B. ALTER TABLE
    • C. MODIFY TRIGGERS IN TABLE
    • D. All of the above
    • E. None of the above
    • Discuss
    • 10. What is the name given to the database management system which is able to handle full text data, image data, audio and video?

    • Options
    • A. Full media
    • B. Graphics media
    • C. Multimedia
    • D. Hypertext
    • E. None of the above
    • Discuss


    Comments

    There are no comments.

Enter a new Comment