Which component in the three-tier database architecture handles the data-processing and business logic?
Which component in the three-tier database architecture handles the data-processing and business logic?
Which type of entity must reference another entity for its data to be meaningful?
Which type of entity must reference another entity for its data to be meaningful?
Which statement accurately describes a characteristic of attributes?
Which statement accurately describes a characteristic of attributes?
Which database security technique prevents invalid data from being entered into the database?
Which database security technique prevents invalid data from being entered into the database?
what are the minimal privileges that a user must have for the relations used to make the view?
To create a view, what are the minimal privileges that a user must have for the relations used to make the view?
Which of the following ACID properties requires that a transaction be executed in its entirety or not all?
Which of the following ACID properties requires that a transaction be executed in its entirety or not all?
Which security technique limits access by unauthorized users to parts of an enterprise database?
Which security technique limits access by unauthorized users to parts of an enterprise database?
A foreign key maps to a:
A foreign key maps to a:
Which characteristic is an advantage of a database management system?
Which characteristic is an advantage of a database management system?
What are the referential constraints for the relations defined in these relation definitions?
Consider the following relation definitions:
STUDENT(
Student_Number: integer NOT NULL
Name: variable length character string length 20 )
Primary Key Student_Number
HOUSING(
Housing_ID: integer NOT NULL
Student_Number: integer NOT NULL
Building: variable length character string length 25 ) Primary Key Housing_ID
Foreign Key Student_Number References STUDENT(Student_Number) ON DELETE NO ACTION
ON UPDATE CASCADE
What are the referential constraints for the relations defined in these relation definitions?