OC PLSQL SE AD2 Multiple choice questions

Hello friends if you are looking for OC PLSQL SE AD MCQ | OC PLSQL SE AD Multiple choice questions | OC PLSQL SE AD Objective type questions | OC PLSQL SE AD Question answers dumps | OC PLSQL SE AD Accenture dumps

Please use ‘FIND IN PAGE OPTION’ in google chrome to find any questions

1)You can overload subprograms if their formal parameters differ only in numeric data type.PL/SQL looks for matc
hing numeric parameters in which order?
A) 1.PLS_INTEGER 2.NUMBER 3.BINARY_FLOAT 4.BINARY_4.DOUBLE
B) 1.BINARY_DOUBLE 2.BINARY_FLOAT 3.PLS_INTEGER 4.NUMBER
C) 1.NUMBER 2.PLS_INTEGER 3.BINARY_FLOAT 4.BINARY_DOUBLE
D) THere is no such ordernin which it looks
ANS-A
2)PL?SQL Exception message consists of which of the following parts?A. Type of Exception B.Error Code C.Error
Message
A)Only A
B)Only B
C)Only A and C
D)A,B and C
ANS-D
3)How many IN arguments procedure DBMS_LOCK.SLEEP has?
A)0
B)1
C)2
D)It can have any number of arguments
ANS-B
4)What will be the output of the following code snippet?
DECLARE
Time TIMESTAMP(3);
BEGIN
Time:='15-SEP-2013 07:48:53.275';
DBMS_OUTPUT.PUT_LINE(TO_CHAR(Time));
End;
A)15-SEP-13 07.48.53.275 AM
B)15-SEP-2013 07.48.53.275 AM
C)15-SEP-.
13 07.48.53.275
D)15-SEP-13 07.48.53.275 PM
ANS-A
5)Which of the following is considered as the best practice whiledesigning trigger?
a)Use triggers to ensure that whenever a specific event occurs,any necessary actions are done(regardless of which us
er or application issues the triggering statement).
b)Do not create triggers that duplicate database features.
c)Do not create triggers that depend on the order in which a SQL statement processes rows(which can vary).
d)Use BEFORE row triggers to modify the row before writing the row data to risk.
e)Use AFTER row triggers to obtain the row ID and use it in operations.
f)Do not create recursive triggers.
g)Use DATABASE triggers judiciously.They fire every time any databases user initiates a triggering event.
A)a,b,c,d,e,f
B)a,b,c,d,e,f,g
C)a,c,d,e,f,g
D)c,d,e,f,g
E)a,b,c,d,f,g
ANS-B
6)Which of the following is false about parameterized cursors.
A)Parameters allow values to be passed to a cursor when it is opened and used within the query when it executes
B)These can be opened more than once in a block,by passing different sets of values each time
C)The datatype of the parameters are same as those for scalar variables,but are not given sizes and scales
D)The parameters are treated like PL/SQL,variables within the cursor's query expression
E)None of the above
ANS-

7)Oracle error after installing or upgrading to a new databses that occurs when attempting to connect before Orcale h
as been started.This error states "Oracle not available".
A)ORA-01034
B)ORA-01555
C)ORA-04031
D)ORA-12154
E)ORA-29516
ANS-A
8)Which of the functions are used in WHEN OTHERS exception handler
A)SQLCODE
B)SQLERRM
C)SQLERRNUM
D)ROWNUM
E)None of these
ANS-A and B
9)What is the output of the following code snippet?
DECLARE
SUBTYPE p_integer IS PLS_INTEGER RANGE-11..11;
y_axis p_integer;
PROCEDURE test(x_var IN p_integer)IS
BEGIN
DBMS_OUTPUT.PUT_LINE(x_var);
END test;
BEGIN
y_axis:=13;
test(12);
END
A)Program executes successfully and prints MORE THAN TEN CHARACTERs
B)ORA-06501: PL/SQL:numeric or value error
C)program fails as NULL can be assigned to VARCHAR2
D)Program fails as NULL v_letter cannot be recognised inside procedure
ANS-B
10)Which of these is not a predefined PL/SQL Character Data Types?
A)NCHAR
B)NRAW
C)RAW
D)NVARCHAR
ANS-B
11)YOu have two triggers on the table.When you drop the table:A.ALLtriggers on a dropped table will remain in the
system but would return an error when used. B.All triggers on a dropped
table have been dropped as well.C Dropping a Trigger totally depends on whether the Trigger is on the statement or
a row level.
A)Only A
B)Only B
C)Both A and c
D)Both B and C
ANS-option B(Only B)
12)User-defined functions can be used in:A.Check constraints B.Indexes C.Virtual colums
A)only B
B)only C
C)Both B and C
D)BOth A and C
ANS-option C(Both B and C)
13)Ram developed the following code:What will be the output of above code?DECLARE
l_variable SIMPLE_DOUBLE:

BEGIN
l_variable:=NULL;
dbms_output.put_line('Result is'||l_result);
END;
A)Program Executes Successful and displays Resukt is.....
B)Program fails as ther is a syntax error while assigning NULL
C)Program fails as there is no datatype like SIMPLE_DOUBLE
D)Program fails as SIMPLE_DOUBLE cannot hold NULL values
ANS-D
14)Which of following auditing types can be used as the simplest way to audit procedure Execution?A. Schema obje
ct auditing B.Priviledge auditing C.Statement auditing
A)Only A
B)Only B
C)Only C
D)Both B and C
ANS-Option C
15)To define independent block,you use which of the following Compiler directive pragma?
A)AUTONOMOUS_BLOCK
B)AUTONOMOUS_TRANSACTION
C)INDEPENDENT_BLOCK
D)AUTONOMOUS_STRING
ANS-B
16)Which system privilege enables someone to execute anyusers's function in database?A.Execute any procedure B
>Execute any function C.Execute any unit
A)only A
B)only B
C)both B and C
D)Both A and B
ANS-option D
17)You have been asked to look employee table using LOCK TABLR statement in a specified lock mode so that to
allow concurrent access to a table;they prevent other users
from locking the entire table for exclusive use.Which type of lock you will use here?
A)LOCK TABLE employee IN ALLOW SHARE MODE NOWAIT;
B)LOCK TABLE employee IN TABLE SHARE MODE NOWAIT;
C)LOCK TABLE employee IN ROW SHARE MODE NOWAIT;
D)There is not such lock
ANS-C
18)What are database triggers?Please select all the correct answers
A)Set of PLSQL package
B)Set of PLSQL function
C)Set of code fires automatically after DDL operations performed
D)Set of code fires automatically after DML operations performed
E)Set of code fires automaticalyy before DML operations performed
ANS-B,C,D,E
19)Native Dynamic SQL has been integrated into the PL/SQL language by adding one new statement ___________
_,which executes a specified SQL statement immediately by enhancing
the OPEN FOR statements
A)Open For
B)Execute Immediate
C)Execute Immediate and Open for
D)None of the above
E)All of the above
ANS-B
20)Which of the following is true about bind variables
A)Bind variables are also called non-PL/SQL variables

B)Bind variables are also calles PL/SQL variables
C)These variables are declared in the host environment such as SQL Plus
D)They can be referenced in PL/SQL statements,by prefixing the colon(:)before the variable name
E)They can be referenced in PL/SQL statements,by suffixing the colon(:)after the variable name
ANS-A,C,D
21)Which of the following is true about LOBs.A LOB can be
Ans-A,B and C
A)An attribute of a user-defined type
B)A column in a table
C)A bind or host variable
22)When you normalize a relation by breaking it into two similar relations,what must you do to maintain data integri
ty?
ANS-*Link the relations by a common field
*Create a primary key(s) for the new relation
23)In which of the following scenarios,you cannot overload subprograms
ANS-*You cannot overload two subprograms if thier formal parameters differ only in subtype and the different subt
ypes are based on types in the same family(...)
*Two functions that differ only in return type,even if the types are in different families
24)Which of these is a procedure(PL/SQL block) that contains the SQL statements and PL/SQL code to be executed
?
ANS-Trigger Action
25)What will be the outcome of the following code?
DECLARE
BEGIN
NULL;
EXCEPTION
WHEN OTHERS THEN
DBMS_OUTPUT>PUT_LINE
(Here is the code);
END;
ANS-COde will fail due to un-handled exception
26)TO handle error comditions(typically ORA messages)that have no predefined name,you must use which of the fo
llowing?
ANS-EXCEPTION_INT
27)What will be the outcome?
DECLARE
marks NUMBER;
Subject NUMBER;
BEGIN
Marks:=100;
Subject:=4;
IF marks>30 THEN
marks:+35;
ELSIF subject<5 THEN
marks:=marks-2;
END IF;
CASE marks
WHEN 100 THEN DBMS_OUTPUT_LINE('EXCELLENT');
WHEN 90 THEN DBMS_OUTPUT_LINE('Very Good');
WHEN 80 THEN DBMS_OUTPUT_LINE('Good');
WHEN 33 THEN DBMS_OUTPUT_LINE('Fair');
WHEN 30 THEN DBMS_OUTPUT_LINE('Poor');
END CASE;
ANS-Code fails due to exception RAISE CASE_NOT_FOUND
28)You have written a code which fails due system failure with disk storage or memory which has no relation......

ANS:- Handle named exceptions whenever possible, instead of using when others in exception handlers.
29)What can cause a high value for recursive calls?
ANS:- 1)A high value for recursive calls is cause by improper cursor usage
2)Due to excessive dynamic space management actions
3)Due to excessive statement re-parses.
30)The technology applies the resources of many computers in a network to a single problem at the same time-ususa
lly to scientific or technical problem.....
ANS:-Grid computing
31)What type of index is recommended for a materialzed view containing only joins...
ANS:-An index on the Rowid's of each of the tables used in the join.
32)Gaps in sequence values can occur when?
ANS:-1)A rollback occurs
2)The system crashes
3)A Sequence is used in another table
33)Complete the following and choose the correct option
PACKAGE pich_pkgu
iS
my_flag BOOLEAN = TRUE
END;
which of the following will display true
ANS;- "BEGIN
DBMS_OUTPUT_LINE(case WHEN pich_pkg.my_flag THEN 'TRUE' END);
END;"
34)Which of the following is true about functions when called from SQL statements
ANS:-1)When called from INSERT,UPDATE or DELETE statement function cannot query or modify any databas
e tables modified by that statement
2)When called from a SELECT,INSERT,UPDATE or DELETE statement the function cannot execute SQL tra
nsaction control statements..................
35)Which of the following data dictionary views can you use to get dynamic statastical information about queues?
ANS:-ALL_QUEUES
36)Explain Plan help developers which of the following ways
ANS:-1)Ensure that the the tables are joined in optimal order
2)Determine the most restrictive indexes to fetch the rows
3)Determine the Best internal join method
4)Determine that the SQL is executing the steps in the optimal order.
37)Which of the following is a restriction or cursor variable
ANS :- a)you cannot declare cursor variables in apackage specification
b)You cannot use comparison operators to test cursor variables for equality,inequality,nullity.
38)When the database detects an event the Trigger mechanism executes the action specified in the trigger.The action
can include publishing the event to a queue.........
ANS:-DBMS_AQ_package
39)By default an anonymus block in which type of unit in terms of AUTHID Clauses?
Ans;-IR Unit (invoker)
40)Which of these Triggers can be defined only on views and not on table ?
ANS;-INSTEAD of
41)ACE's are evaluated in the order they appear in the ACL.which of the following is the outcome of evaluating in a
ccess control entry
ANS:- 1)The application privilege is granted
2)The application privelege is denied
42)When should you use oracle external tables VS Oracle SQL "Loader
ANS:-1)To transfer the data as it is being loaded into the database
2)To Load very larger files with large quantities of data
43)Which of the following is true about Real Apllication Security?
ANS:-1)Supports declaritive security policies
2)Enables end-to-end security for multitier applications resources

3)Provides an integrated solution to secure database and application resources
4)Advances the security architecture of oracle database to meet existing and emerging demands........
44)What are all the parameters recquired to execute DBMS_MVIEWESTIMATE_MVIEW_SIZE?
ANS;-1)stmt_id and select_clause in VARCHAR@ data type
2)NUM_rows and num_bytes as number data type
3)stmt_id and select_clause will be IN clause
45)which of the following is true about Pl SQL exceptions
ANS;-1)you cannot declare an exception twice in the same block
2) you can declare the same exception in two different blocks
3)exceptions declared in a block are considered local to the block and global to all it's sub blocks

Q. package can be altered using A.ALTER B.CREATE C.SYS built-in packages
Ans. Both A AND B
Q.Which of the following Can be used to replace in following procedure to enable successful
execution?
create procedure my_new_proc(cRES OUT varhar2) is begin execute immediate
A.select * from dual into cRES B. select * into cREs from dual C.begin Select* into value from
dual;end,using out cRES
Ans. Both A AND C
Q.Inside subprograms,which of the following parameters act like a constant
Ans. IN
Q.______ clause is used to specify a trigger to be a row level Trigger?
Ans. FOR EACH ROW
Q. The EXISTS operator tests for existence of rows in the results set of the subqurey. what happens
when a subqurey row value is found
Ans. THE CONDITION IS FLAGGED TRUE
THE SEARCH CONTINUES IN THE INNER QUREY
Q .Which of the following are used in WHEN OTHERS exception handler
A. SQLCODE
SQLERRM
Q.Evaluate the SQl statement How many roles will user scott have access to? CREATE ROLE clerk;
Ans. 1
Q. Which of these is not a predefined PL/SQL character Data Types?
Ans.NRAW
Q. Procedure debug info can be find in : A. ALL_OBJECTS B.ALL_PROCEDURES
C.ALL_PROBE_OBJECTS
Ans. A,B, and C
Q. Which is the default value of cursor_sharing?
Ans. Exact
Q. which of these is a type of trigger (Both A and B)
A. Application Trigger
B. Database Trigger
C. Package Trigger

Ans. Both A and B
Q. which of these require less storage space as compared to other datatypes?
A. PLS_INTEGER
Q. You have been asked to lock employee table using the LOCK TABLE… which type of lock you will
use here?
Ans. LOCK TABLE employee IN ROW SHARE MODE MOWAIT;
Q. User-defined functions can be used in: A. Check Constraint B. Indexes C. Virtual columns
Ans. Both A and C
Q. How you can reduce or minimize network traffic when passing Host Cursor Variables to PL/SQl?
Ans. You can reduce network traffic by grouping OPEN_FOR statements
Q. Which of the following statements are allowed to be executed by Dynamic SQL
Ans. CREATE,DROP
ALTER
RETURNING INTO Clause
Q. which of the following is true about LOBs. A LOB can be
Ans. An attribute of user defined data type
A coloumn in a table
A bind or host variable
Q. Which of the following is true about bind variables ?
Ans. These Variables are declared in the host environment, such as SQL Plus
They can be referenced in PL/SQL statements, by prefixing the colon(:) before the variable
name
Q. When you normalized a relation by breaking it into two smaller relations, what must you do to
maintain data integrity?
Ans. Link the relations by common field
Create a primary key(s) for the new relation
Q. In which of the following scenarios, you cannot overload subprograms
Ans. 1.You cannot overload two subprograms if their formal parameters differ only in subtype
The different subtypes are based on types in the same family (Varchar and String)
Two functions that differ only in return type, even if the types are in different families.
Q. Which interface allow the DBA to administer that part …shared pool that is used SQL result cache
and PL/SQL function result cache?
Ans. DBMS_RESULT_CACHE package
Q. What is the out put of the following code snipper?

