READ Free Dumps For Oracle- 1z0-020
| Question ID 8279 | 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. In order to achieve this, which command should a DBA issue? |
| Option A | ALTER TABLE <tabl_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 8281 | 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. |
| 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 | A,B |