This set of Oracle Database Multiple Choice Questions & Answers (MCQs) focuses on “Programmatic Oracle Structures”.
1. What does DLL stand for ?
a) Dynamic Link Library
b) Dynamic Language Library
c) Dynamic Load Library
d) None of the Mentioned
View Answer
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
View Answer
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
View Answer
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
View Answer
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
View Answer
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
View Answer
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
View Answer
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
View Answer
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. What will be the value of svar after execution?
Declare fvar number :=null; svar number :=5; Begin goto <<>> if fvar is null then <<>> svar:=svar+5; end-if; End;
a) Error
b) 10
c) 5
d) None of the Mentioned
View Answer
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;
View Answer
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.
Sanfoundry Global Education & Learning Series – Oracle Database.
To practice all areas of Oracle Database, here is complete set of 1000+ Multiple Choice Questions and Answers.
If you find a mistake in question / option / answer, kindly take a screenshot and email to [email protected]
- Check Oracle Database Books
- Practice Programming MCQs
- Apply for Programming Internship
- Check Information Technology Books