素晴らしい1Z0-083試験問題集試そう1Z0-083問題集PDF [Q145-Q163]

素晴らしい1Z0-083試験問題集試そう1Z0-083問題集PDF

1Z0-083問題集PDFで1Z0-083リアル試験問題解答

Oracle 1Z0-083試験、またはOracle Database Administration II試験は、Oracleデータベースの管理と管理スキルを向上させたいプロフェッショナル向けの認定試験です。この試験は、Oracle Database Administration I試験に合格し、Oracleデータベースの管理に実践的な経験がある個人を対象としています。この試験に合格することは、Oracle Certified Professional（OCP）認定を取得するための要件です。

Oracle Database Administration IIまたは1Z0-083認定試験は、Oracle Database Administration I認定をすでに取得している専門家向けに設計されています。バックアップと回復、パフォーマンスチューニング、セキュリティ管理、データベースのアップグレードと移行など、高度なレベルのデータベース管理タスクを実行するために必要なスキルと知識を検証します。この試験に合格すると、データベース管理者としての信頼性が向上し、新しいキャリアの機会が開かれます。

質問 # 145
Choose three. Which three are performed by Oracle Automatic Storage Management (ASM) instances?

A. managing extent allocation for Oracle database segments
B. acting as an I/O server to write data file blocks to ASM disks on behalf of Database Writer processes (DBWn)
C. mounting disk groups
D. acting as an I/O server to read data file blocks from ASM disks on behalf of database server processes
E. managing Allocation Units (AUs) for disk group content
F. managing space allocation for Oracle ASM files

正解：C、E、F

質問 # 146
Which two are true about the execution of operating system scripts starting from Oracle Database 19c?
(Choose two.)

A. The sudo password must be specified in a response file.
B. root.sh can be executed automatically by the Database Installer only if it is provided with root credentials.
C. The root password cannot be specified in a response file.
D. orainstRoot.sh can be executed automatically by the Database installer by using sudo or root credentials.
E. root.sh can be executed automatically by the Database installer only by using sudo credentials.
F. The sudo password can be specified in a response file.

正解：C、D

質問 # 147
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. C##_APP_USER1 can be created in CDB1.
B. APP1_USER1 can have different privileges in each Application PDB contained in APP1_ROOT.
C. P1_USER1 can be created in CDB1.
D. C##_USER1 will have the same privileges and roles granted in all PDBs in CDB1.
E. APP1_USER1 can be created in CDB1.
F. APP1_USER1 can be created in PDB1.

正解：A、F

解説：
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;

質問 # 148
choose two Which two are benefits of unified auditing in full mode?

A. All audit data is written to both the traditional locations and to the unified location.
B. The audit trail uses less space.
C. Pre 12c audit data is written to the traditional locations and new 12c audit data is written to the unified location.
D. The audit trail is read-only.
E. The audit trail is in a single format.

正解：C、E

質問 # 149
Choose the best answer. 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: $ sqlplus sys/ orac1e@localhost:1521/cdb1 as sysdba SQL> ALTER SYSTEM SET DEFAULT_SHARING=DATA; System altered. SQL> ALTER SESSION SET CONTAINER=app_root; Session altered. SQL> ALTER PLUGGABLE DATABASE APPLICATION companyapp BEGIN UPGRADE '1.0' TO '2.0'; pluggable database altered. SQL> ALTER TABLE emp ADD (sal NUMBER NOT NULL) ; Table altered. SQL> ALTER PLUGGABLE DATABASE APPLICATION companyapp END UPGRADE TO '2.0'; Pluggable database altered. SQL> ALTER SESSION SET CONTAINER=app_pdb1; Session altered. SQL> DESC emp; Name Null? Type --------------------------------------------------------------ENO NUMBER ENAME VARCHAR2 (20) SQL> SELECT * FROM emp; ENO ENAME ---------------------------------100 Alan 200 Ben SQL> ALTER PLUGGABLE DATABASE APPLICATION companyapp SYNC; What will be the outcome and why?

