Oracle Database Multiple Choice Questions and Answers on Programmatic Oracle Structures for Freshers

1. What does DLL stand for ?

a) Dynamic Link Library
b) Dynamic Language Library
c) Dynamic Load Library
d) None of the Mentioned

Answer: a

Explanation: DLL, linking occurs at run time when the routine is actually used. This results in much smaller executable because routines are pulled in only as needed.

2. POST-BLOCK trigger is also a ?

a) Navigational Trigger
b) Key Trigger
c) Transaction Trigger
d) All of the Mentioned

Answer: a

Explanation: Pre- and Post- triggers fire as Form Builder navigates internally through different levels of the object hierarchy.When-New-Instance triggers fire at the end of a navigational sequence that places the input focus in a different item.

3. The system variable that records the select statement that SQL * FORMS most recently used to populate a block is __________

a) SYSTEM.LAST_RECORD
b) SYSTEM.CURSOR_RECORD
c) SYSTEM.CURSOR_FIELD
d) SYSTEM.LAST_QUERY

Answer: d

Explanation: SYSTEM.LAST_QUERY system variable represents the query statement used by Forms to populate a data block during run-time.

4. In Oracle, which of the following package procedure is UNRESTRICTED ?

a) CALL_INPUT
b) CLEAR_BLOCK
c) EXECUTE_QUERY
d) USER_EXIT

Answer: d

Explanation: A user exit is a C subroutine and called by Oracle Forms to do special-purpose processing.It can display messages on the Oracle Forms status line, get and set field values, do high-speed computations and table look-ups, and manipulate Oracle data.

5. What is SQL * FORMS ?

a) SQL * FORMS is a 4GL tool for developing and executing Oracle based interactive based application
b) SQL * FORMS is a 3GL tool for connecting to a Database
c) SQL * FORMS is a reporting tool
d) None of the Mentioned

Answer: a

Explanation: SQL*Forms is a general-purpose tool for developing and executing forms-based interactive applications. The design component of this tool is specially designed for application developers and programmers.

6. Which of the following statement is false ?

a) Any procedure can raise a error and return an user message and error number
b) Error number is ranging from 20000 to 20999 are reserved for user defined messages
c) Oracle checks Uniqueness of User defined errors
d) Raise_Application_error is used for raising an user defined error

Answer: c

Explanation: The UNIQUE constraint uniquely identifies each record in a database table.The UNIQUE and PRIMARY KEY constraints both provide a guarantee for uniqueness for a column or set of columns.

7. What is the result of the following ‘PAN’NULL’KAJ’?

a) Error
b) PAN KAJ
c) PANKAJ
d) NULL

Answer: c

Explanation: In Oracle NULL values represent missing unknown data.

8. Below is the EMP table

EMPNO     ENAME     SALARY
A29       PANKAJ    10000 
A23       SAHIL     20000
A48       ABHYUDAY   
A83       KRISHNA   30000 

Select count(SALARY) from EMP; will result in

a) 1
b) 0
c) 3
d) None of the Mentioned

Answer: c

Explanation: The COUNT() function returns the number of rows that matches a specified criteria.The COUNT(column_name) function returns the number of values (NULL values will not be counted) of the specified column.

9.

Declare 
 fvar number :=null;
 svar number :=5;
   Begin 
 goto <<>>
  if fvar is null then 
   <<>>
  svar:=svar+5;
  end-if;
  End; 

What will be the value of svar after execution?

a) Error
b) 10
c) 5
d) None of the Mentioned

Answer: a

Explanation:Error, line 5 has error.Column 7:PLS-00103: Encountered the symbol “<” when expecting one of the identifier to execute the query.

10. Which of the following queries displays the sum of all employee salaries for those employees not making commission, for each job, including only those sums greater than 2500?

a) select job, sum(Sal) from Emp where sum(Sal) > 2500 and comm is null;
b) select job, sum(Sal) from Emp where comm is null group by job having sum(Sal) > 2500;
c) select job, sum(Sal) from Emp where sum(Sal) > 2500 and comm is null group by job;
d) select job, sum(Sal) from Emp group by job having sum(Sal) > 2500 and comm is not null;

Answer: b

Explanation: SELECT column_name, aggregate_function(column_name)
FROM table_name
WHERE column_name operator value
GROUP BY column_name
HAVING aggregate_function(column_name) operator value;
So base on [select job, sum(Sal) from Emp where comm is null group by job having sum(Sal) > 2500;] this will be the correct answer.