Intermediate SQL Multiple Choice Questions 1 PDF Download

Learn intermediate sql multiple choice questions (MCQs), db test 1 for online course prep exams. Practice database authorization MCQs questions and answers on database authorization for online computer technology degree exam prep.

Free intermediate sql quiz online, study guide has multiple choice question on in authorization graph, node representing database administrator, is known to be with options child node, root node, leaf node and neighboring node to test online e-learning skills for viva exam prep and job's interview questions with answers key. Study to learn database authorization quiz questions with online learning MCQs for competitive exam preparation test.

MCQ on Intermediate SQL Quiz PDF Download Test 1

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

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

A

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

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

A

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

A

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

A

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

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

A