What is Enterprise Structure Configurator (ESC) and what are the benefits of using it?

1 Answer

Answer :

The ESC is an interview-based tool that guides you through the configuration of your enterprise structures. Use the ESC as part of your set up to define the organization structures and job and position structures of the enterprise.

Related questions

Description : What is OEM (Oracle Enterprise Manager)? (for DBA

Last Answer : OEM is a set of systems management tools provided by Oracle Corporation for managing the Oracle environment. It provides tools to monitor the Oracle environment and automate tasks (both one-time and repetitive in nature) to take database administration a step closer to "Lights Out" management.

Description : What is the use of Enter and Esc key in a Slide Show? -Technology

Last Answer : Press Enter to move to the next slide and Esc to close the Slide Show.

Description : The _____ key will launch the start buttons. 1) Esc 2) Shift 3) Windows 4) Shortcut 5) None of these

Last Answer : Answer :3

Description : The“““.enables you tosimultaneously keep multiple Web pagesopen in onebrowser window. (A) tab box (B) pop-up helper (C) tab row (D) addressbar (E) Esc key

Last Answer : tab row

Description : The key used to cancel the current task is: a) ESC b) End c) Ctrl+End d) None of These

Last Answer : a) ESC

Description : The _____enables you to simultaneously keep multiple Web pages open in one browser window: a) tab box b) pop - up helper c) tab row d) address bar e) Esc Key

Last Answer : c) tab row

Description : Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.

Last Answer : ARCHIVELOG mode is a mode that you can put the database in for creating a backup of all transactions that have occurred in the database so that you can recover to any point in time. ... having to write transactions to an archive log and thus increases the performance of the database slightly.

Description : Explain the difference between a hot backup and a cold backup and the benefits associated with each.

Last Answer : A hot backup is basically taking a backup of the database while it is still up and running and it must be in archive log mode. A cold backup is taking a backup of the database while it is ... and thus there will be a slight performance gain as the database is not cutting archive logs to disk.

Description : What are the benefits of distributed options in databases?

Last Answer : Database on other servers can be updated and those transactions can be grouped together with others in a logical unit. Database uses a two phase commit.

Description : WHAT ARE THE BENEFITS OF FLEXFIELDS? 

Last Answer : - Configure applications to support your own accounting, product and other codes. - Enable the construction of intelligent keys. - Configure application to capture additional data. - Use ... combinations entered by the user. - Support multiple flexfield structures depending on data context.

Description : What is the basic structure of PL/SQL ?

Last Answer : PL/SQL uses block structure as its basic structure. Anonymous blocks or nested blocks can be used in PL/SQL.

Description : Where in the Oracle directory tree structure are audit traces placed?

Last Answer : In unix $ORACLE_HOME/rdbms/audit, in Windows the event viewer

Description : Give two examples of how you might determine the structure of the table DEPT.

Last Answer : Use the describe command or use the dbms_metadata.get_ddl package.

Description : What is IAPXTB structure ?

Last Answer : The entries of Pro * C and user exits and the form which simulate the proc or user_exit are stored in IAPXTB table in d/b.

Description : Give the structure of the function ?

Last Answer : FUNCTION name (argument list .....) Return datatype is local variable declarations Begin executable statements Exception execution handlers End;

Description : Give the structure of the procedure ?

Last Answer : PROCEDURE name (parameter list.....) is local variable declarations BEGIN Executable statements. Exception. exception handlers end;

Description : What are the built -ins used for Modifying a groups structure?

Last Answer : ADD-GROUP_COLUMN (function) ADD_GROUP_ROW (procedure) DELETE_GROUP_ROW(procedure)

Description : What is the basic data structure that is required for creating an LOV?

Last Answer : Record Group.

Description : What are the components of logical database structure of Oracle database?

Last Answer : There are tablespaces and database's schema objects.

Description : What are the components of physical database structure of Oracle database?

Last Answer : 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.

Description : How is the data structure of System R different from the relational structure? Unlike Relational systems in System R

Last Answer : ∙ Domains are not supported ∙ Enforcement of candidate key uniqueness is optional ∙ Enforcement of entity integrity is optional ∙ Referential integrity is not enforced

Description : Physical Structure of Database

Last Answer : Usually a database has the below files: a) Data Files (*.dbf) ------------------- b) Redo Logs (*.log) ------------------- c) Undo (*.dbf) ------------------------- d) Spfile or init file ---------- ... - g) Control Files (*.ctl) ------------------- h) Backup Files ----------------------------

