Oracle 1Z0-035 問題集

質問 1：
Using a bitmap structure to manage database object space has several benefits over using freelist structures.
Which three are benefits of managing space using automatic segment-space managed objects? (Choose three.)
A. It requires fewer space related options than freelist managed structures.
B. It readily responds to dynamic changes for concurrent access.
C. It improves performance and space utilization in a multi-instance environment.
D. It improves performance for SYSTEM tablespaces where a high degree of concurrency is required.
正解：A,B,C

質問 2：
What is true if you want to switch undo tablespaces from the current one, called UNDO1, to a new one called UNDO2?
A. It is possible to switch to UNDO2; current active transactions will be automatically migrated to UNDO2.
B. It is possible to switch to UNDO2, but current active transactions will abort.
C. It is possible to switch to UNDO2; only current active transactions will continue to execute inside UNDO1.
D. It is NOT possible to switch unless no active transaction exists in UNDO1.
正解：C

質問 3：
Which CREATE TABLE parameter should you be concerned with if the length of rows in an index-organized table vary over a wide range of values?
A. PCTTHRESHOLD
B. PCTFREE
C. PCTUSED
D. PCTINCREASE
正解：A

質問 4：
What does the Character Set Scanner command line utility do?
A. scans on any character set conversion required, then converts the data
B. performs character set conversions to the new specified character set
C. reports only on any Unicode character conversions required
D. checks for any character definitions that will fail conversion to the new character set
正解：D

質問 5：
An index-organized table (IOT) called SPARSE has had many records deleted.
Which command reorganizes the IOT so that the empty space is removed, while minimizing the impact for users?
A. ALTER INDEX REBUILD ONLINE ;
B. ALTER TABLE COALESCE ;
C. EXPORT with TABLES and IMPORT with the INDEX and IGNORE options.
D. CREATE TABLE AS SELECT ONLINE;
正解：B

質問 6：
Examine the statement:
ALTER TABLE sales EXCHANGE PARTITION q1_2000 WITH TABLE sales_q1_2000 UPDATE GLOBAL INDEXES PARALLEL (DEGREE 4);
What is the result of the statement?
A. Nonpartitioned indexes on the SALES table will be marked UNUSABLE, while valid partitioned global and local indexes will retain their USABLE status.
B. Valid indexes on the exchanged table SALES_Q1_2000 will remain in the USABLE state, while all indexes associated with the new partition Q1_2000, will be marked UNUSABLE, including any global indexes on SALES.
C. Global indexes on the SALES table will be maintained concurrently with the exchange operation if the statement executes with the desired degree of parallelism (four) otherwise it will execute serially and mark the global indexes UNUSABLE.
D. All valid global indexes on the SALES table will retain their USABLE status after the statement completes.
正解：D

質問 7：
Which two procedures or functions are part of the DBMS_METADATA package? (Choose two.)
A. GET_VIEW
B. GET_DDL
C. GET_TABLE
D. GET_TYPE
E. GET_XML
正解：B,E

質問 8：
Click the Exhibit button.
Given the partition definition, which insert statement will fail?

A. insert into sales(year,month,day) values (2000,02,33);
B. insert into sales(year,month,day) values (2000,01,01);
C. insert into sales(year,month,day) values (2000,01,17);
D. insert into sales(year,month,day) values (2000,03,32);
正解：D