Q1. Examine the following parameters for a database instance:MEMORY_MAX_TARGET=0 MEMORY_TARGET=0 SGA_TARGET=0 PGA_AGGREGATE_TARGET=500mWhich three initialization parameters are not controlled by Automatic Shared Memory Management (ASMM)?A. LOG_BUFFERB. SORT_AREA_SIZEC. JAVA_POOL_SIZED. STREAMS_POOL_SIZEE. DB_16K_CACHE_SZIEF. DB_KEEP_CACHE_SIZEView AnswerAnswer: AEFQ2. Which two statements are true about the use of the procedures listed in the v$sysaux_occupants.move_procedure column?A. The procedure may be used for some components to relocate component data to the SYSAUX…
Q1. Which three statements are true about the working of system privileges in a multitenant control database (CDB) that has pluggable databases (PDBs)?A. System privileges apply only to the PDB in which they are used. B. Local users cannot use local system privileges on the schema of a common user.C. The granter of system privileges must possess the set container privilege.D.…
Q1. Identify two correct statements about multitenant architectures.A. Multitenant architecture can be deployed only in a Real Application Clusters (RAC) configuration.B. Multiple pluggable databases (PDBs) share certain multitenant container database (CDB) resources.C. Multiple CDBs share certain PDB resources.D. Multiple non-RAC CDB instances can mount the same PDB as long as they are on the same server.E. Patches are always applied…
Q1. Identify three valid methods of opening, pluggable databases (PDBs).A. ALTER PLUGGABLE DATABASE OPEN ALL ISSUED from the rootB. ALTER PLUGGABLE DATABASE OPEN ALL ISSUED from a PDBC. ALTER PLUGGABLE DATABASE PDB OPEN issued from the seedD. ALTER DATABASE PDB OPEN issued from the rootE. ALTER DATABASE OPEN issued from that PDBF. ALTER PLUGGABLE DATABASE PDB OPEN issued from another…
Q1. What is the effect of specifying the "ENABLE PLUGGABLE DATABASE" clause in a "CREATE DATABASE” statement?A. It will create a multitenant container database (CDB) with only the root opened. B. It will create a CDB with root opened and seed read only.C. It will create a CDB with root and seed opened and one PDB mounted. D. It will create a…
Q1. Which three statements are true concerning the multitenant architecture?A. Each pluggable database (PDB) has its own set of background processes.B. A PDB can have a private temp tablespace.C. PDBs can share the sysaux tablespace.D. Log switches occur only at the multitenant container database (CDB) level.E. Different PDBs can have different default block sizes.F. PDBs share a common system tablespace.G.…
Q1. You upgrade your Oracle database in a multiprocessor environment. As a recommended you execute the following script:SQL > @utlrp.sqlWhich two actions does the script perform?A. Parallel compilation of only the stored PL/SQL codeB. Sequential recompilation of only the stored PL/SQL codeC. Parallel recompilation of any stored PL/SQL codeD. Sequential recompilation of any stored PL/SQL codeE. Parallel recompilation of Java…
Q1. Which three statements are true regarding the use of the Database Migration Assistant for Unicode (DMU)?A. A DBA can check specific tables with the DMUB. The database to be migrated must be opened read-only.C. The release of the database to be converted can be any release since 9.2.0.8.D. The DMU can report columns that are too long in the…
Q1. Which three statements are true about Flashback Database?A. Flashback logs are written sequentially, and are archived. B. Flashback Database uses a restored control file to recover a database.C. The Oracle database automatically creates, deletes, and resides flashback logs in the Fast Recovery Area. D. Flashback Database can recover a database to the state that it was in before a reset logs…
Q1. Which two statements are true concerning the Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)?A. If no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an equal degree of the resource share of that PDB. B. In a PDB plan, subplans may be used…
Q1. Which three statements are true concerning unplugging a pluggable database (PDB)?A. The PDB must be open in read only mode.B. The PDB must be dosed. C. The unplugged PDB becomes a non-CDB. D. The unplugged PDB can be plugged into the same multitenant container database (CDB)E. The unplugged PDB can be plugged into another CDB. F. The PDB data files are automatically…
Q1. Which two statements are true about Oracle Managed Files (OMF)?A. OMF cannot be used in a database that already has data files created with user- specified directions.B. The file system directions that are specified by OMF parameters are created automatically.C. OMF can be used with ASM disk groups, as well as with raw devices, for better file management.D. OMF…
