[2023年05月]更新の1Z1-083試験資料Oracle学習ガイド [Q38-Q62]

[2023年05月]更新の1Z1-083試験資料Oracle学習ガイド

有効な問題最新版を試そう1Z1-083テスト解釈1Z1-083有効な試験ガイド

質問 # 38
Choose three. Which three are true about creating container databases (CDBs) and pluggable databases (PDBs) in Oracle 19c and later releases?

• A. A CDB can be duplicated using the Database Configuration Assistant (DBCA) in silent mode with no configuration required before starting the duplication.
• B. A snapshot copy PDB does not depend on an existing storage snapshot of the source PDB.
• C. A PDB snapshot can be a sparse copy of a source PDB.
• D. A snapshot copy PDB can be a full copy of a source PDB.
• E. A PDB snapshot can be a full copy of a source PDB.
• F. A PDB snapshot depends on an existing storage snapshot of the source PDB.
• G. A CDB can be duplicated using Recovery Manager (RMAN) with no configuration required before starting the duplication.

正解：D、F、G

質問 # 39
Choose three. Which are the three steps in the SQL tuning process for Oracle Database environments?

• A. Test the application as a whole using tuned SQL statements.
• B. Identify poorly tuned SQL statements using the SQL Tuning Advisor.
• C. Tune SQL statements as a group using the SQL Tuning and SQL Access Advisors.
• D. Test tuned SQL statements one at a time for all statements in the application.
• E. Identify poorly tuned SQL statements using Automatic Database Diagnostic Monitor.
• F. Tune individual SQL statements using the SQL Tuning Advisor.

正解：A、E、F

質問 # 40
While backing up to an SBT channel, you determine that the read phase of your compressed Recovery Manager (RMAN) incremental level 0 backup is a bottleneck. FORCE LOGGING is enabled for the database. Which two could improve read performance? (Choose two.)

• A. Increase the size of the database buffer cache.
• B. Enable asynchronous disk I/O.
• C. Increase the level of RMAN multiplexing.
• D. Increase the size of tape I/O buffers.
• E. Disable FORCE LOGGING for the database.

正解：A、E

質問 # 41
Which two are true about Oracle Flashback features?

• A. flashback query can retrieve redo records from online and archived redo log files.
• B. flashback drop can undrop an index when undropping a table.
• C. flashback version query can retrieve redo records from online and archived redo log files.
• D. After a database is restored from flashback logs using the flashback database command, it is sometimes rolled forward using redo logs.
• E. flashback table can undrop a column.

正解：A、E

質問 # 42
Application PDBs, SALES_APP1 and SALES_APP2, must be created and they must access common tables of the SALES_APP application.
Examine these steps:
1. Install the SALES_APP application, including the common tables, in the application root.
2. Install the SALES_APP application in the application root and the common tables in both the CDB root and the application root.
3. Create an application seed.
4. Install the SALES_APP application in the application seed.
5. Create the SALES_APP1 and SALES_APP2 application PDBs.
6. Sync the SALES_APP1 and SALES_APP2 application PDBs with the application root.
7. Sync the SALES_APP1 and SALES_APP2 application PDBs with the application seed.
8. Sync the application seed with the application root.
Which are the minimum required steps in the correct sequence?

• A. 2,5,6
• B. 3,4,1,6,8
• C. 1,3,5,7
• D. 1,3,5,6,7
• E. 1,5,6

正解：E

質問 # 43
Which two are true about OS groups and users for Oracle Grid Infrastructure and the Oracle Relational Database Management System (RDBMS)? (Choose two.)

• A. The Oracle Grid Infrastructure installation must be owned by the grid user.
• B. By default, members of the OSASM group can access Automatic Storage Management and RDBMS instances.
• C. The same OSDBA group must be used for Automatic Storage Management and the Oracle Database.
• D. The primary group for the Oracle Grid Infrastructure and Oracle Database owners must be the Oracle Inventory group.
• E. The Oracle Grid Infrastructure owner must have OSOPER, OSBACKUPDBA, and OSKMDBA as secondary groups.
• F. The Oracle Grid Infrastructure owner owns Oracle Restart and Oracle Automatic Storage Management binaries.

