0

programming languages Online Quiz - 348

Description: programming languages Online Quiz - 348
Number of Questions: 20
Created by:
Tags: programming languages
Attempted 0/20 Correct 0 Score 0
  1. WHERE

  2. HAVING

  3. RESTRICT

  4. GROUP BY

  5. ORDER BY


Correct Option: B
Explanation:

To answer this question, the user needs to understand the purpose of each of the SQL clauses listed and how they are used in a query.

  • WHERE: This clause is used to filter rows of data based on a specified condition or set of conditions. It is used to limit which rows are selected from a table.

  • HAVING: This clause is used to filter the results of an aggregate function applied to a group of rows. It is used to limit which groups are displayed based on a specified condition or set of conditions.

  • RESTRICT: There is no such SQL clause as RESTRICT.

  • GROUP BY: This clause is used to group rows of data based on one or more columns. It is used in conjunction with aggregate functions to calculate results for each group of data.

  • ORDER BY: This clause is used to sort the results of a query by one or more columns in ascending or descending order.

Based on the above information, the correct answer to the question is:

The Answer is: B. HAVING.

The HAVING clause is used to filter the results of an aggregate function applied to a group of rows. It is used to limit which groups are displayed based on a specified condition or set of conditions. Therefore, it can be used to exclude group results that don't meet the specified condition(s).

  1. MAX

  2. MIN

  3. SUM

  4. COUNT

  5. TOTAL

  6. LARGEST


Correct Option: C
Explanation:

To calculate the total of all salaries in the accounting department, you need to use the SUM function.

Option A (MAX) returns the highest value in a set of values.

Option B (MIN) returns the lowest value in a set of values.

Option C (SUM) is the correct option. It returns the sum of all values in a set of values.

Option D (COUNT) returns the number of values in a set of values.

Option E (TOTAL) is not a valid function in SQL.

Option F (LARGEST) is not a valid function in SQL.

Therefore, the answer is: C. SUM.

  1. INSERT

  2. UPDATE

  3. SELECT

  4. DESCRIBE

  5. DELETE


Correct Option: D
  1. With OPTION STRICT ON keyword

  2. With OPTION EXPICIT Keyword

  3. With OPTION STRICT OFF keyword

  4. All the above


Correct Option: A
Explanation:

To enable Strict Type Checking in VB.NET, you need to use the "Option Strict On" keyword. This will enforce data type checking for all variables, parameters, and return types in your code.

Option Explicit, on the other hand, enforces explicit declaration of all variables in your code.

Option Strict Off disables strict type checking and allows automatic type conversions, making it easier to write code but potentially less safe.

Therefore, the correct answer is:

The Answer is: A. With OPTION STRICT ON keyword

  1. Add keyword to Method signature

  2. Add [WebMethod] on top of the Method Signature

  3. Add {WebMethod} on top of the Method Signature

  4. None of the Above


Correct Option: A
  1. Using Only Get..EndGet with in property definition

  2. Using Only Set..EndSet with in property definition

  3. Using both Get and Set

  4. None of these


Correct Option: A
- Hide questions