Tag: programming languages

Questions Related to programming languages

  1. Anthony J. Barr

  2. James Goodnight

  3. John Sall

  4. Caroll G. Perkins


Correct Option: A
  1. Base SAS

  2. SAS Enterprise Business Intelligence Server

  3. SAS/ACCESS

  4. SAS Toolware Studio Administrator


Correct Option: D

SAS had been criticized for its poor graphics, In which version the graphics improved significantly.

  1. SAS 6

  2. SAS 7

  3. SAS 8

  4. SAS 9


Correct Option: B

Location of SAS's Worldwide Headquarters

  1. Cary,NC,USA

  2. Churchgate,Mumbai,India

  3. Ontario,Canada

  4. NYC,New York,USA


Correct Option: A
  1. OLAP Cube Studio

  2. SAS/CONNECT

  3. Enterprise Guide

  4. SAS Enterprise Business Intelligence Server


Correct Option: D
  1. Allows SAS to transparently share data with personal computer applications including MS Access and Microsoft Office Excel

  2. A plugin for Information Delivery Portal. It allows the user to create various graphics that represent a broad range of data. This allows a quick glance to provide a lot of information, without having to look at all the underlying data.

  3. Allows programmers to create and compile object-oriented programs.

  4. A client application that helps with building information maps.


Correct Option: C

Which of the following is not a group function?

  1. avg( )

  2. sqrt( )

  3. sum()

  4. max()


Correct Option: D

AI Explanation

To answer this question, we need to understand what group functions are in the context of databases.

Group functions, also known as aggregate functions, are functions that perform calculations on a set of values and return a single value. These functions are commonly used in SQL queries to summarize data. Some examples of group functions include AVG(), SUM(), and MAX().

Let's go through each option to determine which one is not a group function:

Option A) avg( ) - This option is a group function. The AVG() function calculates the average value of a set of values.

Option B) sqrt( ) - This option is not a group function. The SQRT() function calculates the square root of a single value, not a set of values. Therefore, this is the correct answer.

Option C) sum() - This option is a group function. The SUM() function calculates the sum of a set of values.

Option D) max() - This option is a group function. The MAX() function returns the maximum value from a set of values.

Therefore, the correct answer is B) sqrt( ) because it is not a group function.