Intermediate SQL Multiple Choice Questions and Answers 1 PDF Book Download

Intermediate sql multiple choice questions (MCQs), intermediate sql test prep to learn dbms quiz 1 for CS degree free online courses. Learn database authorization multiple choice questions (MCQs), intermediate sql quiz questions and answers. Free e-learning tutorial on database authorization test prep for big data certification.

Practice intermediate sql career test with multiple choice question: current role associated with a session can be set by executing, for computer science majors with options define role, set role, select role, grant role for online information technology degree. Professional skills assessment test with learning online database authorization quiz questions with dbms MCQs for IT certifications competitive exam prep.

MCQ on Intermediate SQL Test 1Quiz Book Download

MCQ: In authorization graph, node representing database administrator, is known to be

  1. Root node
  2. Child node
  3. Leaf node
  4. Neighboring node


MCQ: Current role associated with a session can be set by executing

  1. set role
  2. define role
  3. select role
  4. grant role


MCQ: To grant a privilege with grantor set to current role associated with a session, we can add clause

  1. granted by current-roll
  2. define by current-role
  3. select by current-role
  4. set by current-role


MCQ: SQL includes a privilege that permits a user to declare foreign keys when creating relations, known as to be

  1. References privilege
  2. Update privilege
  3. Execute privilege
  4. Select privilege


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

  1. Object
  2. Schema
  3. View
  4. Model