Join the discussion
Question 1/33
Your data center uses Oracle Managed Files (OMF) for all databases. All tablespaces are smallfile tablespaces. SALES_Q1 is a permanent user-defined tablespace in the SALES database. The following command is about to be issued by a DBA logged in to the SALES database: ALTER TABLESPACE sales_q1 ADD DATAFILE; Which two actions independently ensure that the command executes successfully?
Correct Answer: C,D
With OMF enabled, Oracle automatically manages file creation. The command ALTER TABLESPACE sales_q1 ADD DATAFILE without a file specification relies on initialization parameters:
A . Specify a path in the DATAFILE clause ... with at least 100 MB of available space.False. With OMF, explicitly specifying a path overrides OMF behavior, but it's not required for success if OMF parameters are set correctly.
B . Add the AUTOEXTEND ON clause with NEXT set to 100M.False. AUTOEXTEND is optional and affects file growth, not the initial creation success, which depends on available space in the OMF location.
C . Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify locations with at least 50 MB of available space.True. If both parameters are set,Oracle may use either for data files (depending on context), and sufficient space (e.g., 50 MB minimum for a smallfile) ensures success.
D . Ensure that DB_CREATE_FILE_DEST specifies a location with at least 100 MB of available space.True. This is the primary OMF parameter for data files; sufficient space (typically 100 MB minimum for a new file) guarantees the command succeeds.
E . Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify locations with at least 50 MB of available space.False. This is redundant with C; only one needs sufficient space, though C's phrasing makes it a valid independent action.
A . Specify a path in the DATAFILE clause ... with at least 100 MB of available space.False. With OMF, explicitly specifying a path overrides OMF behavior, but it's not required for success if OMF parameters are set correctly.
B . Add the AUTOEXTEND ON clause with NEXT set to 100M.False. AUTOEXTEND is optional and affects file growth, not the initial creation success, which depends on available space in the OMF location.
C . Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify locations with at least 50 MB of available space.True. If both parameters are set,Oracle may use either for data files (depending on context), and sufficient space (e.g., 50 MB minimum for a smallfile) ensures success.
D . Ensure that DB_CREATE_FILE_DEST specifies a location with at least 100 MB of available space.True. This is the primary OMF parameter for data files; sufficient space (typically 100 MB minimum for a new file) guarantees the command succeeds.
E . Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify locations with at least 50 MB of available space.False. This is redundant with C; only one needs sufficient space, though C's phrasing makes it a valid independent action.
Add Comments
- Other Question (33q)
- Q1. Your data center uses Oracle Managed Files (OMF) for all databases. All tablespaces are sm...
- Q2. You execute the SHUTDOWN ABORT command. Which two statements are true?...
- Q3. Which two actions can you perform using DBCA for an existing database?...
- Q4. Which three statements are true about the tools used to configure Oracle Net Services?...
- Q5. Which three statements are true about resumable space allocation in Oracle databases?...
- Q6. Which two tasks can you perform using DBCA for databases?...
- Q7. Your database instance is started with an SPFILE. A PFILE is also available. You execute t...
- Q8. In the SPFILE of a single instance database, LOCAL_LISTENER is set to LISTENER_1. The TNSN...
- Q9. Which three statements are true about Deferred Segment Creation in Oracle databases?...
- Q10. In one of your databases, you create a user, HR, and then execute this command: GRANT CREA...
- Q11. Which advisor is used to detect missing or stale object statistics?...
- Q12. Which two are true about shrinking a segment online?...
- Q13. Which of the following is true about the status of a PDB that has been unplugged from a CD...
- Q14. Which resource plan is used to manage the resources for the predefined maintenance window?...
- Q15. You want to view the initialization parameter settings for only a specific PDB. Which of t...
- Q16. Which three tasks are part of the predefined Automated Maintenance Tasks?...
- Q17. Examine this command: ALTER DATABASE MOVE DATAFILE '/u01/sales01.dbf' TO '/u02/sales02.dbf...
- Q18. You execute this command: CREATE SMALLFILE TABLESPACE sales DATAFILE '/u01/app/oracle/sale...
- Q19. Which three functions are performed by dispatchers in a shared server configuration?...
- Q20. Examine this command: SQL> ALTER TABLE ORDERS SHRINK SPACE COMPACT; Which two statement...
- Q21. Which three statements are true about using SQL*Plus?...
- Q22. Which two account management capabilities can be configured using Oracle profiles?...
- Q23. Which three statements are true about Automatic Diagnostic Repository (ADR)?...
- Q24. Which two statements are true about the PMON background process?...
- Q25. Which three statements are true about the Oracle Database server during and immediately af...
- Q26. Which of the following statements is true about external tables?...
- Q27. Which data dictionary view describes the data sources of external tables?...
- Q28. Which two statements describe how Optimizer Statistics are collected?...
- Q29. You must create a tablespace of nonstandard block size in a new file system and plan to us...
- Q30. What is the result of the following command? ALTER PLUGGABLE DATABASE PDB1 DISCARD STATE;...
- Q31. Which two Oracle database space management features require the use of locally managed tab...
- Q32. Which three tasks are performed by background processes in an Oracle database instance?...
- Q33. Which two statements are true about undo segments and the use of undo by transactions in a...
