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).