READ Free Dumps For Oracle- 1z0-020
| Question ID 7809 | A DBA now has the ability to mark certain blocks of a table as being corrupt. This will enable a full table scan to skip over them. Inorderto achieve this, which command should a DBA issue? |
| Option A | ALTER TABLE <table_name> MARK <block_id> ; |
| Option B | SELECT* FROM <table_name> SKIP <block_id> ; |
| Option C | Run the DBVERIFY utility on the relevant datafile. |
| Option D | ALTER TABLESPACE <tablespace_name> MARK<block_id> ; |
| Option E | EXECUTE DBMS_REPAIR.SKIP_CORRUPT_BLOCKS ('<schema_name>', '<table_name>'); |
| Correct Answer | C |
| Question ID 7810 | In the DBA_TRIGGERS data dictionary view, the value in the TABLE_NAME column will be NULL in which situations? (Choose Two) |
| Option A | The trigger is a schema trigger. |
| Option B | The trigger is a database trigger. |
| Option C | The trigger was created by the DBA for another user.The trigger was created by the DBA for another user |
| Option D | The trigger was created by the DBA for another user |
| Option E | The trigger is created with the CREAYE ANY TRIGGER privilege. |
| Option F | The trigger was created by a user who connected with the CONNECT INTERNAL command. |
| Correct Answer | AB |