Ans. The sum of products equals: 166
Q. What impact does the below statement has on the rows in the table employee,department?
Ans. No Row is locked by this statement.
Q. When you retrieve into a ROWID variable, you can use which built-in function?
Ans. ROWIDTOCHAR
Q. you have been asked to use the dynamic SQL Statement that is a DMl statement with a
RETURNING INTO clause. What will you do with the bind variables?
Ans. Put in-bind arguments in the USING clause and out-bind arguments in the RETURNING INTO
clause.
Q. Which will be the outcome of the following code?
Ans. Code will fail due to un-handled exception.
Q. You have written a code which fails due system failure with disk storage or memory which has no
relation how you will handle these type of situations?
Ans. Handle named exceptions whenever possible, instead of using WHEN OTHERS in exception
handlers.
Q. Compile the following package and chose the correct option
Ans. BEGIN DBMS_OUTPUT.PUT_LINE (plch_pkg.my_flag);
Q. Which of the following is true about functions when called from SQL statements.
Ans. When called from INSERT,UPDATE, or DELETE statement, function cannot query or modify any
database tables modified by that statement
When called from SELECT, INSERT ,UPDATE OR DELETE ……….ALTER SYSTEM
Q. Which of the following is true about the WHERE CURRENT OF clasue is CURSORS
Ans. IF A CURSOR IS DECLARED…
THIS ALLOWS UPDATES….
THIS CLAUSE EVALUATES TO THE ROW…….
Q. oracle generates Bytes code for PLSQL Program unit when:
Ans. PLSQL_CODE_TYPE is set to INTERPRETED
Q. Which features are a part of the procedures in the DBMS_STATS package that are not used by the
ANALYZE command?
Ans. Parrlel,external,storing execution,forcing
Q. SYS PACKAGE UTL_RECOMP IS USED…….A.RECOMPILE CAN… B.Package must be… C. package do
not support..
Ans. BOTH A AND B

Q. Which of the packages are used for correcting blocks corrupted in the database?
Ans. DBMS_REPAIR
Q. Procedure compile_schema is a part of which SYS Package?
Ans. DBMS_UTILITY
Q. which of the following are the advantages of Application sessions
A. Application session encapsulate
They enable applications…
An application session can be………
They are accessible by all nodes……..
Q. Which of the following is true about Real Application security
Ans. Supports declarative security …………
Enables end-to-end security…………
Provides an integrated….
Advances the security……..
Q. Which of the following is true about principals in real application security
Ans. Principals are users..
Principal I an..
Principal is a……
Q.Which of the following are the techniques for data masking
Ans. Condition-based Masking
Compound Masking
Deterministic Masking
Q.which of the following is true about plsql exceptions
Ans. You cannot…….
You can declare……..
You can raise………
Exceptions declared……….

1.which of the following is not true about a view in oracle?
Ans: View cannot be created if base table does not exist.
2.which of the following is a valid named block in Oracle PL/SQL?
Ans: All(stored procedure,function,trigger)
3.which PL/SQL builtin procedure is used to raise a user-defined exxeption in oracle PL/SQL?
Ans: RAISE_APPLICATION_ERROR()
4.Which of the following collection is a sparse by its nature?
Ans: both
5.in oracle database,which trigger can be created on database object table?
Ans:before
6.which of the following is a valid trigger event type in oracle pl/sql?
Ans: All(DML,DDL,Logon &Logoff)
7.which of the following is not an external LOB in oracle PL/SQL?
Ans: both(BLOB,CLOB)
8.which of the following is a bounded collection in oracle PL?SQL?
Ans: Varray
9.which of the folloing is a unbounded collection in oracle PL?SQL?
Ans: Both(Nested table,associated array)
10.which type of exception in oracle pl/sql will have a built-in name associated with it?
Ans: predefined exceptions
11. which of the following is mandatory to consider in creation of a PL/SQL function?
Ans: All
12.In oracle PL/SQL ,we can implement polymorphism using which of the following component?
Ans: Package
13.What Is the default mode of a parameter in oracle PL/SQL?
Ans: IN
14.In oracle database,which trigger can be created on database object view?

Ans:Instead of
15.which of the following is a valid collection type in PL/SQL?
Ans: PL/SQL table
16.which of the following are valid for forward declarations?
Ans: 1)All identifiers and subprograms have to be declared before use.
2)Forward declaration consists of the subprogram specification terminated by a semicolon.
3)A forward declaration is used for defining the subprograms in logical or alphabetical
order,defining mutually recursive subprograms and for grouping sub
17.Consider the procedure given below.
CREATE OR REPLACE PROCEDURE PROC_1 AS num1 NUMBER(2);
Num2 NUMBER(2);
ans NUMBER(3);
BEGIN
ans:=num1+num2;
DBMS_OUTPUT_LINE(‘SUM IS’|| ans);
END;
Ans:EXEC PROC_1;
18.Consider the following code:
1.CREATE TABLE songs(songid char(5),singer varchar2(10));
2.INSERT INTO songs values(‘S1’,’Sonu’);
3.ALTER TABLE songs MODIFY songid char(3);
4.ALTER TABLE songs MODIFY singer varchar2(5);
Ans: Statement 3
19. Identify the internl LOB’s.
Ans: BLOB,CLOB,NCLOB
20.Which of the following otion s/are valid with respect to cursor?
Ans: All of the above
21.Assume that the statements are executed one after the other,empno is declared as primary key.

Ans: DUP_VAL_ON_INDEX exception is raised
22.Which command will delete all data drom a table and will write to the rollback segment?
Ans: DELETE
23.Identify the typical modeling reviews
Ans: Inconsisytent views of database,Incompatible data concepts and datatypes,redundant data
24.which statement about triggers is true?
Ans: you use a database trigger to fire when an INSERT statement occurs
25.What is a condition predicate in a DML trigger?
Ans: A conditional predicate allos you to combine several DML triggering events into one in the
trigger body.
26. Which of the following otion s/are valid for FORWARD DECLARARTIONS?
Ans: All the identifiers and subprograms have to be decalred before use,forward declarartion is used
for defining the subprograms in loical or alphabeticl order, defining mutually recursive subprograms
and for grouping subprograms,forward declarartion consists of subprogrms specification terminated
by a semicolon.
27.CREATE TABLE workers (wid char(3) DEFULT LIKE ‘W%’,wname VARCHAR2(10));
What is the output of above query?
Ans: Query fails as pattern matching not allowed in create statement.
28.Which of the following are true about PIVOT tool?
Ans: It automates the oracle PL/SQL code quality rview process,It makes sure that the best practice
rules are applied to each and every line of code,Output of the code quality tool is in two formats as
HTML and XML.
29.For both implicit and explicit cursors ,identify the sequence of operations that PL/SQL performs in
order to execute a sql statement in a program.
Ans: PARSE,BIND,OPEN,EXECUTE
30.consider the following trigger:
CREATE OR REPLACE TRIGGER upper_trig BEFORE INSERT or UPDATE of ename on new_emp
For each ro begin:new.ename:=UPPER(:old.ename);
END;
What will happen when above code is executed?

Ans: Converts all names into upper case
31.which of the following are valid exceptions?
Ans:TOO_MANY_ROWS,ZERO_DIVIDE,INVALID_CURSOR,NO_DATA_FOUND
32.for the pragma directive: PRAGMA EXCEPTION_INIT(exception _name,error_number) The value
of error_number should be
Anss: Any orcle error code other than predefined exception
33. the old and new qualifiers can be ued in ehich of trigger?
Ans: Row evel DML trigger
34. A fetch statement of a cursor returns multiple rows
Ans: false
35.An error-trapping function SQLCODE returns a numeric value 1,--------.
Ans: when user-defined exception is raised.

1.

which parametr made in pl/sql needs bind variable when procedure or
function is execute at schema level?
ans:---->out

2.

....project team customized pre configured validation rules in PIVOT
ans:---->yes

3.

considering the presence of columns salary,employee_id,ename in
employee table where employee_id is primary key column
predict the outcome of below procedure creation............
ans:---->procedure will be created with funtional erorrs

4.

consider=emp(empid,ename) has two rows with below values
row1=(1000,'first name')
row2=(1001,'second name')........
ans:------>1000 first name 1001 second name

5.

html validation report in pivot is used by
ans:----->pl/sql developer

6.

which database object cannot be tested with same type of database
object
ans:----->package

7.

what will happen if a function is defined in package body without
defining the function specification in package specificaton?

ans:----->it is called as private function and you will able to
access......
8.

which of the following is oracle pl/sql collection cannot be defined
at schema level
ans:----->associate table or plsql table

9.

__________ attributre is used to declare a variable for handling table
records and also for an explicit cursor records....with appropriate
option
ans:----->%row type

10.

the old and new qualifiers can used in which type of trigger? choose
most appropriate.....

ans:---->Row level dml trigger
11.

....execution of trigger can be achieved using the _______
clause.fill in the blanks.......
ans:----->option 2:when

12.

......project team customized pre configured validation rules in
pivot
ans:---->yes

13.

consider the following code,predict the output of the program
declare.....
n Numlist=NumList(10,20.....)........
n.Delete(3,6);
ans:----->deletes the element 3 through 6

14.

identify the component of a lob that references to where the lob
value is physically stored
ans:----->LOB Locator

15.

oracle pl/sql supports following data types

ans:----->both
16.

consider the procedure given below
create or replace procedure proc_1 as
num1 NUMBER(2);num2 NUMBER(2);.......

ans:------->all of the above
17.

consider the presence of column named 'department _name' table and
also table named 'employees' choose ....
declare

typet1 is table of employees%row type v1 t1;.....
ans:---->error at line number
18.

6

which of the following is true about packages 1.package body
....2.package specification ...3package can have....
ans:------>1,2 and 3

19.

considering the presence of columns salary employee id in employees
table also the presence of employees with employee_id 100 predict the
output of function creation
create or replace....
v_asal number

.......

return v_sal
ans:------>fuction creates with compilation error as size is mentioned
for a parameter
20.

considering the presence of a column named 'first_name' in 'emp'
table choose the output of the below program

declare
type t1 is table of varchar2(20)......
select first name bulk collect into v1 from emp;
ans:----->error at line number 5
21.

create a multi dimensional collection in pl/sql
ans:------>true

22.

considering the presence of table with column marks .....when an
update operation is performed on marks...
create or replace Trigger updated marks........
Dbms.output.line(old marks are ||old marks........)

end.
ans: ------>it will raise an error as :old and :new cannot be used in
this type of trigger
23.

predict the output of following code

declare
e_exception EXCEPTION;............
when others then......
end;
ans.------>handled in when others section

24.

..... a bind variable declare and value assigned as below two
statements .....

_ENO:100.......
consider below creation of code.....
the presence of columns salary,employee_id in the employees....
.return V_ASAL ;......
ans:------>it will return the annual salary of....present.otherwise raises
an exception .....
25.

predict the outcome of the below procedure creation (Line numbers are
only for reference and needs to be excluded while creation )

create or replace......
execute immmediate truncate from table......
end; /
ans:------->procedure gets created with compilation errors as there is an
error at line 4
26.

which of the following type of oracle pl/sql collection is used for
sparse collection through out its life time ?

ans: ------->associated array
27.

can project team customized pre configured validation rules in pivot

ans.----->yes
28.

validation report in pivot is in which format?

ans.------>HTML
29.

considering the presence of columns salary,employee id,e_name in
employees table
where employee_id is primary key constrained column
predict the outcome of the below procedure creation
create or replace ......
insert into emolyese(ename,salary)values......
end;

ans:----->procedure succesfully gets created

30.

predict the output of below code
declare
v_var1 number;
v_var2 v_var1%type.....
dbms_output.put_line(v_var2);
end

ans:----->numeric or value error
31.

considering the presence of ename in new_emp table ,predict the
outcome of the following trigger
create or replace trigger upper_trig before insert or update.....
new.ename=upper(:old.ename)
end;

ans:-------->trigger gets created successfully
32.

which of the following collection type can be created both at schema
level and pl/sql block?

ans.------->nested table
33.

identify the external lob choose most appropriate option

ans:----->bfile
34.

.....row level trigger will execute if the update statement is
affecting 10 rows

ans.------->10
35.

with respect to a condition predicate in a dml trigger choose
appropriate option.

most

ans:------->A conditional predicate allows you to combine several dml
triggering events in to one inthe trigger body
36.

which of the following pl/sql collection has to be initially dense
and can become sparse if needed?

ans.------->nested array
37.

which of the following exception will not have a bullitin exception
name in pl/sql

ans:------->non-predefined exceptions
38.

which of the collection type can be created both at the schema level
and pl/sql block?

ans:-------->nested table
39.

which pl/sql collection would fit the below scenario

assesment student data of discipline cse(computer science and
engineering) in a college with maximum 60
ans:------->Varray
40.

considering the presence of the columns named 'ename' and 'sal' in
'emp' table and in absence of 1234 employee number.....choose the
output of the
below program

declare
........
select sal*12 into v_sal from emp where empno=1234;
.......
end;
ans:------->exception at line number 5 as there is no employees with
employee number 1234
41.

....Sql code of exception with name NO_DATA_FOUND?

ans:------->100
42.

which statement is true about triggers? choose most appropriate
option.

ans:------>You use a database trigger to fire when an insert statement
occurs.
43.

which of the following pl/sql collection has to be initially dense
and can become sparse if needed?

ans.----->nested table
44.

which of the following builtin is used to associate a exception name
for a non-predefined exception?

ans.----->EXCEPTION_INIT()
45.

which of the following is not a predefined exception ?

ans:------>COLLECTION_NULL
46.

which of the following pl/sql collection will allow index by of
varchar2 data type?

ans.------->Associative array

------------------75 pages pdf------------------------------------------------------------------------

47. which of the following types of oracle pl/sql collection is used for
Sparse collection through out its life time.
Ans:--- Associative array
Nested table

48. Create or replace trigger upper_trig before insert or update of ename
on new_emp
for each row
begin
:new.ename=UPPER(:old.ename);
End;
Ans:--Trigger Created Successfully

49. Which of the following is the SQL CODE for exception with name
TOO_MANY_ROWS
Ans:--1422

50. with respect to a conditional predicate in DML trigger choose most
Appropriate option
Ans:-- A conditional predicate in a DML triggering Events into one.

51. What is the sql code of Exception with Name NO_DATA_FOUND
Ans:-- 100

52. which procedure is used to create Customized Error message?Choose Most
Appropriate option
Ans:-Raise_Application_Error

53. Which of the following is not a valid index by data types in Associate
Arrays?
Ans:-- date

54. which of the following exception will not have a builtin Exception
name in sql?
Ans:--- Non-predefined Exception

