Oracle Database Questions and Answers – Programmatic Oracle Structures

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

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
View Answer

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
View Answer

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

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

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
View Answer

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.
Note: Join free Sanfoundry classes at Telegram or Youtube

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

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
View Answer

Answer: c
Explanation: In Oracle NULL values represent missing unknown data.
advertisement

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

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.
advertisement

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

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;
View Answer

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.

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]

advertisement
advertisement
Subscribe to our Newsletters (Subject-wise). Participate in the Sanfoundry Certification contest to get free Certificate of Merit. Join our social networks below and stay updated with latest contests, videos, internships and jobs!

Youtube | Telegram | LinkedIn | Instagram | Facebook | Twitter | Pinterest
Manish Bhojasia - Founder & CTO at Sanfoundry
Manish Bhojasia, a technology veteran with 20+ years @ Cisco & Wipro, is Founder and CTO at Sanfoundry. He lives in Bangalore, and focuses on development of Linux Kernel, SAN Technologies, Advanced C, Data Structures & Alogrithms. Stay connected with him at LinkedIn.

Subscribe to his free Masterclasses at Youtube & discussions at Telegram SanfoundryClasses.