Oracle 1Z0-083 問題集

質問 1：
Examine this output:

Which two are true? (Choose two.)
A. PDB3 can use all available parallel execution processes at times.
B. Any PDB not specified in the plan will be unable to execute statements in parallel.
C. PDB2 is guaranteed at least 25% of the available parallel execution processes if there is enough demand.
D. PDB3 is guaranteed to receive at least 20% of the available system resources if there is enough demand.
E. PDB1 is always limited to 40% of the available system resources regardless of demand.
F. Any PDB not specified in the plan will be able to use a maximum of 16.5% of the available system resources.
正解：A,B
解説: (Topexam メンバーにのみ表示されます)

質問 2：
A redaction policy was added to the SALcolumn of the SCOTT.EMPtable:

All users have their default set of system privileges.
For which three situations will data not be redacted? (Choose three.)
A. SCOTT sessions, only if the MGR role is set in the session
B. SYSTEM session, only if the MGR role is set in the session
C. SYS sessions, regardless of the roles that are set in the session
D. SYSTEM sessions, regardless of the roles that are set in the session
E. SCOTT sessions, because he is the owner of the table
F. SCOTT sessions, only if the MGR role is granted to SCOTT
正解：C,D,F

質問 3：
Examine this configuration:
28.CDB1is a container database.
29.COMMON_USER_PREFIXis set to an empty string.
30.PDB1is a pluggable database in CDB1.
31.APP1_ROOTis an application container in CDB1.
32.APP1_PDB1is an application PDB in APP1_ROOT.
You execute these commands:
$ sqlplus sys/oracle@localhost:1521/cdb1 as sysdba
SQL> CREATE ROLE role1 CONTAINER=CURRENT;
What 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.
C. ROLE1 will be created only in CDB$ROOT and APP1_ROOT.
D. ROLE1 will be created in CDB$ROOT, PDB1, APP1_ROOT, and APP1_PDB1.
E. It will return an error because common roles must start with C##.
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 4：
Examine this configuration:
23.CDB1and CDB2are two container databases.
24.PDB1is a pluggable database in CDB1.
25.PDB1_C1_SRVis a service for PDB1.
26.CDB1_LINKis a database link in CDB2referring to PDB1.
27.CDB2is also an entry in tnsnames.orapointing to the CDB2database default service.
You execute these commands successfully:
$ sqlplus sys/oracle_4U@cdb2 as sysdba
SQL> CREATE PLUGGABLE DATABASE PDB1
FROM PDB1@CDB1_LINK
SERVICE_NAME_CONVERT=('PDB1_C1_SRV','PDB1_C2_SRV');
Which two are true? (Choose two.)
A. PDB1_C1_SRV in CDB1 will be renamed PDB1_C2_SRV.
B. PDB1 will be created in CDB2 and left in MOUNT state.
C. PDB1 will be created in CDB2 and automatically opened.
D. PDB1_C2_SRV will be created but not started.
E. PDB1_C2_SRV will be created and started automatically.
正解：B,D
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Which two are true about data movement between a non-CDB and a PDB using Data Pump?
(Choose two.)
A. Tablespaces are automatically created as neeed while importing full exports in either a non-CDB or a PDB.
B. Moving data from a PDB to a non-CDB is only possible by using transportable tablespace export and import.
C. A new PDB is automatically created when importing a non-CDB into a CDB.
D. Moving data from a non-CDB to a PDB is only possible by using conventional export and import.
E. Oracle attempts to convert common users to conventional users when moving schemas from a PDB to a non-CDB.
F. Oracle attempts to convert conventional database users to local users when moving schemas from a non-CDB to a PDB.
正解：E,F
解説: (Topexam メンバーにのみ表示されます)

質問 6：
Which three are true about an application container?
A. It always contains multiple applications.
B. Two or more application PDBs in the same application container can be given exclusive access to some tables.
C. It can have new application PDBs created by copying PDB$SEED.
D. Two or more application PDBs in the same application container can share access to tables.
E. It always has a new application PDBs created by copying PDB$SEED.
F. It always contains a single application.
正解：B,C,D