Tag: programming languages

Questions Related to programming languages

It is possible to compare two structures using == operator.
technology programming languages

  1. True

  2. False

Show answer
Correct Option: B

It is possible to compare two structures using == operator.
technology programming languages

  1. True

  2. False

Show answer
Correct Option: B

Which is not a group function?
technology programming languages

  1. Count

  2. Avg

  3. Total

  4. Max

Show answer
Correct Option: C

You can use Avg or Sum group functions for any numeric data?
technology programming languages

  1. True

  2. False

Show answer
Correct Option: B

COUNT (DISTINCT expr) returns
technology programming languages

  1. No. of rows in a table

  2. No. of rows with non-null values of the expr

  3. No. of distinct non-null values of the expr

  4. . None of the above

Show answer
Correct Option: C

All columns in the SELECT list that are not there in the GROUP function, should be in the group by clause
technology programming languages

  1. True

  2. False

Show answer
Correct Option: B

We can use Group functions in the WHERE clause
technology programming languages

  1. True

  2. False

Show answer
Correct Option: B

We can nest Group Functions
technology programming languages

  1. True

  2. False

Show answer
Correct Option: B

When is a Cartesian product formed?
technology programming languages

  1. When a join condition is omitted.

  2. When a join condition is invalid.

  3. All rows in the first table are joined to all rows in the second table

  4. All of the above.

Show answer
Correct Option: D

In a join condition it is mandatory to specify the table name along with the column name
technology programming languages

  1. True

  2. False

Show answer
Correct Option: B