A. It will return an error because EMP is not empty in APP_ROOT.
B. SAL will be added to APP_PDB1.EMP, with 0 in columns of existing rows.
C. SAL will be added to APP_PDB1.EMP, with NULLs in columns of existing rows.
D. It will return an error because the SYNC operation is not allowed when constraints are added to common objects.
E. It will return an error because EMP.SAL is empty in APP_ROOT.

正解：A

質問 # 150
Which three are true about Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), and the Manageability Monitor (MMON) background process? (Choose three.)

A. AWR snapshots must be deleted when no longer required by ADDM.
B. By default, MMON creates an AWR snapshot every 30 minutes.
C. By default, AWR snapshots are automatically purged after eight days.
D. ADDM can recommend extending the buffer cache.
E. ADDM performs its analysis only when a DBA requests it.
F. ADDM can recommend shrinking the buffer cache.

正解：C、D、F

質問 # 151
Which three are true about RMAN archival backups with the RESTORE POINT clause? (Choose three.)

A. Archive logs are retained if they are necessary to allow the database to be recovered to a consistent state when an archival backup is restored.
B. The SPFILE is included in the archival backup.
C. Use of a recovery catalog is always required to support the creation and use of archival backups.
D. They are never considered obsolete by RMAN.
E. The ARCHIVAL attribute for a backup overrides the RMAN retention policy.
F. They can optionally be written to a fast recovery area (FRA).
G. All archive logs are retained after an archival backup is taken, until the next archival backup is taken of the same database.

正解：A、B、E

質問 # 152
Examine this configuration:
* CDB1 is a container database.
* PDB1 and PDB2 are pluggable databases in CDB1.
You execute these commands successfully:

Which two are true? (Choose two.)

A. PDB1 and PDB2 are in MOUNT state.
B. PDB$SEED is in READ ONLY state.
C. PDB1 and PDB2 are in READ ONLY state.
D. Redo logs are opened.
E. CDB$ROOT is in MOUNT state.

正解：B、D

質問 # 153
Which two are true about the Program Global Area (PGA) and its management in an Oracle database instance? (Choose two.)

A. PGA_AGGREGATE_LIMIT is a hard limit on the PGA size for any one session.
B. Sorts and Hash Joins use PGA memory.
C. The entire PGA is located in the System Global Area (SGA) when using shared servers.
D. The private SQL area (UGA) is located in the System Global Area (SGA) when using shared servers.
E. The private SQL area (UGA) is located in the System Global Area (SGA) when using dedicated servers.

正解：B、D

解説：
https://docs.oracle.com/en/database/oracle/oracle-database/19/cncpt/memory-architecture.html#GUID-913335DF-050A-479A-A653-68A064DCCA41

質問 # 154
Which three are true about managing memory components in an Oracle database instance?
(Choose three.)

A. Automatically tuned and resized System Global Area components will always revert to their initial sizes after an instance restart.
B. With Automatic Memory Management, the database instance can increase the System Global Area size by reducing the Program Global Area size.
C. With Automatic Shared Memory Management, the database instance can increase the Program Global Area size by reducing the System Global Area size.
D. Automatic Memory Management must be used together with locking the System Global Area into physical memory.
E. On Line Transaction Processing systems often use less Program Global Area than Decision Support Systems.
F. With Automatic Shared Memory Management, the database instance can increase the Large Pool size by reducing the Shared Pool size.

正解：B、E、F

解説：
In AMM the instance exchanges memory between the SGA and the instance PGA as needed (B is correct) In ASMM the instance automatically distributes this memory among the various SGA components (JUST SGA) (A is correct, E incorrect) After a restart the instance return to the SGA values before the shutdown (not the initial values) (C incorrect)
https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/managing- memory.html#GUID-8F54391B-D42A-4FDA-9D12-E1F81FD113EA F is also correct:
For OLTP systems, the PGA memory typically makes up a small fraction of the available memory, leaving most of the remaining memory for the SGA.
For DSS systems running large, memory-intensive queries, PGA memory can typically use up to
70% of the available memory.
https://docs.oracle.com/database/121/TGDBA/tune_pga.htm#TGDBA472

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

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

正解：B、C、G、H

質問 # 156
Which four are true about performing Tablespace Point-In-Time Recovery (TSPITR) using Recovery Manager (RMAN)?

