Hide Notes 

Slide 1: Vendor: Oracle Exam: 1z0-036 Version: Demo TestKing.org - #1 in IT Testing & Certification Tools
Slide 2: Testking.org is the product of over six years of dedicated hard work and certification achievements. Having learned the hard way to learn IT Exam material and developing excellent tools for achieving, not an easy way, but a smart way to achieve certification success in any field. Developed for Administrators and Engineers by Administrators and Engineers in the daily grind. Fellow technology gurus have pulled together to make the single best location online to find your practice exams and to study for your next test, whether it be Microsoft, Cisco, Oracle, HP, IBM or any other industry standard technology. Our success is built on the success of those who have gone before you. Testking.org continued success is the result of phenomenal word-of-mouth and friendly referrals. It is our famous study guides and prep labs that will grab your attention - but all roads lead to the Testking.org practice exams and Questions and Answers - the ultimate training resource. Testking.org is built on the core knowledge from our technical training staff and through community and the natural infrastructure of social networking. Questions or comments? Contact our customer support today. support@testking.org To get the latest version please visit our Website: http://www.testking.org TestKing.org - #1 in IT Testing & Certification Tools
Slide 3: 1. Which package displays system usage graphs for CPU usage, memory usage, and system load? A. top B. free C. xosview D. xcpustate TestKing.org Answer: C 2. Which information about your system will help you determine if CPU is a bottleneck? (Choose three.) A. pages in B. bigpages C. load factor D. average load E. number of CPUs TestKing.org Answer: CDE 3. Examine the following entry in the sysctl.conf file: fs.file-max = 65536 What is the significance of this entry? A. The entry sets the maximum number of open files for each process to 65536. B. The entry sets the maximum number of subprocesses that a process can spawn to 65536. C. The entry sets the maximum number of files in the operating system (OS) file system to 65536. D. The entry sets the maximum number of background processes of the Oracle database to 65536. TestKing.org Answer: A 4. Which four network components or services can be configured by using Oracle Net Manager? (Choose four.) A. profile B. listener C. names server D. service naming E. Oracle HTTP Server F. connection manager TestKing.org Answer: ABCD 5. Which three statements about shared server configuration are true? (Choose three.) A. There is a large pool area. B. It reduces memory usage. C. It increases the number of server processes. D. Automatic undo management is recommended. E. The user global area (UGA) memory is taken from buffer pool.
Slide 4: F. Portions of PGA are allocated from the System Global Area (SGA). TestKing.org Answer: ABF 6. You have created the automatic database startup script oracle_start in /etc/rc.d/init.d . While starting up the server, you have been receiving the error service oracle_start does not support chkconfig . What must you do to fix this error? A. Schedule a cron task to start up the database. B. Specify the path to the startup script in the oratab file. C. Run the root.sh script to add the script to the runlevel directories. D. Include the line #chkconfig: 2345 20 90 in the oracle_start script. E. Place a copy of the oracle_start script in the rc2.d and rc3.d runlevel directories. TestKing.org Answer: D 7. Which two methods would you use to boot to a nondefault runlevel? (Choose two.) A. Specify the runlevel in the rc#.d directory. B. Specify the runlevel in the init command. C. Specify the runlevel in the chmod command. D. Specify the runlevel as an argument for the inittab file. E. Specify the runlevel at startup by using the boot loader program. TestKing.org Answer: BE 8. You have scheduled a job on a remote host. At the scheduled time, the following is the scenario: - -You are not connected to the remote host. - The Intelligent Agent (IA) is running on the remote host. - The Oracle Enterprise Manager (OEM) console and Oracle Management Server (OMS) are not running on your local host. What happens to the scheduled job? A. The job fails. B. IA executes the job at the scheduled time. C. IA executes the job at the scheduled time provided it is a Fixit job. D. IA places the job in a queue and executes the job when you connect to the remote host. E. IA executes the job at the scheduled time provided the local and remote hosts are using the same operating system. F. IA places the job in a queue and executes the job when you run the O EM console and OMS on your local host. TestKing.org Answer: B 9. You want the default database to participate in automatic startup and have configured the startup script and runlevels. However, the dbstart script does not start the instance. Which two methods can you use to work around the problem? (Choose two.)
Slide 5: A. Specify the command: SQL>CREATE PFILE = '?/dbs/init@.ora' FROM SPFILE = '?/dbs/spfile@.ora' ; B. Specify the command: SQL>CREATE SPFILE = '?/dbs/spfile@.ora' FROM PFILE = '?/dbs/init@.ora' ; C. Edit the dbstart script: Add the line: PFILE=${ORACLE_HOME }/dbs/init@.ora' Replace the line: if [ -f $PFILE ] ; then with if [ -f $PFILE -o -f $SPFILE ] ; then D. Edit the dbstart script: Add the line: SPFILE=${ORACLE_HOME }/dbs/spfile${ORACLE_SID }.ora Replace the line: if [ -f $PFILE ] ; then with if [ -f $PFILE -o -f $SPFILE ] ; then E. Edit the startup script: Add the line: CREATE SPFILE = '?/dbs/spfile@.ora' FROM PFILE = '?/dbs/init@.ora' ; Replace the line: if [ -f $PFILE ] ; then with if [ -f $PFILE -o -f $SPFILE ] ; then TestKing.org Answer: AD 10. What are the four roles of the semaphores parameters? (Choose four.) A. The semmni parameter sets the maximum number of semaphore sets. B. The semmsl parameter sets the maximum number of semaphore sets. C. The semmsl parameter sets the maximum number of semaphores per set. D. The semmns parameter sets the maximum number of semaphores per set. E. The semmns parameter sets the total number of semaphores in the system. F. The semopm parameter sets the total number of semaphores in the system. G. The semmni parameter sets the maximum number of operations per semop call. H. The semopm parameter sets the maximum number of operations per semop call. TestKing.org Answer: ACEH 11. Which statistics enable you to view the impact of SQL statements on input/output (I/O) statistics? A. file statistics in Performance Manager B. sorts and parse calls values in Top SQL C. CPU chart group in Performance Manager D. buffer gets and disk reads values in Top SQL E. statistics obtained from the sar and vmstat commands TestKing.org Answer: D 12. When you restarted the machine after editing the display settings, the monitor displays red, green, and blue lines. Which set of steps should you use to troubleshoot the problem? A. Restart the system. Open a terminal window. Log in as root . Edit the X Windows configuration files. Start up the X Server. Specify the telinit 5 command. B. Restart the system. Open a terminal window. Log in as root . Set the DISPLAY variable. Start up the X Server. Specify the telinit 5 command. C. Switch to the text console. Log in as oracle . Edit the X Windows configuration files. Set the DISPLAY and PATH variables. Start up the X Server. Restart the system. D. Switch to the text console. Log in as root . Turn off GUI by using the telinit 3 command. Edit the X
Slide 6: Windows configuration files. Start up the X Server. Restart the system. TestKing.org Answer: D 13. You have the following entry in the /etc/fstab file: / dev/hda5 /opt ext3 data=writeback 1 0 What is true about the data=writeback part of the entry with respect to the ext3 file system? A. The entry resizes the file system. B. The entry changes the run level to single-user mode. C. The entry specifies a tuning parameter for asynchronous input/output (I/O). D. The entry sets the journaling level so that only the changes to the file system metadata are logged. E. The entry sets the journaling level so that the changes to the file system data as well as the metadata are logged. TestKing.org Answer: D 14. Which two statements are true about Oracle Clustered File System (OCFS)? (Choose two.) A. There is no limit on the number of files on OCFS. B. You can create an OCFS on Logical Volume Manager (LVM). C. You can use OCFS for database files as well as general files. D. You must modify Linux kernel parameters before mounting OCFS. E. Standard file system commands, such as mkdir , rmdir , and mv , are available on OCFS. TestKing.org Answer: AE 15. Which three commands can you use to display an overview of the memory usage in a system? (Choose three.) A. top B. free C. vmstat D. mpstat E. iostat TestKing.org Answer: ABC 16. You executed the following command: cat /proc/slabinfo | grep kio You received the following output: kioctx kiocb kiobuf 270 66080 236 270 66080 236 96 128 9 9 1 4 1 1 1652 1652 64 4 What do you infer from the output? A. The CPU usage is 100%.
Slide 7: B. There are no inactive pages. C. The disk activity needs to be tuned. D. There are waits for the buffer cache. E. The Linux system has asynchronous input/output (I/O) configured on it. F. The value for the shmmax parameter needs to be increased. TestKing.org Answer: E 17. You have specified the configuration in the sysctl.conf file. However, when you restart the system, Linux does not start. Which statement describes the steps that you would take to troubleshoot the problem? A. Use the root login to mount the file system and edit the sysctl.conf file. B. Use the boot loader to enter the emergency mode and switch to runlevel 3. C. Use the boot loader program to boot into runlevel 1 and edit the sysctl.conf file. D. Use the boot loader program to access the available kernels and recompile the kernel. E. Use the root login to access the system in runlevel 6 and edit the /root/.bashrc file. F. Use the single-user mode to access the /proc file system and edit the kernel parameters. TestKing.org Answer: C 18. You are accessing a remote database by using the following username, password, and connect string: user1/user1@orcl_hr You need the following details: - the host name on which the remote database resides - whether the remote database is using dedicated server mode or shared server mode - the protocol being used to access the remote database Which command or utility will give you the desired information? A. tnsping command B. trcroute command C. Oracle Names Control utility D. Oracle Net Configuration Assistant E. Oracle Connection Manager Control utility TestKing.org Answer: A 19. You are creating a database using Database Configuration Assistant (DBCA). You need to save the SQL scripts that are being used to create the database. Which set of options would you select? A. Enable SQL tracing for the DBCA session B. Choose the "New Database" template and select the "Save as a Database Template" option while creating the database C. Choose the "General Purpose" template and select the "Save as a Database Template" option while creating the database
Slide 8: D. Create the database using the "General Purpose" template and then create a new template from the existing database E. Choose the "New Database" template and select the "Generate Database Creation Scripts" option while creating the database TestKing.org Answer: E 20. Which set of steps must user21a perform to schedule a cron task? A. Log in as root . Specify the crontab -e command. B. Log in as user21a . Specify the crontab -e command. C. Log in as user21a . Specify the crontab -l command. Save the cron task to the /etc/crontab file. D. Log in as root . Specify the crontab -l command. Save the cron task to the /var/spool/cron/user21a file. TestKing.org Answer: B