55.
create or replace Trigger Updated_marks
Before update on student
Begin
Dbms_output.put_line('old marks are'||:old.Marks||'New Marks
are'||:New.marks);
Ans:----- it will raise error as :old and :new cannot be allowed in table
level Triggers

56.

create or replace Function Annual_salary

return number
IS
V_sal number;
Begin
select*12 into v_sal from Employees where Employee_id=100;
return v_sal;
end;

ANS:----

57.

Function gets created Successfully

HTML validation Report in PIVOT is used by-------

ANS:--- Project Manager

58.

what is the following is valid exception code that a user can give
for user defined exception

Ans:-----20999

59.

in oracle pl/sql which of the following is stored as a database
objects when once created

Ans:--- All[Triiger,function,procedure]

60.

which of the following is not a predefined Exception

Ans:---which is started with collection option is correct

61.

Represent student data of discipline CSE in a college with maximum of
60 seats

Ans:---All

62.

Which of the following is a bounded and dense collection in sql?

Ans:---Varray

63.

Create or replace Trigger upper_trig Before Insert or update of ename
on new_emp

for each row
Begin
:new.Ename:=UPPER(:old.Ename);
End;

Ans:--- Trigger created Successfully

64.

what will happen if a function is defined in package body withou
defining in package specifiacation

Ans:----- it gives invalid identifire error

65.

which of the following package is used to perform operations on LOBS

Ans:---- dbms_lobs

66.

which of the following is true about order of

Exceptions?

Ans:-- optipons1,3

67.

can project team constructed pre customized validation rules in
pivot?

Ans:----------- YES

68.

In a RAISE_APPLICATION_ERROR what is the valid range of eeroor number
can make use of it?

Ans:--

69.

-20000 to -20999

which of the following exception will not have a builtin error name
in pl/sql

Ans:--Non-predefined Exception

70.

predict the output of the following code

Declare
v_var1 number;
v_var2 v_var1%Type;
Begin

v_var2:='A';
dbms_output.put_line(v_var2);
End;
Ans:------------------------Numeric or value eroor:Character to number
conversion Error

71.

What is pivot Stands for?

Ans:------------- project insights and visualization toolkit

72.

Which of the following is a type of Triggering Event for instead of
Trigger in oracle database

Ans:------------DML

73.

with respect to a condition predicate in a DML trigger choose most
Appropriate option

Ans:---Single lined Ans is correct

74.

create or replace function Annualsal(p_Eno Number)

return number
is
v_sal number;
Begin
select salary*12 into v_sal from employees where employee_id=p_eno;
return v_sal;
end;
Ans:--- It will return Annual salary of an employee if else present
...........otherwise raise an exception

75.

which of the following package is used to implement dynamic sql

Ans:--DBMS_sql

76.

which of the following plsql collection not defined at Schema level

Ans:=-- Associative Array

77.

non-predefined Exception can be defined with name using

Ans:-- Pragma_Exception_init

78.

create or replace procedure new_employee(P_Ename varchar2,p_sal
number)

Is
Begin
insert into Employees(first_name,salary) values(p_Ename,p_sal);
commit;
End;
Ans:---

79.

validation Report in Pivot is in which format?

Ans:--- HTML

80.

Which property of database guarantees persistence of an action once
notified about its success

Ans:--Durability

81.

which of the following pl/sql collection will allow INDEX BY of
VARCHAR2 Data type?

Ans:--

Associative Array

82.

which of these pl/sql collection datatypes also known as Associative
Array?

Ans:-- PL/sql Table

83.

declare
v_ename varchar2;

Begin
select ename into v_ename from emp where empno=1234';
dbms_output.put_line(v_ename);
end;

Ans:--range

84.

Error at line 2 , as the string length constraint must be in

declare
type t1 is table of varchar2(20);

v1 t1;
begin
select first_name bulk collect into v1 from emp;
dbms(v1);
end;
Ans:--- Error at line number 6

85.

create multi-dimensional collection in pl/sql?

Ans:--Yes
86.

which built in cannot be used with Associative Array?

Ans:-- Extend

87.

which parameter mode in pl/sql needs a bind variable when procedure
or function is excuted at schema level?

Ans:--

88.

OUT

which is true about trigger?

Ans:-You use a database Trigger to fire when an Insert statement Occurs

89.

qution not visible in pdf

Ans:--Handled in when others section

90.

Difference between collection Built-in Trim and delete

Ans:--- Delete deletes elements from any position in collection where as
Trim deletes elements from end of the Varray and nested table.

1. WHICH OF THE FOLLOWING PL SQL COLLECTION HAS TO BE INITIALLY DENSE AND CAN BECOME
SPARSE IF NEEDED?
ANS: NESTED TABLE
2. IDENTIFY THE EXTERNAL LOB CHOOSE MOST APPROPRIATE OPTION?
ANS: BFILE
3. WHICH OF THE FOLLOWING PACKAGE IS USED TO IMPLEMENT DYNAMIC SQL?
ANS: DBMS_SQL
4. WHICH OF THE COLLECTION TYPES ARE USABLE AS COLOUMN DATATYPE IN A TABLE?
ANS: VARRAY AND NESTED TABLE
5. BFILE CAN BE ACCESSED IN BOTH READ AND WRITE MODE SAY TRUE OR FALSE?
ANS: FALSE
6. CONSIDER THE PROCEDURE GIVEN BELOW.
CREATE OR REPLACE PROCEDURE PROC_1 AS
num 1 NUMBER(2);
num2 NUMBER(2);
ans NUMBER(3);
BEGIN
ans = num1+num2;
DBMS _OUTPUT.PUT_LINE(‘SUM IS’|| ANS);
END;
ASSUMING THAT THE APPROPRIATE PROCEDURE IS CREATED SUCCESSFULLY, IDENTIFY THE VALID
OPTION THAT IS USED TO EXECUTE THE PROCEDURE.CHOOSE APPROPRIATE OPTION?
ANS: EXEC PROC_1
7. CONSIDERING THE PRESENCE OF THE COLOUMN NAMED ‘ENAME’ IN ‘EMP’ TABLE AND ALSO 1234
EMPLOYEE NUMBER, CHOOSE THE APPROPRIATE OUTPUT THE GIVEN BELOW.
DECLARE
V_ENAME VARCHAR2;
BEGIN
SELECT ENAME INTO V_ENAME FROM EMP WHERE EMPNO=1234;
DBMS_OUTPUT.PUT_LINE (V_ENAME);
END;/
ANS: ERROR AT LINE 2
8. THE OLD AND NEW QUALIFIERS CAN BE USED IN WHICH TYPE OF TRIGGER? CHOOSE THE MOST
APPROPRIATE OPTION?
ANS: ROW LEVEL DML TRIGGER
9. IN ORACLE PL/SQL , WHICH OF THE FOLLOWING CAN BE USED AS RELATIONAL NOT EQUAL TO
OPERATOR?
ANS: ALL (!=,<>,~= )
10. WHICH OF THE FOLLOWING TYPE OF ORACLE PL/SQL COLLECTION IS USED FOR SPARSE
COLLECTION THROUGH OUT ITS LIFE TIME?

ANS: ASSOCIATED ARRAY
11. CONSIDERING THE PRESENCE OF A TABLE STUDENT WITH COLOUMNS MARKS .
PREDICT THE OUTPUT OF THE BELOW TRIGGER EXECUTION WHEN AN UPDATE OPERATION IS
PERFORMED ON MARKS COLUMN OF STUDENT TABLE (WITH SET SERVEROUTPUT ON)
CREATE OR REPLACE TRIGGER UPDATED_MARKS
AFTER UPDATE ON STUDENT
BEGIN
DBMS_OUTPUT.PUT_LINE (“OLD MARKS ARE:”||:OLD MARKS||”NEW MARKS ARE:”||:NEW MARKS);
END ?
ANS: IT WILL RAISE AN ERROR AS :OLD AND :NEW CANNOT BE USED
14. CONSIDERING THE PRESENCE OF COLOUMNS SALARY,EMPLOYEE_ID IN EMPLOYEES TABLE AND
ABSENCE OF EMPLOYEE WITH EMPLOYEE_ID 100.
PREDICT THE OUTCOME OF THE BELOW FUNCTION CREATION.
CREATE OR REPLACE FUNCTION ANNUALSALARY
RETURN NUMBER
IS
V_ASAL NUMBER;
BEGIN
SELECT SALARY*12 INTO V_ASAL FROM EMPLOYEES WHERE EMPLOYEE_ID=100;
RETURNV_ASAL;
END;
ANS: FUNCTION CREATES WITH COMPILATION ERRORS AS SIZE IS MENTIONED FOR/FUNCTION GETS
CREATED WITH RUNTIME ERRORS
13. WITH RESPECT TO A CONDITION PREDICATE IN A DML TRIGGER.CHOOSE MOST APPROPRIATE
OPTION?
ANS: A CONDITIONAL PREDICATE ALLOWS YOU TO COMBINE SEVERAL DML TRIGGERING EVENTS
INTO ONE
14. WHICH OF THE FOLLOWING IS CORRECT TRIGGER TO CHECK UPDATE ON EMP TABLE BETWEEN
9AM AND 6PM?CHOOSE THE MOST APPROPRIATE OPTION?
ANS: CREATE OR REPLACE TRIGGER EMP_UPDATE_CHECK
BEFORE UPDATE ON EMP
BEGIN
IF(TO_CHAR(SYSDATE. ‘HH24’) BETWEEN ‘9’ AND ‘18’) THEN
RAISE_APPLICATION_ERROR(-2055, ‘MODIFICATION OF EMPLOYEE NOT P**** DURING
BUSINESS HOURS’);
END IF;
END;
/
15. WHICH OF THE FOLLOWING CAN BE A TRIGGERING EVENT FOR A INSTEAD OF TRIGGERIN ORACLE
DATABASE?
ANS: DML
16. WHICH OF THE FOLLOWING CANNOT BE INCLUDED IN A PL/SQL PACKAGE? CHOOSE THE MOST
APPROPRIATE OPTION?
ANS: TRIGGERS
17. WHICH OF THE FOLLOWING PACKAGE IS USED TO PERFORM OPERATIONS ON LOBS?
ANS: DBMS_LOB
18. WHICH PARAMETER MODE IN PL/SQL NEEDS A BIND VARIABLE WHEN PROCEDURE OR FUNCTION
IS EXECUTED AT SCHEMA LEVEL?
ANS: ALL (IN,OUT,OUT IN)

19. HOW MANY TIMES A BEFORE UPDATE ROW LEVEL TRIGGER WILL EXECUTE IF THE UPDATE
STATEMENT IS AFFECTING 10 ROWSIMMEDIATE
ANS: 10
20. ORACLE PL/SQL SUPPORTS FOLLOWING NUM1PES?
ANS: BOTH
21. WHICH OF THE FOLLOWING IS ORACLE PL/SQL COLLECTION CANNOT BE DEFINED AT SCHEMA
LEVEL?
ANS: ASSOCIATIVE ARRAY
22. CONDITIONAL EXECUTION OF A TRIGGER CAN BE ACHIEVED USING THE……………CLAUSE.FILL IN
THE BLANKS WITH AN APPROPRIATE OPTION?
ANS: WHEN
23. WHATS OF THE FOLLOWING IS A VALID EXCEPTION CODE THAT A USER CAN GIVE FOR USER
DEFINED EXCEPTION?
ANS: -2999
24 …………………………..ATTRIBUTE IS USED TO DECLARE A VARIABLE FOR HANDLING TABLE RECORDS
AND ALSO FOR AN EXPLICIT CURSOR RECORDS? FILL IN THE BLANK WITH AN APPROPRIATE OPTION?
ANS: %ROWTYPE
25. WHICH OF THE FOLLOWING ABOUT EXISTS METHODS OF PL/SQL COLLECTION IS TRUE?
ANS: RETURNS TRUE IF AND ONLY IF SPECIFIED ELEMENT OF ASSOCIATIVE ARRAY OR VARRAY OR
NESTED TABLE EXITS.
26. WHICH OF THE FOLLOWING STATEMENT IS TRUE FOR REGARDING A DATABASE TRIGGER?CHOOSE
THE MOST APPROPRIATE OPTION?
ANS: A BLOCK OF CODE WHICH IS IMPLICITLY INVOKED UPON OCCURRENCE OF A DATABASE EVENT

27. CAN PROJECT TEAM CUSTOMIZED PRE CONFIGURED VALIDATION RULES IN RA?
ANS: YES
28. WHICH OF THE FOLLOWING TYPE OF EXCEPTION WILL NOT HAVE A BUILTIN EXCEPTION NAME IN
PL/SQL?
ANS: NON PREDEFINED EXCEPTIONS
29. WHICH OF THE FOLLOWING IS/ARE A PREDEFINED EXCEPTION? 1. VALUE_ERROR 2.
INVALID_NUMBER
ANS: BOTH 1 and 2
30. PREDICT THE OUTCOME OF THE BELOW PROCEDURE CREATION.(LINE NUMBERS ARE ONLY FOR
REFERNCE AND NEED TO BE EXCLUDED WHILE CREATION)
1. CREATE OR REPLACE PROCEDURE DROP_TABLE(P_TNAME VARCHAR2)
2. IS
3. BEGIN
4. EXECUTE IMMEDIATE ‘DROP FROM ‘||P_TNAME
5. END;
6. /
ANS: PROCEDURE GETS CREATED WITH COMPILATION ERRORS AS THERE IS AN ERROR AT LINE 4

32. CONSIDERING THE PRESENCE OF A COLOUMN NAMED ‘FIRST_NAME’ IN ’EMP’ TABLE.CHOOSE
THE OUTPUT OF THE BELOW PROGRAM.
1.DECLARE
2. TYPE T1 IS TABLE OF VARCHAR2(20);
3. V1 T1;
4. BEGIN
5. SELECT FIRST_NAME BULK COLLECT INTO V1 FROM EMP;
6. DBMS_OUTPUT.PUT_LINE(V1);
7. END;
ANS: ERROR AT LINE NUMBER 6
33. WHAT IS THE SQLCODE OF EXCEPTION WITH NAME NO_DATA_FOUND?
ANS: 100
34. CONSIDER THE FOLLOWING CODE, PREDICT THE OUT OF THE PROGRAM? DECLARE TYPE NUMLIST
IS TABLE OF NUMBER N NUMLIST= NUMLIST,(10,20,30,40,50,60,70,80,90,100) BEGIN NDELETE(3,6)
END?
ANS : DELETE THE ELEMENTS 3 THROUGH 6
35. CONSIDERING THE PRESENCE OF COLOMNS SALARY, EMPLOYEE_ID, ENAME IN EMPLOYEES
TABLE.WHERE EMPLOYEE_ID IS A PRIMARY KEY CONSTRAINED COLOUMN.PREDICT THE OUTCOMEOF
THE BELOW PROCEDURE CREATION.
CREATE OR REPLACE PROCEDURE NEW_EMPLOYEE (P_ENAME VARCHAR2, P_SAL NUMBER)
IS
BEGIN
INSERT INTO EMPLOYEES (ENAME, SALARY) VALUES(P_ENAME, P_SAL);
COMMIT;
END;
ANS: PROCEDURE WILL BE CREATED WITH RUNTIME ERRORS
36. PREDICT THE OUTPUT OF BELOW CODE.DECLARE V_VAR1 NUMBER, V_VAR2 V_VAR1%TYPE;
BEGIN V_VAR 2 = ‘A’ ; DBMS_OUTPUT.PUT_LINE(V_VAR2); END?
ANS: NUMERIC OR VALUE ERROR
37. CONSIDERING THE PRESENCE OF COLOUMN ENAME IN NEW_EMP TABLE,PREDICT THE OUTCOME
OF THE FOLLOWING TRIGGER.CREATE OR REPLACE TRIGGER UPPER_TRIG BEFORE INSERT OR UPDATE
OF ENAME ON NEW_EMP FOR EACH ROW BEGIN NEW.ENAME=UPPER(:OLD.ENMAE); END;
ANS: TRIGGER GETS CREATED SUCCESSFULLY
38. WHICH OF THE FOLLOWING COLLECTION TYPE CAN BE CREATED BOTH SCHEMA LEVEL AND IN
PL/SQL BLOCK?
ANS: NESTED TABLE

39. PREDICT THE OUTPUT OF THE FOLLOWING CODE?DECLARE E_EXCEPTION EXCEPTION BEGIN
DECLARE E_EXCEPTION EXCEPTION BEGIN RAISE E_EXCEPTION END EXCEPTION WHEN E_EXCEPTION
THEN DBMS_OUTPUT.PUT_LINE(“HANDLED IN E_HANDLING EXCEPTION”) WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE(“HANDLED IN WHEN OTHERS SECTION”) END?
ANS: HANDLED IN WHEN OTHERS SECTION
40. WHICH PL/SQL COLLECTION TYPE WOULD FIT IN THE BELOW SCENARIO.THE PRESENT STUDENTS
DTA OF DISCIPLINE CSE(COMPUTER SCIENCE AND ENGINEERING) IN A COLLEGE WITH MAXIMUM 60?
ANS: VARRAY
41. CONSIDERING THE PRESENCE OF THE COLOUMN NAMED ‘ENAME ’ AND ‘SAL ‘ IN ‘EMP ’ TABLE
AND ALSO 1234 EMPLOYEE NUMBER ,CHOOSE THE OUTPUT OF THE BELOW PROGRAM.DECLARE
V_ENAME VARCHAR2; V_SAL NUMBER; BEGIN SELECT *12 INTO V_SAL FROM EMP WHERE
EMPNO=1234;SELECT ENAME INTO V_ENAME FROM EMP WHERE
EMPNO=1234;DBMS_OUTPUT.PUT_LINE (V_ENAME);END;?
ANS: EXCEPTION AT LINE NUMBER 5 AS THERE IS NO EMPLOYEE WITH EMPLOYEE NUMBER 1234.
42. WHICH STATEMENT IS TRUE ABOUT TRIGGERS?CHOOSE MOST APPROPRIATE OPTION?
ANS: YOU USE A DATABASE TRIGGER TO FIRE WHEN AN INSERT STATEMENT OCCOURS.
43. WHICH OF THE FOLLOWING PL/SQL COLLECTION WILL ALLOW INDEC BY OF VARCHAR2 DATA
TYPE?
ANS: ASSOCIATIVE ARRAY
44. WHICH OF THE FOLLOWING IS NOT A PREDEFINED EXCEPTION?
ANS: COLLECTION_NULL
45. WHICH OF THE FOLLOWING BUILTIN IS USED TO ASSOCIATE A EXECPTION NAME FOR A NONPREDEFINED EXCEPTION?
ANS: EXCEPTION_INIT()
46. IDENTIFY THE COMPONENT OF A LOB THAT REFERENCES TOWHERE THE LOB VALUE IS PHYSICALLY
STORED.CHOOSE APPROPRIATE OPTION?
ANS: LOB LOCATOR.
47. WHAT WILL HAPPEN IF A FUNCTION IS DEFINED IN PACKAGE BODY WITH OUT DEFINING THE
FUNCTION SPECIFICATION IN PACKAGE SPECIFICATION?
ANS: IT IS CALLED AS PRIVATE FUNCTION AND YOU WILL ABLE TO ACCESS
48. WHICH OF THE FOLLOWING IS THE SQL CODE FOR EXCEPTION WITH NAME TOO_MANY_ROWS?
ANS: - 1422
49. WHICH PROCEDURE CAN BE USED TO CREATE A CUSTOMIZED ERROR MESSAGE?CHOOSE MOST
APPROPRIATE OPTION?
ANS: RAISE_APPLICATION_ERROR
50. WHICH OF THE FOLLOWING IS NOT A VALID INDEX BY DATATYPES IN ASSOCIATIVE ARRAYS?
ANS: DATE
51. HTML VALIDATION REPORT IN PIVOT IS USED BY
ANS:PL/SQL DEVELOPER
52. IN ORACLE PL/SQL ,WHICH OF THE FOLLOWING IS STORED AS A DATABASE OBJECT WHEN ONCE
CREATED?
ANS: ALL
53. WHICH OF THE FOLLOWING IS A BOUNDED AND DENSE COLLECTION IN PL/SQL?

ANS: VAARAY
--54. IN WHICH OF THE FOLLOWING OPTION BEST DESCRIBES TOO_MANY_ROWS NAMED
EXCEPTIONS.CHOOSE APPROPRIATE OPTION?
ANS:PRE-DEFINED EXCEPTION
55. NON-PREDEFINED EXCEPTION CAN BE DEFINED WITH NAME USING .CHOOSE MOST APPROPRIATE
OPTION?
ANS: PRAGMA EXCEPTION_INIT
56. VIEWS CREATE A COPY OF THE DATA FROM THE BASE TABLE?
ANS: TRUE
57. ORACLE PL/SQL SUPPORTS FOLLOWING DATATYPE?
ANS: BOTH (SCALAR AND COMPOSITE)
58. WHICH OF THE FOLLOWING IA VALID NAMED BLOCK IN ORACLE PL/SQL?
ANS: ALL (STORED PROCEDURE, FUNCTION, TRIGGER)
59. WHICH OF THE FOLLOWING COLLECTION IS A SPARSE BY IT’S NATURE?
ANS: ASSOCIATIVE ARRAY
60. WHICH OF THE FOLLOWING PL/SQL COLLECTION IS DENSE THROUGH OUT ITS EXISTENCE IN A
PROGRAM EXECUTION?
ANS :- VARRAY
61. IN ORACLE DATABASE, WHICH TRIGGER CAN BE CREATED ON DATABASE OBJECT TABLE?
ANS :- DATABASE TRIGGER
62. WHICH PL/SQL BUILTIN PROCEDURE IS USED TO RAISE A USER-DEFINED EXCEPTION IN ORACLE
PL/SQL?
ANS :- RAISE_APPLICATION_ERROR()
--63. IN ORACLE DATABASE, WHICH TRIGGER TIMING CAN BE CREATED ON DATABASE OBJECT VIEW?
ANS :- INSTEAD OF
64. WHICH OF THE FOLLOWINF IS A VALID COLLECTION TYPE IN PL/SQL?
ANS :- PL/SQL TABLE
65. WHICH OF THE FOLLOWING IS A BOUNDED COLLECTION IN ORACLE PL/SQL?
ANS :- VARRAY
66. WHICH OF THE FOLLOWING IS A VALID TRIGGER TIMING IN ORACLE PL/SQL?
ANS :- ALL (BEFORE, AFTER, INSTEADOF)
67. WHICH OF THE FOLLOWING IS A VALID PL/SQL COLLECTION BUILTIN?
ANS :- ALL (COUNT, DELETE, TRIM)
--68. IN ORACLE PL/SQL, WE CAN IMPLEMENT POLYMORPHISM USING WHICH OF THE FOLLOWING
COMPONENT?
ANS :69. WHICH OF THE FOLLOWING IS A VALID PREDEFINED EXCEPTION IN PL/SQL?
ANS :- NO_DATA_FOUND
70. WHICH OF THE FOLLOWING IS SERVER SIDE PROGRAM IN PL/SQL?
ANS :- ALL(STORED PROCEDURE, FUNCTION, PACKAGE)

71. WHICH OF THE FOLLOWING IS MANDATORY IN PL/SQL FUNCTION?
ANS :- HAVING RETURN STATEMENT
72. WHICH OF THE FOLLOWING IS A VALID TRIGGER TYPE IN PL/SQL?
ANS :- BOTH(ROW LEVEL AND STATEMENT LEVEL)
73. :NEW AND :OLD QUALIFIERS CAN BE USED ONLY IN ROW LEVEL TRIGGER?
ANS : TRUE
74. WHICH OF THE FOLLOWING APPROACHES ARE USED TO IMPLEMENT DYNAMIC SQL?
ANS : BOTH (USING EXECUTE IMMEDIATE AND USING DBMS_SQL PACKAGE)

1. In oracle forms, Which of the following is used to get the item
property at run time?
a)GET_ITEM_PROPERTY()
b)GET_PROPERTY()
c)GET_PROPERTY_ITEM()
d)None
Ans:a
2. When the user navigates from one record to another record in a block,
which trigger can be fired among the given options?
a)WHEN-NEW-FORM-INSTANCE
b)WHEN-NEW-RECORD-INSTANCE
c)PRE-FORM
d)WHEN-NEW-BLOCK-INSTANCE
Ans:b
3. Which of the following is considered as the advantage of property
class in Oracle forms?
a)If one or more properties of the data entry field require change, a
property class enables at the other data entry fields on the form to map
to this change.
b)If each property is individually set, then it will be tedious to
maintain the standards in the form. A property class helps to avoid this.
c)To help maintain consistency in the form. Oracle forms builder provides
a solution of property class.
d)All
Ans:d
4.which of the following is used to capture the type of error?
a)ERROR_TYPE
b)ERROR_NAME
c)ERROR_CATEGORY
d)None
Ans:a
5.which of the following is used to valid value returned by SHOW_ALERT()
builtin?
a)0
b)1
c)2
d)alert_button1
Ans:d
6.In oracle forms, Which of the following triggers is used to trap the
check box events when the selection is changed?
a)WHEN-CHECKBOX-CHANGED
b)WHEN-BUTTON-CHANGED
c)WHEN-CHECK-CHANGED
d)WHEN-CHECK-BOX-CHANGED
Ans:WHEN-CHECKBOX-CHANGED (a)
7.Which of the following property cannot be set using Visual Attribute of
Oracle Forms?
a)Menu Module
b)Font Style

