1Z0-050 무료 덤프문제 온라인 액세스

You want to perform the following operations for the DATA ASM disk group:
-Verify the consistency of the disk.
-Cross-check all the file extent maps and allocation tables for consistency. -Check whether the alias metadata directory and file directory are linked correctly. -Check that ASM metadata directories do not have unreachable allocated blocks.
Which command accomplishes these tasks?

• A.ALTER DISKGROUP data CHECK DISK IN FAILURE GROUP 1;
• B.ALTER DISKGROUP data CHECK DISK;
• C.ALTER DISKGROUP data CHECK FILE;
• D.ALTER DISKGROUP data CHECK;

Examine the section of the Health Check report given below:
DBMS_HM.GET_RUN_REPORT('HM_RUN_1061')
Run Name: HM_RUN_1061 Run Id: 1061 Check Name : Data Block Integrity Check Mode : REACTIVE Status : COMPLETED Start Time : 2007-05-12 22:11:02.032292 -07:00 End Time : 2007-05-12 22:11:20.835135 -07:00 Error Encountered: 0 Source Incident Id : 7418 Number of Incidents Created :0
Which two statements are true regarding the Health Check report? (Choose two.)

• A.Health Check was performed to check interblock and intersegment corruption.
• B.Health Check was performed manually.
• C.Health Check was performed by the Health Monitor automatically in response to a critical error.
• D.Health Check was performed to check the disk image block corruptions
• E.Health Check was performed to verify the integrity of database files and report failures.

Examine the following command:
ALTER DISKGROUP data MOUNT FORCE;
In which scenario can you use the above command to mount the disk group?

• A.when one or more ASM files are dropped
• B.when ASM disk goes offline
• C.when some disks in a failure group for a disk group are rebalancing
• D.when some disks in a disk group are offline

Which statement describes the effect of table redefinition on the triggers attached to the table?

• A.Only triggers that are affected by the changes to the structure of the table are invalidated and automatically revalidated with the next DML execution on the table.
• B.All triggers on the table are invalidated and are automatically revalidated with the next DML execution on the table '
• C.All triggers on the table are invalidated and must be manually recompiled before the next DML execution on the table.
• D.All triggers on the table remain valid.

You have applications that have frequently executed queries, and produce small and static result sets.
You configure the sqlnet.ora file in the client machine to set a nonzero value for the OCI_RESULT_CACHE_MAX_SIZE parameter.
What is the purpose of this configuration?

• A.to enhance the query performance by creating a cache in the client memory for sorting operations
• B.to avoid round trips to the server by enabling caching of query results in client memory
• C.to avoid the storing of query plans and results in the server by creating a cache in the client memory
• D.to improve performance by storing a copy of the data from the private SQL area of the PGA