Description : Explain Oracle memory structure

Last Answer : The Oracle RDBMS creates and uses storage on the computer hard disk and in random access memory (RAM). The portion in the computer s RAM is called memory structure. Oracle has two memory structures ... the user has retrieved from the database or data that the user wants to place into the database.

Description : How can you check the structure of a table from sqlplus?

Last Answer : DESCRIBE or DESC

Description : The ultimate aim to encourage the enterprise to save the energy , reduce the production cost and increase economic benefits is ____ A. Energy audit C. Energy saving B. Energy management D. Energy

Last Answer : Energy management

Description : Which type of economic structure is the government given the authority to regulate some of the process of free enterprise?

Last Answer : mixed market

Description : Every entrepreneur should draw an _______ for his project to ensure the timely completion of all activities involved in setting up an enterprise. A. cost structure B. implementation plan C. market structure D. production structure

Last Answer : B. implementation plan

Description : How does one backup a database using the export utility? (for DBA

Last Answer : Oracle exports are "logical" database backups (not physical) as they extract data and logical definitions from the database into a file. Other backup strategies normally back-up the physical data ... exports include more information about the database in the export file than user level exports.

Description : Give the reasoning behind using an index.

Last Answer : Faster access to data blocks in a table.

Description : How you will avoid your query from using indexes?

Last Answer : SELECT * FROM emp Where emp_no+' '=12345; i.e you have to concatenate the column name with space within codes in the where condition. SELECT /*+ FULL(a) */ ename, emp_no from emp where emp_no=1234; i.e using HINTS

Description : What is the maximum buffer size that can be specified using the DBMS_OUTPUT.ENABLE function?

Last Answer : 1,000,00

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 : Why is Oracle not using the damn index? (for DBA

Last Answer : This problem normally only arises when the query plan is being generated by the Cost Based Optimizer. The usual cause is because the CBO calculates that executing a Full Table Scan would be faster ... with AUTOTRACE to see the statistics. Compare this to the explain plan when not using an index.

Description : How does one backup a database using RMAN? (for DBA

Last Answer : The biggest advantage of RMAN is that it only backup used space in the database. Rman doesn't put tablespaces in backup mode, saving on redo generation overhead. RMAN will re-read database ... directly to tape. Alternatively one can backup to disk and then manually copy the backups to tape.

Description : How will you enforce security using stored procedures?

Last Answer : Don't grant user access directly to tables within the application. Instead grant the ability to access the procedures that access the tables. When procedure executed it will execute the privilege of procedures owner. Users cannot access tables except via the procedure.

Description : How can one see who is using a temporary segment? (for DBA

Last Answer : For every user using temporary space, there is an entry in SYS.V$_LOCK with type 'TS'. All temporary segments are named 'ffff.bbbb' where 'ffff' is the file it is in and 'bbbb' is ... For usage stats, see SYS.V_$SORT_SEGMENT From Oracle 8.0, one can just query SYS.v$sort_usage. Look at these

Description : How will you enforce security using stored procedures?

Last Answer : Don't grant user access directly to tables within the application. Instead grant the ability to access the procedures that access the tables. When procedure executed it will execute the privilege of procedures owner. Users cannot access tables except via the procedure.

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 : If an enterprise has too many resources and they will be paying for assets they aren’t using is termed as a) Under provisioning b) Elasticity c) Over provisioning d) None of the above

Last Answer : Over provisioning

Description : An analyst is valuing a firm's equity using the ‘Enterprise Value to Revenue Ratio’ of similar firms. Which of the following is not a factor that the analyst should use? a) Revenue growth b) EBITDA margins

Last Answer : d) Debt Equity ratio

Description : An analyst is valuing a firm's equity using the ‘Enterprise Value to Revenue Ratio’ of similar firms. Which of the following is not a factor that the analyst should use? a) Revenue growth b) EBITDA margins

Last Answer : d) Debt Equity ratio

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.

Description : What is import/export and why does one need it? (for DBA

Last Answer : The Oracle export (EXP) and import (IMP) utilities are used to perform logical database backup and recovery. They are also used to move Oracle data from one machine, database or schema to ... corruption. Ensure that all the data can be read. . Transporting tablespaces between databases . Etc.