Security and Authorization MCQs Quiz Online PDF Download

Learn security and authorization MCQs, database management system test for learning online courses and test prep to practice. Intermediate sql quiz has multiple choice questions (MCQ), security and authorization quiz questions and answers, security and authorization tutorials for online purpose of DBMS courses distance learning.

Database management system practice test MCQ: authorization on a relation allows a user to update any tuple in relation, is known to be with choices select authorization, grant authorization, define authorization and update authorization problem solving skills for summative and formative assessment, competitive exam prep, interview questions with answer key. Free study guide is for online learning security and authorization quiz with MCQs to practice test questions with answers.

MCQs on Security and Authorization Quiz PDF Download

MCQ. Authorization on a relation allows a user to update any tuple in relation, is known to be

  1. select authorization
  2. grant authorization
  3. define authorization
  4. update authorization

D

MCQ. SQL authorization mechanism grants privileges on

  1. Entire relation
  2. Specified attributes
  3. Both A and B
  4. Specified tuples

C

MCQ. Privileges that are granted implicitly to all current and future users, are called as

  1. Private
  2. Natural
  3. Unnatural
  4. Public

D

MCQ. To revoke an authorization, we use statement

  1. Revoke
  2. Modify
  3. Alter
  4. Define

A

MCQ. SQL authorization mechanism doesn't grants privileges on

  1. Specified attributes
  2. Specified tuples
  3. Entire relation
  4. None of the above

B