c)Font size
d)Foreground Color
Ans:a
8.What is the default canvas in forms?
a)Content Canvas
b)Stacked Canvas
c)Horizontal Canvas
d)Tab Canvas
Ans:a
9.In oracle forms, Which of the following trigger is used to trap the
radio button events when the selection is changed?
a)WHEN-RADIO-CHANGED
b)WHEN-BUTTON-CHANGED
c)WHEN-RADIO-MOVED
d)WHEN-RADIO-BUTTON-CHANGED
Ans:a
10.Which of the following is not an object of a form module?Choose most
appropriate option.
a)Visual Attributes
b)Property Classes
c)Triggers
d)Menus
Ans:d
11.In the Master-Detail form, when the user queries for the records in
the master block and starts moving through them,
Which of the following options can occur in the detail block? Choose the
most appropriate option.
a)The detail records can get displayed automatically after the master
record is displayed.
b)The detail records can be displayed only when the cursor is positioned
on the detail block.
c)The detail records can be displayed after the user queries for them in
the detail block.
d)all of the above
Ans:d
12.Which of the following is used to capture the error code in oracle
forms?
a)ERROR_TYPE
b)ERROR_CODE
c)ERROR_NAME
d)None
Ans:b
13.In Master detail block, Which of the following property specifies how
the deletion of the record when the master block should affect the detail
block.
a)Delete record behaviour
b)Remove record behaviour
c)Delete Row behaviour

d)Delete Record
Ans:a
14.Ajay Created a Master Detail Form.
MasterBlock:Customer
DetailBlock:Transaction
When he query Customer block he needs all transactions for that customer
need to be automatically appear in detail block.
What are the valid Relations properties need to be set to meet this
requirement.
a)Deferred: No
Automatic Query: Yes/No
a)Deferred: Yes
Automatic Query: Yes
a)Deferred: Yes
Automatic Query: No
a)Deferred: Yes/No
Automatic Query: Yes
Ans:a
15.Which of the following is the valid value for SWITCH MENU argument of
open_form builtin?
a)DO_REPLACE
b)REPLACE
c)DO_REMOVE
d)DO_SWITCH
Ans:a
16.Identify the appropriate trigger that should be created to check that
a primary key value is unique immediately after it is entered by the
operator.
Choose the most appropriate option.
a)WHEN-VALIDATE-ITEM trigger that issues a SELECT statement to check if
the value already exists in the block's datasource.
b)WHEN-NEW-ITEM-INSTANCE trigger that issues a SELECT statement to check
if the value already exists in the block's datasource.
c)POST-TEXT-ITEM trigger that issues a SELECT statement to check if the
value already exists in the block's datasource.
d)None
Ans:a
17.If user wants to perform DML operations through a called form, in form
to form navigation. Which of the following value has to be assigned to
Query Mode property?
a)QUERY_ONLY
b)NO_QUERY_ONLY
c)QUERY_WRITE
d)None
Ans: b
18.Raman created Patient details form. He wants to autogenerate
Patient_Id for every new patient record? Which of the following is
appropriate trigger to achieve this requirement?
a)When-new-record-instance

b)post-item
c)When-validate-item
d)Post-record
Ans:a
19.Which of the following options is used to save the form data?
a)Commit_Form;
b)Clear_Form(DO_COMMIT);
c)clear_form(Ask_commit);
d)All
Ans:d
20.There are two forms
1. FORM1
2. FORM2
Each of these forms needs to have menu module MENU1 attached.
Which of the following property of FORM1 and FORM2 needs to be given with
MENU1 location?
a)Menu Module
b)Module
c)Module Menu
d)All of the above
Ans: b
21.Which of the following is a collection of program units that includes
procedures,functions and packages independent of the form module.
a)PL/SQL Library
b)Object Library
c)Collections
d)All
Ans:a
22.Which of the following builtin is used to move from one block to
another block in oracle forms?
a)GO_BLOCK()
b)MOVE_BLOCK()
c)NAVIGATE_BLOCK()
d)None
Ans:a
23.Theresa created a form to search for existing employees details.
However she is able to add new employees and able to modify existing
details also,
which should be restricted. Select the appropriate option to achieve this
requirement?
Form Name:EMP_FORM
Data Block Name: Emp
a)set insert allowed to yes,update allowed to yes. Query Allowed Yes in
the property palette of in the Emp Datablock.
b)set insert allowed to no,update allowed to no. Query Allowed Yes in the
property palette of in the Emp Datablock.
c)set insert allowed to no,update allowed to yes. Query Allowed Yes in
the property palette of in the Emp Datablock.

d)set insert allowed to yes,update allowed to no. Query Allowed Yes in
the property palette of in the Emp Datablock.
Ans:b
24.Which one of these options can be used to raise an error in a form
module?
Choose most appropriate option.
Ans:RAISE FORM_TRIGGER_FAILURE
25.Laxman created Products form. When he runs the form he is able to
query the existing products and modify them. However he was not able to
add a new product
and getting an error as 'Cannot perform this operation'. What might be
the reason?
a)Update Allowed is set to 'yes' Query Allowed is set to 'yes' and insert
allowed is set to 'yes'.
b)Update Allowed is set to 'yes' Query Allowed is set to 'no' and insert
allowed is set to 'yes'.
c)Update Allowed is set to 'yes' Query Allowed is set to 'yes' and insert
allowed is set to 'no'.
d)Update Allowed is set to 'no' Query Allowed is set to 'yes' and insert
allowed is set to 'no'.
Ans:c
26.Which of the following form builder module will have .pll extension?
a)Program Library List
b)Primary Library List
c)PL/SQL Library Module Binary
d)Programming List Library
Ans:c
27.Which of the following module of oracle forms builder a menu can be
attached in the property palette?
a)Form Module
b)PL/SQL Library
c)Object Library
d)All
Ans:a
28.Which of the following builtin is used to invoke an LOV in forms?
a)SHOW_LOV()
b)OPEN_LOV()
c)LOAD_LOV()
d)CALL_LOV()
Ans:a
29.Which of the following builtin is used to invoke an alert in oracle
forms?
a)SHOW_ALERT()
b)CALL_ALERT()
c)LOAD_ALERT()
d)INVOKE_ALERT()
Ans:a

30.Which of the following builtin is used to change the visual attribute
property at runtime?
a)SET_ITEM_PROPERTY()
b)GET_ITEM_PROPERTY()
c)SET_PROPERTY_FORM()
d)SET_ITEM_ATTRIBUTE()
Ans:a
31.Which of the trigger is used to handle oracle form errors?
a)ON-ERROR
b)WHEN-ERROR-OCCUR
c)WHEN-ERROR-RAISED
d)NEW
Ans:a
32.Which option should Lucy choose to display the current date in an item
named TransactionDate in the Transaction Module.
Choose most appropriate option.
a)SYSDATE
b)$$SYSDATE$$
c)$$date$$
d)$$currentdate$$
Ans:c
33.Ram has created a form in which data block is created using wizard,
which of the following builtin is used to perform insertion
operation?
a)FORM_COMMIT;
b)SAVE_COMMIT;
c)COMMIT_FORM;
d)LOG_FORM;
Ans:c
34.Which of the following builtin is used to retrieve the name of the
item that caused the ON-ERROR trigger to fire?
Ans:SYSTEM.TRIGGER_ITEM
35.What is the default value for the Menu Module Property for a form.
Choose the most appropriate option.
a)DEFAULT
b)SMARTBAR
c)DEFAULTSMARTBAR
d)DEFAULT&SMARTBAR
Ans:d
36.Which of the following is a system variable, which holds a value that
indicates whether the current record is the last record in a block?
a)SYSTEM.LAST_RECORD
b)SYSTEM.FINAL_RECORD
c)SYSTEM.RECORD_LAST
d)SYSTEM.LAST_ROW
Ans:a

37.In oracle forms, Which of the following builtin is used to display a
message?
a)MESSAGE()
b)RAISE_MESSAGE()
c)DISPLAY_MESSAGE()
d)None
Ans:a
38.Which of the following is not a correct match for component and
executable?
1)Form:.fmx
2)Menu:.mmx
3)PL/SQL Library:.plx
4)Object Library:.olx
a)1
b)2
c)3
d)4
Ans:d
39.Identify the appropriate display styles of an alert.
a)Stop,Caution,Note
b)Warn,Implify,Stop
c)Caution,Note,Simple
d)None of the above
Ans:a
40.State True or False
In master detail, If the deferred Property is set to 'Yes' and Automatic
Query is set to 'Yes',The associated detail records are retrieved when
the form
cursor is positioned on the detail block.
Ans:True
41.To create a 'CUT' (Which cuts the selected text)menu option in menu
module. Which type of menu has to be selected?
a)Magic
b)Plained
c)Checked
d)All
Ans:a
42.Which of the following builtin is used to change the menu property at
run time?
Ans:SET_MENU_ITEM_PROPERTY
43.Which of the following function is used to create a record group?
a)CREATE_QUERY_FORM_GROUP()
b)CREATE_GROUP_FROM_QUERY()
c)CREATE_GROUP_QUERY()
d)CREATE_QUERY()
Ans:b

