borrachito_test

With improved performance for LOB writes, what happens to JSON data when used?. It is internally transformed into the OSON data type and stored as a LOB. It is stored in an external database table. It is stored as plain text.

Which two statements accurately describe Automatic Segment Space Management (ASSM)?. It reduces contention by allowing multiple processes to search different BMBs concurrently. It uses free lists to manage space allocation within a segment. It utilizes bitmap blocks (BMBs) to track block fill levels within a segment. It requires manual adjustment of default values for the PCTUSED and PCTFREE parameters. It is recommended for automatic management of segment space used in the database BUFFER CACHE.

Which two are true about using Database Resource Manager in an Oracle multitenant environment?. A CDB-level resource plan can limit PDB UNDO use. A CDB-level resource plan is mandatory when using PDB-level resource plans. A PDB-level resource plan can limit session PGA memory. A CDB-level resource plan can limit session CPU utilization. A CDB-level resource plan can limit PDB CPU utilization.

You want to transport the UNIVERSITY tablespace from one database to another. The UNIVERSITY tablespace is currently open read/write. The source and destination platforms have the same endian format. Examine this list of steps: 1. Make the UNIVERSITY tablespace read-only on the source system. 2. Export the UNIVERSITY tablespace metadata using EXPDP. 3. Create a cross-platform backup set from the UNIVERSITY tablespace on the source system, using an RMAN command that includes the DATAPUMP clause. 4. Copy the cross-platform backup and Data Pump file sets to the destination system. 5. Copy the Data Pump dump set from the source to the destination system. 6. Restore the cross-platform backup set on the destination system using an RMAN command that includes the DATAPUMP clause. 7. Import the UNIVERSITY tablespace metadata using IMPDP. 8. Make the UNIVERSITY tablespace read/write on the destination system. Which are the minimum number of steps required, in the correct order, to transport the UNIVERSITY tablespace?. 2, 3, 4, 5, 6, 7. 1, 2, 3, 4, 5, 6, 7, 8. 1, 3, 4, 6, 8.

Which two statements are true about patchsets?. They can be applied in a rolling fashion for Clusterware and the databases. They are installed via OPatch or OPatchAuto. Installing a patchset is considered an “upgrade.”. They can introduce new features. They are only released quarterly.

What is the primary purpose of creating a duplicate database?. To increase the performance of the target database. To provide a development environment that is always synchronized with the target database. To test backup and recovery procedures.

What is the primary benefit of using column-level auditing in Oracle Database 23ai?. It provides a simple auditing configuration of all DML operations such as INSERT, UPDATE, and DELETE at the schema level for all the columns with the same name. It simplifies the process of auditing all database activities on a column in an application schema when the same column name is used with the objects. It allows for more focused and selective auditing of specific columns within database objects.

Which two are common indicators of contention within the shared pool?. Waits on I/O operations. Excessive database buffer activity. Waits on latches. High redo log generation rates. Waits on mutexes.

What is the main benefit of rebuilding an index?. To unlock index blocks of a specified index during direct loads to allow automatic rebuild of the affected index blocks to keep the index as compact as possible. To reduce the number of blocks needed for the index and possibly the number of levels, which can improve I/O performance and SQL execution costs. To remove the content of an index from the database.

A database is configured in ARCHIVELOG mode. Full RMAN backups are taken daily and no backup to trace has been taken of the control file. A media failure has occurred. Select the two scenarios where complete recovery is possible. After losing an archived log from before the most recent backup. After losing the SYSTEM tablespace. When any archived log from, before, or after the most recent backup is corrupt. After losing an archived log from after the most recent backup. After losing all copies of the control file.

Which two are true about various Oracle security and auditing capabilities?. Fine-grained auditing (FGA) policies in an application root are automatically synchronized to all application PDBs contained in the application container when they are updated. Application-common OLS policies can be created only if all the PDBs in the application container are closed. Unified auditing can be synchronized to all application PDBs in an application container. Application-common Transparent Security Data Protection (TSDP) policies can be created only if all the PDBs in the application container are closed. Application Transparent Security Data Protection (TSDP) and Unified audit policies are always container specific.

What is a key benefit of using binary compression for RMAN backups?. It requires no additional CPU or system resources. It reduces the amount of backup time. It allows for faster restore operations.

What is a key factor to consider when choosing an upgrade method?. The storage configuration and space available. The size of the database and the time required for the upgrade. The complexity of the applications.

When does the Replay Upgrade process automatically begin when plugging in an earlier release PDB into a new release CDB?. When the PDB is opened, the CDB detects that the PDB is an earlier release. Only after a manual command is issued to start the replay upgrade process. When the PDB is plugged into the CDB.

