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

Immediately after adding a new disk to or removing an existing disk from an ASM instance, you find that the performance of the database goes down initially until the time the addition or removal process is completed, and then gradually becomes normal. Which two activities would you perform to maintain a consistent performance of the database while adding or removing disks? (Choose two.)

• A.Increase the number of ARB processes by setting up a higher value for ASM_POWER_LIMIT.
• B.Define the POWER option while adding or removing the disks.
• C.Increase the number of slave database writer processes by setting up a higher value for DBWR_IO_SLAVES.
• D.Increase the number of DBWR processes by setting up a higher value for DB_WRITER_PROCESSES.

Evaluate the following SQL statement used to create the PRODUCTS table:
CREATE TABLE products
(product_id NUMBER(3) PRIMARY KEY,
product_desc VARCHAR2(25),
qty NUMBER(8,2),
rate NUMBER(10,2),
total_value AS ( qty * rate))
PARTITION BY RANGE (total_value)
(PARTITION p1 VALUES LESS THAN (100000),
PARTITION p2 VALUES LESS THAN (150000),
PARTITION p3 VALUES LESS THAN (MAXVALUE))
COMPRESS FOR ALL OPERATIONS;
Which statement is true regarding this command?

• A.It executes successfully but the values in the TOTAL_VALUE column would not be physically stored in the partitions.
• B.It produces an error because compression cannot be used for the TOTAL_VALUE partition key.
• C.It executes successfully but partition pruning cannot happen for this partition key.
• D.It produces an error because the TOTAL_VALUE column cannot be used as a partition key.

You executed the following PL/SQL block successfully:
VARIABLE tname VARCHAR2(20)
BEGIN
dbms_addm.insert_finding_directive (NULL, DIR_NAME=>'Detail CPU Usage',
FINDING_NAME=>'CPU Usage',
MIN_ACTIVE_SESSIONS=>0, MIN_PERC_IMPACT=>90);
:tname := 'database ADDM task4';
dbms_addm.analyze_db(:tname, 150, 162);
END;
/ Then you executed the following command:
SQL> SELECT dbms_addm.get_report(:tname) FROM DUAL;
The above command produces Automatic Database Diagnostic Monitor (ADDM) analysis ____.

• A.with the CPU Usage finding for snapshots below 90
• B.with the CPU Usage finding for snapshots not between 150 and 162
• C.without the CPU Usage finding if it is less than 90
• D.with the CPU Usage finding if it is less than 90

Evaluate the following command and its output:
SQL>SELECT * FROM dba_temp_free_space; TABLESPACE_NAME TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACE
LMTEMP 250609664 101048576 149561088
Which two statements correctly interpret the output? (Choose two.)

• A.FREE_SPACE indicates only the space that is currently unallocated.
• B.ALLOCATED_SPACE indicates both the space currently allocated and used, and the space that is available for reuse.
• C.FREE_SPACE indicates only the space that is currently allocated and available for reuse.
• D.ALLOCATED_SPACE indicates only the space currently allocated and in use.
• E.FREE_SPACE indicates both the space that is currently allocated and available for reuse, and the space that is currently unallocated.

You upgraded Oracle Database 10g to Oracle Database 11g. How would this affect the existing users' passwords?

• A.All passwords remain non-case-sensitive and cannot be changed.
• B.All passwords automatically become case-sensitive.
• C.All passwords remain non-case-sensitive till they are changed.
• D.All passwords remain non-case-sensitive until their password attribute in the profile is altered.