44.Which of the following is a system variable that holds the value of
the current record number?
Ans:SYSTEM.CURSOR_RECORD (SYSTEM.CURRENT_RECORD)
45.Which of the following is a valid menu item type in oracle forms?
a)Magic
b)Plain
c)check
d)all
Ans:d
46.In oracle forms what is the return type of SHOW_LOV() builtin?
a)NUMBER
b)Date
c)VARCHAR2
d)Boolean
Ans:d
47.Identify the first step that needs to be performed in order to attach
a custom menu module to a form module.
Choose the most appropriate option.
a)creates the executable of the menu module by compiling the same.
b)Attach the menu module to the appropriate form.
c)Create the executable of the menu module by executing the same.
d)None of the above.
Ans:a
48.Which of the following can be associated only to an item and not to a
module in Oracle forms?
a)Menu
b)Popup Menu
c)Both
d)None
Ans:Menu (ans doubt)
49.State True/False
An alert can have maximum five buttons.
Ans:False
50.Which of the following builtin cannot be used in oracle forms?
a)RAISE_APPLICATION_ERROR()
b)CALL_FORM()
c)DBMS_OUTPUT.PUT_LINE()
d)CLEAR_FORM()
Ans:c
51.Which of the following library can store program units in oracle
forms?
a)PL SQL Library
b)Object Library
c)Object Navigator
d)Data Library
Ans:a

52.Ram wants to make TOTAL PRICE item to be non-editable in orders form
when the form applets loads. Select the appropriate trigger to achieve
the same.
a)when-new-record-instance
b)when-new-item-instance
c)when-validate-item
d)when-new-form-instance
Ans:d
53.Customer name is mandatory field in customer form, What are the
different ways to achieve this?
a)Go to property Palette of customer name and set required yes.
b)write a code in when-validate-item of customer name to check whether
customer name is null.If null,raise a form error.
options
a)Only A is correct option
b)only B is correct option
c)Either A or B is suffice
d)Both A and B or needed
Ans:c
54.Choose the correct line of code to programatically set a visual
attribute named 'VA_ERROR' to item item1 present to block1?
Ans:SET_ITEM_PROPERTY('block1.item1',current_record_attribute,'VA_ERROR')
;
55.The requirement is to ensure that the fields are loaded with data when
the form opens up.
which trigger can be used for this requirement?
a)when-validate-form
b)pre-form
c)pre-logon
d)post-form
Ans:b
56.Which of the following operations can be done with the 'when-buttonpressed' trigger?
a)Forms and Block Navigation
b)Saving the Form data
c)Invoking Calculations
d)All
Ans:d
57.Ramesh has created a form in which data block is created using wizard.
Which of the following builtin and trigger combination
should be used to load the data into the form, when the form loads?
Ans:When-new-form-instance,EXECUTE_QUERY
58.which of the following trigger can be used to perform datablock level
validation?
Ans:when-new-block-instance
59.which of the following options can be used to raise an error in a form
module?
a)raise_application_error
b)rise trigger_form

c)raise form_trigger_failure
d)pragma exception init
Ans:c
60)Which of the following builtin is used to load an image in a image
item?
a)READ_FILE()
b)READ_IMAGE_FILE()
c)READ_IMAGE()
d)LOAD_IMAGE()
Ans:b
61)What are the different types of delete details we can have on master
detail forms?
Ans:Non-Isolate,Cascade,Isolate
62)What are the different default triggers created when Master Deletes
Property is set to Cascade?
Master Deletes Property Resulting Triggers
--------------------------------------------------a)Cascading On-Clear-Details
b)On-Populate-Details
c)Pre-delete
d)all
Ans:d
63)Which of the following contains the select statement associated with
LOV in oracle forms?
a)Record Group
b)Block Group
c)Object Group
d)PLSQL Library
Ans:a
64)Which of the valid canvas view?
a)Content Canvas
b)Stacked Canvas
c)Horizontal Toolbar Canvas
d)All
Ans:d
65)The form builder launches a web browser and specifies the URL to run
the form. Inorder to run the form,there must be an
HTTP listener already started and goes by the name
_____________.
a)Form Runtime Listener
b)OC4J HTTP Listener
c)Forms Listener
d)HTTP Listener
Ans:b
66)Which among the following can be classified as Navigational triggers?
Ans:Pre-BLock,Post-Form,Post-Record etc...

67)while creating a master-detail form identify the trigger that will get
fired to check if the join column value in the master block is NULL or
not.
Ans:ON_CHECK_DELETE_MASTER
68)Amit has placed two text items and a push button on the canvas. Pick
the triggers that get executed when he presses the tab key.
a)Post-text-item
b)when-item-pressed
c)pre-text-item
d)key-next-item
Ans:a,c,d
69)The CUST_DEPT form has called the ORD_DET form for the user to enter
the order details for the customer. The CALL_FORM function has been used
to call
ORD_DET from CUST_DET. what is the feature of the CALL_FORM function?
Ans:When called form completes the operation, it releases lock and
control goes back to the calling form.
70)Which of the following options are VALID for canvases?
Ans:
1.By default, any canvas created, is assigned at runtime to the window
named WINDOW1
2.Content Canvas can be created with the help of Layout wizard,Layout
Editor and Object Navigator.
3.A tab canvas, made up of one or more tab pages, allows you to group and
display a large amount of related information on a single,dynamic canvas
object.
4.A stacked canvas with raise on entry property set to yes can be
displayed only through navigation or programmatic control.
71)Under which situations does the following error occur: No master
Blocks are available.
Ans:If the foreign key is not defined at the block level.
72)Which of the following functions can be accomplished only with the use
of key triggers?
Ans:
1.Changing function keys default functionality
2.Disabling function keys
73)Which of the following module of oracle forms builder a menu can be
attached in the property palette?
a)Form Module
b)PL/SQL cursor
c)Object Library
d)All
Ans:a
74)Which of the following is used to retrieve the name of the item that
caused the ON-ERROR trigger to fire?
Ans:SYSTEM.TRIGGER_ITEM
75)In Master Detail Block, Which of the following value has to be set to
'DELETE RECORD BEHAVIOUR' so that a Master record can be deleted, but
the associated Detail Records are not affected?
a)NON-ISOLATED

b)Cascading
c)Isolated
d)All
Ans:d
76)Which two statements about FORM_TRIGGER_FAILURE are true?(choose two)
a)You cannot raise FORM_TRIGGER_FAILURE in a exception handler.
b)FORM_TRIGGER_FAILURE does not cause an unhandled exception.
c)FORM_TRIGGER_FAILURE causes a trigger to fail in a controlled manner.
d)If you use FORM_TRIGGER_FAILURE to fail a trigger that is called by
another trigger,the called trigger automatically fails.
e)Processing continues after FORM_TRIGGER_FAILURE is raised until the end
of the PL/SQL block that contains it.
f)You must code an exception handler to define how you want the
FORM_TRIGGER_FAILURE exception.
Ans:BC(ans doubt)
77)which two statements are true of a Query Record Group?(choose two)
a)The record group is associated with a query.
b)The record group can be created only at run time.
c)The record group can be created and modified only at design time.
d)The record group can be created and modified at design time or at run
time.
Ans:AD
78)Which three statements about display items are true?
a)A display item can be a database item.
b)The content of a display item can be read and change programmatically.
c)If a display item is a part of a control block,its calculation mode
property is ignored.
d)A display item does not have a Format mask property,so a text item must
be used where that functionality is required.
e)The content of a display item can be validated using a Key-Next-Item
trigger with the scope of the display item.
f)A display item does not have a Multi-Line Property, so a text item must
be used where the functionality is required.
Ans:ABF
79)which two statements define a static record group?
a)The record group can be created only at run time.
b)The record group is not associated with a query.
c)The record group can be created and modified only at design time.
d)The record group can be created and modified at design time or at run
time.
Ans:BC
80)An application uses a menu that contains a check type menu item. You
want to programmatically toogle the checked
/unchecked state of the check item.
which two built-ins can you use to accomplish this?(Choose two)
a)FIND_ITEM
b)REPLACE_MENU
c)FIND_MENU_ITEM
d)GET_ITEM_PROPERTY

e)SET_ITEM_PROPERTY
f)SET_MENU_ITEM_PROPERTY
g)GET_MENU_ITEM_PROPERTY
Ans: FG
81)How can you programmatically determine which button a user pressed to
respond to an alert?
a)Use the GET_ALERT_PROPERTY function.
b)Use the GET_ALERT_BUTTON_PROPERTY function.
c)Check the value returned by the SHOW_ALERT function to see if it is 1,2
or 3.
d)Check the value returned by the SHOW_ALERT function to see if it is
ALERT_BUTTON1,ALERT_BUTTON2 and ALERT_BUTTON3.
Ans:d
82)Which of the following are the types parameters passed from calling
form?(choose three)
a)GLOBAL
b)SYSTEM
c)PARAMETER
d)LOCAL
Ans:abc
83)Which of the following built in is used to add elements in list item
at run time?
a)ADD_LIST_ELEMENT()
b)ADD_ELEMENT()
c)ADD_LIST_ELEMENTS()
d)ADD_ELEMENTS()
Ans:a
84)Which of the following contains select statement associated with LOV
in oracle forms?
a)RECORD GROUP
b)BLOCK GROUP
c)OBJECT GROUP
d)PLSQL LIBRARY
Ans:a
85)Which of the following item type has to be chosen for displaying more
than 4 options for a single field?
a)TEXT ITEM
b)RADIO BUTTON
c)LIST ITEM
d)ALL
Ans:c
86)In oracle forms, Business Logic is written in which of the following
languages?
a)Java
b)HTML
c)XML
d)PL/SQL

Ans:d
87)which of the following is valid item type in oracle forms?
a)TEXT ITEM
b)RADIO BUTTON
c)LIST ITEM
d)ALL
Ans:d
88)In forms development, Which GUI item needs to be considered for the
fields like GENDER?
a)RADIO BUTTON
b)CHECK BOX
c)TEXT ITEM
d)DISPLAY ITEM
Ans:a
89)Which of the following builtin is used to clear a list in oracle
forms?
a)CLEAR_LIST_ITEM()
b)FLUSH_ITEM()
c)FLUSH_LIST_ITEM()
d)CLEAR_LIST()
Ans:d
90)Which of the following database can oracle forms connect to?
a)Oracle Database
b)Oracle NoSQL database
c)DB2
d)None
Ans:a
91)How many ALERTS can be created on a single form?
a)1
b)2
c)3
d)Any Number
Ans:d
92)What is the difference between LOV and List item?
Ans: LOV displays multi column information where as the list item
displays single column information.
93)Oracle forms are used to develop front applications in oracle Ebusiness rule?
Ans:True
94)Which of the following are the various ways to print a message in
oracle forms?
a)MESSAGE()
b)DISPLAY()
c)PRINT()
d)None
Ans:a

95)Which of the following library can contain objects such as Data
Blocks, Items, Canvases, windows etc.
a)PLSQL library
b)Object Library
c)Object Navigator
d)Data Library
Ans:b
96)Lucifier Created a Login form. When user login, he should get a
BOOKING form where he can book tickets for a movie.
He wrote the following codein When-button-pressed of Login Button.
BEGIN
CALL_FORM('FORM',NO_HIDE,NO_REPLACE,QUERY_ONLY);
END;
Whenever he has logged in and tried booking details for Avengers. However
when he is typing something in booking
form, he is getting an error "Form is running in query only mode" what is
the reason for this?
Ans: Modify the code in login button as
CALL_FORM('FORM',NO_HIDE,NO_REPLACE,NO_QUERY_ONLY);
97)You wish to have certain values initialized in a form when the form is
first opened. Which trigger
will you use? Choose an appropriate option.
a)WHEN-NEW-FORM
b)PRE-FORM
c)PRE-LOGON
d)WHEN-NEW-FORM-INSTANCE
Ans:b
98)Which built in combination we use to create a parameter list and check
the parameter list created successfully?
a)CREATE_PARAMETER_LIST
b)ID_NULL
c)CREATE_QUERY_PARAMETER_LIST
d)ID-NULL
Ans:AB
99)Which are the valid statements about canvases,windows?(choose three)
a)An application may have a single window into which all canvases are
displayed.
b)Canvases are the form components that are used to display items.
c)Canvases and windows are non-form components.
d)The window is the frame through which the canvas is used.
Ans:ABD
100)Which built-in we can use to toggle checked/unchecked state of the
check item?(choose two)
a)FIND_ITEM
b)SET_MENU_ITEM_PROPERTY
c)GET_MENU_ITEM_PROPERTY
d)GET_ITEM_PROPERTY

Ans: BC
101)Which is the valid statements about obj libraries?
a)Object Libraries are saved as part of the form module.
b)Individuals items cannot be placed into an object library.
c)All Object libraries in the current working directory are opened when
the form builder is opened.
d)Using Object libraries can immense network performance...
Ans:C
102)Which property of relation object is used for the coordination
between a Master and Detail Block in
Master-Detail Form. Choose an appropriate option.
a)Join Condition
b)Delete Record Behaviour
c)Deferred
d)None of the above
Ans:a
103)Which are the valid statements about key triggers?(Choose three)
a)Key triggers change the default behaviour of the function key.
b))Key-trigger fires when the key combination of corresponding function..
c)A function key can be disabled by acting NULL trigger.
d)Key-triggers cannot change the default behaviour of the function key.
Ans:abc
104)What is the physical and logical limit of canvases in a form?
a)No limit
b)10-15
c)1-5
d)2-4
Ans:ab
105) Which builtin should be used to invoke one form from another form
so that you can navigate between the two forms?
a)CALL_FORM
b)OPEN_FORM
c)NEW_FORM
d)RUN_FORM
Ans:b
106)While inserting a radio button in form___ no of radio buttons can be
assigned to a radio group. Choose most appropriate option.
a)Four
b)Unlimited
c)Ten
d)None of the above
Ans: b
107)which of the following property can be set using visual Attribute of
oracle forms?
a)Foreground color
b)Background color
c)Font Name

d)All
Ans:d
108)Following builtin is used to change the property of an alert at
runtime?
a)SET_ITEM_PROPERTY()
b)SET_ALERT_PROPERTY()
c)SET_ALERT()
d)NONE
Ans:b
109)Which application trigger is required to be attached to a text item
to display field for every row record being inserted through
oracle form?
Ans:when-new-record-instance
110)Which of the following is the argument value that allows you to only
read the data from base tables?
Ans:QUERY_ONLY
111)which builtin is used to destroy parameter list from the memory?
Ans:DESTROY_PARAMETER_LIST
112)A single block can be connected to multiple database objects like
table,view or synonym.
Ans:true
113)Which is the VALID statement about FRAMES?
a)Frame is not an object with properties.
b)Each frame cannot be associated with a block.
c)Frames cannot be grouped within an object library.
d)Frames are used to visually group data objects or control objects.
Ans:d
114)You wish to implement the logic for changing a text item as noneditable in a form when the form is loaded into the browser.
In which trigger we can implement the logic.
Ans:when-new-form-instance
115)The customer is filling up the ORDER_ENTRY form. Various triggers are
written for the ITEM_DETAILS text field.
What will be the sequence of firing these triggers for the text item?
Ans:pre-text-item,when-new-item-instance,key-next-item,when-validateitem,post-text-item
116)What is the physical and logical limit of toolbar canvases in a form?
a)No limit,10-15
b)No limit,1-5
c)No limit,10
d)Zero limit,10-15
Ans:a (ans doubt)
117)Which is the valid statement about blocks?
a)A block connected to any database object is called control block.
b)A block not connected to any database object is called data aware
block.

c)A block connected to any database object is called data aware block.
d)A block must be connected to only table.
Ans:c
118)Which builtin will copies the value into the object by name you
specify?
a)COPY
b)COPY_CASE
c)CP_PLAN
d)COPY_IN
Ans:a
119)You wish to implement a list item initially with few values for a
column in a data block and then allow the users to enter the values
in the column at runtime, which list items type will allow you to achieve
this behaviour?
a)A poplist
b)A TList
c)A combo box
d)None
Ans:c
120)which of the following functions can be accomplished only with the
use of key triggers?
a)Navigating between blocks
b)Disabling functions keys
c)Validating data
d)Modifying data before it is committed
e)Changing function key's default functionality
Ans:be
121)which of the following system variable returns the record position
status?
Ans:CURSOR_RECORD

