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

PDoees PL/SQL stands for Procedural Language extension of SQL

  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
  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
  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

What does DML stand for?

  1. Data Mode Lane

  2. Data Manipulation language

  3. Data Model Language

  4. Different Mode Level


Correct Option: B

Which of the following is not a SQL keyword or SQL clause?

  1. UPDATE

  2. SELECT

  3. INSERT

  4. INVERT


Correct Option: D

There are triggers for…

  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