- Home
- Database
- Oracle 12 C
- OCA Oracle 12C Administration(1Z0-062)
26.
If the tablespace is offline, which statements should be executed to make the USERS tablespace read-only? (Choose all that apply.)
- A.ALTER TABLESPACE USERS READ ONLY
- B.ALTER DATABASE MAKE TABLESPACE USERS READ ONLY
- C.ALTER TABLESPACE USERS ONLINE
- D.ALTER TABLESPACE USERS TEMPORARY
- Answer & Explanation
- Report
Answer : [C, A]
Explanation :
Explanation :
| To make a tablespace read-only, all the data files belonging to the tablespace must be online and available. So bring the tablespace online, and then make it read-only. |
27.
How would you add more space to a tablespace? (Choose all that apply.)
- A.ALTER TABLESPACE <TABLESPACE NAME> ADD DATAFILE SIZE <N>
- B.ALTER DATABASE DATAFILE <FILENAME> RESIZE <N>
- C.ALTER DATAFILE <FILENAME> RESIZE <N>
- D.ALTER DATAFILE <FILENAME> RESIZE <N>
- Answer & Explanation
- Report
Answer : [A, B]
Explanation :
Explanation :
| You can add more space to a tablespace either by adding a data file or by increasing the size of an existing data file. Option A does not have a filename specified; it uses the OMF feature to generate the filename. |
28.
The database is using automatic memory management. The standard block size for the database is 8KB. You need to create a tablespace with a block size of 16KB. Which initialization parameter should be set?
- A.DB_8K_CACHE_SIZE
- B.DB_16K_CACHE_SIZE
- C.DB_CACHE_SIZE
- D.None of the above
- Answer & Explanation
- Report
Answer : [B]
Explanation :
Explanation :
| DB_CACHE_SIZE doesn’t need to be set for the standard block size because Automatic Memory Management is used. If you set DB_CACHE_SIZE, its value will be used as the minimum. DB_16K_CACHE_SIZE should be set for the nonstandard block size. You must not set the DB_8K_CACHE_SIZE parameter because the standard block size is 8KB. |
29.
Which data dictionary view can be queried to obtain information about the files that
belong to locally managed temporary tablespaces?
- A.DBA_DATA_FILES
- B.DBA_TABLESPACES
- C.DBA_TEMP_FILES
- D.DBA_LOCAL_FILES
- Answer & Explanation
- Report
Answer : [C]
Explanation :
Explanation :
| Locally managed temporary tablespaces are created using the CREATE TEMPORARY TABLESPACE command. The data files (temporary files) belonging to these tablespaces are in the DBA_TEMP_FILES view. The EXTENT_MANAGEMENT column of the DBA_TABLESPACES view shows the type of tablespace. The data files belonging to locally managed permanent tablespaces and dictionary-managed (permanent and temporary) tablespaces can be queried from DBA_DATA_FILES. Locally managed temporary tablespaces reduce contention on the data dictionary tables. |
30.
How would you drop a tablespace if the tablespace were not empty?
- A.Rename all the objects in the tablespace, and then drop the tablespace.
- B.Remove the data files belonging to the tablespace from the disk.
- C.Use ALTER DATABASE DROP
CASCADE. - D.Use DROP TABLESPACE
INCLUDING CONTENTS.
- Answer & Explanation
- Report
Answer : [D]
Explanation :
Explanation :
| The INCLUDING CONTENTS clause is used to drop a tablespace that is not empty. Oracle does not remove the data files that belong to the tablespace if the files are not Oracle-managed; you need to do it manually using an OS command. Oracle updates only the control file. To remove the files, you can include the INCLUDING CONTENTS AND DATAFILES clause. |
|
|
||||||||||||||||||||||||||||
