Category: Oracle Exam

QUESTION 1
ABC Corp. has a requirement to share business documents from its Oracle E-Business Suite Release12 (EBS) instance with external business-to-business (B2B) exchange partners. Select the best method that you would recommend to meet this requirement.
A.    Build a workflow process and integrate it with external B2B exchange.
B.    Use notification mailer to share the documents with external B2B exchange.
C.    Use Oracle Applications Framework to integrate with external B2B exchange.
D.    Use the Advanced Workflow Mailer functionality in Oracle E-Business Suite Release 12.
E.    Build a workflow process and use Business Event System to integrate it with an external B2B exchange partner.

Answer: E   

» Read more

QUESTION 1
You want to display employee records in tabular format, but the form is not wide enough to display all the items in the Employees block. The employee IDs and names of displayed records should always be visible, but you want to scroll the additional information as users tab through the Items, the form should look like a spreadsheet with the first two columns frozen.
Which canvas types would be most appropriate in this scenario?

A.    content canvas in a window with a horizontal scroll bar
B.    content canvas and multiple tab canvases
C.    content canvas and a tab canvas with multiple tab pages
D.    content canvas and a stacked canvas with a horizontal scroll bar
E.    multiple content canvases

Answer: C
Explanation:
After an entity is divided into groups, if all groups cannot be displayed simultaneously,
it becomes necessary for two or more regions to be displayed in the exact same space, one at a time, using a Tab control. The user can jump to a specific region by selecting a tab or by progressing continuously through all fields of all Tab regions. A set of fields, minimally the primary key fields, should remain visible so the user can maintain context at all times. There, “frozen” fields must be placed inside the Tab control on the left side.
When best to use Tab regions:
* When the user must see all fields of a record in a single window, but they do not need to see them all simultaneously.
* When entire regions need to be hidden from a user due to security restrictions, the current state of data, or other product installations.

» Read more

QUESTION 1
Which two statements are true about the context of an application? (Choose two.)

A.    It is attached to a session.
B.    It is owned by the user SYS.
C.    A user can change the context of his or her application.
D.    The PL/SQL package associated with the context must exist before the context is created.
E.    The predefined attributes in the USERENV application context can be changed as per the requirements.

Answer: AB

» Read more

QUESTION 1
View the Exhibit. The EMPLOYEES table contains 100 records. You are developing a Human Resources form that has an Employees block with properties as shown in the exhibit. When you run the form and execute a query in the Employees block, approximately how many network round trips will be made to the server before records are displayed in the block?
 

A.    1
B.    2
C.    10
D.    50
E.    100

Answer: C

» Read more

QUESTION 1
View the Exhibit. Which two statements are true about the output of the cat /proc/partitions command? (Choose two.)
 

A.    The hard disk has four partitions.
B.    The hard disk has six partitions.
C.    The swap partition is not shown in the output.
D.    The major column shows the device number with partitions.
E.    The #blocks column shows the number of inode blocks in that partition.

Answer: AD

» Read more

QUESTION 1
Identify four uses of the Oracle Scheduler. (Choose four.)
A.    Enables you to set idle time limits for a resource plan.
B.    Enables you to schedule job execution based on time.
C.    Enables you to execute jobs in a clustered environment.
D.    Enables you to assign priorities to the consumer groups.
E.    Enables you to map a consumer group to an Oracle user.
F.    Enables you to create a job that makes use of saved programs and schedules.
G.    Enables you to periodically execute operating system script files located on the same server as the database.

Answer: BCFG

» Read more

QUESTION 1
A database is running in ARCHIVELOG mode. It has two online redo log groups and each group has one member. A LGWR I/O fails due to permanent media failure that has resulted in the loss of a redo log file and the LGWR terminates causing the instance to crash. Which method should be used to efficiently recover from this loss of the current group member?

A.    Restart the database; it would automatically re-create the corrupted redo log member.
B.    Restore the corrupted redo log group, perform incomplete recovery, relocate by renaming the member of the damaged online redo log group to a new location, and then open the database with RESETLOGS.
C.    Restore the corrupted redo log member, perform incomplete recovery, relocate by renaming the member of the damaged online redo log group to a new location, and then open the database with RESETLOGS.
D.    Restore whole database backup, perform incomplete recovery, relocate by renaming the member of the damaged online redo log group to a new location, and then open the database with the RESETLOGS option.

Answer: D

» Read more

QUESTION 1
Which is the correct description of the significance of the ORACLE_HOME environmental variable?

A.    It specifies the directory containing the Oracle software.
B.    It specifies the directory containing the Oracle-Managed Files.
C.    It specifies the directory for database files, if not specified explicitly.
D.    It specifies the base directory of Optimal Flexible Architecture (OFA).

Answer: A

» Read more

QUESTION 1
The Oracle Application Server is installed on your machine. In Forms Builder, you open the HResource form and connect to the HR database. You also edit your Forms Builder run-time preferences and click Set Default. To test the HResource form module, you click Run Form and receive the error message FRM-10142 (The HTTP listener is not running). What action should you take?
A.    Start an OC4J instance.
B.    Start the Oracle HTTP Server.
C.    Run the batch file STOPINST.BAT.
D.    Start the browser before clicking Run Form.
E.    Generate the form and move the .fmx file to the Oracle Application Server deployment directory.

Answer: A

» Read more

QUESTION 1
You instance has these parameter settings:
 
Which three statements are true about these settings if no hints are used in a SQL statement?

A.    A statement estimated for more than 10 seconds always has its degree of parallelism computed automatically.
B.    A statement with a computed degree of parallelism greater than 8 will be queued for a maximum of 10 seconds.
C.    A statement that executes for more than 10 seconds always has its degree of parallelism computed automatically.
D.    A statement with a computed degree of parallelism greater than 8 will raise an error.
E.    A statement with any computed degree of parallelism will be queued if the number of busy parallel execution processes exceeds 64.
F.    A statement with a computed degree of parallelism of 20 will be queued if the number of available parallel execution processes is less 5.

Answer: CEF

» Read more

QUESTION 1
Requirement demands that an incoming request from a portfolio manager has to have a higher priority compared to other users of the application. As an administrator, which one of the following approaches would you adopt?
A.    Use Work Manager with the execute thread model to set up rules to associate a priority to the user.
B.    Use Work Manager fair-share-request-class to associate a priority to the user.
C.    Use Work Manager response-time-request-class to associate a priority to the user.
D.    Use Work Manager context-request-class to associate a priority to the user.

Answer: D

» Read more