Description : What is a package ? What are the advantages of packages ? What is Pragma EXECPTION_INIT ? Explain the usage ?
Last Answer : The PRAGMA EXECPTION_INIT tells the complier to associate an exception with an oracle error. To get an error message of a specific oracle error. e.g. PRAGMA EXCEPTION_INIT (exception name, oracle error number)
Description : When the form is running in DEBUG mode, If you want to examine the values of global variables and other form variables, What package procedure command you would use in your trigger text ?
Last Answer : Break. SYSTEM VARIABLES
Description : What package procedure is used for calling another form ?
Last Answer : Call (E.g. Call(formname)
Description : What ERASE package procedure does ?
Last Answer : Erase removes an indicated global variable.
Description : You have just compiled a PL/SQL package but got errors, how would you view the errors?
Last Answer : SHOW ERRORS
Description : Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
Last Answer : A function and procedure are the same in that they are intended to be a collection of PL/SQL code that carries a single task. While a procedure does not have to return any ... functions and procedures that are grouped together based on their commonality to a business function or application.
Description : What is a Package ?
Last Answer : A Package is a collection of related procedures, functions, variables and other package constructs together as a unit in the database.
Description : What is difference between a Cursor declared in a procedure and Cursor declared in a package specification ?
Last Answer : A cursor declared in a package specification is global and can be accessed by other procedures or procedures in a package. A cursor declared in a procedure is local to the procedure that can not be accessed by other procedures.
Description : What are two parts of package ?
Last Answer : The two parts of package are PACKAGE SPECIFICATION & PACKAGE BODY. Package Specification contains declarations that are global to the packages and local to the schema. Package Body contains actual procedures and local declaration of the procedures and cursor declarations.
Description : Name the tables where characteristics of Package, procedure and functions are stored ?
Last Answer : User_objects, User_Source and User_error.
Description : Identify package function from the following ?
Last Answer : 1. Error- Code 2. Break 3. Call 4. Error-text 5. Form-failure 6. Form-fatal 7. Execute-query 8. Anchor View 9. Message_code? 1. Error_Code 2. Error_Text 3. Form_Failure 4. Form_Fatal 5. Message_Code
Description : What are the different types of Package Procedure ?
Last Answer : 1. Restricted package procedure. 2. Unrestricted package procedure.
Description : What is a Package Procedure ?
Last Answer : A Package procedure is built in PL/SQL procedure.
Description : What Enter package procedure does ?
Last Answer : Enter Validate-data in the current validation unit.
Description : Error_Code is a package proecdure ?
Last Answer : a. True b. false False
Description : What package procedure used for invoke sql *plus from sql *forms ?
Last Answer : Host (E.g. Host (sqlplus))
Description : Can we use GO-BLOCK package in a pre-field trigger ?
Last Answer : No
Description : Can we use a restricted package procedure in ON-VALIDATE-FIELD Trigger ?
Description : What the PAUSE package procedure does ?
Last Answer : Pause suspends processing until the operator presses a function key
Description : What is the difference between restricted and unrestricted package procedure ?
Last Answer : Restricted package procedure that affects the basic functions of SQL * Forms. It cannot used in all triggers except key triggers. Unrestricted package procedure that does not interfere with the basic functions of SQL * Forms it can be used in any triggers.
Description : EXIT_FORM is a restricted package procedure ?a. True b. False
Last Answer : True
Description : What is a Text_io Package?
Last Answer : It allows you to read and write information to a file in the file system.
Description : What does DBMS_FGA package do?
Last Answer : The DBMS_FGA package provides fine-grained security functions. DBMS_FGA is a PL/SQL package used to define Fine Grain Auditing on objects. DBMS_FGA Package Subprograms: ▪ ADD_POLICY Procedure - ... DROP_POLICY Procedure - Drops an audit policy ▪ ENABLE_POLICY Procedure - Enables an audit policy
Description : What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode ?
Last Answer : Complete database recovery from disk failure is possible only in ARCHIVELOG mode. Online database backup is possible only in ARCHIVELOG mode.
Description : What are the advantages of VIEW ?
Last Answer : To protect some of the columns of a table from other users.To hide complexity of a query.To hide complexity of calculations.
Description : What are % TYPE and % ROWTYPE ? What are the advantages of using these over datatypes?
Last Answer : % TYPE provides the data type of a variable or a database column to that variable. % ROWTYPE provides the record type that represents a entire row of a table or view or columns selected in ... database definition of a column in a table changes, the data type of a variable changes accordingly.
Description : What are advantages fo Stored Procedures?
Last Answer : Extensibility,Modularity, Reusability, Maintainability and one time compilation.
Description : It is possible to use raw devices as data files and what is the advantages over file. system files ?
Last Answer : Yes. The advantages over file system files. I/O will be improved because Oracle is bye-passing the kernnel which writing into disk. Disk Corruption will be very less.
Description : What are the advantages of views?
Last Answer : Provide an additional level of table security, by restricting access to a predetermined set of rows and columns of a table. - Hide data complexity. - Simplify commands for the user. - Present the data in a different perspective from that of the base table. - Store complex queries.
Description : What are stored-procedures? And what are the advantages of using them.
Last Answer : Stored procedures are database objects that perform a user defined operation. A stored procedure can have a set of compound SQL statements. A stored procedure executes the SQL commands and returns the result to the client. Stored procedures are used to reduce network traffic.
Description : Advantages of DBMS?
Last Answer : ∙ Redundancy is controlled. ∙ Unauthorized access is restricted. ∙ Providing multiple user interfaces. ∙ Enforcing integrity constraints. ∙ Providing backup and recovery.
Description : Suppose a customer table is having different columns like customer no, payments.What will be the query to select top three max payments?
Last Answer : SELECT customer_no, payments from customer C1 WHERE 3
Description : When do you use WHERE clause and when do you use HAVING clause?
Last Answer : HAVING clause is used when you want to specify a condition for a group function and it is written after GROUP BY clause. The WHERE clause is used when you want to specify a condition for columns, single row functions except group functions and it is written before GROUP BY clause if it is used.
Description : What is advantage of having disk shadowing/ Mirroring ?
Last Answer : Shadow set of disks save as a backup in the event of disk failure. In most Operating System if any disk failure occurs it automatically switchover to place of failed disk. Improved performance because most OS ... instead of the main set of files. This reduces I/O load on the main set of disks.
Description : What is the significance of having storage clause ?
Last Answer : We can plan the storage for a table as how much initial extents are required, how much can be extended next, how much % should leave free for managing row updations etc.,
Description : What are disadvantages of having raw devices ?
Last Answer : We should depend on export/import utility for backup/recovery (fully reliable) The tar command cannot be used for physical file backup, instead we can use dd command which is less flexible and has limited recoveries.
Description : A Column is having many repeated values which type of index you should create on this column, if you have to?
Last Answer : For example, assume there is a motor vehicle database with numerous low-cardinality columns such as car_color, car_make, car_model, and car_year. Each column contains less than 100 distinct values by themselves, and a b tree index would be fairly useless in a database of 20 million vehicles.
Description : A table is having few rows, should you create indexes on this table
Last Answer : Small tables do not require indexes; if a query is taking too long, then the table might have grown from small to large. You can create an index on any column; however, if the ... , creating an index on the column does not increase performance and the index takes up resources unnecessarily.
Description : The Advantages of Buying a Vacation Package?
Last Answer : There are many advantages to buying a vacation package. Package deals usually combine either a flight and a hotel or a flight, hotel, and rental car. One of the obvious reasons for wanting to get a ... in order to save not only money but the time and frustration you would waste waiting in line.
Description : Can I download Keynote and just Keynote without having to buy the complete iWork package?
Last Answer : No, but it’s only $80. Or free if you’re deviant.
Description : What internet and phone package would be less expensive option to having two separate providers?
Last Answer : I just know of several places which have this type of phone service out of the internet for your business. What ever the type of business you may use.
Description : A prerequisite of effective time management is: 1. Knowing the dictated project completion date 2. Having the most advanced software package for project planning, scheduling and control 3. ... and the person responsible for each of them 4. Having a well staffed scheduling department
Last Answer : 1. Knowing the dictated project completion date
Description : What does "jumps off the screen" mean?
Last Answer : answer:AMD is a relatively small manufacturer but well established in the industry. In this context, AMD jumps off the screen at the guy doing the research into acquiring companies for ... chip manufacturing division, but AMD is the one that really stands out from an acquisition perspective.
Description : How to add conditions in select statement in oracle?
Last Answer : Just add the decode
Description : How can I dump an oracle schema to a LOCAL file over a network connection from sqlplus?
Last Answer : By connecting and spooling are you excluding the exp/imp commands (or expdb/impdb in 10g)?
Description : What are the two ways to incorporate images into a oracle forms application?
Last Answer : Boilerplate Images Image_items
Description : Can one export a subset of a table? (for DBA
Last Answer : From Oracle8i one can use the QUERY= export parameter to selectively unload a subset of the data from a table. Look at this example: exp scott/tiger tables=emp query=\"where deptno=10\"
Description : What are the types of visual attribute settings?
Last Answer : Custom Visual attributes Default visual attributes Named Visual attributes. Window
Description : How does one use the import/export utilities? (for DBA
Last Answer : Look for the "imp" and "exp" executables in your $ORACLE_HOME/bin directory. One can run them interactively, using command line parameters, or using parameter files. Look at the imp/exp parameters ... and export data with the "Schema Manager" GUI that ships with Oracle Enterprise Manager (OEM).
Description : what is a display item?
Last Answer : Display items are similar to text items but store only fetched or assigned values. Operators cannot navigate to a display item or edit the value it contains.