1 : oracle immediately re-uses the space assigned to row-directory portion of the data block once you delete the corresponding rows.
1 b! i% c9 H/ D p " I4 n( G! K+ K- B
1. true
! a7 S: j8 a# F W% P' f" }& j 2. false
" l1 C: j' l% K: L7 f. \, `
. g9 _0 W8 T( D* c2 E 2 8 H5 M; N0 ?# b
* _& z9 x9 a& W; e0 f+ B4 [ q. 2 : which of the following three portions of a data block are collectively called as overhead. ( ^8 w: I s" ~
7 u- ^4 a% [/ r5 R9 b9 A# m
1. table directory, row directory and row data
; x8 Y2 Z* T0 a3 p 2. data block header, table diretory and free space
5 ]) F; A# y! ]& o1 C( ~ 3. table directory, row directory and data blcok header
8 f6 w Z' d+ @/ U' e, R2 `+ a1 V 4. data block header, row data and row header " [) W" |4 P7 S( u
* u: ]7 }% M# s0 R) k- Q; ^ H1 r 3
, Q7 U# S7 V6 ^
( r6 P+ p4 O& X; W1 A: G q. 3 : which portion of the data block contains table or index data
) L" y7 c9 C0 l( a
8 x' ?, p1 X2 Q 1. table directory 1 d0 P( c$ |6 y. [# [7 M8 \ h% y- f
2. row directory
! C4 `' n' z' C, @: E 3. overhead
8 Q4 \: r, a5 z9 n) _ 4. row data
7 `0 }4 d. y/ _. h1 o7 n# J% V
; f/ q9 W, D" T# i 4 " r. |7 a( s0 C& a& m
9 |3 u0 t+ l( e% i
q. 4 : what are the two space management parameters for controling the use of free space in a data block 5 @) W2 X: W$ r. z: n- h
6 [) s1 F8 P) F& R% \1 a 1. initial and next
& d; ]' i6 o5 E( H. X2 W# I 2. pctfree and pctused
" J: l1 \2 U( A% F: n# V: m# R" w 3. tablespace and storage
+ g. o3 ^4 l5 Y0 @1 |6 Y 4. free space cannot be controlled at block level $ z; B+ V+ K* g5 W) _' |
) V! E0 C ~" z Z 2
' S) u$ z6 D1 p7 |: L
# b: B- t# L0 g7 J9 n& P. H q. 5 : the maximum number of transactions that a block can support is
* p3 g' r, x. {" W & `3 u3 u) I) P; E S! R2 d' K
1. 100
* e' d+ i" x: L' ?6 A: x. H3 l 2. 255 7 M, ]/ M8 j3 ^$ e" g
3. 1000 + b2 `5 ~2 u- T! x# G* V9 l
4. unlimited / L" D. t$ P2 w, G3 s8 l
2 i- @; i4 ^( u ]& P% G 2 - H8 P0 L1 F6 a; d/ B5 K0 N
5 l3 g/ E; z9 L9 N+ [
q. 6 : what is pctfree # k8 u; u$ C& q9 g, s
$ i$ U' ]7 U7 F8 q6 q 1. a space management parameter which sets aside that much percentage of memory in the data block for future update of existing rows.
+ z$ N7 ]% C n) j o; l 2. a space management parameter which determines the minimum percentage of a block that can be used for row data plus overhead. r' I7 m/ s! M" J
3. a space management parameter which tells oracle that the block is available for inserts after the percentage of used memory falls below certain percentage. % { _% |1 T j& j+ K' s/ w7 k. _
4. all of them 7 s; T5 M$ s. {' A) S9 l
% ~4 }% P" h4 \/ h$ J0 V 1 / G2 j" d) K2 u
! {2 a: L# v. r0 |. K q. 7 : what is the default value of next parameter ; d! O ~+ W/ y% ^$ D- }# m+ Q
- ]$ X& A& q+ G m4 ?7 S9 I 1. 1 block * p: b6 l5 E8 {/ w
2. 2 blocks
% O X+ s5 W1 } 3. 5 blocks 5 [) i" z, s) w5 j5 _2 T0 ~/ |- E
4. 100 blocks
$ p' W& | G# O' G* R* T. k
, q! Q0 W+ J! p 3 7 a8 O9 m1 M, N: O9 U# i
( N& _2 f7 {- N0 |+ _ q. 8 : which parameter reserves the more space for future updates
* M M* s+ L p
% o+ T9 r: h1 s' E 1. high pctincrease
, z! y/ @" c# ~- b 2. high pctfree
4 _) ^0 C- q6 P! w, a4 T; [ 3. high initial $ x, P# Y, |9 j5 b4 X. A3 H
4. high pctused
/ X2 G# v+ j u8 E& M! x; Y . O% X' e+ Z& q6 @9 N2 q
2 0 \: O# L7 K! ]
3 |: u- @/ W$ M q. 9 : pctfree and pctused together should not exceed 6 o9 [# y4 A/ T0 n1 K2 u- N0 ]
$ R. P' H8 @+ r4 h8 ? 1. 100 8 J! s# D4 p( @) v0 u0 [
2. 50 b/ u- K9 J" O: T% G8 d+ s
3. 25
) I/ V2 Y! D( X( Q. p 4. 10
6 N' _# K6 `5 @$ \' |% b , n1 T5 `% b) |8 G' J9 {2 M$ b
1
4 h/ L. L' O2 E5 F& A* A. \ - i' L, o$ y. D' s" N
q. 10 : row migration is a result of |