최신 9i DBA 1Z0-035 무료샘플문제:
1. The new time and date data types support greater precision for capturing fractional seconds and time zone information. This gives the Oracle9i database greater flexibility in supporting locality preferences. What is the default degree of precision of fractional seconds when specifying the TIMESTAMP data type?
A) 6 digits
B) 12 digits
C) 9 digits
D) 22 digits
2. What is the meaning of using "character semantics" to create a table?
A) You specify the width of a column in characters, not in bytes.
B) You use only CHAR data types.
C) You use single letter names of all columns.
D) You use only character type data types (CHAR, NCHAR, VARCHAR2, NVARCHAR2, CLOB, NCLOB).
E) All columns are a single character wide.
3. What are the two methods used to add a second, or subsequent, block size to an existing database? (Choose two.)
A) Transport a tablespace with a different block size into the database.
B) Take a tablespace offline, and then put it back online with a new block size specification.
C) Re-create the control file to specify a new block size for specific data files.
D) Create a new tablespace and include a block size specification.
4. What are three advantages of index-organized tables? (Choose three.)
A) The table needs to be analyzed less frequently.
B) Data is stored in primary key sequence.
C) Fewer I/O operations are needed to retrieve data.
D) Less physical storage space is needed for the data.
5. The enterprise data warehouse routinely receives data from various production OLTP databases. The database block size on the data warehouse is 8192, and in the OLTP databases it may be 2048, 4096 or 8192. The current SGA is 112 MB.
Oracle9i has the ability to transport tablespaces with different block sizes.
Which two parameters are required in order to "plug in" the OLTP tablespaces into the warehouse database? (Choose two.)
A) DB_2K_BLOCK_BUFFERS
B) DB_4K_CACHE_SIZE
C) DB_8K_BLOCK_BUFFERS
D) DB_2K_CACHE_SIZE
E) DB_4K_BLOCK_BUFFERS
F) DB_8K_CACHE_SIZE
질문과 대답:
| 질문 # 1 정답: A | 질문 # 2 정답: A | 질문 # 3 정답: A,D | 질문 # 4 정답: B,C,D | 질문 # 5 정답: B,D |
985 개 고객 리뷰
품질과 가치ITCertKR 의 높은 정확도를 보장하는 최고품질의 덤프는 IT인증시험에 대비하여 제작된것으로서 높은 적중율을 자랑하고 있습니다.
테스트 및 승인ITCertKR 의 덤프는 모두 엘리트한 전문가들이 실제시험문제를 분석하여 답을 작성한 만큼 시험문제의 적중률은 아주 높습니다.
쉽게 시험패스ITCertKR의 테스트 엔진을 사용하여 시험을 준비한다는것은 첫 번째 시도에서 인증시험 패스성공을 의미합니다.
주문하기전 체험ITCertKR의 각 제품은 무료 데모를 제공합니다. 구입하기로 결정하기 전에 덤프샘플문제로 덤프품질과 실용성을 검증할수 있습니다.
