问题:单选题You install a non-RAC Oracle Database. During Installation, the Oracle Universal Installer (OUI) prompts you to enter the path of the Inventory directory and also to specify an operating system group name. Which statement is true?()A The ORACLE_BASE ba...
Friday, March 22, 2024
问题:单选题Your database has the SRV1 service configured for an application that runs on middle-tier application server. The application has multiple modules. You enable tracing at the service level by executing the following command: SQL exec DBMS_MONITOR.SERV_...
Monday, April 15, 2024
问题:多选题Your multitenant container database has three pluggable databases (PDBs): PDB1, PDB2, and PDB3.Which two RMAN commands may be; used to back up only the PDB1 pluggable database?()ABACKUP PLUGGABLE DATABASE PDB1 while connected to the root containerBBACK...
Wednesday, November 8, 2023
问题:多选题You notice that the elapsed time for an important database scheduler Job is unacceptably long. The job belongs to a scheduler job class and window. Which two actions would reduce the job's elapsed time?()AIncreasing the priority of the job class to whi...
Sunday, May 5, 2024
问题:多选题Which three features work together, to allow a SQL statement to have different cursors for the samestatement based on different selectivity ranges?()ABind Variable PeekingBSQL Plan BaselinesCAdaptive Cursor SharingDBind variable used in a SQL statement...
Tuesday, December 19, 2023
问题:多选题In your Database, the TBS PERCENT USED parameter is set to 60 and the TBS PERCENT FREE parameter is set to 20. Which two storage-tiering actions might be automated when using information Lifecycle Management (ILM) to automate data movement?()AThe movem...
问题:多选题You upgraded your database from pre-12c to a multitenant container database (CDB) containing pluggable databases (PDBs). Examine the query and its output: Which two tasks must you perform to add users with SYSBACKUP, SYSDG, and SYSKM privilege to the p...
Thursday, May 9, 2024
问题:多选题Which three statements are true about using flashback database in a multitenant container database(CDB)?()AThe root container can be flashed back without flashing back the pluggable databases (PDBs).BTo enable flashback database, the CDB must be mounte...
问题:多选题Which two statements are true about the RMAN validate database command?()AIt checks the database for intrablock corruptions.BIt can detect corrupt pfiles.CIt can detect corrupt spfiles.DIt checks the database for interblock corruptions.EIt can detect c...
Saturday, April 20, 2024
问题:多选题Which three are true about the large pool for an Oracle database instance that supports shared serverconnections?()AAllocates memory for RMAN backup and restore operationsBAllocates memory for shared and private SQL areasCContains a cursor area for sto...
Wednesday, October 18, 2023
问题:单选题You are connected to a pluggable database (PDB) as a common user with DBA privileges. The STATISTICS_LEVEL parameter is PDB_MODIFIABLE. You execute the following: SQL ALTER SYSTEM SET STATISTICS_LEVEL = ALL SID = ‘*’ SCOPE = SPFILE; Which is true abou...
问题:多选题Which two statements are true about the Oracle Direct Network File system (DNFS)?()AIt utilizes the OS file system cache.BA traditional NFS mount is not required when using Direct NFS.COracle Disk Manager can manage NFS on its own, without using the op...
问题:单选题Your database supports a DSS workload that involves the execution of complex queries: Currently, the library cache contains the ideal workload for analysis. You want to analyze some of the queries for an application that are cached in the library cache...
问题:多选题What are three purposes of the RMAN “FROM” clause?()Ato support PUSH-based active database duplicationBto support synchronization of a standby database with the primary database in a Data environmentCTo support PULL-based active database duplicationDTo...
问题:多选题Identify two correct statements about multitenant architectures.()AMultitenant architecture can be deployed only in a Real Application Clusters (RAC) configuration.BMultiple pluggable databases (PDBs) share certain multitenant container database (CDB) ...
问题:多选题You have altered a non-unique index to be invisible to determine if queries execute within an acceptable response time without using this index. Which two are possible if table updates are performed which affect the invisible index columns?()AThe index...
问题:多选题Which three statements are true concerning unplugging a pluggable database (PDB)?()AThe PDB must be open in read only mode.BThe PDB must be dosed.CThe unplugged PDB becomes a non-cdb.DThe unplugged PDB can be plugged into the same multitenant container...
问题:单选题To implement Automatic Management (AMM), you set the following parameters: When you try to start the database instance with these parameter settings, you receive the following error message: SQL startup ORA-00824: cannot set SGA_TARGET or MEMORY_TARGE...
问题:单选题You want to capture column group usage and gather extended statistics for better cardinality estimates for the CUSTOMERS table in the SH schema. Examine the following steps: 1. Issue the SELECT DBMS_STATS.CREATE_EXTENDED_STATS (‘SH’, ‘CUSTOMERS’) FROM ...
Saturday, May 27, 2023