Which is a benefit of using service aggregation and tracing for application performance tuning?. Service aggregation and tracing provide real-time performance metrics that can be used to immediately diagnose bottlenecks. Service aggregation allows for the collection of performance statistics at different levels of granularity, such as service, module, and action, which help in pinpointing performance issues. Service aggregation and tracing allow for collecting statistics at the operating system level for a comprehensive performance overview.

What is a key advantage of Oracle AI Vector Search?. It requires a specialized vector database for effective semantic search. It eliminates data fragmentation by combining semantic and relational search in one system. It is limited to keyword-based searches on structured data.

What happens to existing Flashback Database logs when you disable Flashback Database?. They are deleted when expired based on the DB_FLASHBACK_RETENTION_TARGET parameter. They are automatically deleted. They are retained until the next backup with the DELETE EXPIRED option.

Which two statistics are collected by Adaptive Query Plans?. Cardinality. Number of Distinct Values. Clustering Factor. Selectivity. Histograms.

You plan to perform cross-platform PDB transport using XTTS. Which two are true?. The source PDB can be in MOUNT or OPEN state. The source PDB must not be an application root. The source and target platforms must have the same endianness. The source PDB must be in MOUNT state. A backup of the PDB must exist, taken using the BACKUP command with the TO PLATFORM clause.

What is the primary purpose of Oracle Grid Infrastructure for a stand-alone server?. To provide only storage management for a single database instance. To provide storage management and restart capabilities for multiple database instances on a cluster. To provide storage management and restart capabilities for a single database instance.

Which two statements are true about actions that can or cannot be performed by users with the SYSBACKUP privilege?. They can create any table. They cannot create restore points. They can drop any tablespace. They can view data from any user-defined table. They cannot drop tablespaces.

What is the Optimizer Statistics Advisor primarily used for?. To automatically implement all statistics recommendations for monitoring the PDBs. To analyze and fix database instance performance-related statistics settings. To recommend advice about issues related to the gathering of statistics, status of automatic statistics gathering jobs, and the quality of current statistics.

Which two capabilities require the use of the RMAN recovery catalog?. Using RMAN stored scripts. Using the REPORT SCHEMA command to list a database’s current data files and tablespaces. Creating customized reports about a single database’s backups. Creating encrypted backups. Using the KEEP FOREVER clause with the BACKUP command.

Which statement is correct about RMAN duplexed backup sets?. They can be created only by using the COPIES option of a BACKUP command. They can be written only to disk. They can be created by using the RMAN CONFIGURE command to specify duplexing before taking a backup.

What is the primary purpose of a PDB lockdown profile?. To restrict operations, features, and options used by users connected to a given PDB. To lock a SYSDBA password profile within a PDB. To manage user password management configuration in PDBs using CDB profiles.

How do you configure a CDB for local undo mode?. Open the CDB in read-only mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON, and then change the CDB to read/write mode. Open the CDB instance in restricted mode. In CDB$ROOT, drop the UNDO tablespace. Execute ALTER DATABASE LOCAL UNDO ON in each PDB, and then restart the CDB instance. Open the CDB instance in upgrade mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON, and then restart the CDB instance.

In Oracle Database 23ai, what action does the Automatic SQL Plan Management take if an alternative plan performs better than the current plan?. The alternative plan is accepted and added to the baseline. The alternative plan is added to the plan history but not activated. The alternative plan is added to the plan history for DBA approval.

What is the purpose of the 23ai Oracle Preinstallation RPM?. To install all optional Oracle software packages. To install all packages required for Oracle software. To install a minimal set of additional packages required for Oracle software installations.

In the context of TDE, what is the function of the WALLET_ROOT initialization parameter?. To specify the location of the sqlnet.ora file which includes the location of the database keystore. To define the CDB keystore management system used for storing the keystore. To specify the path to the root directory containing subdirectories for PDB keystores.

What is the primary purpose of an application root in an application container?. To act as a template for new regular PDBs. To provide a single master application definition. To store data independently of other PDBs.

Which background process is primarily responsible for transaction recovery and may trigger transaction quarantine?. SMON. RWR. PMON.

Which two types of performance problems are reported by ADDM for PDBs?. User I/O waits. Top SQL statements. Excessive checkpoint writes. I/O capacity limits. Total SGA sizing issues of the database.

What is the significance of the ADR being stored outside of any database?. It makes the diagnostic data less secure. It makes it available for problem diagnosis even when the database is down. It means the diagnostic data can be accessed only by the SYSDBA user.

Which two resources are always shared among CDB$ROOT and all pluggable databases (PDBs) in a multitenant database?. Temporary tablespaces. The log writer process (LGWR). SYSAUX tablespaces. UNDO tablespaces. The Process Monitor Process (PMON).

What is the purpose of the SERVICE_NAME_CONVERT clause when cloning or plugging a PDB?. To rename the PDB. To avoid conflicts with the names of existing services because the new PDB inherits services from the source. To set the option for converting PDB service names during a switchover when creating a refreshable clone.

