Oracle 10g DBA 1z0-046考题（分享）

aliload

Oracle   10g DBA   1z0-046考题
1. In an online transaction processing (OLTP) database instance that involves a high volume of data manipulation language (DML) operations, you decide to increase the value of the LOG_BUFFER parameter.
* v3 R% Z8 I& S6 `9 n. O+ ?3 uWhat could be the reason for this change?
! M- G4 t" B7 O1 `* B1 ~A.The buffer busy wait event has been detected.
B.The no free buffers event has been detected.
2 K0 F0 B. f# C: PC.The log buffer space wait event has been detected.
. K1 [- e: r$ U$ g1 AD.The log file completion wait event has been detected.
" T+ g8 w$ ^3 [, V# C; C4 dE.The value for the free buffer inspected statistics is growing.
ANSWER: C

. o) L, g, ^2 b) }2. ho.sh is an executable shell script. You executed the following command that leads to an error:
$ strace -o /tmp/ho.out ./ho.sh
strace: exec: Permission denied
What could you do to execute the command successfully in the next attempt?
4 \4 F. S3 \( RA.Provide the shell reference with the command.
2 ~. x- I7 m* F7 N/ b1 ~) QB.Remove the shell reference present inside the shell script.
C.Execute the command as the root operating system user.
D.The extension for the output file should be changed to .log.
ANSWER: A

