Which three statements are true about table data storage in an Oracle Database? (Choose three.) A. Data block headers contain their own Data Block Address (DBA) B. A table row piece can be chained across several database blocks C. Multiple row pieces from the same row may be stored in different database blocks D. Multiple row pieces from… Read More »
You execute this command:Sufficient storage is available in filesystem /u01.Which two statements are true about the BIG_TBS tablespace? (Choose two.) A. AUTOEXTEND is possible for the datafile B. It will be a dictionary-managed tablespace by default C. It must be bigger than the largest SMALLFILE tablespace D. It will always have a 32K blocksize E. Additional data files… Read More »
Which three statements are true about table data storage in an Oracle Database? (Choose three.) A. Multiple row pieces from the same row may be stored in different database blocks B. Multiple row pieces from the same row may be stored in the same block C. Data block headers contain their own Data Block Address (DBA) D. A… Read More »
You execute this command:Sufficient storage is available in filesystem /u01.Which two statements are true about the BIG_TBS tablespace? (Choose two.) A. Additional data files may not be added B. It will always have a 32K blocksize C. It must be bigger than the largest SMALLFILE tablespace D. AUTOEXTEND is possible for the datafile E. It will be a… Read More »
Which OCI storage service does not provide encryption for data at rest? A. File Storage B. Block Volume C. Local NVMe D. Object Storage Correct Answer: C NVMe stands for non-volatile memory express. It is a storage protocol created to fasten the transfer of data between enterprise and client systems and solid-state drives (SSDs) over a computer’s high-speed… Read More »
What is the minimum of storage that a persistent volume claim can obtain in Oracle Cloud Infrastructure Container Engine for Kubernetes (OKE)? A. 50 GB B. 10 GB C. 1 GB D. 1 TB Correct Answer: A The minimum amount of persistent storage that a PVC can request is 50 gigabytes. If the request is for less than… Read More »
Which two statements are true about accessing cloud-based storage through the storage API? A. It can make it easier to resume multi-step operationsacross devices by storing a user’s progress. B. It is the principal way of retrieving data from backend, on-premises systems. C. It is a convenient way ofstoring data that is specific to your mobile application without… Read More »
What is the minimum of storage that a persistent volume claim can obtain in Oracle Cloud Infrastructure Container Engine for Kubernetes (OKE)? A. 50 GB B. 10 GB C. 1 GB D. 1 TB Correct Answer: A ExplanationThe minimum amount of persistent storage that a PVC can request is 50 gigabytes. If the request is for less than… Read More »
You are processing millions of files in an Oracle Cloud Infrastructure (OCI) Object Storage bucket. Each time a new file is created, you want to send an email to the customer and create an order in a database. The solution should perform and minimize cost, Which action should you use to trigger this email? A. Schedule a cron… Read More »
In which four ways can Oracle Database optimally access data in Object Storage? A. optimized data archive using hybrid partitioned tables B. scan avoidance using columnar pruning for .csv files C. scan avoidance using columnar pruning for columnar stores like parquet and orc D. scan avoidance using partitioned external tables E. optimized data archive using partitioned external tables… Read More »