READ Free Dumps For Oracle- 1z0-062
Question ID 2465 | Examine these two statements: |
Option A | A. The MRKT tablespace is created as a small file tablespace, because the file size is less than the minimum required for big file files. |
Option B | B. The MRKT tablespace may be dropped if it has no contents. |
Option C | C. Users who were using the old default tablespace will have their default tablespaces changed to the MRKT tablespace. |
Option D | D. No more data files can be added to the tablespace. |
Option E | E. The relative file number of the tablespace is not stored in rowids for the table rows that are stored in the MRKT tablespace. |
Correct Answer | B,C,D |
Question ID 2466 | In your database, you want to ensure that idle sessions that are blocking active are automatically terminated after a specified period of time. |
Option A | A. Setting a metric threshold |
Option B | B. Implementing Database Resource Manager |
Option C | C. Enabling resumable timeout for user sessions |
Option D | D. Decreasing the value of the IDLE_TIME resource limit in the default profile |
Correct Answer | D |