If you are an expert in Oracle Packages then this is for you. Let us know if you looking for a job change? Then do not worry, we’ve a right answer for your job interview preparation. If you are preparing for Oracle Packages job interview then go through Wisdomjobs interview questions and answers page. Oracle Packages is the set of schema objects which are grouped together. It can have variables, types, exceptions, constants and more. These packages are stored in database upon compilation to make it reachable to every application to access. Good knowledge on the Oracle Packages are must to crack the job. Below are the Oracle Packages interview questions and answers which makes you comfortable to face the interviews:
Question 1. Who Owns The Operating System Files Created By The Utl_file Package?
Answer :
The operating system files generated by utl_file are owned by operating system user Oracle.
Question 2. What Do You Understand By Flashback Feature Of Oracle?
Answer :
Flashback feature allows you to use a flashback version of the database, that is, you can query the database from a state in the past based on a specific System Change Number (SCN) or time in the past.
Question 3. How Can You Communicate With Operating System Files From Oracle?
Answer :
Question 4. Does Oracle Provide Any Package To Deal With Materialized Views?
Answer :
You can use the dbms_mview package to deal with materialized views. It is also called dbms_snapshot.
Some of the procedures provided by the dbms_mview packages are as given follows:
Question 5. How Can You Create A User Defined Lock?
Answer :
The dbms_lock package can be used to create user defined locks.
Question 6. Does Oracle Support Asynchronous Notification?
Answer :
Oracle supports asynchronous notification using the dbms_alert package.
Question 7. How Can You Get Actual Data Change Values From Previous Transactions In Oracle?
Answer :
Oracle provides a feature called log minner, which can be used to view data changes from previous transactions.
Question 8. Explain The Major Functions Provided By The Dbms_stats Procedure?
Answer :
The dbms_stats procedure performs the following general functions:
Question 9. What Is The Use Of Recording Information About Current Session?
Answer :
Question 10. What Is A User Defined Lock?
Answer :
Question 11. What Functionality Does Oracle Provide To Secure Sensitive Information?
Answer :
Question 12. List Some Of The Procedures Provided By The Dbms_aq Package?
Answer :
Some of the procedures provided by the dbms_aq package are enqueue, dequeue, register and unregister.
Question 13. How Can You Grant Privileges On Aq To Other Users?
Answer :
Question 14. How Can You Enable Flashback Feature?
Answer :
Oracle provides the dbms_flashback package to use flashback feature.
The package has the following procedures to facilitate this feature:
Question 15. How Does Oracle Facilitate Communication Between Different Sessions?
Answer :
Question 16. How Can You Record Information About Current Session?
Answer :
Oracle provides a package called dbms_application_info. This package can be used to set information about current session.
Question 17. What Are The Benefits Of Flashback Feature?
Answer :
Flashback feature provides the following benefits:
Question 18. What Do You Understand By Fine Grained Auditing?
Answer :
Question 19. What Is The Commonly Used Procedure Of The Dbms_lock Package?
Answer :
Question 20. Can You Redefine A Table Online?
Answer :
Yes, you can use the dbms_redefinition package to redefine a table online.
Question 21. How Can You Find Out If A Table Can Be Redefined?
Answer :
You can use the dbms_redefinition.can_redef_table procedure to determine if a table can be redefined.
Question 22. How Can A Session Indicate Its Interest In Receiving Alerts?
Answer :
A session can register itself for a specific type of alert or a alerts by using the register procedure. Such sessions are called waiting session.
Question 23. Which Procedures Can You Use To Encrypt And Decrypt Data In Different Formats?
Answer :
Following procedures can be used to encrypt or decrypt data in different formats:
Question 24. What Procedures Can You Use To Register With An Aq?
Answer :
Question 25. How Can You Implement Fine Grained Auditing?
Answer :
Oracle has provided a package called dbms_fga to implement fine grained auditing.
It contains the following procedures:
Question 26. How Can You Manage Optimizer Statistics?
Answer :
Question 27. How Can You Schedule A Job In Database?
Answer :
You can use the dbms_scheduler package to create and schedule a database job.
Question 28. Name Some Of The Procedures Available In The Dbms_application_info Package?
Answer :
The procedures available in the dbms_application_info package are set_module, sect_action, read_module, set_client_info, read_client_info and set set_session_longtops.
Question 29. List The Log Miner Procedures?
Answer :
Log miner procedures are given as follows:
The following two functions can also be used with log miners:
Question 30. How Can You Process Messages In Order Asynchronously?
Answer :
Oracle provides a package called dbms_aq package to queue the messages, which can be consumed by another session or application in order.
Question 31. How Would You Determine Who Has Added A Row To A Table?
Answer :
This can be determined by using the fine grained auditing feature for the table.
Question 32. How Can You Initialize Log Miner?
Answer :
You can use the DBMS_LOGMNR.START_LOGMNR procedure to initialize the log miner.
Question 33. How Can You Get The Information Processed By Log Miner Procedures?
Answer :
The information processed by log miner is stored in the v$logmnr_contents view.
You can be use the dbms_logmnr.mine_value and dbms_logmnr.column_present procedures with the data in the v$logmnr_contents view to review the information.
Answer :
You can use the dbms_profiler package to collect and store profile information about a PL/SQL application.
Question 35. How Can Retrieve Object Definitions From Data Dictionary?
Answer :
You can use the dbms_metadata package to retrieve object definitions from data dictionary by specifying the following:
Question 36. When Does An Alert Gets Signaled?
Answer :
Alerts are transaction based. Whenever, a transaction causing event of interest commits, the alert is signaled.
Question 37. How Can You Create An Advanced Queuing (aq)?
Answer :
Oracle provides the dbms_aqadm package to create an advanced queue. This package can be used to create, alter, and drop AQ.
The procedure that provides these functions are given as follows:
Answer :
You can use the fine grained auditing features of Oracle.
Question 39. How Do You Resize A Datafile?
Answer :
You can resize a datafile by using the ALTER DATABASE DATAFILE <file_name> RESIZE; statement.
Oracle Packages Related Practice Tests |
|
---|---|
Oracle Apps ERP Practice Tests | Oracle BPM Practice Tests |
All rights reserved © 2020 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.