What are the default extensions of the files created by
library module?

1 Answer

Answer :

The default file extensions indicate the library module type and
storage format .pll - pl/sql library module binary

Related questions

Description : What are the default extensions of the files created by menu module?

Last Answer : .mmb, .mmx

Description : What are the default extensions of the files created by forms modules?

Last Answer : .fmb - form module binary .fmx - form module executable

Description : What are the different file extensions that are created by oracle reports?

Last Answer : Rep file and Rdf file.

Description : What are the different default triggers created when Master Deletes Property is set to Cascade?

Last Answer : Master Deletes Property Resulting Triggers --------------------------------------------------- Cascading On-Clear-Details On-Populate-Details Pre-delete

Description : What are the different default triggers created when Master Deletes Property is set to isolated?

Last Answer : Master Deletes Property Resulting Triggers --------------------------------------------------- Isolated On-Clear-Details On-Populate-Details

Description : What are the different default triggers created when Master Deletes Property is set to Non-isolated?

Last Answer : Master Deletes Property Resulting Triggers ---------------------------------------------------- Non-Isolated(the default) On-Check-Delete-Master On-Clear-Details On-Populate-Details

Description : Which default Database roles are created when you create a Database?

Last Answer : CONNECT , RESOURCE and DBA are three default roles. The DBA_ROLES data dictionary view can be used to list all roles of a database and the authentication used for each role. The following query lists all the roles in ... ------------ -------- CONNECT NO RESOURCE NO DBA NO SECURITY_ADMIN YES

Description : Name the two files that are created when you generate the form give the filex extension ?

Last Answer : INP (Source File) FRM (Executable File)

Description : What is the most important module in Oracle Financials? (for DBA

Last Answer : The General Ledger (GL) module is the basis for all other Oracle Financial modules. All other modules provide information to it. If you implement Oracle Financials, you should switch your current GL ... with it first to give your implementation team a chance to be familiar with Oracle Financials.

Description : Is there any way, by default, to have iWork save your spreadsheets and documents as .doc and .xls extensions?

Last Answer : You can by changing the default settings, but it is not a good idea. Those extensions are used by the operating system to know what program to use them with. Opening a file with the wrong program can damage files to a point where the files are unreadable by even the origional program.

Description : The join defined by the default data link is an outer join yes or no?

Last Answer : Yes

Description : Which parameter specified in the DEFAULT STORAGE clause of CREATE TABLESPACE cannot be altered after creating the tablespace?

Last Answer : All the default storage parameters defined for the tablespace can be changed using the ALTER TABLESPACE command. When objects are created their INITIAL and MINEXTENS values cannot be changed.

Description : Can u set default font in forms?

Last Answer : Yes. Change windows registry(regedit). Set form45_font to the desired font.

Description : Can the default values be assigned to actual parameters?

Last Answer : Yes

Description : What are the default parameter that appear at run time in the parameter screen? What are the various sub events a mouse double click event involves?

Last Answer : Destype and Desname.

Description : What is default tablespace ?

Last Answer : The Tablespace to contain schema objects created without specifying a tablespace name.

Description : Which are the default passwords of SYSTEM/SYS?

Last Answer : MANAGER / CHANGE_ON_INSTALL

Description : What is a library?

Last Answer : A library is a collection of subprograms including user named procedures, functions and packages.

Description : Can you store objects in library?

Last Answer : Referencing allows you to create objects that inherit their functionality and appearance from other objects. Referencing an object is similar to copying an object, except that the resulting reference ... the source object when you open or regenerate the module that contains the reference object.

Description : Explain the following file extension related to library?

Last Answer : .pll,.lib,.pld The library pll files is a portable design file comparable to an fmb form file The library lib file is a plat form specific, generated library file comparable to a fmx form file The pld file is Txt format file and can be used for source controlling your library files Parameter

Description : What is a library in Forms 4.0?

Last Answer : A library is a collection of Pl/SQL program units, including user named procedures, functions & packages

Description : Is it possible to attach same library to more than one form?

Last Answer : Yes

Description : Where is a procedure return in an external pl/sql library executed at the client or at the server?

Last Answer : At the client.

Description : What is the advantage of the library?

Last Answer : Libraries provide a convenient means of storing client-side program units and sharing them among multiple applications. Once you create a library, you can attach it to any other form, ... library can reference program units in the attached library. Library support dynamic loading-that is library

Description : On Mac, how can I play an mp4 file with subtitles? (there are two subtitle files, with .idx and .sub extensions)

Last Answer : SOLVED—I posted too hastily. :) For some reason, restarting VLC made a difference (I don’t see why that would make a difference in this case, but now they’re working fine together and I’ve got subs).

Description : MP3, WMA, WAVE, MIDI are the extensions given to audio files. -Technology

Last Answer : TrueAll of the above are audio file extensions.

Description : gif, jpg, bmp, png are used as extensions for files which store (A) Audio data (B) Image data (C) Video data (D) Text data

Last Answer : (B) Image data

Description : Why do online library catalog searches always default to "Key Words Anywhere"?

