Home › Quizzes › SQL Group Functions and Database Operations

SQL Group Functions and Database Operations

Test your knowledge of SQL group functions, DML statements, database transactions, and join operations in Oracle Database

20 Questions Published
Play Quiz Practise this topic out loud

Questions

Question 1 Multiple Choice (Single Answer)

When is a Cartesian product formed?

  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.
Question 2 True/False

A Non equi-join is a join condition that does not contain an equality operator.

  1. True
  2. False
Question 3 True/False

SYSDATE is a date function that returns the current database server date and time.

  1. True
  2. False
Question 4 Multiple Choice (Single Answer)

Which keyword used in DML statements prohibits you from changing rows that are not in the sub-query?

  1. CHECK keyword
  2. WITH CHECK keyword
  3. WITH CHECK OPTION keyword
  4. None of the Above
Question 5 Multiple Choice (Single Answer)

Explicit Defaults can be used in

  1. INSERT statement
  2. UPDATE statement
  3. Both of the Above
  4. None of the Above
Question 6 Multiple Choice (Single Answer)

MERGE statement

  1. Avoids separate updates
  2. ncreases performance and ease of use
  3. Is useful in data warehousing applications
  4. All of the above
Question 7 Multiple Choice (Single Answer)

Database transactions end with

  1. COMMIT or ROLLBACK
  2. A DDL or DCL statement executing
  3. USER exiting iSQL*Plus or System crash
  4. Any one of the above
Question 8 True/False

You can update more than 1 row in a table with one update syntax

  1. True
  2. False
Question 9 Multiple Choice (Single Answer)

Which is not a group function?

  1. Count
  2. Avg
  3. Total
  4. Max
Question 10 True/False

You can use Avg or Sum group functions for any numeric data

  1. True
  2. False
Question 11 Multiple Choice (Single Answer)

COUNT(DISTINCT expr) returns

  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
Question 12 Multiple Choice (Single Answer)

Which function forces group functions to include null values?

  1. Group By
  2. NVL
  3. Order By
  4. Having
Question 13 True/False

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

  1. True
  2. False
Question 14 Multiple Choice (Single Answer)

Which is the clause used to restrict groups?

  1. HAVING
  2. WHERE
  3. Order By
  4. Group by
Question 15 True/False

We can use Group functions in the WHERE clause

  1. True
  2. False
Question 16 Multiple Choice (Single Answer)

We can use MIN and MAX for any

  1. Numeric data
  2. Data type
  3. Char data
  4. None of the Above
Question 17 True/False

We can nest Group Functions

  1. True
  2. False
Question 18 Multiple Choice (Single Answer)

Delete from Employee where grade = ‘Y’” deletes

  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
Question 19 True/False

In an Oracle Database, Locks are critical

  1. True
  2. False
Question 20 True/False

Character values are case insensitive

  1. True
  2. False
← Back to Quizzes