Home › Quizzes › Oracle PL/SQL and Database Fundamentals

Oracle PL/SQL and Database Fundamentals

Test your knowledge of Oracle PL/SQL programming, including PL/SQL blocks, control structures, exception handling, data types, and Oracle data dictionary views.

19 Questions Published
Play Quiz Practise this topic out loud

Questions

Question 1 Multiple Choice (Single Answer)

_______ commands can be used in PL/SQL blocks.

  1. DML
  2. DDL
  3. DCL
  4. None of above
Question 2 Multiple Choice (Single Answer)

_______ 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
Question 3 Multiple Choice (Single Answer)

PL/SQL supports all _____ statements.

  1. DML
  2. TCL
  3. SQL
  4. DCL
Question 4 Multiple Choice (Single Answer)

_______ engine executes only the procedural statement.

  1. PL/SQL
  2. SQL
  3. DBMS
  4. RDBMS
Question 5 Multiple Choice (Single Answer)

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

  1. variable
  2. numerical
  3. lexical
  4. binary
Question 6 Multiple Choice (Single Answer)

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

  1. declarative
  2. executable
  3. exception handling
  4. none of above
Question 7 Multiple Choice (Single Answer)

______ is available only with SQL statement.

  1. CEST
  2. CAST
  3. CUST
  4. None of above
Question 8 Multiple Choice (Single Answer)

DBMS stands for

  1. Database Migrate System
  2. Database Management System
  3. Data Manipulating System
  4. Database Management Storage
Question 9 Multiple Choice (Single Answer)

_______ 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
Question 10 Multiple Choice (Single Answer)

_______ 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
Question 11 Multiple Choice (Single Answer)

_______ statement allows us to branch to a label unconditionally.

  1. IF
  2. IF THEN ELSE IF
  3. EXIT WHEN
  4. GO TO
Question 12 Multiple Choice (Single Answer)

Loops can be broadly classified into _____ types.

  1. two
  2. three
  3. four
  4. five
Question 13 Multiple Choice (Single Answer)

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

  1. Condition
  2. Loop
  3. Label
  4. None of above
Question 14 Multiple Choice (Single Answer)

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

  1. five
  2. two
  3. three
  4. four
Question 15 Multiple Choice (Single Answer)

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
Question 16 Multiple Choice (Single Answer)

______condition in PL/SQL is termed as an exception.

  1. If
  2. If then else if
  3. For
  4. Error
Question 17 Multiple Choice (Single Answer)

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
Question 18 Multiple Choice (Single Answer)

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

  1. user_types
  2. user_source
  3. user_data
  4. user_code
Question 19 Multiple Choice (Single Answer)

There are _____ types of exceptions in PL/SQL.

  1. two
  2. four
  3. three
  4. six
← Back to Quizzes