; P, o7 y0 r/ @3. You need to ensure that whenever you create a new file, it should have the following set of permissions:
$ Z) O8 B- i( ]# G8 @u=rwx,g=rx,o=rx.
Which statement can you add to the .bashrc script to set the desired file permissions?
5 U) C0 K2 Z( A2 B4 N$ r2 v7 tA.umask 455
B.umask 012
. O! {1 F) [" b) ?; d& N" HC.umask 0755
8 `: V0 Z; y  P! aD.chmod u=rwx,g=rx,o=rx
3 y9 f, e% K7 c& H: dANSWER: C
4 |8 s( ^) E0 W1 u+ x1 N- ?: @
; I# {7 K& J3 {8 N4 W  C4. Which three statements are true about Oracle Clustered File System (OCFS)? (Choose three.)
. a( E) X6 N& Y/ sA.There is no limit on the number of files on OCFS.
# O+ K' B8 o& \, ^  z: U8 x* |B.You can use OCFS for database files as well as general files.
C.You can create an OCFS using Logical Volume Manager (LVM).
D.You must modify the Linux kernel parameters before mounting OCFS.
E.Standard file system commands, such as mkdir, rmdir, and mv, are available on OCFS.
ANSWER: ABE
7 p2 Z: H5 I3 u. b/ k$ h+ D: e
6 L8 `. S; v6 `8 y" E4 S) a$ u' x) N5. The OS user BOB is a member the osoper OS group in the database server. You want BOB :
Which of the option would fulfill the requirement?
A.Assign the sysdba privilege to BOB.
* ^" _, c1 q, K& ?% ~B.Assign the osdba OS group to BOB.
) ?7 ?9 O* J( E! ]9 gC.Set the REMOTE_LOGIN_PASSWORDFILE initialization parameter to SHARED.
D.Set the REMOTE_LOGIN_PASSWORDFILE initialization parameter to EXCLUSIVE.
ANSWER: B

6. You executed the ipcs -m command to list all the shared memory segments in your Oracle server.
% V9 U/ p7 u9 j8 e2 F! u$ [! LView the Exhibit exhibit1 that shows the output of this command.
- l7 n( ~8 @9 X! s2 |: tLater, you executed the same command to check the shared memory segments.
View the Exhibit exhibit2 that shows the output of this command.
# O, `, W; O* ?Why is the large shared memory segment not listed in the second Exhibit?
: L$ A, j% z8 }2 `  n2 Q" YA.The Oracle database instance is shut down.
! g# n- F% _) {0 jB.The swap space has been increased in the system.
& P: m  B* w, N& ~4 UC.The Oracle database instance is configured in shared server mode.
D.The large pool size set for the Oracle database instance is reset to zero.
( _( Y+ i5 v: j, u9 _ANSWER: A

7. You attempt to modify the ksms.s library and relink the Oracle database executable to use the address 0X15000000 for the System Global Area (SGA). You receive an error.
Which set of commands would you use to restore the original settings?
( a, `: H, K5 K8 t3 YA.echo 0X1000000 > ksms.s
make -f ins_rdbms.mk ksms.s
B.echo 0X15000000 > ksms.s
( S; p& h$ V3 c! U- V# |0 @' amake -f ins_rdbms.mk ioracle
C.make -f ins_rdbms.mk ksms.s
1 Q( ?; c0 w9 r3 o- N1 Z5 p) kmake -f ins_rdbms.mk ioracle
( O" E1 E2 Q% l* t" BD.genksms > ksms.s
$ x+ P  w( \" h: |make -f ins_rdbms.mk ksms.o
make -f ins_rdbms.mk ioracle
E.genksms -s 0X10000000 > ksms.o
! e0 ]0 G! E/ Z) QANSWER: D

" S+ t1 f8 g, Q! L% S2 Q2 b; G8. You want to install Oracle Database 10g on a Linux machine. You want to ensure that no tainted modules are loaded on the kernel. Which commands will you execute to achieve this?
A.uname -r
. B( B" ~) V" V  C; L* iB.uname -v
C.cat /proc/version
2 S3 B! H5 ~# }' `$ sD.cat /proc/sys/kernel/tainted
4 N  m+ y$ l0 f6 Q$ x5 ]ANSWER: D

9. Examine the content of the /proc/sys/kernel/tainted file on your Linux machine:
[root@edtdr6p1 root]# cat /proc/sys/kernel/tainted
1
" p0 H! i, [3 r6 J) {( M# ]What will happen when you install Oracle Database 10g on this machine?
" Y: C7 G/ s& j: W% TA.Installation will fail because of the tainted kernel.
6 j5 ~: L) @- v8 ?' a. t! }! vB.Installation will be successful, but Oracle will not provide support for the database product.
' f) ~% g7 P( BC.Installation will be successful. Oracle will provide support for the database product but not for the operating system (OS).
( h0 i/ j9 W: [) D" e+ FD.Installation will be successful and Oracle will provide support for the database product as well as the OS.
7 @0 J5 y4 u4 yE.Successful installation and Oracle support for database product as well as Linux OS will depend on the module tainting the kernel.
& g  T  j! V! C7 }! h3 W1 sANSWER: E

10. A non-General Public License (GPL) driver was loaded on a Linux machine. To verify that the module has tainted the kernel, you executed the cat /proc/sys/kernel/tainted command and received the following output:
[root@edtdr6p1 root]# cat /proc/sys/kernel/tainted
5 {1 u" e7 y# C( `9 I9 u# \# T+ d# v1
What do you infer from the output? (Choose all that apply.)
A.A proprietary module has been loaded.
: T) [* Q- \$ Z5 J8 {1 N8 NB.A module is marked unsupported by the vendor.
C.All the loaded modules have General Public License (GPL).
D.A module was force-loaded by using the insmod -f command.
9 U$ X% B& ]2 t: z- f. c+ kANSWER: AD

7 i6 i' I# Q" O: d+ J! i2 x/ R0 ^11. Which command is used to identify the kernel version number?
A.which
B.whatis
- i6 i6 I$ ^7 N' ?3 p3 A- UC.uname -r
" g" `4 n' |$ f' AD.ulimit -m
/ a7 g& C0 n6 N( X! R; v6 {. u' mE.chkconfig
9 D3 ?. E1 x  W7 }& d+ lANSWER: C

- p7 \$ w. `1 Y7 I' r5 \3 h! Y12. Match the following commands with the purpose they are used for:
1 F, P- r& s  e' [; CI chmod a) To create a file with the desired time stamp
ii touch b) To use the variable of the parent shell in child shell
1 j, R9 @4 e6 |+ i8 J  W/ ~iii alias c) To give write permission to a directory
iv uname d) To simplify long commands
  P( z' J; B9 b, S0 j% |v export e) To see the Linux release number
: H0 x  J! z4 c  @6 Y2 tA.i-a, ii-e, iii-d, iv-c, v-b
$ ]$ Q1 Q, O: |( o, ^B.i-c, ii-a, iii-e, iv-d, v-b
+ E" a, s) j. m- i$ JC.i-c, ii-e, iii-b, iv-a, v-b
; W: `+ T. {1 B: z3 Q& BD.i-c, ii-a, iii-d, iv-e, v-b
3 @$ Z) p, \" hANSWER: D
. Q6 [8 u/ J  H, t# a# N$ W
  [4 h- O! s  G% x3 R13. You logged in as user user1 on a Linux machine. You need to check which groups you belong to. Which commands will you use? (Choose two.)
' z* C9 K) D2 nA.id
- b- S, `: g+ t8 F5 f9 kB.uname -G
. T, Q7 l2 ]* eC.cat /etc/passwd
D.cat /etc/group
3 r% [* }/ p6 \E.cat .bash_profile
( c. W9 o/ K, a% d! Q8 C8 P& KANSWER: AD

1 C0 m& ~$ [$ V$ l2 u! p( ]. d" q14. View the Exhibit.
, B  P6 z; H% h) x) ?) M/ UWhich two statements are true about the output of the cat /proc/partitions command? (Choose two.)
7 G! G' [& |+ A2 y4 j6 ]2 bA.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.
  k6 J9 B" M+ h5 @' a# j/ }3 {
