A database is configured to use automatic undo management with temporary undo enabled.An UPDATE is executed on a temporary table.Where is the UNDO stored? A. in the undo tablespace B. in the PGA C. in the SYSAUX tablespace D. in the SGA E. in the temporary tablespace Correct Answer: A
Which four account management capabilities can be configured using Oracle profiles? (Choose four.) A. the ability to prevent a password from ever being reused B. the number of hours for which an account is locked after the configured number of login attempts has been reached C. the number of days for which an account is locked after the… Read More »
Which three Oracle database space management features will work with both Dictionary and Locally managed tablespaces? (Choose three.) A. Oracle Managed Files (OMF) B. Online table segment shrink C. Online index segment shrink D. Automatic data file extension (AUTOEXTEND) E. Capacity planning growth reports based on historical data in the Automatic Workload Repository (AWR) Correct Answer: A,D,E Explanation
A database is configured to use automatic undo management with temporary undo enabled.An UPDATE is executed on a temporary table.Where is the UNDO stored? A. in the undo tablespace B. in the SYSAUX tablespace C. in the SGA D. in the PGA E. in the temporary tablespace Correct Answer: E http://www.dba-oracle.com/t_temp_undo_enabled.htm
Which two statements are true regarding Oracle database space management within blocks managed by Automatic Segment Space Management (ASSM)? (Choose two.) A. PCTFREE defaults to 10% for all blocks in all segments for all compression methods B. Insert operations always attempt to find blocks with free space appropriate to the length of the row being inserted C. Update… Read More »
Which three Oracle database space management features will work with both Dictionary and Locally managed tablespaces? (Choose three.) A. Online table segment shrink B. Automatic data file extension (AUTOEXTEND) C. Capacity planning growth reports based on historical data in the Automatic Workload Repository (AWR) D. Oracle Managed Files (OMF) E. Online index segment shrink Correct Answer: B,C,D
Which OCI Identity and access management capability helps you to organize multiple users into teams? A. Policies B. Groups C. Dynamic Groups D. Users Correct Answer: B IAM Group is A collection of users who all need the same type of access to a particular set of resources or compartment.IAM DYNAMIC GROUP is A special type of group… Read More »
Which component of the Oracle Cloud Infrastructure (OCI) Identity and Access Management (IAM) service can be used for controlling access to resources for authenticated principals? A. Compartment B. Policy C. Network Source D. Group Correct Answer: B
Which three services Integrate with Oracle Cloud Infrastructure (OCI) Key Management? A. Functions B. Block Volume C. Object Storage D. Auto Scaling E. Identity and Access Management F. File Storage Correct Answer: B,C,F DATA ENCRYPTIONProtect customer data at-rest and in-transit in a way that allows customers to meet their security and compliance requirements for cryptographic algorithms and key… Read More »
What is used for cluster management and tot providing the API used for configuring and managing resources in a cluster created using Oracle Cloud Infrastructure Container Engine for Kubernetes (OKE)?Response: A. The master node is responsible for cluster management and for providing the API. B. The Cluster State Store is responsible for cluster management and for providing the… Read More »