正真正銘のベスト試験材料は1Z0-083テストエンジン練習試験合格させます
[2025年更新]1Z0-083のPDF問題、完璧に練習問題で合格
質問 # 156
choose three You want to duplicate one of your databases when connected to the target database and to the recovery catalog. Which three are true about this type of database duplication ) The duplication process can create backup sets or image copies
- A. The duplication process can use existing backup sets or image copies.
- B. The target database must be open
- C. The duplication -process pushes backup sets to the auxiliary instance.
- D. The duplication process can use existing backup sets or image copies
- E. The duplication process pushes image copies to the auxiliary instance.
- F. The target database must be in mount state.
正解：A、B、E
質問 # 157
Examine this configuration:
1. CDB1is a container database.
2. COMMON_USER_PREFIXis C##.
3. PDB1is a pluggable database contained in CDB1.
4. APP1_ROOTis an application container contained in CDB1.
5. APP1_PDB1is an application PDB contained in APP1_ROOT.
You execute these commands successfully:
Which two are true? (Choose two.)
- A. APP1_USER1 can be created in PDB1.
- B. APP1_USER1 can have different privileges in each Application PDB contained in APP1_ROOT.
- C. C##_APP_USER1 can be created in CDB1.
- D. P1_USER1 can be created in CDB1.
- E. APP1_USER1 can be created in CDB1.
- F. C##_USER1 will have the same privileges and roles granted in all PDBs in CDB1.
正解：A、C
解説：
For the common user:
The username must be unique across all containers. So D is correct because APP_USER1 is different from APP1_USER1 in APP1_ROOT B,E are wrong because you can only create local user in specific PDB.
A is true because APP1_USER1 is unique in PDB1
F is false because common user will not have the same privileges and role unless you grant it with option CONTAINER=ALL;
質問 # 158
Which three actions will add a resource to an Oracle Restart configuration? (Choose three.)
- A. creating a disk group using the CREATE DISKGROUP SQL statement
- B. creating a database service using DBMS_SERVICE.CREATE_SERVICE
- C. creating an Oracle Database service by modifying the SERVICE_NAMES parameter
- D. creating an Oracle Automatic Storage Management (ASM) instance with ASM Configuration Assistant (ASMCA)
- E. creating a database service using Oracle Database Configuration Assistant (DBCA)
- F. creating a database using the CREATE DATABASE SQL statement
正解：B、E、F
質問 # 159
PDB1 and PBD2 are pluggable databases in CDB1.
Examine these commands:
CDB1 is then restarted.
Which three are true? (Choose three.)
- A. PDB1 will be opened READ WRITE.
- B. PDB$SEED will be opened READ ONLY.
- C. PDB2 will be opened READ WRITE.
- D. PDB$SEED will be MOUNTED.
- E. PDB1 will be MOUNTED.
- F. PDB2 will be MOUNTED.
正解：A、B、C
質問 # 160
Which two are true about the execution of operating system scripts starting from Oracle Database 19c? (Choose two.)
- A. root.sh can be executed automatically by the Database installer only by using sudo credentials.
- B. The sudo password can be specified in a response file.
- C. The sudo password must be specified in a response file.
- D. root.sh can be executed automatically by the Database Installer only if it is provided with root credentials.
- E. The root password cannot be specified in a response file.
- F. orainstRoot.sh can be executed automatically by the Database installer by using sudo or root credentials.
正解：A、E
質問 # 161
Which three actions are performed by Database Upgrade Assistant (DBUA)? (Choose three.)
- A. It sets all user tablespaces to "read-only" before starting the upgrade.
- B. It removes the AUDSYS schema and the AUDIT_ADMIN and AUDIT_VIEWER roles
- C. It recompiles all stored PL/SQL code by using utlrp.sql.
- D. It increases tablespace size, if required, to meet upgrade requirements.
- E. It performs prerequisite checks to verify if the Oracle database is ready for upgrade.
- F. It empties the RECYCLE BIN.
正解：C、D、E
解説：
Reference:
https://oracle-base.com/articles/12c/upgrading-to-12c
質問 # 162
Choose the best answer. Examine this configuration: 1. CDB1 is an Oracle Database 12c Release 2 container database (CDB). 2. PDB1 and PDB2 are two pluggable databases (PDBs) in CDB1. After successfully performing all the preupgrade tasks, you execute these commands from the Oracle Database 18c environment: $ export ORACLE_SID=cdb1 $ sqlplus / as sysdba SQL> STARTUP UPGRADE; SQL> SHOW pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------------------------------------------------------------2 PDB$SEED 3 PDB1 4 PDB2 MIGRATE YES MOUNTED YES MOUNTED YES SQL> ALTER PLUGGABLE DATABASE pdb1 OPEN UPGRADE; Pluggable database altered. SQL> exit $ $ORACLE_HOME/perl/bin/perl catctl.pl -C 'PDB2' What is the outcome?
- A. CDB$ROOT, PDB$SEED, PDB1, and PDB2 are upgraded.
- B. Only CDB$ROOT, PDB$SEED, and PDB1 are upgraded.
- C. It fails because PDB$SEED is in MIGRATE state.
- D. It fails because PDB2 is not in UPGRADE state.
- E. Only CDB$ROOT, PDB$SEED, and PDB2 are upgraded.
- F. Only CDB$ROOT and PDB$SEED are upgraded.
正解：D
質問 # 163
You plan to perform cross-platform PDB transport using XTTS. Which two are true?
- A. The source PDB must be in MOUNT state.
- B. The source and target platforms must have the same endianess.
- C. A backup of the PDB must exist, taken using the BACKUP command with the To PLATFORM clause.
- D. The source PDB can be in MOUNT or OPEN state.
- E. Automatic conversion of endianess occurs.
- F. The source PDB must not be an application root.
正解：B、D
質問 # 164
On the 10th of August, you implement an incremental database backup strategy and configure a recovery window of five days.
Level 0 backups are taken on the 10th, 17th, and 24th of August. Differential level 1 incremental backups are taken daily between the level 0 backups.
Today is the 26th of August.
Which backups will be obsolete?
- A. all backups prior to 20th of August
- B. all backups prior to 22nd of August
- C. all backups prior to 24th of August
- D. all backups prior to 10th of August
- E. all backups prior to 17th of August
正解：E
質問 # 165
Choose three. Which three actions will add a resource to an Oracle Restart configuration?
- A. creating a database using the CREATE DATABASE SQL statement
- B. creating a disk group using the CREATE DISKGROUP SQL statement
- C. creating an Oracle Database service by modifying the SERVICE_NAMES parameter
- D. creating an Oracle Automatic Storage Management (ASM) instance with ASM Configuration Assistant (ASMCA)
- E. creating a database service using Oracle Database Configuration Assistant (DBCA)
- F. creating a database service using DBMS_SERVICE.CREATE_SERVICE
正解：B、D、E
質問 # 166
Which three are true about Database Point-in-Time Recovery? (Choose three.)
- A. The Database must be in ARCHIVELOG mode.
- B. The database must have FLASHBACK DATABASE ON to perform Database Point-in-Time Recovery.
- C. The database must be open RESETLOGS after Database Point-in-Time Recovery.
- D. The database must be in MOUNT state when performing Database Point-in-Time Recovery.
- E. The target point for the recovery must be specified as a stime or System Change Number (SCN).
- F. Database Point-in-Time Recovery is performed by the Managed Recovery Process (MRP)
正解：B、C、F
質問 # 167
Which two are true about common objects? (Choose two.)
- A. They can exist in CDB$ROOTand an application root.
- B. They can be extended data-linked in CDB$ROOT.
- C. They can exist in user-defined schemas only in application containers.
- D. They can be created only in CDB$ROOT.
- E. They can be only metadata-linked in an application container.
- F. They can be created only in an application root.
正解：B、F
解説：
Explanation/Reference: https://blog.toadworld.com/2017/08/01/oracle-multi-tenant-application-containers-part-iii-sharing-of- data-in-application-common-objects
質問 # 168
A container database (CDB) contains two pluggable databases PDB1 and PDB2.
The LOCAL_UNDO_ENABLEDdatabase property is set to FALSEin the CDB.
Data file 24 of PDB2was deleted and you need to restore and recover it.
The only RMAN backup that exists was created with the BACKUP DATABASEcommand while connected to CDB$ROOT.
Which three are true? (Choose three.)
- A. Data file 24 can be restored only while connected to PDB2.
- B. Data file 24 can be restored only while connected to CDB$ROOT.
- C. Data file 24 can be recovered while connected to PDB2.
- D. Data file 24 can be recovered only while connected to PDB2.
- E. Data file 24 can be recovered while connected to CDB$ROOT.
- F. Data file 24 can be restored and recovered while connected to CDB$ROOT.
正解：A、E、F
質問 # 169
Which two are true about RMAN image copies?
- A. They can be encrypted using Transparent Data Encryption (TDE).
- B. They can be used as a level 0 incremental backup.
- C. They are the only backup option available for databases in NOARCHIVELOG mode.
- D. They can only be written to disk.
- E. They can be used as a level 1 incremental backup.
正解：B、D
質問 # 170
You are administering a multitenant container database (COB) that contains two pluggable databases (PDBs), pdb1 and pdb2. You are connected to pdb2 as a common user with DBA privileges. The statistics_level parameter is PDB modifiable. As the user sys, execute the following command on pdb2: SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SID='*' SCOPE=SPFILE; Which statement is true about the result of this command?
- A. The statement is ignored because there is no SPFILE for a PDB.
- B. The statistics_level parameter is set to all when any of the PDBs is reopened.
- C. The statistics_level parameter is set to all only for PDB2 when it is reopened.
- D. The statistics_level parameter is set to all when the root database is restarted.
正解：C
質問 # 171
Choose the best answer. Examine this configuration:
1. CDB1 is a container database.
2. There are several pluggable databases (PDBs) in CDB1.
5. Each PDB has several tables with referential integrity constraints.
6. FLASHBACK DATABASE is ON.
7. UNDO RETENTION GUARANTEE is enabled.
Multiple undesired multitable changes were made in all the PDBs.
Which method can be used to undo the changes using a single command?
- A. flashback transaction
- B. flashback database
- C. flashback table
- D. restore and recover database
- E. flashback table and transaction
正解：B
質問 # 172
......
ベスト最新資料は1Z0-083オンライン練習試験：https://www.goshiken.com/Oracle/1Z0-083-mondaishu.html
リアル練習1Z0-083 Oracle Database Administration II試験知能問題集：https://drive.google.com/open?id=1MFozKTW3XGMEhA-PbXDf9MiE2HRNoO0m