Aptitude Reasoning English GK Computer Knowledge Programming Skill Banking Software Testing



Question - 1

How many types of literals are available in PL/SQL?

  • 3
  • 4
  • 5
  • 6
Solutions
Question - 2

How many bytes does each character in the UTF8 encoding take up?

  • 1
  • 2
  • 3
  • All the above
Solutions
Question - 3

Which datatype is not allowed in the definition of PL/SQL record?

  • A Collection
  • A Scalar
  • A composite
  • Both B & C
Solutions
Question - 4

Which is not a PL/SQL unit.

  • Type
  • Table
  • Trigger
  • None of the above
Solutions
Question - 5

Which collection types is also known as index-by tables, lets you look up elements using arbitrary numbers and strings for subscript values?

  • Associative arrays
  • Numerical Array
  • Nested tables
  • None of the above
Solutions
Question - 6

From the following PL/SQL Delimiters____________symbol is exponentiation operator.

  • ~=
  • <>
  • **
  • --
Solutions
Question - 7

Which of the following retains duplicate rows in the result of a query or in an aggregate expression?

  • ALL
  • DISTINCT
  • PRIOR
  • None of the above
Solutions
Question - 8

PL/SQL stands for

  • Portable Language/SQL
  • Programming Language/SQL
  • Procedural Language/SQL
  • None of these
Solutions
Question - 9

What value will be assigned to the variable declared as below − counter binary_integer;

  • 0
  • 1
  • NULL
  • None of the above
Solutions
Question - 10

which of the following datatypes supports PS/SQL ?

  • Scalar datatype
  • Composite datatype
  • Linear datatype
  • Both A & B
Solutions
Question - 11

Which operations cannot be performed on cursor expressions?

  • BIND
  • EXECUTE
  • Both A & B
  • None of these
Solutions
Question - 12

what is the purpose of triggers ?

  • Enforcing referential integrity
  • Synchronous replication of tables
  • Preventing invalid transactions
  • All the above
Solutions
Question - 13

___command is used to encrypt a PL/SQL application.

  • WRAP
  • WAMPP
  • XAMP
  • None of the above
Solutions
Question - 14

Which of the following is the correct syntax for creating an explicit cursor?

  • CURSOR cursor_name IS select_statement;
  • CREATE CURSOR cursor_name IS select_statement;
  • CREATE CURSOR cursor_name AS select_statement;
  • CURSOR cursor_name AS select_statement;
Solutions
Question - 15

he constructs of a procedure, function or a package are ________ .

  • Variables and Constants
  • Cursors
  • Exceptions
  • All the above
Solutions
Question - 16

Which keyword and parameter used for declaring an explicit cursor?

  • constraint
  • cursor_variable_declaration
  • collection_declaration
  • cursor_declaration
Solutions
Question - 17

Which of the following declares an instance of an object type?

  • record_declaration
  • object_declaration
  • procedure_declaration
  • None of the above
Solutions
Question - 18

Which Exception is also known as Oracle named exception handler?

  • Predefined Exception
  • Internal Exception
  • User defined Exception
  • None of the above
Solutions
Question - 19

Select invalid variable types

  • VARCHAR1
  • VARCHAR2
  • CHAR
  • INTEGER
Solutions
Question - 20

Which of the following is used to declare a record?

  • %ROWTYPE
  • %TYPE
  • Both A & B
  • None of the above
Solutions
Tags:
60+ Best PL/SQL Interview Questions, PL/SQL MCQ questions for placement,PL/SQL interview questions, Previously asked PL/SQL Questions, Frequently asked PL/SQL Questions,PL/SQL Questions for TCS, PL/SQL Interview Questions for Freshers, PL/SQL Interview Questions for Experience, Accenture PL/SQL Interview Questions, PL/SQL Objective Questions for Interview,


Practice More sets Questions