Which two actions will add a resource to an Oracle Restart configuration?. Creating a disk group using the CREATE DISKGROUP SQL statement. Creating a database using the CREATE DATABASE SQL statement. Creating a database service using DBMS_SERVICE.CREATE_SERVICE. Creating a database service using Oracle Database Configuration Assistant (DBCA). Creating an Oracle Automatic Storage Management (ASM) instance with ASM Configuration Assistant (ASMCA).

When using RMAN Data Transport using the NOCATALOG method, which is a prerequisite for transporting a PDB?. The PDB must use shared undo. The PDB must use local undo. The destination platform must be open restricted.

Where is the alert log file typically stored on the server?. $ORACLE_BASE/diag/rdbms/<db_name>/<SID>/log. $ORACLE_BASE/diag/rdbms/<db_name>/<SID>/trace. $ORACLE_HOME/diag/rdbms/<db_name>/<SID>/trace.

What does RMAN primarily use to restore blocks during block media recovery?. Metadata from Control files. Incremental backups and Redo Logs. Flashback logs and full or level 0 backups.

Examine these database parameter settings: SGA_TARGET = 0 SHARED_POOL_SIZE = 400M DB_CACHE_SIZE = 600M LARGE_POOL_SIZE = 300 The SGA_TARGET is then set to 1800M. Which two statements are true about the values of SHARED_POOL_SIZE, DB_CACHE_SIZE, and LARGE_POOL_SIZE?. Their values are retained as an upper bound. Their values can be modified by using the ALTER SYSTEM command. Their values are retained as a lower bound. Their values are immediately resized. SHARED_POOL_SIZE retains its specified size but DB_CACHE_SIZE and LARGE_POOL_SIZE are immediately resized.

Which two items are performed by Oracle Automatic Storage Management (ASM) instances?. Mounting disk groups. Acting as an I/O server to read data file blocks from ASM disks on behalf of database server processes. Managing Allocation Units (AUs) for disk group content. Managing extent allocation for Oracle database segments. Acting as an I/O server to write data file blocks to ASM disks on behalf of Database Writer processes (DBWn).

What are two benefits of deploying True Cache in a partitioned configuration?. It enables caching a larger data set than a single True Cache instance. It enforces all True Cache instances to store an identical copy of the data. It allows dividing data across multiple True Cache instances for specific needs. It limits the total size of cached data compared to a uniform configuration. It prevents the use of COLOCATION_TAG for load balancing purposes.

The DBCA templates include information such as the database name, size of memory structures, character set, and many other parameters that are needed to create a database. What type of file is a database template?. Binary file. XML file. JSON file.

Which factor does the Oracle Optimizer use to determine the best execution plan for a SQL statement?. Statistics gathered for the system and schema objects, information in the dictionary, and WHERE clause qualifiers. Only the SQL statement’s syntax and structure unless hints are provided by the developers. Only the SQL statement’s syntax and structure.

Which two are purposes of Database Replay?. To compare real-time database performance to the captured period for performance monitoring. To test the impact of system changes by replaying a real-world workload on a test system. To emulate a production environment to make bugs more reproducible. To create a backup of the application workload that can be applied automatically or manually on a duplicate database. To automatically identify and fix bugs in the database software.

Which is a required task after a database upgrade?. Implementing new database features. Verifying and setting tablespace alert thresholds. Validating the ORACLE_HOME and PATH environment variables.

Which TWO of the following statements accurately describe the Automatic Workload Repository (AWR)?. AWR snapshots provide a persistent record of database statistics. AWR stores only in-memory statistics and does not use disk storage. AWR snapshots are accessible only through dynamic performance (V$) views. AWR is used by Oracle Database components for problem detection and self-tuning. AWR can be used only by tools such as SQL Developer and EMCC.

What is the purpose of Oracle High Availability Services (OHASD)?. It acts as the core process for Oracle Restart. It monitors and controls ASM. It monitors and controls the database.

Which statement accurately describes how schema-level privileges are granted?. They are granted using the GRANT ANY command with the ON SCHEMA clause. They are granted using the GRANT <privilege> ON SCHEMA <schema_name> TO <user/role> syntax. They are automatically granted to all users who have been created as schema owners in a PDB.

Why is it important to increase the column limit for Machine Learning and IoT workloads?. These workloads can have hundreds or thousands of dimensional attribute columns. These workloads require a normalized schema. These workloads typically use OLTP systems.

Which statement is correct about Oracle instance recovery?. Recovery reads redo until the end of the redo thread, and then opens the database. SMON then rolls back any dead transactions. Recovery begins from the last checkpoint position that was calculated by the Database Writer before instance failure. Recovery reads redo until the end of the redo thread. SMON rolls back any dead transactions, and then the database is opened.

