Join the discussion
Question 9/33
Which three statements are true about Deferred Segment Creation in Oracle databases?
Correct Answer: C,D,E
A .False. IOTs require immediate segment creation.
B .False. SYS-owned tables don't use deferred creation.
C .True. Default since 11gR2, continued in 23ai.
D .True. Indexes inherit this attribute unless overridden.
E .True. Sessions can alter this via DEFERRED_SEGMENT_CREATION.
B .False. SYS-owned tables don't use deferred creation.
C .True. Default since 11gR2, continued in 23ai.
D .True. Indexes inherit this attribute unless overridden.
E .True. Sessions can alter this via DEFERRED_SEGMENT_CREATION.
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...