正解：D、F

質問 # 44
Which three methods can be used for heap table data migration after upgrading a database? (Choose three.)

• A. using Database Upgrade Assistant
• B. using the CREATE TABLE AS SELECT SQL statement
• C. using Database Replay
• D. using operating system file copy utilities
• E. using SQL Developer
• F. using Oracle Data Pump

正解：A、B、D

質問 # 45
Oracle Data Redaction is active on the SCOTT.EMP table. You queried the table twice. SQL> SELECT ENAME, SAL, COMM, MGR, HIREDATE FROM EMP WHERE DEPTNO=30; SQL> SELECT ENAME, SAL, COMM, MGR, HIREDATE FROM EMP WHERE DEPTNO=30; Which is guaranteed to be true concerning the redaction policy?

• A. FULL redaction is active on the SAL column
• B. PARTIAL redaction is active on the MGR column.
• C. RANDOM redaction is active on the HIREDATE column
• D. RANDOM redaction is active on the MGR column
• E. PARTIAL redaction is active of the HIREDATE column.

正解：C

質問 # 46
Which three are true about an application seed pluggable database (PDB)?

• A. It cannot be added to an application container after the application container has already been created.
• B. A new application PDB created by cloning an application seed PDB can have an up-to-date version of the application installed after cloning completes.
• C. It Is automatically synchronized with its application root PDB when an application is upgraded.
• D. It cannot be dropped from its application container.
• E. A new application PDB created by cloning an application seed PDB can have an old version of the application installed after cloning completes.
• F. It is not required in an application container.
• G. It is automatically synchronized with its application root PDB when an application is installed.

正解：A、B、E、G

質問 # 47
Which two are true about common objects? (Choose two.)

• A. They can be extended data-linked in CDB$ROOT.
• B. They can be only metadata-linked in an application container.
• C. They can exist in CDB$ROOT and an application root.
• D. They can be created only in an application root.
• E. They can be created only in CDB$ROOT.
• F. They can exist in user-defined schemas only in application containers.

正解：D、F

解説：
Reference:
https://blog.toadworld.com/2017/08/01/oracle-multi-tenant-application-containers-part-iii-sharing- of-data-in-application-common-objects

質問 # 48
You want to transport the UNIVERSITY tablespace from one database to another.
The UNIVERSITY tablespace is currently open read/write.
The source and destination platforms have the same endian format.
Examine this list of steps:
1. Make the UNIVERSITY tablespace read-only on the source system.
2. Export the UNIVERSITY tablespace metadata using EXPDP.
3. Create a cross-platform backup set from the UNIVERSITY tablespace on the source system, using an RMAN command that includes the DATAPUMP clause.
4. Copy the cross-platform backup sets to the destination system.
5. Copy the Data Pump dump set from the source to the destination system.
6. Restore the cross-platform backup set on the destination system using an RMAN command that includes the DATAPUMP clause.
7. Import the UNIVERSITY tablespace metadata using IMPDP.
8. Make the UNIVERSITY tablespace read/write on the destination system.
Which are the minimum number of steps required, in the correct order, to transport the UNIVERSITY tablespace?

• A. 1, 2, 3, 4, 5, 6, 7, 8
• B. 1, 3, 4, 6, 8
• C. 2, 3, 4, 5, 6, 7
• D. 3, 4, 6

正解：B

質問 # 49
Application PDBs, SALES_APP1 and SALES_APP2, must be created and they must access common tables of the SALES APP application. Examine these steps:
Install the SALES_APP application, induding the common tables, in the application root.
Install the SALES_APP application in the application root and the common tables in both the CDB root and the application root.
Create an application seed.
Install the SALES_APP application in the application seed.
Create the SALES_APP1 and SALES_APP2 application PDBs.
Sync the SALES_APP1 and SALES_APP2 application PDBs with the application root.
Sync the SALES_APP1 and SALES_APP2 application PDBs with the application seed.
Sync the application seed with the application root. Which are the minimum required steps in the correct sequence?

