0

databases Online Quiz - 10

Description: databases Online Quiz - 10
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  1. It is a DML command

  2. It is a DDL command

  3. Provides the ability to conditionally update or insert data into a database table

  4. Provides the ability to MERGE VIEWS and INDICES of a TABLE


Correct Option: A,C
  1. EQUI-JOIN

  2. NONEQUI-JOIN

  3. SELF-JOIN

  4. OUTER-JOIN

  5. MERGE-JOIN

  6. TRANSACTION-JOIN


Correct Option: A,B,C,D
  1. SELECT

  2. WHERE

  3. GROUP BY

  4. FROM

  5. ORDER BY

  6. HAVING


Correct Option: A,D
  1. ORACLE BASICS

  2. Oracle Basics

  3. oracle basics

  4. oracleBasics


Correct Option: B

Identify the correct output --- select CONCAT('ORACLE' || 'BASICS') from dual;

  1. ORACLE BASICS

  2. ORACLEBASICS

  3. oraclebasics

  4. oracleBasics


Correct Option: B

Which functions mentioned below are GROUP functions? Choose all that apply

  1. ADD_MONTHS

  2. COUNT

  3. ROUND

  4. DISTINCT

  5. AVG

  6. SUM


Correct Option: B,E,F
  1. WHERE clause

  2. GROUP BY clause

  3. GROUP functions

  4. DISTINCT keyword

  5. FROM clause


Correct Option: B,C,D

%ROWTYPE attribute is used to declare a variable and associate it's data type with the TABLE/CURSOR object.

  1. True

  2. False


Correct Option: A

Within a PL/SQL block, which commands are allowed? Choose all that apply

  1. SELECT

  2. CREATE

  3. DELETE

  4. DROP

  5. UPDATE

  6. INSERT


Correct Option: A,C,E,F

IF-THEN-ELSE-ENDIF construct is used for conditional control in a PL/SQL block. What happens if the condition in IF-THEN-ELSE-ENDIF block evaluates to NULL?

  1. The SQL statements in the IF condition are processed.

  2. The SQL statements in the ELSE condition are processed.

  3. IF-THEN-ELSE-ENDIF construct is skipped.

  4. The SQL statements in the IF condition as well as ELSE condition are processed.


Correct Option: C
  1. Cursors

  2. Cursor For Loop

  3. Simple Loop

  4. Exit Loop

  5. Numeric For Loop

  6. While Loop


Correct Option: B,C,E,F
- Hide questions