Examine this configuration: 1. CDB1

单选题 Examine this configuration: 1. CDB1 is a container database. 2. DEFAULT_SHARING is METADATA. 3. APP_ROOT is an application root contained in CDB1. 4. APP_PDB1 is an application PDB contained in APP_ROOT. 5. COMPANYAPP is an application contained in APP_ROOT. 6. EMP is a common table created in APP_ROOT and all its application PDBs, created when version 1.0 of COMPANYAPP was installed. You execute these commands: What will be the outcome and why?

A、 SAL will be added to APP_PDB1.EMP, with 0 in columns of existing rows

B、 It will return an error because EMP.SAL is empty in APP_ROOT

C、 It will return an error because the SYNC operation is not allowed when constraints are added to common objects

D、 It will return an error because EMP is not empty in APP_ROOT

E、 SAL will be added to APP_PDB1.EMP, with NULLs in columns of existing rows

查看答案

下载APP答题

由4l***fq提供分享举报纠错

相关试题

单选题 Which operating system group is NOT needed to perform an Oracle Database installation?

A、OSRACDBA

B、OSDB

C、OSASM

D、OSKMDB

E、OSOPER

查看答案

单选题 Examine this configuration: 1. CDB1 is a container database. 2. COMMON_USER_PREFIX is set to an empty string. 3. PDB1 is a pluggable database in CDB1. 4. APP1_ROOT is an application container in CDB1. 5. APP1_PDB1 is an application PDB in APP1_ROOT You execute these commands: $ sqlplus sys/oracle@localhost:1521/cdb1 as sysdba SQL> CREATE ROLE role1 CONTAINER=CURRENT; Which is true?

A、It will return an error because creation of a local role is not allowed in CDB$ROOT

B、ROLE1 will be created only in CDB$ROOT and APP1_ROOT

C、ROLE1 will be created only in CDB$ROOT

D、It will return an error because common roles must start with C##

E、ROLE1 will be created in CDB$ROOT, PDB1, APP1_ROOT, and APP1_PDB1

查看答案

单选题 Examine this extract from the show parameters command: NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_16k_cache_size big integer 0 db_2k_cache_size big integer 0 db_32k_cache_size big integer 0 db_4k_cache_size big integer 0 db_8k_cache_size big integer 0 db_cache_size big integer 0 java_pool_size big integer 0 large_pool_size big integer 0 memory_max_target big integer 800M memory_target big integer 800M pga_aggregate_limit big integer 2G pga_aggregate_target big integer 0 sga_max_size big integer 800M sga_min_size big integer 0 sga_target big integer 0 shared_pool_reserved_size big integer 7130316 shared_pool_size big integer 0 statistics_level string TYPICAL workarea_size_policy string AUTO How are System Global Area (SGA) and Program Global Area (PGA) memory managed by an instance using these parameter settings?

A、SGA memory is manually managed and PGA memory is managed by using Automated SQL Execution Memory Management

B、SGA and PGA memory are managed by using Automatic Memory Management (AMM)

C、SGA memory is managed by using Automatic Shared Memory Management (ASMM) and PGA memory is managed by using Automated SQL Execution Memory Management

D、SGA memory is managed by using Automatic Shared Memory Management (ASMM) and PGA memory is manually managed

E、SGA and PGA memory are manually managed

查看答案

单选题 SQL Performance Analyzer (SPA) has reported several regressed SQL statements for one of your databases. Which action could help in the performance management of these regressed SQL statements?

A、Use the SQL Tuning Advisor for each of the regressed statements.

B、Create SQL plan directives for each of the regressed statements.

C、Use the SQL Access Advisor for each of the regressed statements.

D、Create an adaptive execution plan for each of the regressed statements.

查看答案

单选题 How do you configure a CDB for local undo mode?

A、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.

B、Open the CDB instance in restricted mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON, and create an UNDO tablespace in each PDB, then restart the CDB instance.

C、Open the CDB instance in upgrade mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON, and then restart the CDB instance.

D、Open the CDB instance in read-only mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON, and then change the CDB to read/write mode.

E、Open the CDB instance in upgrade mode. In each PDB, execute ALTER DATABASE LOCAL UNDO ON, create an UNDO tablespace, and then restart the CDB instance.

查看答案

单选题 Your CDB has two regular PDBs as well as one application container with two application PDBs and an application seed. No changes have been made to the standard PDB$SEED. How many default temporary tablespaces can be assigned in the CDB?

A、eight

B、six

C、five

D、three

E、seven

查看答案

单选题 Which statement correctly describes the SQL profiling performed by the SQL Tuning Advisor?

A、It is a set of recommendations by the optimizer to create new indexes

B、It is a set of recommendations by the optimizer to change the access methods used

C、It is auxiliary information collected by the optimizer for a SQL statement to help use better joins orders

D、It is a set of recommendations by the optimizer to restructure a SQL statement to avoid sub optimal execution plans

E、It is auxiliary information collected by the optimizer for a SQL statement to eliminate estimation error

查看答案

单选题 You execute this command successfully: SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE; What is the outcome?

A、It creates a binary backup of the control file

B、It creates a file that contains RMAN scripts to create a duplicate database

C、It creates a file that contains SQL statement to re-create the control file

D、It creates a copy of the control file in the fast recovery area(FRA)

E、It updates the alert log with the location and contents of the control file

查看答案