1z1-034 試験問題を無料オンラインアクセス

To accomplish user-managed backup for the USERS tablespace, you issued the following command to put the tablespace in backup mode:
SQL> ALTER TABLESPACE users BEGIN BACKUP;
While copying the file to the backup destination a power outage caused the instance to terminate abnormally.
Which statement is true about the next database startup and the userstablespace?

• A.The database will open, and the tablespace automatically comes out of the backup mode.
• B.The database will be mounted, and data files in the USERS tablespace must be taken out of the backup mode.
• C.The database will be mounted, and recovery must be performed on the USERS tablespace.
• D.The database will not be mounted, and you must restore all the data files for the USERS tablespace from the backup, and perform recovery.

Evaluate the following statements:
CREATE TABLE purchase_orders (
po_id NUMBER(4),
po_date TIMESTAMP,
supplier_id NUMBER(6),
po_total NUMBER(8,2),
CONSTRAINT order_pk PRIMARY KEY(po_id))
PARTITION BY RANGE(po_date) (
PARTITION Q1 VALUES LESS THAN (TO_DATE('1-apr-2007','d-mon-yyyy'),
PARTITION Q2 VALUES LESS THAN (TO_DATE('1-jul-2007','d-mon-yyyy'),
PARTITION Q3 VALUES LESS THAN (TO_DATE('1-oct-2007','d-mon-yyyy'),
PARTITION Q4 VALUES LESS THAN (TO_DATE('1-jan-2008','d-mon-yyyy'));
CREATE TABLE purchase_order_items (
po_id NUMBER(4) NOT NULL,
product_id NUMBER(6) NOT NULL,
unit_price NUMBER(8,2),
quantity NUMBER(8),
CONSTRAINT po_items_fk FOREIGN KEY (po_id)
REFERENCES purchase_orders(po_id))
PARTITION BY REFERENCE(po_items_fk);
What are the two consequences of the above statements? (Choose two.)

• A.Partitions of PURCHASE_ORDER_ITEMS have system-generated names.
• B.Partitions of the PURCHASE_ORDER_ITEMS table exist in the same tablespaces as the partitions of the PURCHASE_ORDERS table.
• C.Partition maintenance operations performed on the PURCHASE_ORDER_ITEMS table are automatically reflected in the PURCHASE_ORDERS table.
• D.Both PURCHASE_ORDERS and PURCHASE_ORDER_ITEMS tables are created with four partitions each.
• E.The PURCHASE_ORDER_ITEMS table inherits the partitioning key from the parent table by automatically duplicating the key columns.

SQL> SELECT blocks FROM user_segments WHERE segment_name=,ALTBT; BLOCKS
704
SQL> ALTER TABLE altb SHRINK SPACE COMPACT;
Table altered.
SQL> SELECT blocks FROM user_segments WHERE segment_name=*ALTB*;
BLOCKS
704
View the Exhibit and examine the output and commands executed on the ALTB table.
Why does the number of blocks for the table remain the same after the shrink operation?

• A.because the high-water mark (HWM) did not move due to the compact option that is used in the shrink operation
• B.because the row IDs remain the same for all rows during the shrink operation
• C.because the progress of the shrink operation is not saved in the bitmap blocks of the table
• D.because the table did not contain migrated or chained rows

Which two statements are true regarding the functionality of the remap command in ASMCMD?

• A.It repairs blocks that have read disk I/O errors.
• B.It checks whether the alias metadata directory and the file directory are linked correctly.
• C.It repairs blocks by always reading them from the mirror copy and writing them to the original location.
• D.It reads the blocks from a good copy of an ASM mirror and rewrites them to an alternate location on disk if the blocks on the original location cannot be read properly.

While designing a database, you created the EMPLOYEES table as an index-organized table (IOT).
You must create a bitmap index on the EMPLOYEES .JOB_ID column.
Which must you do to enable the creation of the bitmap index?

• A.A mapping table must have been created.
• B.A primary key must have been created.
• C.The PCTTHRESHOLD option must have been specified.
• D.An overflow tablespace must have been specified.