Tag: databases

Questions Related to databases

In an Oracle Database, Locks are critical

technology databases

  1. True

  2. False

Show answer
Correct Option: B

Which is not a group function?
technology databases

  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 databases

  1. True

  2. False

Show answer
Correct Option: B

COUNT(DISTINCT expr) returns
technology databases

  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

Which function forces group functions to include null values?
technology databases

  1. Group By

  2. NVL

  3. Order By

  4. Having

Show answer
Correct Option: B

All columns in the SELECT list, that are not there in the GROUP function, should be in the Group By clause

technology databases

  1. True

  2. False

Show answer
Correct Option: B

Which is the clause used to restrict groups?
technology databases

  1. HAVING

  2. WHERE

  3. Order By

  4. Group by

Show answer
Correct Option: A

We can nest Group Functions
technology databases

  1. True

  2. False

Show answer
Correct Option: B

Limiting the rows in a select statement for a specific condition is done by the clause

technology databases

  1. Distinct

  2. Projection

  3. Where

  4. All of the above

Show answer
Correct Option: C

Character values are case insensitive
technology databases

  1. True

  2. False

Show answer
Correct Option: B