intermediate sql

MCQsQuestion.com has 7 Question/Answers about Topic intermediate sql

Creator of an object (relation/view/role) holds all privileges on the

Creator of an object (relation/view/role) holds all privileges on the
  • A. Object
  • B. Schema
  • C. View
  • D. Model
  • Correct Answer: Option A

SQL authorization mechanism grants privileges on

SQL authorization mechanism grants privileges on
  • A. Entire relation
  • B. Specified attributes
  • C. Both A and B
  • D. Specified tuples
  • Correct Answer: Option C

System returns an error if there are any cascading revocations, and does not carry out the

System returns an error if there are any cascading revocations, and does not carry out the
  • A. Restrict action
  • B. Assign action
  • C. Revoke action
  • D. Cascade action
  • Correct Answer: Option C

Keyword that can be used instead of restrict to indicate that revocation should cascade, is

Keyword that can be used instead of restrict to indicate that revocation should cascade, is
  • A. Revoke
  • B. Cascade
  • C. Assign
  • D. Arrange
  • Correct Answer: Option B

In most database systems, cascading revocation is the

In most database systems, cascading revocation is the
  • A. Non acceptable behavior
  • B. Acceptable behavior
  • C. By default behavior
  • D. Not encouraged behavior
  • Correct Answer: Option C

Any authorization that can be granted to a user can be granted to a

Any authorization that can be granted to a user can be granted to a
  • A. Schema
  • B. Entity
  • C. Role
  • D. Tuple
  • Correct Answer: Option C

A sequence of queries and updates that together carry out a task, is known as

A sequence of queries and updates that together carry out a task, is known as
  • A. Gratification
  • B. Authorizing
  • C. Transaction
  • D. Domain
  • Correct Answer: Option C