Transcript Pass4sure 1z0

1Z0-236
Oracle
Oracle 11i Applications DBA Fundamentals II
Thousands of IT Professionals before you have already passed their 1Z0-236 certification
exams using the Oracle 1Z0-236 Practice Exam from ipass4sure.com. Once you start using
our 1Z0-236 exam questions you simply can't stop! You are guaranteed to pass your Oracle
1Z0-236 test with ease and in your first attempt.
Here's what you can expect from the ipass4sure Oracle 1Z0-236 course:
* Up-to-Date Oracle 1Z0-236 questions designed to familiarize you with the real exam.
* 100% correct Oracle 1Z0-236 answers you simply can't find in other 1Z0-236 courses.
* All of our tests are easy to download. Your file will be saved as a 1Z0-236 PDF.
* Oracle 1Z0-236 brain dump free content featuring the real 1Z0-236 test questions.
Oracle 1Z0-236 Certification Exam is of core importance both in your Professional
life and Oracle Certification Path. With Oracle Certification you can get a good
job easily in the market and get on your path for success. Professionals who passed
Oracle 1Z0-236 Certification Exam are an absolute favorite in the industry.
If you pass Oracle 1Z0-236 Certification Exam then career opportunities are
open for you.
Our 1Z0-236 Questions & Answers provide you an easy solution to your Oracle 1Z0-236
Exam Preparation. Our 1Z0-236 Q&As contains the most updated Oracle 1Z0-236 real tests.
You can use our 1Z0-236 Q&As on any PC with most versions of Acrobat Reader and prepare
the exam easily.
1Z0-236
QUESTION: 1
You plan to perform a backup of the control file in your database. Which two statements
regarding the control file backup are true? (Choose two.)
A. You can back up the control file to a binary file.
B. You must bring the database to the NOMOUNT state to perform the control file backup.
C. You must store all types of control file backups in the location defined by
USER_DUMP_DEST.
D. You can back up the control file by generating a script that can be used to re-create the
control file.
Answer: A, D
QUESTION: 2
Which type of lock is held by SQL statements and PL/SQL objects in the Library Cache?
A.
B.
C.
D.
breakable parse locks
row-level (TX type) lock
table-level manual locks
table-level (TM type) locks
Answer: A
QUESTION: 3
In an online transaction processing (OLTP) system, which is configured in shared server
mode, you execute the following query to examine the sort performance:
SQL> SELECT d.value "Disk", m.value "Mem", (d.value/m.value)*100 "Ratio"
FROM v$sysstat m, v$sysstat d
WHERE m.name='sorts (memory)' and d.name='sorts (disk)';
Disk
Mem
Ratio
---------- ---------- ------------23
206
11.165049
What action would you take after observing the output?
A.
B.
C.
D.
increase the value of SORT_AREA_SIZE
increase the size of the temporary tablespace
increase the value of PGA_AGGREGATE_TARGET
no action required because the ratio is perfect for an OLTP system
Answer: A
QUESTION: 4
Users complain of slow response time in your online transaction processing (OLTP) system.
You compare current statistics with baseline statistics. You notice that in the current statistics
1Z0-236
library cache, the hit ratio has decreased and there are request misses for shared pool reserved
area. Given below are the sizes of shared pool and shared pool reserved area:
SHARED_POOL_SIZE = 500 MB SHARED_POOL_RESERVED_SIZE = 50 MB
What kind of strategy would you suggest for performance tuning?
A.
B.
C.
D.
E.
increase the size of only the shared pool
decrease the size of the shared pool reserved area
increase the size of only the shared pool reserved area
increase the sizes of both the shared pool and the shared pool reserved area
increase the size of the shared pool and decrease the size of the shared pool reserved area
Answer: D
QUESTION: 5
You are working in an OLTP environment. You wish to reduce the virtual memory
requirements for the Oracle instance due to Operating system paging or swap overheads. You
need to determine whether the buffer cache is oversized and could tolerate being reduced. In
which two cases can you afford to reduce the buffer cache size? (Choose two.)
A.
B.
C.
D.
E.
if the cache hit ratio is very high
if there are no waits for free buffers
if the rate of physical I/O is very high
if the number of full table scans is very low
if the number of index accesses is very high
Answer: A, B
QUESTION: 6
When starting up the test database, you encounter the following error after mounting the
database:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/u01/oracle/app/oradata/log2.log' ORA-27037: unable to
obtain file status
While investigating the reason, you find that the status of the redo log group 2 is CURRENT.
Which type of recovery would you perform to ensure that the database is functional?
A.
B.
C.
D.
E.
Open Database recovery
Time-Based incomplete recovery
recovery using the backup control file
Cancel-Based incomplete recovery
Change-Based incomplete recovery
Answer: D
1Z0-236
QUESTION: 7
What provides the information about the free extents in a temporary tablespace before a sort
operation?
A.
B.
C.
D.
E.
LRU chain
sort extent pool
resource free list
free extent table (FET$)
used extent table (UET$)
Answer: B
QUESTION: 8
What action can you take to reduce the recovery time in case of instance failures?
A.
B.
C.
D.
E.
use an SPFILE
multiplex the control files
reduce the number of data files used by the database
reduce the number of redo log members in each group
configure database parameters to increase the frequency of checkpoints
Answer: E
QUESTION: 9
The HR team is complaining about the poor response time of SQL statements on certain
tables. On investigation, you find that the generation of recursive calls (in addition to SQL
statements) to perform space management operations is the cause for the poor response time.
To solve the problem, you executed the following command as the first step:
SQL> SELECT owner, table_name, blocks, empty_blocks
2 FROM dba_tables
3 WHERE empty_blocks/(blocks+empty_blocks)<.1;
OWNER
TABLE_NAME
BLOCKS EMPTY_BLOCKS
----------------------------------------- --------------------HR
REGIONS
1205
30
HR
LOCATIONS
110
5
Select the next step that you would perform.
A.
B.
C.
D.
allocating extent to the tables by using the ALTER TABLE command
changing the block size by using the ALTER TABLESPACE command
exporting, dropping, and importing the REGIONS and LOCATIONS tables
creating the necessary indexes on the REGIONS and LOCATIONS tables
Pass4sure $89 Lifetime Membership Features;
-
Pass4sure $89 Lifetime Membership includes Over 2100 Exams in One Price.
All Pass4sure Questions and Answers are included in $89 package.
All Pass4sure audio exams are included free in $89 package (See List).
All Pass4sure study guides are included free in $89 package (See List).
Lifetime login access, no hidden fee, no login expiry.
Free updates for Lifetime.
Free Download Access to All new exams added in future.
Accurate answers with explanations (If applicable).
Verified answers researched by industry experts.
Study Material updated on regular basis.
Questions, Answers and Study Guides are downloadable in PDF format.
Audio Exams are downloadable in MP3 format.
No authorization code required to open exam.
Portable anywhere.
100% success Guarantee.
Fast, helpful support 24x7.
View list of All exams (Q&A) provided in $89 membership;
http://www.ipass4sure.com/allexams.asp
View list of All Study Guides (SG) provided FREE for members;
http://www.ipass4sure.com/study-guides.asp
View list of All Audio Exams (AE) provided FREE for members;
http://www.ipass4sure.com/audio-exams.asp
Download All Exams Sample QAs.
http://www.ipass4sure.com/samples.asp
To purchase $89 Lifetime Full Access Membership click here (One time fee)
https://www.regnow.com/softsell/nph-softsell.cgi?item=30820-3
3COM
CompTIA
Filemaker
ADOBE
ComputerAssociates Fortinet
APC
CWNP
Foundry
Apple
DELL
Fujitsu
BEA
ECCouncil
GuidanceSoftware
BICSI
EMC
HDI
CheckPoint Enterasys
Hitachi
Cisco
ExamExpress
HP
Citrix
Exin
Huawei
CIW
ExtremeNetworks
Hyperion
and many others.. See complete list Here
IBM
IISFA
Intel
ISACA
ISC2
ISEB
ISM
Juniper
Legato
Lotus
LPI
McAfee
McData
Microsoft
Mile2
NetworkAppliance
Network-General
Nokia
Nortel
Novell
OMG
Oracle
PMI
Polycom
RedHat
Sair
SASInstitute
SCP
See-Beyond
SNIA
Sun
Sybase
Symantec
TeraData
TIA
Tibco
TruSecure
Veritas
Vmware