0

Oracle DBMS PL/SQL

Description: Online Test for Oracle,DBMS, PL/SQL, Structured Query Language, Trigger, Packages, Users, Permissions and other software Technology tests and Notes
Number of Questions: 25
Created by:
Tags: Oracle DBMS PL/SQL Structured Query language Triggers Packages Users Permissions Databases Programming OOPs
Attempted 0/25 Correct 0 Score 0

The total main features of object oriented programming are

  1. two

  2. three

  3. five

  4. four


Correct Option: B

The wrapping of data and functions into a single unit is known as

  1. polymorphism

  2. inheritance

  3. encapsulation

  4. none of above


Correct Option: C

_______ commands can be used in PL/SQL blocks.

  1. DML

  2. DDL

  3. DCL

  4. None of above


Correct Option: A

_______ is a pointer to an object and may be used within a SQL statement as an operator.

  1. DREF

  2. REF

  3. OREF

  4. None of above


Correct Option: B

PL/SQL supports all _____ statements.

  1. DML

  2. TCL

  3. SQL

  4. DCL


Correct Option: C

_______ engine executes only the procedural statement.

  1. PL/SQL

  2. SQL

  3. DBMS

  4. RDBMS


Correct Option: A

PL/SQL text can contain group of characters known as _______ units.

  1. variable

  2. numerical

  3. lexical

  4. binary


Correct Option: C

Variables and constants should be declared in the _______ part of PL/SQL block.

  1. declarative

  2. executable

  3. exception handling

  4. none of above


Correct Option: A

______ is available only with SQL statement.

  1. CEST

  2. CAST

  3. CUST

  4. None of above


Correct Option: B

The ability of an object to take more than one form is known as

  1. polymorphism

  2. inheritance

  3. encapsulation

  4. none of above


Correct Option: A

DBMS stands for

  1. Database Migrate System

  2. Database Management System

  3. Data Manipulating System

  4. Database Management Storage


Correct Option: B

_______ statement allows us to complete a loop if further processing is undesirable or impossible.

  1. IF

  2. IF THEN ELSE IF

  3. EXIT WHEN

  4. GO TO


Correct Option: C

The object oriented programming is a way to organize data and code within

  1. class

  2. object

  3. program

  4. method


Correct Option: C

_______ statement can be used when we want to select from several mutually exclusive alternatives.

  1. IF

  2. IF THEN ELSE IF

  3. EXIT WHEN

  4. GO TO


Correct Option: B

_______ statement allows us to branch to a label unconditionally.

  1. IF

  2. IF THEN ELSE IF

  3. EXIT WHEN

  4. GO TO


Correct Option: D

Loops can be broadly classified into _____ types.

  1. two

  2. three

  3. four

  4. five


Correct Option: B

Which of the following statements is used to execute sequence of statements multiple times?

  1. Condition

  2. Loop

  3. Label

  4. None of above


Correct Option: B

PL/SQL data types can be classified into _______ data types.

  1. five

  2. two

  3. three

  4. four


Correct Option: B

Object is a _______ software component.

  1. redefining

  2. redirecting

  3. reusable

  4. none of above


Correct Option: C

To check the source code of object types, use the _____ data dictionary view.

  1. user_types

  2. user_source

  3. user_data

  4. user_code


Correct Option: B
Explanation:

 To check the source code of object types, use the user_source data dictionary view.

______condition in PL/SQL is termed as an exception.

  1. If

  2. If then else if

  3. For

  4. Error


Correct Option: D

User-defined exceptions should be declared in the ________ part of the PL/SQL block.

  1. declarative

  2. executable

  3. exception handling

  4. none of above


Correct Option: A

________ allows designing of new objects that inherit the functionality of objects that are already created.

  1. Polymorphism

  2. Inheritance

  3. Encapsulation

  4. None of above


Correct Option: B

To see the various types created, use the ______ data dictionary view.

  1. user_types

  2. user_source

  3. user_data

  4. user_code


Correct Option: A

There are _____ types of exceptions in PL/SQL.

  1. two

  2. four

  3. three

  4. six


Correct Option: A
- Hide questions