Intermediate SQL Multiple Choice Questions 1 PDF Download

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

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 the authorization graph, the node representing the database administrator, is known to be

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

A

MCQ. The 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 the grantor set to the current role associated with a session, we can add the 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. The creator of an object (relation/view/role) holds all privileges on the

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

A