Way 2 Freshers

You are browsing the archives of ORCLE programs.

How do you pass the parameters from one form to another form?
To pass one or more parameters to a called form, the calling form must perform the following steps in a trigger or user named routine execute the create_parameter_list built-in function to programmatically. Create a parameter list to execute the add parameter built-in procedure to [...]

How do you trap the error in forms 3.0 ?
using On-Message or On-Error triggers.
How many pages you can in a single form ?
Unlimited
While specifying master/detail relationship between two blocks specifying the join condition is a must ?
True or False. ?
True
EXIT_FORM is a restricted package procedure ?
a. True b. False
True
What is the usage of an ON-INSERT,ON-DELETE [...]

It is possible to use raw devices as data files and what is the advantages over file. system files ?
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.
What are disadvantages of having raw devices ?
We should depend [...]

What third party tools can be used with Oracle EBU/ RMAN? (for DBA)
The following Media Management Software Vendors have integrated their media management software packages with Oracle Recovery Manager and Oracle7 Enterprise Backup Utility. The Media Management Vendors will provide first line technical support for the integrated backup/recover solutions.
Veritas NetBackup
EMC Data Manager (EDM)
HP OMNIBack II
IBM’s [...]

What is the Maximum allowed length of Record group Column?
Record group column names cannot exceed 30 characters.
Which parameter can be used to set read level consistency across multiple queries?
Read only
What are the different types of Record Groups?
Query Record Groups
NonQuery Record Groups
State Record Groups
From which designation is it preferred to send the output to the printed?
Previewer
What [...]

What is SGA?
The System Global Area in an Oracle database is the area in memory to facilitate the transfer of information between users. It holds the most recently requested structural information between users. It holds the most recently requested structural information about the database. The structure is database buffers, dictionary cache, redo log buffer and [...]

How does one see the uptime for a database? (for DBA )
Look at the following SQL query:
SELECT to_char (startup_time,’DD-MON-YYYY HH24: MI: SS’) “DB Startup Time”
FROM sys.v_$instance;
Marco Bergman provided the following alternative solution:
SELECT to_char (logon_time,’Dy dd Mon HH24: MI: SS’) “DB Startup Time”
FROM sys.v_$session
WHERE Sid=1 /* this is pmon */
/
Users still running on Oracle 7 can [...]

Define Transaction ?
A Transaction is a logical unit of work that comprises one or more SQL statements executed by a single user.
What is Read-Only Transaction ?
A Read-Only transaction ensures that the results of each query executed in the transaction are consistant with respect to the same point in time.
What is a deadlock ? Explain .
Two [...]

Can a view based on another view?
Yes.
What are the advantages of views?
- 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 [...]

What are the components of physical database structure of Oracle database?
Oracle database is comprised of three types of files. One or more datafiles, two are more redo log files, and one or more control files.
What are the components of logical database structure of Oracle database?
There are tablespaces and database’s schema objects.
What is a tablespace?
A database [...]