Last Answer : Because library websites are often designed by people to whom the idea of computers and the internet is still relatively foreign? People who use phrases like Web 2.0 ? People who are entirely flummoxed by ... anyone under the age of 30 again? Or maybe this is just the libraries I'm familiar with

Description : A(n) ____________ is a measure of program size based on the number and  complexity of inputs, outputs, queries, files, and program interfaces.  a. function point  b. line of code  c. project plan  d. standard module  e. workplan

Last Answer : a. function point

Description : How does one give developers access to trace files (required as input to tkprof)? (for DBA)

Last Answer : The "alter session set sql_trace=true" command generates trace files in USER_DUMP_DEST that can be used by developers as input to tkprof. On Unix the default file mask for these files are "rwx r-- -- ... = true Include this in your INIT.ORA file and bounce your database for it to take effect.

Description : Can one resize tablespaces and data files? (for DBA)

Last Answer : One can manually increase or decrease the size of a datafile from Oracle 7.2 using the command. ALTER DATABASE DATAFILE 'filename2' RESIZE 100M; Because you can change the ... UNLIMITED DEFAULT STORAGE (INITIAL 10240 NEXT 10240 MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0) ONLINE PERMANENT;

Description : Name two files used for network connection to a database.

Last Answer : TNSNAMES.ORA and SQLNET.ORA

Description : You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?

Last Answer : I would create a text based backup control file, stipulating where on disk all the data files where and then issue the recover command with the using backup control file clause.

Description : What are the characteristics of data files?

Last Answer : A data file can be associated with only one database. Once created a data file can't change size. One or more data files form a logical unit of database storage called a tablespace.

Description : Table Space,Data Files,Parameter File, Control Files

Last Answer : Table Space :: The table space is useful for storing the data in the database.When a database is created two table spaces are created. a) System Table space :: This data file stores all the tables ... They contain the Db name, name and location of dbs, data files ,redo log files and time stamp.

Description : How to implement the multiple control files for an existing database ?

Last Answer : Shutdown the database Copy one of the existing control file to new location Edit Config ora file by adding new control file. name Restart the database.

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 : I've lost my REDOLOG files, how can I get my DB back? (for DBA

Last Answer : The following INIT.ORA parameter may be required if your current redo logs are corrupted or blown away. Caution is advised when enabling this parameter as you might end-up losing your entire database. Please contact Oracle Support before using it. _allow_resetlogs_corruption = true

Description : Can one export to multiple files?/ Can one beat the Unix 2 Gig limit? (for DBA

Last Answer : From Oracle8i, the export utility supports multiple output files. This feature enables large exports to be divided into files whose sizes will not exceed any operating system limits (FILESIZE= parameter). When ... > scott.exp.gz & # feed the pipe exp userid=scott/tiger file=exp.pipe ...

Description : Does Oracle write to data files in begin/hot backup mode? (for DBA

Last Answer : Oracle will stop updating file headers, but will continue to write data to the database files even if a tablespace is in backup mode.In backup mode, Oracle will write out complete changed blocks ... ). Because of this, one should notice increased log activity and archiving during on-line backups.

Description : How does one backup archived log files? (for DBA

Last Answer : One can backup archived log files using RMAN or any operating system backup utility. Remember to delete files after backing them up to prevent the archive log directory from filling up. If the ... oracle/arch_backup/log_t%t_s%s_p%p' 5> (archivelog all delete input); 6> release channel dev1; 7> }

Description : What are the Characteristics of Data Files ?

Last Answer : A data file can be associated with only one database. Once created a data file can't change size. One or more data files form a logical unit of database storage called a tablespace.

Description : What are database files, control files and log files. How many of these files should a database have at least? Why?

Last Answer : ∙ Database Files The database files hold the actual data and are typically the largest in size. Depending on their sizes, the tables (and other objects) for all the user accounts can go in one ... or redo log file to the database, the information is recorded in the control files. ∙ Redo Logs

Description : Name the three major set of files on disk that compose a database in Oracle

Last Answer : There are three major sets of files on disk that compose a database. All the files are binary. These are ∙ Database files ∙ Control files ∙ Redo logs The most important of these ... actual data resides. The control files and the redo logs support the functioning of the architecture itself.

Description : What is the purpose of Redo Log files?

Last Answer : Before Oracle changes data in a datafile it writes these changes to the redo log. If something happens to one of the datafiles, a backed up datafile can be restored and the redo, that was written since, replied, which brings the datafile to the state it had before it became unavailable.

Description : What Oracle tool will you use to transform datafiles into text files?

Last Answer : Trick question: you can’t do that, at least with any Oracle tool. A very experienced DBA should perfectly know this.

Description : What command will you use to navigate through ASM files?

Last Answer : asmcmd

Description : Can a repeating frame be created without a data group as a base?

Last Answer : No

Description : Use the add_group_column function to add a column to record group that was created at a design time?

Last Answer : False

Description : What are the roles and user accounts created automatically with the database?

Last Answer : DBA - role Contains all database system privileges. SYS user account - The DBA role will be assigned to this account. All of the base tables and views for the database's dictionary ... administrative information and internal tables and views used by oracle tools are created using this username.