Question

Which of the following is TRUE for the System Variable $date$?

(a) Can be assigned to a global variable

(b) Can be assigned to any field only during design time

(c) Can be assigned to any variable or field during run time

(d) Can be assigned to a local variable

This question was posed to me in examination.

Question is taken from A Simple Transaction Model topic in portion Transactions of Database Management

Answer 1

Correct choice is (b) Can be assigned to any field only during design time

The explanation is: A database schema of a database system is its structure described in a formal language supported by the database management system and refers to the organization of data as a blueprint of how a database is constructed.