• A. 2,5,6
• B. 3,4,1.6,8
• C. 1,3,5,7
• D. 1,3,5,6,7
• E. 1,5,6

正解：E

質問 # 50
Examine these queries and their output:

After a system crash, an instance restart and an attempted opening of the PDBs result in:

Which two are true? (Choose two.)

• A. Data file 24 must be recovered while PDB2 is closed.
• B. Data file 24 must be recovered while the CDB is opened.
• C. Data file 24 cannot be recovered while the CDB is opened.
• D. Data file 24 can be recovered while CDB$ROOTand PDB$SEEDare opened.
• E. Data file 24 can be recovered while PDB2 is opened.

正解：B、C

質問 # 51
You plan to install Oracle Grid Infrastructure for a Standalone Server and Oracle Database for the first time on a server. Examine this command and its outcome: Which two are true? (Choose two.)

• A. oracle can own an Oracle Database installation but not an Oracle Grid Infrastructure installation.
• B. oracle will be an owner of the Oracle Inventory.
• C. The user account, oracle, and group, oinstall, can be used for all Oracle software installations.
• D. oracle will be granted the SYSASM privilege when installing the Oracle Database software.
• E. oracle must be the owner of every Oracle Database installation.

正解：A、C

質問 # 52
Which two are true about Oracle Database Configuration Assistant (DBCA) templates?

• A. Oracle DBCA templates can be used to create new databases and duplicate existing databases.
• B. New templates can only be created by modifying an existing user-created template.
• C. The Data Warehouse template is most suitable when transaction response time is the key criterion.
• D. Oracle DBCA templates can store only logical structure and not database files.
• E. The General Purpose or Transaction Processing templates are most suitable when concurrency and recoverability are key criteria.

正解：A、D

質問 # 53
You notice that the performance of your production 24x7 Oracle 12c database has significantly degraded. Sometimes, you are not able to connect to the database instance because it hangs. How can you detect the cause of the degraded performance?

• A. by running ADDM to fetch information from the latest Automatic Workload Repository (AWR) snapshots
• B. by using Active Session History (ASH) data and performing hang analysis
• C. by performing emergency monitoring using Real-Time Automatic Database Diagnostic Monitor (ADDM) to fetch data directly from SGA for analysis
• D. by running ADDM in diagnostic mode

正解：C

質問 # 54
A container database (CDB) contains two pluggable databases PDB1 and PDB2.
The local_undo_enabled database property is set to false in the CDB.
Data file 24 of PDB2 was deleted and you need to restore and recover it.
The only RMAN backup that exists was created with the backup database command while connected to CDB$ROOT.
Which three are true?

• A. Data file 24 can be recovered while connected to PDB2.
• B. Data file 24 can be recovered while connected to CDB$ROOT.
• C. Data file 24 can be restored and recovered while connected to CDB$ROOT.
• D. Data file 24 can be restored only while connected to PDB2.
• E. Data file 24 can be restored only while connected to CDB$ROOT.
• F. Data file 24 can be recovered only while connected to PDB2.

正解：A、B、C

質問 # 55
Which two are true about RMAN backups when using a media manager to write backups to tape when there are only two tape drives?

• A. Any backup set written to the SBT device in this configuration can contain a maximum of two backup pieces.
• B. SBT tape compression can be used even if no RMAN compression is configured.
• C. The SBT device should be configured to use parallelism 2 to allow both tape drives to be used simultaneously
• D. Any backup written to the SBT device in this configuration can contain a maximum of two backup sets.
• E. SBT tape compression and RMAN backup compression should be used in parallel.

正解：B、E

質問 # 56
Which three actions are performed by the Oracle Preinstallation RPM, oracle-database-server-xxxx- preinstall, for Oracle Grid Infrastructure, where xxxx is the Oracle version and release? (Choose three.)

