0

databases Online Quiz - 146

Description: databases Online Quiz - 146
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0

If you use the CREATE DATABASE statement on an existing database, all data in the datafiles will be lost.

  1. True

  2. False


Correct Option: A
  1. SELECT row_name INTO variable_name FROM table_name [WHERE condition];

  2. SELECT column_name INTO variable_name FROM table_name [WHERE condition];

  3. SELECT column_name INTO variable_name FROM table_name [WHEN condition];

  4. SELECT table_name INTO variable_name FROM table_name [WHERE condition];


Correct Option: B
  1. table_name record_type_name;

  2. column_name record_type_name;

  3. record_type_name record_name;

  4. record_name record_type_name;


Correct Option: D

There are ______ types of loops in PL/SQL

  1. 1

  2. 3

  3. 2

  4. 4


Correct Option: B
  1. EXECUTE [or EXEC] database.function_name;

  2. employee_name := employer_details_func;

  3. SELECT employer_details_func FROM dual;

  4. dbms_output.put_line(employer_details_func);


Correct Option: A

SQL%ISOPEN attribute always returns null in implicit Cursors.

  1. True

  2. False


Correct Option: B

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

  1. True

  2. False


Correct Option: B

Which SQL keyword is used to retrieve a minimum value?

  1. MIN

  2. LOW

  3. DOWN

  4. LOWER


Correct Option: A
  1. Records

  2. Fields

  3. Attributes

  4. Cardinality


Correct Option: A
  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.


Correct Option: A
  1. Data Mode Lane

  2. Data Manipulation language

  3. Data Model Language

  4. Different Mode Level


Correct Option: B
  1. insert and delete only

  2. update and delete only

  3. update, delete and insert

  4. insert and update only


Correct Option: C
- Hide questions