Materialized view is a temporary table that is stored in the database to represent a view, which is maintained as the base table(s) are updated. Advantages - may be faster than trying to perform view resolution. - may also be useful for integrity checking and query optimisation.
What will be an ideal response?
Discretionary – each user is given appropriate access rights (or privileges) on specific database
objects.
Mandatory – each database object is assigned a certain classification level (e.g. Top Secret,
Secret, Confidential, Unclassified) and each subject (e.g. user, application) is given a designated
clearance level (Top Secret > Secret > Confidential > Unclassified).
SQL security mechanism is based on discretionary access control.
You might also like to view...
You can define your own reductions for an IntStream by calling its ________ method. The first argument is a value that helps you begin the reduction operation and the second argument is an object that implements the IntBinaryOperator functional interface.
a. reduction. b. lessen c. trim d. reduce
A keyboard is an input device used to move the on-screen pointer to enable the user to select and manipulate objects.
Answer the following statement true (T) or false (F)
A storage area network includes only storage devices.
Answer the following statement true (T) or false (F)
Setting a bounds for a type parameter uses which keyword?
A- implements B- bounded C- extends D- Depends if you are setting the bounds as a class or an interface