Tag: databases

Questions Related to databases

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 use Group functions in the WHERE clause
technology databases

  1. True

  2. False

Show answer
Correct Option: B

We can use MIN and MAX for any

technology databases

  1. Numeric data

  2. Data type

  3. Char data

  4. None of the Above

Show answer
Correct Option: A

We can nest Group Functions
technology databases

  1. True

  2. False

Show answer
Correct Option: B

Delete from Employee where grade = ‘Y’” deletes
technology databases

  1. All rows of the Employee table

  2. Rows of the Employee table where the set grade is ‘Y’

  3. Delete 1 row

  4. Nothing will be deleted

Show answer
Correct Option: B