READ Free Dumps For Oracle- 1z0-050
| Question ID 6027 | 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? |
| Option A | It executes successfully but partition pruning cannot happen for this partition key. |
| Option B | It produces an error because the TOTAL_VALUE column cannot be used as a partition key. |
| Option C | It produces an error because compression cannot be used for the TOTAL_VALUE partition key. |
| Option D | It executes successfully but the values in the TOTAL_VALUE column would not be physically stored in the partitions. |
| Correct Answer | D |
| Question ID 6028 | The Oracle Database 11g database is running in the ARCHIVELOG mode. The archived redo log files are stored on three locations. The Flash Recovery Area is one of the locations. The details are given below:LOG_ARCHIVE_DEST _2 = 'SERVICE = Stdb1 DB_RECOVERY_FILE_DEST = 7u01/oradata'Examine the following RMAN command issued to set the deletion policy for archived log files: RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO sbt; Which statement is true regarding what this command accomplishes? |
| Option A | All archived redo log files backed up at least twice to tape are deleted. |
| Option B | All archived redo log files backed up at least once to tape are eligible for deletion. |
| Option C | All archived redo log files backed up at least twice to tape are deleted from the flash recovery area. |
| Option D | All archived redo log files in local archiving destinations and the flash recovery area backed up at least twice to tape are eligible for deletion. |
| Correct Answer | D |