Query record group
A query record group is a record group that has an associated SELECT
statement. Query record groups can be created and modified at design time
or at runtime.
Non-query record group
A non-query record group is a group that does not have an associated
query. Non-query record groups can be created and modified only at
runtime.
Static record group
A static record group is not associated with a query. Static record
groups can be created and modified only at design time.

1. In oracle forms, Which of the following is used to get the item
property at run time?
a)GET_ITEM_PROPERTY()
b)GET_PROPERTY()
c)GET_PROPERTY_ITEM()
d)None
ANS:-a
2. When the user navigates from one record to another record in a block,
which trigger can be fired among the given options?
a)WHEN-NEW-FORM-INSTANCE
b)WHEN-NEW-RECORD-INSTANCE
c)PRE-FORM
d)WHEN-NEW-BLOCK-INSTANCE
ANS:-b
3. Which of the following is considered as the advantage of property
class in Oracle forms?
a)If one or more properties of the data entry field require change, a
property class enables at the other data entry fields on the form to map
to this change.
b)If each property is individually set, then it will be tedious to
maintain the standards in the form. A property class helps to avoid this.
c)To help maintain consistency in the form. Oracle forms builder provides
a solution of property class.
d)All
ANS:-d
4.which of the following is used to capture the type of error?
a)ERROR_TYPE
b)ERROR_NAME
c)ERROR_CATEGORY
d)None
ANS:-a
5.which of the following is used to valid value returned by SHOW_ALERT()
builtin?

a)0
b)1
c)2
d)alert_button1
ANS:-d
6.In oracle forms, Which of the following triggers is used to trap the
check box events when the selection is changed?
a)WHEN-CHECKBOX-CHANGED
b)WHEN-BUTTON-CHANGED
c)WHEN-CHECK-CHANGED
d)WHEN-CHECK-BOX-CHANGED
ANS:-WHEN-CHECKBOX-CHANGED (a)
7.Which of the following property cannot be set using Visual Attribute of
Oracle Forms?
a)Menu Module
b)Font Style
c)Font size
d)Foreground Color
ANS:-a
8.What is the default canvas in forms?
a)Content Canvas
b)Stacked Canvas
c)Horizontal Canvas
d)Tab Canvas
ANS:-a
9.In oracle forms, Which of the following trigger is used to trap the
radio button events when the selection is changed?
a)WHEN-RADIO-CHANGED
b)WHEN-BUTTON-CHANGED
c)WHEN-RADIO-MOVED
d)WHEN-RADIO-BUTTON-CHANGED
ANS:-a
10.Which of the following is not an object of a form module?Choose most

appropriate option.
a)Visual Attributes
b)Property Classes
c)Triggers
d)Menus
ANS:-d
11.In the Master-Detail form, when the user queries for the records in
the master block and starts moving through them,
Which of the following options can occur in the detail block? Choose the
most appropriate option.
a)The detail records can get displayed automatically after the master
record is displayed.
b)The detail records can be displayed only when the cursor is positioned
on the detail block.
c)The detail records can be displayed after the user queries for them in
the detail block.
d)all of the above
ANS:-d
12.Which of the following is used to capture the error code in oracle
forms?
a)ERROR_TYPE
b)ERROR_CODE
c)ERROR_NAME
d)None
ANS:-b
13.In Master detail block, Which of the following property specifies how
the deletion of the record when the master block should affect the detail
block.
a)Delete record behaviour
b)Remove record behaviour
c)Delete Row behaviour
d)Delete Record
ANS:-a

14.Ajay Created a Master Detail Form.
MasterBlock:Customer
DetailBlock:Transaction
When he query Customer block he needs all transactions for that customer
need to be automatically appear in detail block.
What are the valid Relations properties need to be set to meet this
requirement.
a)Deferred: No
Automatic Query: Yes/No
a)Deferred: Yes
Automatic Query: Yes
a)Deferred: Yes
Automatic Query: No
a)Deferred: Yes/No
Automatic Query: Yes
ANS:-a
15.Which of the following is the valid value for SWITCH MENU argument of
open_form builtin?
a)DO_REPLACE
b)REPLACE
c)DO_REMOVE
d)DO_SWITCH
ANS:-a
16.Identify the appropriate trigger that should be created to check that
a primary key value is unique immediately after it is entered by the
operator.
Choose the most appropriate option.
a)WHEN-VALIDATE-ITEM trigger that issues a SELECT statement to check if
the value already exists in the block's datasource.
b)WHEN-NEW-ITEM-INSTANCE trigger that issues a SELECT statement to check
if the value already exists in the block's datasource.
c)POST-TEXT-ITEM trigger that issues a SELECT statement to check if the
value already exists in the block's datasource.

d)None
ANS:-a
17.If user wants to perform DML operations through a called form, in form
to form navigation. Which of the following value has to be assigned to
Query Mode property?
a)QUERY_ONLY
b)NO_QUERY_ONLY
c)QUERY_WRITE
d)None
ANS:- b
18.Raman created Patient details form. He wants to autogenerate
Patient_Id for every new patient record? Which of the following is
appropriate trigger to achieve this requirement?
a)When-new-record-instance
b)post-item
c)When-validate-item
d)Post-record
ANS:-a
19.Which of the following options is used to save the form data?
a)Commit_Form;
b)Clear_Form(DO_COMMIT);
c)clear_form(Ask_commit);
d)All
ANS:-d
20.There are two forms
1. FORM1
2. FORM2
Each of these forms needs to have menu module MENU1 attached.
Which of the following property of FORM1 and FORM2 needs to be given with
MENU1 location?
a)Menu Module
b)Module
c)Module Menu

d)All of the above
ANS:- b
21.Which of the following is a collection of program units that includes
procedures,functions and packages independent of the form module.
a)PL/SQL Library
b)Object Library
c)Collections
d)All
ANS:-a
22.Which of the following builtin is used to move from one block to
another block in oracle forms?
a)GO_BLOCK()
b)MOVE_BLOCK()
c)NAVIGATE_BLOCK()
d)None
ANS:-a
23.Theresa created a form to search for existing employees details.
However she is able to add new employees and able to modify existing
details also,
which should be restricted. Select the appropriate option to achieve this
requirement?
Form Name:EMP_FORM
Data Block Name: Emp
a)set insert allowed to yes,update allowed to yes. Query Allowed Yes in
the property palette of in the Emp Datablock.
b)set insert allowed to no,update allowed to no. Query Allowed Yes in the
property palette of in the Emp Datablock.
c)set insert allowed to no,update allowed to yes. Query Allowed Yes in
the property palette of in the Emp Datablock.
d)set insert allowed to yes,update allowed to no. Query Allowed Yes in
the property palette of in the Emp Datablock.
ANS:-b
24.Which one of these options can be used to raise an error in a form

module?
Choose most appropriate option.
ANS:-RAISE FORM_TRIGGER_FAILURE
25.Laxman created Products form. When he runs the form he is able to
query the existing products and modify them. However he was not able to
add a new product
and getting an error as 'Cannot perform this operation'. What might be
the reason?
a)Update Allowed is set to 'yes' Query Allowed is set to 'yes' and insert
allowed is set to 'yes'.
b)Update Allowed is set to 'yes' Query Allowed is set to 'no' and insert
allowed is set to 'yes'.
c)Update Allowed is set to 'yes' Query Allowed is set to 'yes' and insert
allowed is set to 'no'.
d)Update Allowed is set to 'no' Query Allowed is set to 'yes' and insert
allowed is set to 'no'.
ANS:-c
26.Which of the following form builder module will have .pll extension?
a)Program Library List
b)Primary Library List
c)PL/SQL Library Module Binary
d)Programming List Library
ANS:-c
27.Which of the following module of oracle forms builder a menu can be
attached in the property palette?
a)Form Module
b)PL/SQL Library
c)Object Library
d)All
ANS:-a
28.Which of the following builtin is used to invoke an LOV in forms?
a)SHOW_LOV()
b)OPEN_LOV()

c)LOAD_LOV()
d)CALL_LOV()
ANS:-a
29.Which of the following builtin is used to invoke an alert in oracle
forms?
a)SHOW_ALERT()
b)CALL_ALERT()
c)LOAD_ALERT()
d)INVOKE_ALERT()
ANS:-a
30.Which of the following builtin is used to change the visual attribute
property at runtime?
a)SET_ITEM_PROPERTY()
b)GET_ITEM_PROPERTY()
c)SET_PROPERTY_FORM()
d)SET_ITEM_ATTRIBUTE()
ANS:-a
31.Which of the trigger is used to handle oracle form errors?
a)ON-ERROR
b)WHEN-ERROR-OCCUR
c)WHEN-ERROR-RAISED
d)NEW
ANS:-a
32.Which option should Lucy choose to display the current date in an item
named TransactionDate in the Transaction Module.
Choose most appropriate option.
a)SYSDATE
b)$$SYSDATE$$
c)$$date$$
d)$$currentdate$$
ANS:-c
33.Ram has created a form in which data block is created using wizard,
which of the following builtin is used to perform insertion

operation?
a)FORM_COMMIT;
b)SAVE_COMMIT;
c)COMMIT_FORM;
d)LOG_FORM;
ANS:-c
34.Which of the following builtin is used to retrieve the name of the
item that caused the ON-ERROR trigger to fire?
ANS:-SYSTEM.TRIGGER_ITEM
35.What is the default value for the Menu Module Property for a form.
Choose the most appropriate option.
a)DEFAULT
b)SMARTBAR
c)DEFAULTSMARTBAR
d)DEFAULT&SMARTBAR
ANS:-d
36.Which of the following is a system variable, which holds a value that
indicates whether the current record is the last record in a block?
a)SYSTEM.LAST_RECORD
b)SYSTEM.FINAL_RECORD
c)SYSTEM.RECORD_LAST
d)SYSTEM.LAST_ROW
ANS:-a
37.In oracle forms, Which of the following builtin is used to display a
message?
a)MESSAGE()
b)RAISE_MESSAGE()
c)DISPLAY_MESSAGE()
d)None
ANS:-a
38.Which of the following is not a correct match for component and
executable?
1)Form:.fmx

2)Menu:.mmx
3)PL/SQL Library:.plx
4)Object Library:.olx
a)1
b)2
c)3
d)4
ANS:-d
39.Identify the appropriate display styles of an alert.
a)Stop,Caution,Note
b)Warn,Implify,Stop
c)Caution,Note,Simple
d)None of the above
ANS:-a
40.State True or False
In master detail, If the deferred Property is set to 'Yes' and Automatic
Query is set to 'Yes',The associated detail records are retrieved when
the form
cursor is positioned on the detail block.
ANS:-True
41.To create a 'CUT' (Which cuts the selected text)menu option in menu
module. Which type of menu has to be selected?
a)Magic
b)Plained
c)Checked
d)All
ANS:-a
42.Which of the following builtin is used to change the menu property at
run time?
ANS:-SET_MENU_ITEM_PROPERTY
43.Which of the following function is used to create a record group?
a)CREATE_QUERY_FORM_GROUP()
b)CREATE_GROUP_FROM_QUERY()

c)CREATE_GROUP_QUERY()
d)CREATE_QUERY()
ANS:-b
44.Which of the following is a system variable that holds the value of
the current record number?
ANS:-SYSTEM.CURSOR_RECORD (SYSTEM.CURRENT_RECORD)
45.Which of the following is a valid menu item type in oracle forms?
a)Magic
b)Plain
c)check
d)all
ANS:-d
46.In oracle forms what is the return type of SHOW_LOV() builtin?
a)NUMBER
b)Date
c)VARCHAR2
d)Boolean
ANS:-d
47.Identify the first step that needs to be performed in order to attach
a custom menu module to a form module.
Choose the most appropriate option.
a)creates the executable of the menu module by compiling the same.
b)Attach the menu module to the appropriate form.
c)Create the executable of the menu module by executing the same.
d)None of the above.
ANS:-a
48.Which of the following can be associated only to an item and not to a
module in Oracle forms?
a)Menu
b)Popup Menu
c)Both
d)None
ANS:-Menu (ans doubt)

49.State True/False
An alert can have maximum five buttons.
ANS:-False
50.Which of the following builtin cannot be used in oracle forms?
a)RAISE_APPLICATION_ERROR()
b)CALL_FORM()
c)DBMS_OUTPUT.PUT_LINE()
d)CLEAR_FORM()
ANS:-c
51.Which of the following library can store program units in oracle
forms?
a)PL SQL Library
b)Object Library
c)Object Navigator
d)Data Library
ANS:-a
52.Ram wants to make TOTAL PRICE item to be non-editable in orders form
when the form applets loads. Select the appropriate trigger to achieve
the same.
a)when-new-record-instance
b)when-new-item-instance
c)when-validate-item
d)when-new-form-instance
ANS:-d
53.Customer name is mandatory field in customer form, What are the
different ways to achieve this?
a)Go to property Palette of customer name and set required yes.
b)write a code in when-validate-item of customer name to check whether
customer name is null.If null,raise a form error.
options
a)Only A is correct option
b)only B is correct option
c)Either A or B is suffice

d)Both A and B or needed
ANS:-c
54.Choose the correct line of code to programatically set a visual
attribute named 'VA_ERROR' to item item1 present to block1?
ANS:-SET_ITEM_PROPERTY('block1.item1',current_record_attribute,'VA_ERROR')
;
55.The requirement is to ensure that the fields are loaded with data when
the form opens up.
which trigger can be used for this requirement?
a)when-validate-form
b)pre-form
c)pre-logon
d)post-form
ANS:-b
56.Which of the following operations can be done with the 'when-buttonpressed' trigger?
a)Forms and Block Navigation
b)Saving the Form data
c)Invoking Calculations
d)All
ANS:-d
57.Ramesh has created a form in which data block is created using wizard.
Which of the following builtin and trigger combination
should be used to load the data into the form, when the form loads?
ANS:-When-new-form-instance,EXECUTE_QUERY
58.which of the following trigger can be used to perform datablock level
validation?
ANS:-when-new-block-instance
59.which of the following options can be used to raise an error in a form
module?
a)raise_application_error
b)rise trigger_form
c)raise form_trigger_failure
d)pragma exception init

ANS:-c
60)Which of the following builtin is used to load an image in a image
item?
a)READ_FILE()
b)READ_IMAGE_FILE()
c)READ_IMAGE()
d)LOAD_IMAGE()
ANS:-b
61)What are the different types of delete details we can have on master
detail forms?
ANS:-Non-Isolate,Cascade,Isolate
62)What are the different default triggers created when Master Deletes
Property is set to Cascade?
Master Deletes Property Resulting Triggers
--------------------------------------------------a)Cascading On-Clear-Details
b)On-Populate-Details
c)Pre-delete
d)all
ANS:-d
63)Which of the following contains the select statement associated with
LOV in oracle forms?
a)Record Group
b)Block Group
c)Object Group
d)PLSQL Library
ANS:-a
64)Which of the valid canvas view?
a)Content Canvas
b)Stacked Canvas
c)Horizontal Toolbar Canvas
d)All
ANS:-d

65)The form builder launches a web browser and specifies the URL to run
the form. Inorder to run the form,there must be an
HTTP listener already started and goes by the name
_____________.
a)Form Runtime Listener
b)OC4J HTTP Listener
c)Forms Listener
d)HTTP Listener
ANS:-b
66)Which among the following can be classified as Navigational triggers?
ANS:-Pre-BLock,Post-Form,Post-Record etc...
67)while creating a master-detail form identify the trigger that will get
fired to check if the join column value in the master block is NULL or
not.
ANS:-ON_CHECK_DELETE_MASTER
68)Amit has placed two text items and a push button on the canvas. Pick
the triggers that get executed when he presses the tab key.
a)Post-text-item
b)when-item-pressed
c)pre-text-item
d)key-next-item
ANS:-a,c,d
69)The CUST_DEPT form has called the ORD_DET form for the user to enter
the order details for the customer. The CALL_FORM function has been used
to call
ORD_DET from CUST_DET. what is the feature of the CALL_FORM function?
ANS:-When called form completes the operation, it releases lock and
control goes back to the calling form.
70)Which of the following options are VALID for canvases?
ANS:1.By default, any canvas created, is assigned at runtime to the window
named WINDOW1
2.Content Canvas can be created with the help of Layout wizard,Layout

