Intermediate SQL Multiple Choice Questions 1 PDF Download

Learn intermediate sql multiple choice questions (MCQs), database management system test 1 for online learning, course exam prep. Practice database authorization MCQs, intermediate sql questions and answers on database authorization test for online SQL outer join courses distance learning.

Free intermediate sql quiz online, self-study student guide has multiple choice question: in authorization graph, node representing database administrator, is known to be with choices child node, root node, leaf node and neighboring node for summative assessment, formative assessment of jobs' seekers and students with online jobs and courses' tests. Study to learn online database authorization quiz questions with database management system MCQs for IT certifications competitive exam prep.

MCQ on Intermediate SQL Test 1 Quiz PDF 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

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