READ Free Dumps For Oracle- 1z0-050
| Question ID 5989 | Evaluate the following command: SQL>ALTER SYSTEM SET db_securefile = 'IGNORE1; What is the impact of this setting on the usage of Secure Files? |
| Option A | It forces Basic Files to be created even if the SECUREFILE option is specified to createthe LOB. |
| Option B | It forces Secure Files to be created even if the BASICFILE option is specified to create the LOB. |
| Option C | It does not allow the creation of Secure Files and generates an error if the SECUREFILE option is specified to create the LOB. |
| Option D | It ignores the SECUREFILE option only if a Manual Segment Space Management tablespace is used and creates a Basic File. |
| Option E |
|
| Correct Answer | A |
| Question ID 5990 |
| |
| Option A | all disks in the disk group | |
| Option B | all disks that are currently in OFFLINE mode | |
| Option C | all disks that are not currently in OFFLINE mode | |
| Option D | all disks in the disk group only if all of them are ONLINE | |
| Correct Answer | C |
You are managing an Oracle Database 11g ASM instance with a disk group dg01 having three disks. One of the disks in the disk group becomes unavailable because of power failure. You issued the following command to change the DISK_REPAIR_TIME attribute from 3.6 hours to 5 hours:
ALTER DISKGROUP dg01 SET ATTRIBUTE 'disk_repair_time' = '5h'; To which disks in the disk group will the new value be applicable?