Aggregate Functions Quiz Questions and Answers 75 PDF Download

Learn aggregate functions quiz online, database management system test 75 for online learning, distance learning courses. Free introduction to sql quiz, aggregate functions multiple choice questions and answers to learn database management system quiz with answers. Practice tests for educational assessment on aggregate functions test with answers, database users and administrators, transformation of relational expressions, lock based protocols, indexing in dbms, aggregate functions practice test for online applications of DBMS courses distance learning.

Free online aggregate functions course worksheet has multiple choice quiz question: aggregate functions are functions that take a set or multiset of values as input and return with options Single value, Multiple sets , Multiple attributes and a relation for online competitive exams, certifications tests for financial aids, scholarships contests in universities, study introduction to sql multiple choice questions based quiz question and answers.

Quiz on Aggregate Functions Worksheet 75 Quiz PDF Download

Aggregate Functions Quiz

MCQ: Aggregate functions are functions that take a set or multiset of values as input and return

  1. Single value
  2. Multiple sets
  3. Multiple attributes
  4. A relation

A

Indexing in DBMS Quiz

MCQ: Indexing technique should perform types of access that are supported

  1. Efficiently
  2. Minimum
  3. Maximum
  4. Specifically

A

Lock Based Protocols Quiz

MCQ: A two-phase locking protocol variant that requires that all locks be held until transaction commit is called

  1. Lock-point two-phase locking protocol
  2. Deadlock two-phase locking protocol
  3. Strict two-phase locking protocol
  4. Rigorous two-phase locking protocol

D

Transformation of Relational Expressions Quiz

MCQ: Operations of Natural-join are

  1. Commutative
  2. Associative
  3. Distributive
  4. Conjunctive

B

Database Users and Administrators Quiz

MCQ: Ensuring enough free disk space availability for normal operations, are goals to be achieved by

  1. Database Manager
  2. Database system
  3. Database administrator
  4. Database users

C