gs gs116 Laying the Foundation - Aggregation of Data - Quiz No.1
gs gs116 Microsoft SQL Server Quiz
This quiz belongs to book/course code gs gs116 Microsoft SQL Server of gs organization. We have 100 quizzes available related to the book/course Microsoft SQL Server. This quiz has a total of 10 multiple choice questions (MCQs) to prepare and belongs to topic Laying the Foundation. NVAEducation wants its users to help them learn in an easy way. For that purpose, you are free to prepare online MCQs and quizzes.
NVAEducation also facilitates users to contribute in online competitions with other students to make a challenging situation to learn in a creative way. You can create one to one, and group competition on an topic of a book/course code. Also on NVAEducation you can get certifications by passing the online quiz test.
Question 1: Aggregate functions are functions that take a ___________ as input and return a single value.
Collection of values
Single value
Double value
All of the mentioned
Question 4: Which of the following is not an aggregate function?
Avg
Sum
With
Min
Question 5: If we do want to eliminate duplicates, we use the keyword __________in the aggregate expression.
Distinct
Count
Avg
Primary key
Question 6: All aggregate functions except __________ ignore null values in their input collection.
Count(attribute)
Count(*)
Avg
Sum
Question 8: Which of the following should be used to find all the courses taught in the Fall 2009 semester but not in the Spring 2010 semester?
Select distinct course id from section where semester = ’Fall’ and year= 2009 and course id not in (select course id from section where semester = ’Spring’ and year= 2010); Select distinct course_id from instructor where name not in (’Fall’, ’Spring’);Select course id from section where semester = 'Spring' and year= 2010); Select count (distinct ID) from takes where (course id, sec id, semester, year) in (select course id, sec id, semester, year from teaches where teaches.ID= 10101);
Question 9: The phrase “greater than at least one” is represented in SQL by ___________
< all
< some
> all
> some
Question 10: We can test for the nonexistence of tuples in a subquery by using the __________ construct.
Not exist
Not exists
Exists
Exist
Online Quizzes of gs116 Microsoft SQL Server
Developing with SQL Server - Error Handling - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
Laying the Foundation - Aggregation of Data - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
Laying the Foundation - Joins in SQL Server - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
Laying the Foundation - Views in SQL Server - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
