All India Exams
Home AptitudeBankEngineeringEnglishGKInterviewOnline TestPlacement PapersReasoning
  • Home
  • Aptitude
  • Bank
  • Engineering
  • English
  • GK
  • Interview
  • Online Test
  • Placement Papers
  • Reasoning

Aggregate Functions DBMS Questions And Answers

Here you can find Aggregate Functions DBMS Questions and Answers.

Why Aggregate Functions DBMS Questions and Answers Required?

In this Aggregate Functions DBMS Questions and Answers section you can learn and practice Aggregate Functions DBMS Questions and Answers to improve your skills in order to face technical inerview conducted by organisations. By Practicing these interview questions, you can easily crack any Exams interview.

Where can I get Aggregate Functions DBMS Questions and Answers?

AllIndiaExams provides you lots Aggregate Functions DBMS Questions and Answers with proper explanation. Fully solved examples with detailed answer description. All students, freshers can download Aggregate Functions Questions and Answers as PDF files and eBooks.

How to solve these Aggregate Functions DBMS Questions and Answers?

You no need to worry, we have given lots of Aggregate Functions DBMS Questions and Answers and also we have provided lots of FAQ's to quickly answer the questions in the Competitive Exams interview.

Aggregate Functions DBMS Questions & Answers

1. Aggregate Functions DBMS are functions that take a ___________ as input and return a single value.

Aggregate Functions DBMS Questions & Answers

2. Select __________ from instructor where dept name= ’Comp. Sci.’;Which of the following should be used to find the mean of the salary ?

Aggregate Functions DBMS Questions & Answers

3. All Aggregate Functions DBMS except _____ ignore null values in their input collection.

Aggregate Functions DBMS Questions & Answers

4. A Boolean data type that can take values true, false, and________ .

Aggregate Functions DBMS Questions & Answers

5. Select count (____ ID) from teaches where semester = ’Spring’ and year = 2010; If we do want to eliminate duplicates, we use the keyword ______in the aggregate expression.

Aggregate Functions DBMS Questions & Answers

6. The ____ connective tests for set membership, where the set is a collection of values produced by a select clause. The ____ connective tests for the absence of set membership.

Aggregate Functions DBMS Questions & Answers

7. We can test for the nonexistence of tuples in a subquery by using the _____ construct.

Home EngineeringComputer Science & EngineeringDBMS Questions and AnswersAggregate Functions

Aggregate Functions - DBMS Questions and Answers

This is the DBMS questions and answers section on "Aggregate Functions" with explanation for various interview, competitive examination and entrance test. Solved examples with detailed answer description, explanation are given and it would be easy to understand.

Aggregate Functions DBMS Questions

Online Test Name Aggregate Functions
Exam Type Multiple Choice Questions
Category Computer Science Engineering Quiz
Number of Questions 07
1. Aggregate functions are functions that take a ___________ as input and return a single value.
  • A. Collection of values
  • B. Single value
  • C. Aggregate value
  • D. Both a & b
  • View Answer
  • Workspace
  • Report
  • Discuss

Answer & Explanation

Answer: Option A

Explanation:

Collection of values

Workspace

Report Error


2. Select __________ from instructor where dept name= 'Comp. Sci.';
Which of the following should be used to find the mean of the salary ?
  • A. Mean(salary)
  • B. Avg(salary)
  • C. Sum(salary)
  • D. Count(salary)
  • View Answer
  • Workspace
  • Report
  • Discuss

Answer & Explanation

Answer: Option B

Explanation:

Avg(salary)

Avg() is used to find the mean of the values.

Workspace

Report Error


3. All aggregate functions except _____ ignore null values in their input collection.
  • A. Count(attribute)
  • B. Count(*)
  • C. Avg
  • D. Sum
  • View Answer
  • Workspace
  • Report
  • Discuss

Answer & Explanation

Answer: Option B

Explanation:

Count(*)

* is used to select all values including null.

Workspace

Report Error


4. A Boolean data type that can take values true, false, and________ .
  • A. 1
  • B. 0
  • C. Null
  • D. Unknown
  • View Answer
  • Workspace
  • Report
  • Discuss

Answer & Explanation

Answer: Option D

Explanation:

Unknown

Unknown values do not take null value but it is not known.

Workspace

Report Error


5. Select count (____ ID)
from teaches
where semester = 'Spring' and year = 2010;
If we do want to eliminate duplicates, we use the keyword ______in the aggregate expression.
  • A. Distinct
  • B. Count
  • C. Avg
  • D. Primary key
  • View Answer
  • Workspace
  • Report
  • Discuss

Answer & Explanation

Answer: Option A

Explanation:

Distinct

Distinct keyword is used to select only unique items from the relation.

Workspace

Report Error


  • «
  • 1
  • 2
  • »

Related Topics:

  • DBMS Keys
  • Normal Forms
  • OLAP
  • Indexes
  • Transactions
  • Relational Algebra
  • RAID
  • Physical Storage Media
  • Views
  • Deadlocks

Mock Tests & Online Quizzes

  • Aptitude Online Test

  • Reasoning Online Test

  • GK Online Test

  • English Online Test

  • RRB Mock Test

  • RBI Mock Test

  • Free SBI Mock Test

  • IBPS Mock Test FREE

  • SSC Mock Test

  • CAT Exam Mock Test

  • GATE Mock Test

  • IT Courses Quiz

Questions and Answers

  • Aptitude Questions
  • Verbal Reasoning Questions
  • Non Verbal Reasoning
  • Logical Reasoning Questions
  • Data Sufficiency Questions
  • Data Interpretation
  • eLitmus Sample Papers
  • ECE Questions and Answers
  • EEE Questions and Answers
  • Verbal Ability Questions
  • GK Questions

Programming Quiz

  • C Programming
  • C++ Programming
  • PHP Programming
  • Java Programming
  • Python Programming
  • DataScience MCQ
  • Hadoop MCQ
  • Mongo DB MCQ
  • MySQL MCQ

Interview Questions

  • Java Interview Questions
  • .Net Interview Questions
  • Networking Interview Questions
  • C Language Interview Questions
  • C++ Interview Questions
  • Testing Interview Questions
  • Android Interview Questions
  • HR Interview Questions
  • Group Discussion Topics

Mock Tests

  • CAT Mock Test
  • SSC Mock Test
  • AMCAT Mock Online Test
  • LIC Mock Test
  • IBPS Mock Test
  • RRB Mock Test
  • RBI Mock Test
  • Free SBI Mock Test
© by AllIndiaExams.in. All Rights Reserved | Copyright | Terms of Use & Privacy Policy