A. It can be used to recover a dropped tablespace.
B. RMAN always includes tablespaces containing undo segments in the recovery set.
C. It can be used to recover a truncated table.
D. It can be performed using an auxiliary instance managed by RMAN.
E. RMAN automatically adds any required tablespaces to the recovery set to make it self-contained.
F. flashback database must be enabled for it to work.
G. It can be performed using an auxiliary instance managed by a DBA.
H. It can be performed repeatedly until the correct time is found without using an RMAN catalog.

正解：D、F、G、H

質問 # 157
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. Enable only OMF.
B. Set the PDB_FILE_NAME_CONVERTparameter and enable OMF.
C. Set only the PDB_FILE_NAME_CONVERTparameter.
D. Add the FILE_NAME_CONVERTclause to the statement and set the PDB_FILE_NAME_CONVERT parameter.
E. Add only the CREATE_FILE_DESTclause to the statement.
F. Add the FILE_NAME_CONVERTclause to the statement and enable Oracle Managed Files (OMF)

正解：A、B、E

質問 # 158
Choose the best answer. 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 root. 7. Sync seed. 8. Sync the SALES_APP1 and SALES_APP2 application PDBs with the application the SALES_APP1 and SALES_APP2 application PDBs with the application the application seed with the application root.
Which are the minimum required steps in the correct sequence?

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

正解：A

質問 # 159
Which two are true about creating pluggable databases (PDBs) using snapshots in Oracle 19c and later releases?

A. A PDB snapshot is always a sparse copy of the source PDB
B. A snapshot copy PDB depends on a storage snapshot which can be stored on any file system
C. A snapshot copy PDB depends on a storage snapshot which can only be stored on specific file systems
D. A PDB snapshot depends on a storage snapshot which can only be stored on specific file systems
E. A PDB snapshot is always a full copy of the source PDB
F. A PDB snapshot depends on a storage snapshot which can be stored on any file system
G. A snapshot copy PDB can be created from a stand-alone clone PDB

正解：A、D

質問 # 160
Which three are true about managing memory components in an Oracle database instance? (Choose three.)

A. Automatically tuned and resized System Global Area components will always revert to their initial sizes after an instance restart.
B. With Automatic Shared Memory Management, the database instance can increase the Program Global Area size by reducing the System Global Area size.
C. Automatic Memory Management must be used together with locking the System Global Area into physical memory.
D. On Line Transaction Processing systems often use less Program Global Area than Decision Support Systems.
E. With Automatic Memory Management, the database instance can increase the System Global Area size by reducing the Program Global Area size.
F. With Automatic Shared Memory Management, the database instance can increase the Large Pool size by reducing the Shared Pool size.

正解：B、D、F

解説：
Reference:
https://docs.oracle.com/database/121/TGDBA/tune_shared_pool.htm

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

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

正解：B、C、F

解説：
Argument of veginha handles the upgrade itself, this question handles about a heap move.

質問 # 162
Which three are located by using environment variables? (Choose three.)

A. default directories for temporary files used by temporary tablespaces
B. the location of Oracle Net Services configuration files
C. the Optimal Flexible Architecture (OFA) compliant path to store Oracle software and configuration files.
D. the temporary disk space used by Oracle Installer during installation
E. the list of a disk group names to be mounted by an Oracle Automatic Storage Management (ASM) instance at startup
F. the maximum number of database files that can be opened by a database instance

正解：B、C、D

解説：
A - ORACLE_BASE, ORACLE_HOME - correct
B - TNS_ADMIN, old TWO_TASK, etc - correct
C - spfile parameter ASM_DISKGROUPS, not env variable
D - [s]pfile parameter DB_CREATE_FILE_DEST, not env variable
E - TMP, TEMP - correct
F - [s]pfile parameter DB_FILES, not env variable

質問 # 163
......

有効な1Z0-083テスト解答とOracle 1Z0-083試験PDF：https://www.jpntest.com/shiken/1Z0-083-mondaishu

実際に出る1Z0-083試験問題集には正確で更新された問題：https://drive.google.com/open?id=17WV-ABIxinlY3Ue6MMEMq0nuc2EwvVEN