Editor and Object Navigator.
3.A tab canvas, made up of one or more tab pages, allows you to group and
display a large amount of related information on a single,dynamic canvas
object.
4.A stacked canvas with raise on entry property set to yes can be
displayed only through navigation or programmatic control.
71)Under which situations does the following error occur: No master
Blocks are available.
ANS:-If the foreign key is not defined at the block level.
72)Which of the following functions can be accomplished only with the use
of key triggers?
ANS:1.Changing function keys default functionality
2.Disabling function keys
73)Which of the following module of oracle forms builder a menu can be
attached in the property palette?
a)Form Module
b)PL/SQL cursor
c)Object Library
d)All
ANS:-a
74)Which of the following is used to retrieve the name of the item that
caused the ON-ERROR trigger to fire?
ANS:-SYSTEM.TRIGGER_ITEM
75)In Master Detail Block, Which of the following value has to be set to
'DELETE RECORD BEHAVIOUR' so that a Master record can be deleted, but
the associated Detail Records are not affected?
a)NON-ISOLATED
b)Cascading
c)Isolated
d)All
ANS:-d
76)Which two statements about FORM_TRIGGER_FAILURE are true?(choose two)

a)You cannot raise FORM_TRIGGER_FAILURE in a exception handler.
b)FORM_TRIGGER_FAILURE does not cause an unhandled exception.
c)FORM_TRIGGER_FAILURE causes a trigger to fail in a controlled manner.
d)If you use FORM_TRIGGER_FAILURE to fail a trigger that is called by
another trigger,the called trigger automatically fails.
e)Processing continues after FORM_TRIGGER_FAILURE is raised until the end
of the PL/SQL block that contains it.
f)You must code an exception handler to define how you want the
FORM_TRIGGER_FAILURE exception.
ANS:-BC(ans doubt)
77)which two statements are true of a Query Record Group?(choose two)
a)The record group is associated with a query.
b)The record group can be created only at run time.
c)The record group can be created and modified only at design time.
d)The record group can be created and modified at design time or at run
time.
ANS:-AD
78)Which three statements about display items are true?
a)A display item can be a database item.
b)The content of a display item can be read and change programmatically.
c)If a display item is a part of a control block,its calculation mode
property is ignored.
d)A display item does not have a Format mask property,so a text item must
be used where that functionality is required.
e)The content of a display item can be validated using a Key-Next-Item
trigger with the scope of the display item.
f)A display item does not have a Multi-Line Property, so a text item must
be used where the functionality is required.
ANS:-ABF
79)which two statements define a static record group?
a)The record group can be created only at run time.
b)The record group is not associated with a query.
c)The record group can be created and modified only at design time.

d)The record group can be created and modified at design time or at run
time.
ANS:-BC
80)An application uses a menu that contains a check type menu item. You
want to programmatically toogle the checked
/unchecked state of the check item.
which two built-ins can you use to accomplish this?(Choose two)
a)FIND_ITEM
b)REPLACE_MENU
c)FIND_MENU_ITEM
d)GET_ITEM_PROPERTY
e)SET_ITEM_PROPERTY
f)SET_MENU_ITEM_PROPERTY
g)GET_MENU_ITEM_PROPERTY
ANS:- FG
81)How can you programmatically determine which button a user pressed to
respond to an alert?
a)Use the GET_ALERT_PROPERTY function.
b)Use the GET_ALERT_BUTTON_PROPERTY function.
c)Check the value returned by the SHOW_ALERT function to see if it is 1,2
or 3.
d)Check the value returned by the SHOW_ALERT function to see if it is
ALERT_BUTTON1,ALERT_BUTTON2 and ALERT_BUTTON3.
ANS:-d
82)Which of the following are the types parameters passed from calling
form?(choose three)
a)GLOBAL
b)SYSTEM
c)PARAMETER
d)LOCAL
ANS:-abc
83)Which of the following built in is used to add elements in list item
at run time?

a)ADD_LIST_ELEMENT()
b)ADD_ELEMENT()
c)ADD_LIST_ELEMENTS()
d)ADD_ELEMENTS()
ANS:-a
84)Which of the following contains select statement associated with LOV
in oracle forms?
a)RECORD GROUP
b)BLOCK GROUP
c)OBJECT GROUP
d)PLSQL LIBRARY
ANS:-a
85)Which of the following item type has to be chosen for displaying more
than 4 options for a single field?
a)TEXT ITEM
b)RADIO BUTTON
c)LIST ITEM
d)ALL
ANS:-c
86)In oracle forms, Business Logic is written in which of the following
languages?
a)Java
b)HTML
c)XML
d)PL/SQL
ANS:-d
87)which of the following is valid item type in oracle forms?
a)TEXT ITEM
b)RADIO BUTTON
c)LIST ITEM
d)ALL
ANS:-d
88)In forms development, Which GUI item needs to be considered for the

fields like GENDER?
a)RADIO BUTTON
b)CHECK BOX
c)TEXT ITEM
d)DISPLAY ITEM
ANS:-a
89)Which of the following builtin is used to clear a list in oracle
forms?
a)CLEAR_LIST_ITEM()
b)FLUSH_ITEM()
c)FLUSH_LIST_ITEM()
d)CLEAR_LIST()
ANS:-d
90)Which of the following database can oracle forms connect to?
a)Oracle Database
b)Oracle NoSQL database
c)DB2
d)None
ANS:-a
91)How many ALERTS can be created on a single form?
a)1
b)2
c)3
d)Any Number
ANS:-d
92)What is the difference between LOV and List item?
ANS:- LOV displays multi column information where as the list item
displays single column information.
93)Oracle forms are used to develop front applications in oracle Ebusiness rule?
ANS:-True
94)Which of the following are the various ways to print a message in
oracle forms?
a)MESSAGE()

b)DISPLAY()
c)PRINT()
d)None
ANS:-a
95)Which of the following library can contain objects such as Data
Blocks, Items, Canvases, windows etc.
a)PLSQL library
b)Object Library
c)Object Navigator
d)Data Library
ANS:-b
96)Lucifier Created a Login form. When user login, he should get a
BOOKING form where he can book tickets for a movie.
He wrote the following codein When-button-pressed of Login Button.
BEGIN
CALL_FORM('FORM',NO_HIDE,NO_REPLACE,QUERY_ONLY);
END;
Whenever he has logged in and tried booking details for Avengers. However
when he is typing something in booking
form, he is getting an error "Form is running in query only mode" what is
the reason for this?
ANS:- Modify the code in login button as
CALL_FORM('FORM',NO_HIDE,NO_REPLACE,NO_QUERY_ONLY);
97)You wish to have certain values initialized in a form when the form is
first opened. Which trigger
will you use? Choose an appropriate option.
a)WHEN-NEW-FORM
b)PRE-FORM
c)PRE-LOGON
d)WHEN-NEW-FORM-INSTANCE
ANS:-b
98)Which built in combination we use to create a parameter list and check
the parameter list created successfully?

a)CREATE_PARAMETER_LIST
b)ID_NULL
c)CREATE_QUERY_PARAMETER_LIST
d)ID-NULL
ANS:-AB
99)Which are the valid statements about canvases,windows?(choose three)
a)An application may have a single window into which all canvases are
displayed.
b)Canvases are the form components that are used to display items.
c)Canvases and windows are non-form components.
d)The window is the frame through which the canvas is used.
ANS:-ABD
100)Which built-in we can use to toggle checked/unchecked state of the
check item?(choose two)
a)FIND_ITEM
b)SET_MENU_ITEM_PROPERTY
c)GET_MENU_ITEM_PROPERTY
d)GET_ITEM_PROPERTY
ANS:- BC
101)Which is the valid statements about obj libraries?
a)Object Libraries are saved as part of the form module.
b)Individuals items cannot be placed into an object library.
c)All Object libraries in the current working directory are opened when
the form builder is opened.
d)Using Object libraries can immense network performance...
ANS:-C
102)Which property of relation object is used for the coordination
between a Master and Detail Block in
Master-Detail Form. Choose an appropriate option.
a)Join Condition
b)Delete Record Behaviour
c)Deferred
d)None of the above

ANS:-a
103)Which are the valid statements about key triggers?(Choose three)
a)Key triggers change the default behaviour of the function key.
b))Key-trigger fires when the key combination of corresponding function..
c)A function key can be disabled by acting NULL trigger.
d)Key-triggers cannot change the default behaviour of the function key.
ANS:-abc
104)What is the physical and logical limit of canvases in a form?
a)No limit
b)10-15
c)1-5
d)2-4
ANS:-ab
105) Which builtin should be used to invoke one form from another form
so that you can navigate between the two forms?
a)CALL_FORM
b)OPEN_FORM
c)NEW_FORM
d)RUN_FORM
ANS:-b
106)While inserting a radio button in form___ no of radio buttons can be
assigned to a radio group. Choose most appropriate option.
a)Four
b)Unlimited
c)Ten
d)None of the above
ANS:- b
107)which of the following property can be set using visual Attribute of
oracle forms?
a)Foreground color
b)Background color
c)Font Name
d)All

ANS:-d
108)Following builtin is used to change the property of an alert at
runtime?
a)SET_ITEM_PROPERTY()
b)SET_ALERT_PROPERTY()
c)SET_ALERT()
d)NONE
ANS:-b
109)Which application trigger is required to be attached to a text item
to display field for every row record being inserted through
oracle form?
ANS:-when-new-record-instance
110)Which of the following is the argument value that allows you to only
read the data from base tables?
ANS:-QUERY_ONLY
111)which builtin is used to destroy parameter list from the memory?
ANS:-DESTROY_PARAMETER_LIST
112)A single block can be connected to multiple database objects like
table,view or synonym.
ANS:-true
113)Which is the VALID statement about FRAMES?
a)Frame is not an object with properties.
b)Each frame cannot be associated with a block.
c)Frames cannot be grouped within an object library.
d)Frames are used to visually group data objects or control objects.
ANS:-d
114)You wish to implement the logic for changing a text item as noneditable in a form when
the form is loaded into the browser.
In which trigger we can implement the logic.
ANS:-when-new-form-instance
115)The customer is filling up the ORDER_ENTRY form. Various triggers are
written for the ITEM_DETAILS text field.
What will be the sequence of firing these triggers for the text item?
ANS:-pre-text-item,when-new-item-instance,key-next-item,when-validateitem,post-text-item

116)What is the physical and logical limit of toolbar canvases in a form?
a)No limit,10-15
b)No limit,1-5
c)No limit,10
d)Zero limit,10-15
ANS:-a (ans doubt)
117)Which is the valid statement about blocks?
a)A block connected to any database object is called control block.
b)A block not connected to any database object is called data aware
block.
c)A block connected to any database object is called data aware block.
d)A block must be connected to only table.
ANS:-c
118)Which builtin will copies the value into the object by name you
specify?
a)COPY
b)COPY_CASE
c)CP_PLAN
d)COPY_IN
ANS:-a
119)You wish to implement a list item initially with few values for a
column in a data block and then allow the users to enter the values
in the column at runtime, which list items type will allow you to achieve
this behaviour?
a)A poplist
b)A TList
c)A combo box
d)None
ANS:-c
120)which of the following functions can be accomplished only with the
use of key triggers?
a)Navigating between blocks
b)Disabling functions keys

c)Validating data
d)Modifying data before it is committed
e)Changing function key's default functionality
ANS:-be
121)which of the following system variable returns the record position
status?
ANS:-CURSOR_RECORD
Query record group
A query record group is a record group that has an associated SELECT
statement. Query record groups can be created and modified at design time
or at runtime.
Non-query record group
A non-query record group is a group that does not have an associated
query. Non-query record groups can be created and modified only at
runtime.
Static record group
A static record group is not associated with a query. Static record
groups can be created and modified only at design time.

MCQ 2

1. WHICH OF THE FOLLOWING PL SQL COLLECTION HAS TO BE INITIALLY DENSE AND CAN BECOME
SPARSE IF NEEDED?
ANS: NESTED TABLE
2. IDENTIFY THE EXTERNAL LOB CHOOSE MOST APPROPRIATE OPTION?
ANS: BFILE
3. WHICH OF THE FOLLOWING PACKAGE IS USED TO IMPLEMENT DYNAMIC SQL?
ANS: DBMS_SQL
4. WHICH OF THE COLLECTION TYPES ARE USABLE AS COLOUMN DATATYPE IN A TABLE?
ANS: VARRAY AND NESTED TABLE
5. BFILE CAN BE ACCESSED IN BOTH READ AND WRITE MODE SAY TRUE OR FALSE?
ANS: FALSE
6. CONSIDER THE PROCEDURE GIVEN BELOW.
CREATE OR REPLACE PROCEDURE PROC_1 AS

num 1 NUMBER(2);
num2 NUMBER(2);
ans NUMBER(3);
BEGIN
ans = num1+num2;
DBMS _OUTPUT.PUT_LINE(‘SUM IS’|| ANS);
END;
ASSUMING THAT THE APPROPRIATE PROCEDURE IS CREATED SUCCESSFULLY, IDENTIFY THE VALID
OPTION THAT IS USED TO EXECUTE THE PROCEDURE.CHOOSE APPROPRIATE OPTION?
ANS: EXEC PROC_1
7. CONSIDERING THE PRESENCE OF THE COLOUMN NAMED ‘ENAME’ IN ‘EMP’ TABLE AND ALSO 1234
EMPLOYEE NUMBER, CHOOSE THE APPROPRIATE OUTPUT THE GIVEN BELOW.
DECLARE
V_ENAME VARCHAR2;
BEGIN
SELECT ENAME INTO V_ENAME FROM EMP WHERE EMPNO=1234;
DBMS_OUTPUT.PUT_LINE (V_ENAME);
END;/
ANS: ERROR AT LINE 2
8. THE OLD AND NEW QUALIFIERS CAN BE USED IN WHICH TYPE OF TRIGGER? CHOOSE THE MOST
APPROPRIATE OPTION?
ANS: ROW LEVEL DML TRIGGER
9. IN ORACLE PL/SQL , WHICH OF THE FOLLOWING CAN BE USED AS RELATIONAL NOT EQUAL TO
OPERATOR?
ANS: ALL (!=,<>,~= )
10. WHICH OF THE FOLLOWING TYPE OF ORACLE PL/SQL COLLECTION IS USED FOR SPARSE
COLLECTION THROUGH OUT ITS LIFE TIME?

ANS: ASSOCIATED ARRAY
11. CONSIDERING THE PRESENCE OF A TABLE STUDENT WITH COLOUMNS MARKS .
PREDICT THE OUTPUT OF THE BELOW TRIGGER EXECUTION WHEN AN UPDATE OPERATION IS
PERFORMED ON MARKS COLUMN OF STUDENT TABLE (WITH SET SERVEROUTPUT ON)
CREATE OR REPLACE TRIGGER UPDATED_MARKS
AFTER UPDATE ON STUDENT
BEGIN
DBMS_OUTPUT.PUT_LINE (“OLD MARKS ARE:”||:OLD MARKS||”NEW MARKS ARE:”||:NEW MARKS);
END ?
ANS: IT WILL RAISE AN ERROR AS :OLD AND :NEW CANNOT BE USED
14. CONSIDERING THE PRESENCE OF COLOUMNS SALARY,EMPLOYEE_ID IN EMPLOYEES TABLE AND
ABSENCE OF EMPLOYEE WITH EMPLOYEE_ID 100.
PREDICT THE OUTCOME OF THE BELOW FUNCTION CREATION.
CREATE OR REPLACE FUNCTION ANNUALSALARY
RETURN NUMBER
IS
V_ASAL NUMBER;
BEGIN
SELECT SALARY*12 INTO V_ASAL FROM EMPLOYEES WHERE EMPLOYEE_ID=100;
RETURNV_ASAL;
END;
ANS: FUNCTION CREATES WITH COMPILATION ERRORS AS SIZE IS MENTIONED FOR/FUNCTION GETS
CREATED WITH RUNTIME ERRORS
13. WITH RESPECT TO A CONDITION PREDICATE IN A DML TRIGGER.CHOOSE MOST APPROPRIATE
OPTION?
ANS: A CONDITIONAL PREDICATE ALLOWS YOU TO COMBINE SEVERAL DML TRIGGERING EVENTS
INTO ONE
14. WHICH OF THE FOLLOWING IS CORRECT TRIGGER TO CHECK UPDATE ON EMP TABLE BETWEEN
9AM AND 6PM?CHOOSE THE MOST APPROPRIATE OPTION?
ANS: CREATE OR REPLACE TRIGGER EMP_UPDATE_CHECK
BEFORE UPDATE ON EMP
BEGIN
IF(TO_CHAR(SYSDATE. ‘HH24’) BETWEEN ‘9’ AND ‘18’) THEN
RAISE_APPLICATION_ERROR(-2055, ‘MODIFICATION OF EMPLOYEE NOT P**** DURING
BUSINESS HOURS’);
END IF;
END;
/
15. WHICH OF THE FOLLOWING CAN BE A TRIGGERING EVENT FOR A INSTEAD OF TRIGGERIN ORACLE
DATABASE?
ANS: DML
16. WHICH OF THE FOLLOWING CANNOT BE INCLUDED IN A PL/SQL PACKAGE? CHOOSE THE MOST
APPROPRIATE OPTION?
ANS: TRIGGERS
17. WHICH OF THE FOLLOWING PACKAGE IS USED TO PERFORM OPERATIONS ON LOBS?
ANS: DBMS_LOB
18. WHICH PARAMETER MODE IN PL/SQL NEEDS A BIND VARIABLE WHEN PROCEDURE OR FUNCTION

