READ Free Dumps For Oracle- 1z0-050
| Question ID 6023 | You issued the following command: CREATE GLOBAL TEMPORARY TABLE admin work area (startdate DATE, enddate DATE, class CHAR(20)) ON COMMIT DELETE ROWS TABLESPACE tbs_t1; An index is then created on the ADMIN_WORK_AREA temporary table. Which two statements are true regarding the TBS_T1 tablespace in the above command? (Choose two.) |
| Option A | It stores only the temporary table but not its indexes. |
| Option B | It stores both the temporary table as well as its indexes. |
| Option C | It must be a nondefault temporary tablespace for the database. |
| Option D | It can be a default or nondefault temporary tablespace for the database. |
| Option E | It must be the default temporary tablespace of the user who issues the command. |
| Correct Answer | B,D |
| Question ID 6024 | Which two prerequisites are needed for performing workload capture and replay? (Choose two.) |
| Option A | setting up the directory to capture the workload |
| Option B | running the database in shared server mode |
| Option C | Close all sessions performing queries using database links. |
| Option D | The database on which the workload is replayed has to be a restore of the original database to a specific SCN. |
| Correct Answer | A,D |