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.
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?
Which three actions would be helpful in determining the cause of a node reboot?
A. determining the time of the node reboot by using the update command and subtracting the up time from the current system time
B. looking for messages such as “Oracle CSSD failure. Rebooting for cluster integrity /var/log/messages
C. using the crsctl command to view tracing information
D. inspecting the ocssd log for “Begin Dump” or “End Dump” messages
E. inspecting the database alert log for reboot messages
Identify the two direct sources from where SQL plans can be loaded into the SQL plan baselines. (Choose two.)
A. Cursor cache
B. Stored outline
C. SQL Tuning Set
D. Automatic Workload Repository (AWR) snapshots
Which optional parameter of the DESCRIPTION clause of a TNS entry can you use to randomize the access to available listeners?
Which of the following commands, in Windows 7, could a technician use to schedule a disk integrity scan upon next boot?
Which of the following is enabled in the BIOS that will prompt a user, Joe, to enter his password every time the laptop performs a POST?
A. Power User access
B. Power on password
C. Administrative password
D. User profile access
A user reports that their computer is running considerably slower after visiting a website. The user’s PC has a current antivirus package that is running correctly. Which of the following should the technician do FIRST in order to diagnose the problem?
A. Clear the web browser history.
B. Run an anti-spyware tool.
C. Defrag the user’s hard drive.
D. Run the CHKDSK utility.
Which of the following memory types has a clock speed of 400MHz?
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.
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.
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.
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).
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.
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.