• A. configuring the OS for Oracle Automatic Storage Management shared storage access
• B. creating the OSDBA (dba) group
• C. creating thte oraInventory (oinstall) group
• D. creating the grid OS user
• E. creating the oracleOS user
• F. performing checks to ensure minimum configuration requirements for Oracle Grid Infrastructure are met

正解：A、B、C

解説：
Explanation/Reference: https://docs.oracle.com/cd/E11882_01/install.112/e41961/prelinux.htm#CWLIN2932

質問 # 57
You issued this command:
RMAN> BACKUP RECOVERY AREA FORCE;
Which three are true? (Choose three.)

• A. All files in any previous FRA that have not yet been backed up, are backed up.
• B. All files in the current FRA that have been backed up already, are backed up.
• C. All Oracle recovery files normally written to the FRA and which have been backed up already to the current FRA, are backed up.
• D. All Oracle recovery files normally written to the FRA and which have been backed up already to in any previous FRA, are backed up.
• E. All files in the current fast recovery area (FRA) that have not yet been backed up, are backed up.
• F. All Oracle recovery files normally written to the FRA and which have not yet been backed up, are backed up.
• G. All files in any previous FRA that have been backed up already, are backed up.

正解：E、F、G

質問 # 58
Examine the command for creating pluggable database PDB2 in container database CDB2.

Select three options, any one of which is required for it to execute successfully. (Choose three.)

• A. Add the FILE_NAME_CONVERTclause to the statement and enable Oracle Managed Files (OMF)
• B. Add only the CREATE_FILE_DESTclause to the statement.
• C. Set only the PDB_FILE_NAME_CONVERTparameter.
• D. Enable only OMF.
• E. Add the FILE_NAME_CONVERTclause to the statement and set the PDB_FILE_NAME_CONVERT parameter.
• F. Set the PDB_FILE_NAME_CONVERTparameter and enable OMF.

正解：B、D、F

質問 # 59
Which four are true about duplicating a database using Recovery Manager (RMAN)? (Choose four.)

• A. Duplication can be done by having the auxiliary database instance pull backup sets from the target database instance.
• B. A connection to the recovery catalog instance is always required.
• C. Duplication can be done by having the target database instance push copies to the auxiliary database instance.
• D. A backup of the target database is always required.
• E. A subset of the target database can be duplicated.
• F. A new DBID is always created for the duplicated database.
• G. A connection to the target database instance is always required.
• H. A connection to an auxiliary instance is always required.

正解：A、C、E、H

質問 # 60
Which two are true about gathering optimizer statistics? (Choose two.)

• A. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open PDBs except PDB$SEED.
• B. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open pluggable databases (PDBs)
• C. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics only in CDB$ROOT.
• D. System statistics can be gathered only while connected to CDB$ROOT.
• E. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to a PDB opened in read/write mode gathers object statistics for that PDB.

正解：B、E

解説：
https://mikedietrichde.com/2016/10/21/gather-fixed-objects-stats-in-pdbs-as-well/#:~:text=Yes%2C%20you'll%20have%20to,independently%20from%20the%20CDB%24ROOT.&text=Oracle%20Database%20automatically%20gathers%20fixed,Automatic%20Optimizer%20Statistics%20Collection%E2%80%9C) .
Reference:
https://docs.oracle.com/en/database/oracle/oracle-database/20/arpls/DBMS_STATS.html

質問 # 61
You issued this command: RMAN> BACKUP RECOVERY FILES; Which two are true? (Choose two.)

• A. These backups can be written to disk or SBT.
• B. All Oracle recovery files not in the current FRA that have not been backed up already, are backed up.
• C. All Oracle recovery files in the current FRA that have not been backed up already, are backed up. D)All Oracle recovery files in the current fast recovery area (FRA) are backed up.
• D. All non-Oracle files in the current FRA that have not been backed up already, are backed up.

正解：B、C

質問 # 62
......

1Z1-083試験問題と解答：https://www.passtest.jp/Oracle/1Z1-083-shiken.html

1Z1-083実際の問題解答PDFは100%カバー率でリアル試験問題：https://drive.google.com/open?id=1XA5bSjudHMQPeMqX5OTWKyOOFahFwC54