Question - 1
How many types of literals are available in PL/SQL?
Answer- C
Question - 2
How many bytes does each character in the UTF8 encoding take up?
Answer- D
Question - 3
Which datatype is not allowed in the definition of PL/SQL record?
- A Collection
- A Scalar
- A composite
- Both B & C
Solutions
Answer- A
Question - 4
Which is not a PL/SQL unit.
- Type
- Table
- Trigger
- None of the above
Solutions
Answer- B
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
Answer- A
Question - 6
From the following PL/SQL Delimiters____________symbol is exponentiation operator.
Answer- C
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
Answer- A
Question - 8
- Portable Language/SQL
- Programming Language/SQL
- Procedural Language/SQL
- None of these
Solutions
Answer- C
Question - 9
What value will be assigned to the variable declared as below − counter binary_integer;
- 0
- 1
- NULL
- None of the above
Solutions
Answer- C
Question - 10
which of the following datatypes supports PS/SQL ?
- Scalar datatype
- Composite datatype
- Linear datatype
- Both A & B
Solutions
Answer- D
Question - 11
Which operations cannot be performed on cursor expressions?
- BIND
- EXECUTE
- Both A & B
- None of these
Solutions
Answer- C
Question - 12
what is the purpose of triggers ?
- Enforcing referential integrity
- Synchronous replication of tables
- Preventing invalid transactions
- All the above
Solutions
Answer- D
Question - 13
___command is used to encrypt a PL/SQL application.
- WRAP
- WAMPP
- XAMP
- None of the above
Solutions
Answer- A
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
Answer- A
Question - 15
he constructs of a procedure, function or a package are ________ .
- Variables and Constants
- Cursors
- Exceptions
- All the above
Solutions
Answer- D
Question - 16
Which keyword and parameter used for declaring an explicit cursor?
- constraint
- cursor_variable_declaration
- collection_declaration
- cursor_declaration
Solutions
Answer- D
Question - 17
Which of the following declares an instance of an object type?
- record_declaration
- object_declaration
- procedure_declaration
- None of the above
Solutions
Answer- B
Question - 18
Which Exception is also known as Oracle named exception handler?
- Predefined Exception
- Internal Exception
- User defined Exception
- None of the above
Solutions
Answer- A
Question - 19
Select invalid variable types
- VARCHAR1
- VARCHAR2
- CHAR
- INTEGER
Solutions
Answer- B
Question - 20
Which of the following is used to declare a record?
- %ROWTYPE
- %TYPE
- Both A & B
- None of the above
Solutions
Answer- A
Practice more set questions