IS EXECUTED AT SCHEMA LEVEL?
ANS: ALL (IN,OUT,OUT IN)

19. HOW MANY TIMES A BEFORE UPDATE ROW LEVEL TRIGGER WILL EXECUTE IF THE UPDATE
STATEMENT IS AFFECTING 10 ROWSIMMEDIATE
ANS: 10
20. ORACLE PL/SQL SUPPORTS FOLLOWING NUM1PES?
ANS: BOTH
21. WHICH OF THE FOLLOWING IS ORACLE PL/SQL COLLECTION CANNOT BE DEFINED AT SCHEMA
LEVEL?
ANS: ASSOCIATIVE ARRAY
22. CONDITIONAL EXECUTION OF A TRIGGER CAN BE ACHIEVED USING THE .............CLAUSE.FILL IN
THE BLANKS WITH AN APPROPRIATE OPTION?
ANS: WHEN
23. WHATS OF THE FOLLOWING IS A VALID EXCEPTION CODE THAT A USER CAN GIVE FOR USER
DEFINED EXCEPTION?
ANS: -2999
24 ..............................ATTRIBUTE IS USED TO DECLARE A VARIABLE FOR HANDLING TABLE RECORDS
AND ALSO FOR AN EXPLICIT CURSOR RECORDS? FILL IN THE BLANK WITH AN APPROPRIATE OPTION?
ANS: %ROWTYPE
25. WHICH OF THE FOLLOWING ABOUT EXISTS METHODS OF PL/SQL COLLECTION IS TRUE?
ANS: RETURNS TRUE IF AND ONLY IF SPECIFIED ELEMENT OF ASSOCIATIVE ARRAY OR VARRAY OR
NESTED TABLE EXITS.
26. WHICH OF THE FOLLOWING STATEMENT IS TRUE FOR REGARDING A DATABASE TRIGGER?CHOOSE
THE MOST APPROPRIATE OPTION?
ANS: A BLOCK OF CODE WHICH IS IMPLICITLY INVOKED UPON OCCURRENCE OF A DATABASE EVENT

27. CAN PROJECT TEAM CUSTOMIZED PRE CONFIGURED VALIDATION RULES IN RA?
ANS: YES
28. WHICH OF THE FOLLOWING TYPE OF EXCEPTION WILL NOT HAVE A BUILTIN EXCEPTION NAME IN
PL/SQL?
ANS: NON PREDEFINED EXCEPTIONS
29. WHICH OF THE FOLLOWING IS/ARE A PREDEFINED EXCEPTION? 1. VALUE_ERROR 2.
INVALID_NUMBER
ANS: BOTH 1 and 2
30. PREDICT THE OUTCOME OF THE BELOW PROCEDURE CREATION.(LINE NUMBERS ARE ONLY FOR
REFERNCE AND NEED TO BE EXCLUDED WHILE CREATION)
1. CREATE OR REPLACE PROCEDURE DROP_TABLE(P_TNAME VARCHAR2)
2. IS
3. BEGIN
4. EXECUTE IMMEDIATE ‘DROP FROM ‘||P_TNAME
5. END;
6. /
ANS: PROCEDURE GETS CREATED WITH COMPILATION ERRORS AS THERE IS AN ERROR AT LINE 4
31. CONSIDER A BIND VARIABLE DECLARED AND VALUE ASSIGNED AS BELOW TWO STATEMENTS.
VARIABLE P_ENO NUMBER;
EXEC :P_ENO=100;

NOW CONSIDER THE BELOW FUNCTION CREATION CODE. CONSIDERING THE PRESENCE OF
COLOUMNS SALARY,EMPLOYEE_ID IN A TABLE EMPLOYEES.PREDICT THE RESULT OF THE FUNCTION
WHEN EXECUTED AFTER ITS CREATION.
CREATE OR REPLACE FUNCTION ANNUALSAL(P_ENO NUMBER)
RETURN NUMBER
IS
V_ASAL NUMBER
BEGIN
SELECT SALARY*12 INTO V_ASAL FROM EMPLOYEES WHERE EMPLOYEE_ID=P_ENO;
RETURN V_ASAL;
END;
ANS: IT WILL RETURN THE ANNUAL SALARY OF AN EMPLOYEE IF….PRESENT.OTHERWISE RAISES AN
EXCEPTION
32. CONSIDERING THE PRESENCE OF A COLOUMN NAMED ‘FIRST_NAME’ IN ’EMP’ TABLE.CHOOSE
THE OUTPUT OF THE BELOW PROGRAM.
1.DECLARE
2. TYPE T1 IS TABLE OF VARCHAR2(20);
3. V1 T1;
4. BEGIN
5. SELECT FIRST_NAME BULK COLLECT INTO V1 FROM EMP;
6. DBMS_OUTPUT.PUT_LINE(V1);
7. END;
ANS: ERROR AT LINE NUMBER 6
33. WHAT IS THE SQLCODE OF EXCEPTION WITH NAME NO_DATA_FOUND?
ANS: 100
34. CONSIDER THE FOLLOWING CODE, PREDICT THE OUT OF THE PROGRAM? DECLARE TYPE NUMLIST
IS TABLE OF NUMBER N NUMLIST= NUMLIST,(10,20,30,40,50,60,70,80,90,100) BEGIN NDELETE(3,6)
END?
ANS : DELETE THE ELEMENTS 3 THROUGH 6
35. CONSIDERING THE PRESENCE OF COLOMNS SALARY, EMPLOYEE_ID, ENAME IN EMPLOYEES
TABLE.WHERE EMPLOYEE_ID IS A PRIMARY KEY CONSTRAINED COLOUMN.PREDICT THE OUTCOMEOF
THE BELOW PROCEDURE CREATION.
CREATE OR REPLACE PROCEDURE NEW_EMPLOYEE (P_ENAME VARCHAR2, P_SAL NUMBER)
IS
BEGIN
INSERT INTO EMPLOYEES (ENAME, SALARY) VALUES(P_ENAME, P_SAL);
COMMIT;
END;
ANS: PROCEDURE WILL BE CREATED WITH RUNTIME ERRORS
36. PREDICT THE OUTPUT OF BELOW CODE.DECLARE V_VAR1 NUMBER, V_VAR2 V_VAR1%TYPE;
BEGIN V_VAR 2 = ‘A’ ; DBMS_OUTPUT.PUT_LINE(V_VAR2); END?
ANS: NUMERIC OR VALUE ERROR
37. CONSIDERING THE PRESENCE OF COLOUMN ENAME IN NEW_EMP TABLE,PREDICT THE OUTCOME
OF THE FOLLOWING TRIGGER.CREATE OR REPLACE TRIGGER UPPER_TRIG BEFORE INSERT OR UPDATE
OF ENAME ON NEW_EMP FOR EACH ROW BEGIN NEW.ENAME=UPPER(:OLD.ENMAE); END;
ANS: TRIGGER GETS CREATED SUCCESSFULLY
38. WHICH OF THE FOLLOWING COLLECTION TYPE CAN BE CREATED BOTH SCHEMA LEVEL AND IN
PL/SQL BLOCK?
ANS: NESTED TABLE

39. PREDICT THE OUTPUT OF THE FOLLOWING CODE?DECLARE E_EXCEPTION EXCEPTION BEGIN
DECLARE E_EXCEPTION EXCEPTION BEGIN RAISE E_EXCEPTION END EXCEPTION WHEN E_EXCEPTION
THEN DBMS_OUTPUT.PUT_LINE(“HANDLED IN E_HANDLING EXCEPTION”) WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE(“HANDLED IN WHEN OTHERS SECTION”) END?
ANS: HANDLED IN WHEN OTHERS SECTION
40. WHICH PL/SQL COLLECTION TYPE WOULD FIT IN THE BELOW SCENARIO.THE PRESENT STUDENTS
DTA OF DISCIPLINE CSE(COMPUTER SCIENCE AND ENGINEERING) IN A COLLEGE WITH MAXIMUM 60?
ANS: VARRAY
41. CONSIDERING THE PRESENCE OF THE COLOUMN NAMED ‘ENAME ’ AND ‘SAL ‘ IN ‘EMP ’ TABLE
AND ALSO 1234 EMPLOYEE NUMBER ,CHOOSE THE OUTPUT OF THE BELOW PROGRAM.DECLARE
V_ENAME VARCHAR2; V_SAL NUMBER; BEGIN SELECT *12 INTO V_SAL FROM EMP WHERE
EMPNO=1234;SELECT ENAME INTO V_ENAME FROM EMP WHERE
EMPNO=1234;DBMS_OUTPUT.PUT_LINE (V_ENAME);END;?
ANS: EXCEPTION AT LINE NUMBER 5 AS THERE IS NO EMPLOYEE WITH EMPLOYEE NUMBER 1234.
42. WHICH STATEMENT IS TRUE ABOUT TRIGGERS?CHOOSE MOST APPROPRIATE OPTION?
ANS: YOU USE A DATABASE TRIGGER TO FIRE WHEN AN INSERT STATEMENT OCCOURS.
43. WHICH OF THE FOLLOWING PL/SQL COLLECTION WILL ALLOW INDEC BY OF VARCHAR2 DATA
TYPE?
ANS: ASSOCIATIVE ARRAY
44. WHICH OF THE FOLLOWING IS NOT A PREDEFINED EXCEPTION?
ANS: COLLECTION_NULL
45. WHICH OF THE FOLLOWING BUILTIN IS USED TO ASSOCIATE A EXECPTION NAME FOR A NONPREDEFINED EXCEPTION?
ANS: EXCEPTION_INIT()
46. IDENTIFY THE COMPONENT OF A LOB THAT REFERENCES TOWHERE THE LOB VALUE IS PHYSICALLY
STORED.CHOOSE APPROPRIATE OPTION?
ANS: LOB LOCATOR.
47. WHAT WILL HAPPEN IF A FUNCTION IS DEFINED IN PACKAGE BODY WITH OUT DEFINING THE
FUNCTION SPECIFICATION IN PACKAGE SPECIFICATION?
ANS: IT IS CALLED AS PRIVATE FUNCTION AND YOU WILL ABLE TO ACCESS
48. WHICH OF THE FOLLOWING IS THE SQL CODE FOR EXCEPTION WITH NAME TOO_MANY_ROWS?
ANS: - 1422
49. WHICH PROCEDURE CAN BE USED TO CREATE A CUSTOMIZED ERROR MESSAGE?CHOOSE MOST
APPROPRIATE OPTION?
ANS: RAISE_APPLICATION_ERROR
50. WHICH OF THE FOLLOWING IS NOT A VALID INDEX BY DATATYPES IN ASSOCIATIVE ARRAYS?
ANS: DATE
51. HTML VALIDATION REPORT IN PIVOT IS USED BY
ANS:PL/SQL DEVELOPER
52. IN ORACLE PL/SQL ,WHICH OF THE FOLLOWING IS STORED AS A DATABASE OBJECT WHEN ONCE
CREATED?
ANS: ALL
53. WHICH OF THE FOLLOWING IS A BOUNDED AND DENSE COLLECTION IN PL/SQL?

ANS: VAARAY
--54. IN WHICH OF THE FOLLOWING OPTION BEST DESCRIBES TOO_MANY_ROWS NAMED
EXCEPTIONS.CHOOSE APPROPRIATE OPTION?
ANS:PRE-DEFINED EXCEPTION
55. NON-PREDEFINED EXCEPTION CAN BE DEFINED WITH NAME USING .CHOOSE MOST APPROPRIATE
OPTION?
ANS: PRAGMA EXCEPTION_INIT
56. VIEWS CREATE A COPY OF THE DATA FROM THE BASE TABLE?
ANS: TRUE
57. ORACLE PL/SQL SUPPORTS FOLLOWING DATATYPE?
ANS: BOTH (SCALAR AND COMPOSITE)
58. WHICH OF THE FOLLOWING IA VALID NAMED BLOCK IN ORACLE PL/SQL?
ANS: ALL (STORED PROCEDURE, FUNCTION, TRIGGER)
59. WHICH OF THE FOLLOWING COLLECTION IS A SPARSE BY IT’S NATURE?
ANS: ASSOCIATIVE ARRAY
60. WHICH OF THE FOLLOWING PL/SQL COLLECTION IS DENSE THROUGH OUT ITS EXISTENCE IN A
PROGRAM EXECUTION?
ANS :- VARRAY
61. IN ORACLE DATABASE, WHICH TRIGGER CAN BE CREATED ON DATABASE OBJECT TABLE?
ANS :- DATABASE TRIGGER
62. WHICH PL/SQL BUILTIN PROCEDURE IS USED TO RAISE A USER-DEFINED EXCEPTION IN ORACLE
PL/SQL?
ANS :- RAISE_APPLICATION_ERROR()
--63. IN ORACLE DATABASE, WHICH TRIGGER TIMING CAN BE CREATED ON DATABASE OBJECT VIEW?
ANS :- INSTEAD OF
64. WHICH OF THE FOLLOWINF IS A VALID COLLECTION TYPE IN PL/SQL?
ANS :- PL/SQL TABLE
65. WHICH OF THE FOLLOWING IS A BOUNDED COLLECTION IN ORACLE PL/SQL?
ANS :- VARRAY
66. WHICH OF THE FOLLOWING IS A VALID TRIGGER TIMING IN ORACLE PL/SQL?
ANS :- ALL (BEFORE, AFTER, INSTEADOF)
67. WHICH OF THE FOLLOWING IS A VALID PL/SQL COLLECTION BUILTIN?
ANS :- ALL (COUNT, DELETE, TRIM)
--68. IN ORACLE PL/SQL, WE CAN IMPLEMENT POLYMORPHISM USING WHICH OF THE FOLLOWING
COMPONENT?
ANS :69. WHICH OF THE FOLLOWING IS A VALID PREDEFINED EXCEPTION IN PL/SQL?
ANS :- NO_DATA_FOUND
70. WHICH OF THE FOLLOWING IS SERVER SIDE PROGRAM IN PL/SQL?
ANS :- ALL(STORED PROCEDURE, FUNCTION, PACKAGE)

71. WHICH OF THE FOLLOWING IS MANDATORY IN PL/SQL FUNCTION?
ANS :- HAVING RETURN STATEMENT
72. WHICH OF THE FOLLOWING IS A VALID TRIGGER TYPE IN PL/SQL?
ANS :- BOTH(ROW LEVEL AND STATEMENT LEVEL)
73. :NEW AND :OLD QUALIFIERS CAN BE USED ONLY IN ROW LEVEL TRIGGER?
ANS : TRUE
74. WHICH OF THE FOLLOWING APPROACHES ARE USED TO IMPLEMENT DYNAMIC SQL?
ANS : BOTH (USING EXECUTE IMMEDIATE AND USING DBMS_SQL PACKAGE)