1 h1 j9 @8 U* k3 a+ sANSWER: AD

2 p( {/ v) A4 E& f9 f/ p0 `15. Which command would you use to identify the users that belong to the oradba group?
6 h$ ~5 J7 {3 tA.id -G
B.uname -g
9 g' h! t9 j+ S6 b$ r7 W: T1 vC.grep ^oradba: /etc/passwd
2 [' ^0 m& l# E5 I+ `D.grep ^oradba: /etc/group
ANSWER: D
$ T5 G. v! Y3 s0 E  O  t; B" y
# s9 s6 h  j! V5 q% G16. View the Exhibit and examine the output.
% I2 X# K/ y* d/ a4 O% ?1 s# vWhat do you infer from this? (Choose all that apply.)
6 E+ D' j+ W9 H# E$ r/ a/ CA.The command output is stored in the pmon.txt file.
B.The command shows all the processes running on the machine.
% ^7 J, u( G4 c3 z9 \2 d" ^& eC.The command appends the pmon.txt file with the output of the command.
% Q' z! a/ k# }' C# U& qD.The command shows only those processes that contain the text _pmon running on your machine.
0 H( T5 Y1 g- M' S- \# cE.The logs generated while executing the command will be stored in the pmon.txt file.

ANSWER: AD
# z" [& g0 s- e, X' q# v
$ J7 u' j/ {8 y17. View the following script:
if [ -r /etc/oratab ]
/ x$ p$ i6 W' S' uthen
ORATAB=/etc/oratab
% P. ]! Y2 ^# x6 V0 relse
if [ -r /var/opt/oracle/oratab ]
8 `0 q: V& a0 z% @- j! Dthen
ORATAB=/var/opt/oracle/oratab
- W+ p& V' {' C2 felse
echo "Can't find any oratab file"
exit 1
5 L% R3 R. S$ p* A+ F& yfi
fi
grep -v [\#\*] $ORATAB | cut -d ":" -f1
Which statement is true about the execution and output of the script?
+ m' o# j2 d2 u- JA.It will execute only in the /etc/oratab directory.
0 @  O" T1 y% i4 g0 Z6 n% YB.It will show all the Oracle homes listed in the oratab file on the local machine.
# k4 ^* X1 {' q+ YC.It will show all Oracle database SIDs listed in the oratab file on the local machine.
0 n4 s# {7 w- i) f# \' mD.The script output will depend on the command-line arguments passed while executing the script.
ANSWER: C

4 \2 s6 t+ e  K7 n7 x18. Which three statements are true about the built-in shell variables? (Choose three.)
A.The $? Variable stores true and false values.
% i" q3 A8 x; U& b  i8 O, a8 QB.The $* variable stores all the command-line parameters passed.
/ Z9 _" C, y  e: h$ F6 s3 s) {C.The $# variable stores the total number of command-line parameters.
) J. P3 Q* ~* j) b0 `! P: ^/ YD.The values for these variables are retained in the session until it is reset.
E.The $n variable can store n number of positional command-line parameters.
ANSWER: BCE

19. View the following script:
if [ -d $1 ]
then
0 c: O6 P% H. H& Vfor Data in `ls $1 *|tr -s " "| grep .dbf`
) {0 S4 m; v8 ndo
echo $Data
done
else
1 }8 K, j, w. E% A. U1 gecho -e "No Directory specified"
# O  h/ }2 ]- G! I# C: kfi
2 |" C& @1 l$ b8 H3 J5 OWhich statement is true about the script?
4 v9 ~& |# j# E+ O1 sA.The script displays the total number of .dbf files on the local machine.
B.The script will not execute because no value for the $1 variable is given.
5 V1 D2 `, I& F2 ZC.The script displays the .dbf files in the location given as a value in the positional parameter.
" l  M3 t: `1 x0 Q7 tD.The script will give an error because the variable name should contain the letters of the English alphabet.
% V6 x3 w4 w& XANSWER: C
9 A$ T  ~; U. i( K3 G7 ~
& [( s7 r% l* |3 Q0 P, S2 p, t) A20. You have started an instance with the DBWR_IO_SLAVES initialization parameter set to 2. What will be the result of setting this parameter? (Choose two.)
0 t# v9 H! E& gA.The DISK_ASYNCH_IO initialization parameter will be set to True.
B.The TAPE_ASYNCH_IO initialization parameter will be set to True.
: ^5 t2 @( _" Y0 x2 {C.The database instance will simulate asynchronous input/output (I/O).
D.Oracle server will update the value for the DB_CACHE_SIZE initialization parameter as per the system requirement.
E.If the existing value of the DB_WRITER_PROCESSES initialization parameter is set to greater than 1, then the DB_WRITER_PROCESSES parameter will be set to 1.
, \+ Z  \! E$ f( C9 A; \9 s+ lhabet.
ANSWER: CE
( x  f+ j' k9 `  E
21. Which two statements are correct about the DB_WRITER_PROCESSES initialization parameter? (Choose two.)
A.The default value for DB_WRITER_PROCESSES is (CPU_COUNT+7)/8.
. [! c6 h8 X/ E& T/ e2 B5 DB.You set DB_WRITER_PROCESSES to greater than one to simulate asynchronous input/output (I/O).
; ]: J& h( p3 [C.You cannot set DB_WRITER_PROCESSES to greater than one if asynchronous I/O is enabled for the Oracle server.
9 ?2 |5 b: T# U& X% @$ T& D8 I4 C/ c) hD.You cannot set DB_WRITER_PROCESSES to greater than one if the DBWR_IO_SLAVES initialization parameter is set to greater than zero.
& V" N- r3 C/ F' ^+ x+ cE.You must set an appropriate value for the LOG_PARALLELISM initialization parameter before modifying the default value for DB_WRITER_PROCESSES.
* ~' }) h  I. o+ v0 A% B& WANSWER: AD
( r: w7 B* U8 o9 C2 |, c
22. You set the PRE_PAGE_SGA initialization parameter to True. Which two outcomes will result due to the setting of this parameter value? (Choose two.)
A.The startup process will take more time.
B.The value for DB_BLOCK_LRU_LATCHES will be set to 4.
" ^& \' I- }$ F# N3 HC.The database instance cannot use multiple DBWR processes.
D.The database instance will simulate synchronous input/output (I/O).
E.Each Oracle server process will read the entire System Global Area (SGA) to physical memory at session startup.
4 a, ?" ~* i. A' e0 b+ C4 @+ c/ aANSWER: AE
: |5 I. u) @6 m2 y* x
23. In an online transaction processing (OLTP) database, a large number of concurrent users are performing small transactions on a specific schema. You observe the statistics and find that total_waits for buffer busy event is increasing significantly. You are in the process of creating another OLTP database with similar workload.
What would you do to avoid the wait event in the new database?
( D; P6 o+ A  d9 {A.Consider setting a larger value for DB_BLOCK_SIZE for the database.
& H: @8 S$ B8 V: U& `B.Consider setting a smaller value for DB_BLOCK_SIZE for the database.
* Q* H$ c& Y; o* D: D* FC.Consider setting a larger value for the DB_CACHE_SIZE parameter for the database.
D.Consider using the DB_BLOCK_BUFFERS parameter instead of the DB_CACHE_SIZE parameter for the database.
, N" C( ~2 u$ a2 r4 vANSWER: B
* P7 b) [* e" N( ~
  H5 e! H0 ]4 F, ?+ e24. You executed the following command:
cat /proc/slabinfo | grep kio
You received the following output:
2 F4 O/ ~- n5 f" L0 l' H+ `kioctx 270 270 128 9 9 1
; b% \( K" W  T; ?kiocb 66080 66080 96 1652 1652 1
kiobuf 236 236 64 4 4 1
What do you infer from the output?
A.There are no inactive pages.
B.The disk activity needs to be tuned.
# J- f5 I( {6 w5 s3 |' y: ~( x& ]C.There are waits for the buffer cache.
D.The value for the shmmax parameter needs to be increased.
$ @4 c1 L3 F6 V3 }# h. ~! T+ l* o2 p! hE.The Linux system has asynchronous input/output (I/O) configured on it.
o greater than 1, then the DB_WRITER_PROCESSES parameter will be set to 1.
habet.
ANSWER: E
/ w" z- C0 M% {# H
25. You executed the following command on a Linux machine:
$ cat /proc/slabinfo | grep kio
/ I, h! @# {2 e/ m) ]kioctx 270 270 128 9 9 1 : 252 126
kiocb 66080 66080 96 1652 1652 1 : 252 126
: R5 |4 l' \& c+ \kiobuf 236 236 64 4 4 1 : 252 126
  J  m' J7 n0 kWhich statement describes the purpose of executing the command?
" N  x8 |( ^6 b9 xA.to check the virtual memory usage in the Linux system
B.to compare the I/O statistics of different channels in the system
5 T7 X+ ^  l3 _7 B, RC.to check whether the asynchronous I/O is working in the Linux system
D.to check whether multiple data bus adapters are being used in the Linux system
E.to check whether the shared memory file system is being used in the Linux system
6 Q! o$ ^' `7 o) a# Y" B+ I4 p4 t+ nANSWER: C

  H2 N1 K1 W. Q; Z- w- p26. You detected free buffer waits events for your database instance running in a machine that has multiple CPUs. You increased the database buffer cache size as the first step. After a few hours of work on the database, further investigation shows that the same event is being recorded.
5 n+ u. B( I3 f/ J" [What would be your next step to avoid this event in future?
9 x- k* N8 E3 H" o. w' yA.Decrease the value of the DBWR_IO_SLAVES parameter.
7 Z0 \+ C; T8 i- \+ ?/ W1 A+ vB.Increase the value of the DB_WRITER_PROCESSES parameter.
3 Y+ t' M6 |" v, t! RC.Set the USE_INDIRECT_DATA_BUFFERS parameter to TRUE.
D.Increase the value of the DB_FILE_MULTIBLOCK_READ_COUNT parameter.
ANSWER: B
5 M+ z& E7 v0 f, P+ R& I- @
$ \$ {( m5 M. |; Y, }27. To simulate asynchronous I/O for your database, you set the value for the DBWR_IO_SLAVES parameter. The large pool and Java pool are configured for the database instance.
4 a/ x! c; @2 v5 g2 j) dWhich memory area is used as the communication area for I/O buffers?
A.The java pool
7 C2 T6 V# n) F5 P( F* xB.The large pool
2 L' V+ c2 Z$ z* h* {C.The shared pool
5 o$ c0 G; T; l7 ZD.Memory space allocated separately outside the SGA
" H0 I2 P( L! l. w0 kANSWER: B

28. Which statement correctly describes the relationship between the DB_WRITER_PROCESSES initialization parameter and I/O slaves that are enabled in the Oracle database instance?
: e2 N: F$ K: ~5 r3 k% P# wA.Setting DB_WRITER_PROCESSES to more than one reduces DBWR_IO_SLAVES to one.
B.Enabling I/O slaves forces the value of the DB_WRITER_PROCESSES parameter to be set to one.
$ N; U+ g$ ~% XC.Each DBWR process uses a single I/O slave when DB_WRITER_PROCESSES is set to more than one.
D.The database performance is directly proportional to the number of I/O slaves when DB_WRITER_PROCESSES is set to more than one.
6 ?3 W$ y% z5 K  Y4 L* _8 BANSWER: B

29. You have a Linux machine with an Oracle database instance running in it. The database users log on and log off from the database instance frequently. The page size for the system is 4 KB and the SGA size is 100 MB. To reduce the page fault, you set the PRE_PAGE_SGA parameter to TRUE for the database instance. After some time you observed that the process startup duration has increased significantly.
+ H) \* V. S% E9 _7 @What could be the reason for this?
A.The SGA has been locked into physical memory.
B.Each server process that starts must access every page in SGA.
8 D/ W; p* G2 W( O6 u8 f0 Z$ @C.The session memory for the new connections is allocated from SGA.
. F( S8 o2 ^9 d) S0 W' h% ?* w- k* i' DD.The SGA size is adjusted by the Automatic Shared Memory Management feature during every new connection.
ANSWER: B

3 {; w# t" [; Y30. You are working on a database instance with the following requirements:
During daytime, there is a large volume of transaction that requires a large database buffer cache.
% P. t0 W; B3 h, T6 I2 uIn the night, batch jobs are run. These jobs require a higher value for the large pool.
5 {* s6 d& i% }% x9 O. k& U! R3 NYou want to automate the configuration for the memory components so that the parameters are not required to be changed manually every day. What would you do?
+ W$ P* s: l% ?7 v9 ^3 G: ?A.Set the PRE_PAGE_SGA initialization parameter to TRUE.
7 L1 |/ v) z3 v4 ]3 K$ S! G& ?B.Set the SGA_TARGET initialization parameter to a nonzero value.
' t- {+ t' \/ a; \) X0 G% qC.Set the DB_BLOCK_BUFFERS initialization parameter to a nonzero value.
( _& k( x# Y( g) ND.Set the USE_INDIRECT_DATA_BUFFERS initialization parameter to TRUE.
: I% o$ {) x- `6 [1 ~ANSWER: B