Machine-translated by Google. Questions are authored in English.
Top

Discussion

Which of the following is true concerning systems information in an RDBMS?

  • A.RDBMS store database definition information in system-created tables.
  • B.This information can be accessed using SQL.
  • C.This information often cannot be updated by a user.
  • D.All of the above.

Answer: D

Correct answer: All of the above.

The catalogue is itself held as tables, so it can be queried with ordinary SELECT statements - which is how a developer discovers what columns a table has. It is maintained by the system in response to DDL, so it is not directly updatable; altering it by hand would leave the database inconsistent with itself.

No comment is present. Be the first to comment.
Loading…

Post your comment

Please log in or register to post a comment.