How will you populate a table into the In-Memory column store?. Enable the INMEMORY attribute on the table or partition. Set the DB_CACHE parameter to INMEMORY for the table. Database automatically loads objects into INMEMORY when it is enabled in the instance and buffer cache is too small for the object.

What does RMAN multiplexing determine?. How RMAN allocates disk buffers for reading multiple file. How many channels are used for the backup. How fast data is written to tape.

What is the key difference between “Typical Mode” and “Advanced Mode” when creating a database with DBCA?. Advanced mode uses default settings. Typical mode allows for more customization. Typical mode requires minimal user input.

What is the primary goal of the SQL Access Advisor?. To analyze and optimize the access path used for a SQL execution plan for tuning high-load SQL statements captured by ADDM. To analyze a SQL workload captured by AWR snapshots and recommend the appropriate access method, such as direct path read or scatter read, to enhance query performance. To analyze a SQL workload and recommend the appropriate access structures, such as indexes, materialized views, and partitioning.

Consider the following SQL statement used to create a table with a Lock-Free Reservation: CREATE TABLE Account ( ID NUMBER PRIMARY KEY, Name VARCHAR2(10), Balance NUMBER reservable CONSTRAINT minimum_balance CHECK (Balance >= 50) ); Which statement is correct regarding the Balance column in the Account table?. The Balance column is a primary key and an identity column. The Balance column can be part of a foreign key constraint. The Balance column is a reservable column and must be of a numeric data type.

HR_ROOT is an application container with the HR_APP application installed. No application PDBs and no application seed have yet been created in HR_ROOT. An application PDB, PDB1, must be created so that the HR_APP application’s common objects are accessible to it. Which two methods can be used?. Create an application seed, synchronize it with HR_ROOT, and then create the PDB1 application PDB. Create the PDB1 application PDB and synchronize it with HR_ROOT. Create the PDB1 application PDB and synchronize it with PDB$SEED. Create the PDB1 application PDB and install HR_APP in it. Create an application seed, and install HR_APP in it.

Examine the following configuration: 1. CDB1 is a container database running in ARCHIVELOG mode. 2. Multiple uncommitted transactions are running in CDB1. 3. Redo log groups 1 and 2 are INACTIVE. 4. Redo log group 3 is the CURRENT group. All members of redo log group 3 are lost before it is archived. Examine these possible steps: 1. SHUTDOWN ABORT 2. STARTUP NOMOUNT 3. STARTUP MOUNT 4. ALTER DATABASE MOUNT 5. RESTORE DATABASE 6. RECOVER DATABASE NOREDO 7. RECOVER DATABASE UNTIL AVAILABLE 8. RESTORE ARCHIVELOG ALL 9. ALTER DATABASE OPEN 10. ALTER DATABASE OPEN RESETLOGS Choose the minimum required steps in the correct order to recover the database. Opciones visibles en la foto: 1, 3, 5, 8, 6, 10. 1, 2, 4, 5, 7, 9. Aqui falta alguna, checar.

What is a key change to Hybrid Columnar Compression (HCC) in Oracle Database 23ai?. The default use of Zstandard (zstd) compression. The elimination of the need for direct-path or array inserts. A requirement for all tables to be stored in a locally managed tablespace.

What is the primary benefit of using multiple buffer pools in an Oracle database?. To load each table that is primarily used for bulk data loads in its own buffers. To manage different types of data with varying access patterns more effectively. To allow faster intensive SQL operations to be performed in memory, like joins and sorts.

Your container database, CDB1, is in local undo mode. You successfully execute this command while connected to CDB1: CREATE PLUGGABLE DATABASE pdb1 ADMIN USER pdb1_admin IDENTIFIED BY pdb123 ROLES=(CONNECT) CREATE_FILE_DEST='/u01/app/oracle/oradata/cdb1/pdb1'; Which two statements are true about PDB1?. It has the same common users defined as does CDB1. It has only local roles. It has no local users. It has the same number of roles as CDB1. Service PDB1 is created for remote logins to PDB1.

What is the primary function of vector embedding models in AI Vector Search?. To store vector embeddings separately from business data. To transform unstructured data like text or images into mathematical vector representations. To directly execute keyword-based searches on unstructured data.

What is the purpose of the MEMOPTIMIZE_WRITES initialization parameter in Oracle Database 23ai?. To control when the database uses fast ingest for inserting data. To set the size of the large pool. To manage caching operations.

Which two statements are true about tuning dimensions and details of v$sys_time_model and DB time?. When WAIT_TIME is high, instance tuning may improve performance. Tuning the systems in which CPU time is more dominant than the SQL execution WAIT_TIME. Tuning is required for Parsing Elapsed Time for successful soft and hard parse operations only. When CPU time is high, SQL tuning may improve performance. Tuning would be required for CPU usage and DB Time consumed for operations performed by all Background Processes and Database Maintenance.