Tag: databases

Questions Related to databases

Implicit Cursors are created by users in PL/SQL block.
technology databases

  1. True

  2. False

Show answer
Correct Option: B

Oracle engine creates Cursors for every SELECT statements.
technology databases

  1. True

  2. False

Show answer
Correct Option: B

There are 4 attributes of Cursor variables
technology databases

  1. True

  2. False

Show answer
Correct Option: B

Explicit Cursors need to be opened in DECLARE section.
technology databases

  1. True

  2. False

Show answer
Correct Option: A

Which SQL keyword is used to retrieve a minimum value?
technology databases

  1. MIN

  2. LOW

  3. DOWN

  4. LOWER

Show answer
Correct Option: A

The table rows are also known as...
technology databases

  1. Records

  2. Fields

  3. Attributes

  4. Cardinality

Show answer
Correct Option: A

What is the ABS SQL function used for?
technology databases

  1. To return the absolute, positive value of a numeric expression.

  2. To return the average value of a numeric expression.

  3. To return the maximum value of a numeric expression.

  4. To return the minimum value of a numeric expression.

Show answer
Correct Option: A

Which SQL keyword is used to retrieve only unique values?
technology databases

  1. DISTINCTIVE

  2. UNIQUE

  3. DISTINCT

  4. DIFFERENT

Show answer
Correct Option: C

What does DML stand for?
technology databases

  1. Data Mode Lane

  2. Data Manipulation language

  3. Data Model Language

  4. Different Mode Level

Show answer
Correct Option: B

Which of the following commands is used to delete data from a SQL database table?
technology databases

  1. DELETE

  2. UNION

  3. SELECT

  4. INSERT

Show answer
Correct Option: A