• ホーム
  • ブログ
  • 一番最新のOracle 1Z1-083試験問題集PDFには2024年更新 [Q110-Q131]

一番最新のOracle 1Z1-083試験問題集PDFには2024年更新 [Q110-Q131]

Share

一番最新のOracle 1Z1-083試験問題集PDFには2024年更新

100%無料Oracle Database 19c 1Z1-083問題集PDFお試しサンプル認定ガイドがカバーされます


Oracle 1Z1-083: Oracle Database Administration IIは、Oracleデータベースを管理および維持する責任を持つデータベース管理者向けに設計された認定試験です。この試験は、Oracle Certified Professional Database Administrator認定トラックの一部であり、データベースセキュリティ、バックアップとリカバリ、パフォーマンスチューニング、データベースアップグレードなどの領域における候補者の知識とスキルをテストすることを意図しています。


Oracle 1Z1-083試験の準備をするには、候補者はOracleデータベースの豊富な経験を持ち、データベース管理のベストプラクティスを完全に理解する必要があります。また、教室やオンラインコースなどのOracleのトレーニングリソース、練習試験や学習ガイドも活用する必要があります。候補者はまた、Oracle認定コミュニティへの参加を検討する必要があります。そこでは、試験の準備をして貴重な研究資料とリソースにアクセスする他の専門家とつながることができます。

 

質問 # 110
Which three are true about post-upgrade activities when upgrading an Oracle database using Database Upgrade Assistant?

  • A. The new extended data type capability must be enabled by running the utlrp.sql script
  • B. The Oracle Application Express configuration should be updated after upgrading Oracle Database.
  • C. After a manual upgrade, TNSNAMES.ORA entries must be updated to reflect the new ORACLE_HOME.
  • D. Time zone files must be upgraded manually using the DBMS_DST PL/SQL package.
  • E. Any Recovery Manager (RMAN) recovery catalog must be upgraded manually.

正解：A、B、E


質問 # 111
Which three are true about corrupted data blocks and their recovery in an Oracle Database?

  • A. DB_BLOCK_CHECKING=TRUE causes a check sum to be added to each data block to help detect physical or media corruption.
  • B. If a row lock is held by a nonexistent transaction, the block containing the row is media corrupt.
  • C. A media corrupt block is one where the block is not formatted correctly.
  • D. The ANALYZE TABLE VALIDATE STRUCTURE CASCADE command verifies that each table row has an index entry pointing to it.
  • E. DB_LOST_WRITE_PROTECT=TYPICAL causes extra logging overhead on the standby database.
  • F. If a row lock is held by a nonexistent transaction, the block containing the row is logically corrupt.

正解：D、E、F


質問 # 112
Choose three. In a single-instance, multitenant container database (CDB), which three are only ever defined in or part of CDB$ROOT?

  • A. control files
  • B. mandatory Oracle-supplied PL/SQL packages
  • C. redo logs
  • D. user-defined PL/SQL packages
  • E. all data dictionary metadata
  • F. temporary tablespaces
  • G. undo tablespaces

正解：A、C、E


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

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

正解：B、E、F、G

解説：
A duplicate database is a copy of your target database. With the FOR STANDBY clause, it keeps the same unique database identifier(DBID); If FOR STANDBY not specified it creates a new DBID. The duplicate database can include the same content or only a subset from the source database. It can be in the same host or a separate host. The principal work of the duplication is performed by the auxiliary channels.These channels correspond to a server session on the auxiliary instance on the destination host for backup based duplication. For active database duplication the target channels perform the work of pushing data file copies to the auxiliary instance (if number of allocated target channels is greater than the number of allocated auxiliary channels).


質問 # 114
Which two are true about instance recovery?

  • A. It is performed by the Recovery Writer (rvwr) background process.
  • B. It is performed automatically after the database is opened; however, blocks requiring recovery are not available until they are recovered.
  • C. It is not possible if an archived log is missing.
  • D. It is performed automatically while the database remains in mount state. Then the database is opened.
  • E. Setting fast_start_mttr_target to a lower value reduces instance recovery time by causing dirty buffers to be written to disk more frequently, thereby reducing the number of I/Os needed during instance recovery.
  • F. Setting fast_start_mttr_target to a higher value reduces instance recovery time by causing the log writer to write more frequently, thereby reducing the number of I/Os needed during instance recovery.

正解：A、C


質問 # 115
Which two are true about server-generated alerts? (Choose two.)

  • A. Stateless alerts can be purged manually from the alert history.
  • B. Stateful alerts must be created by a DBA after resolving the problem.
  • C. Stateful alerts are purged automatically from the alert history.
  • D. Stateless alerts can be cleared manually.
  • E. Stateless alerts are automatically cleared.

正解：B、D


質問 # 116
Which three are true about Optimizer Statistics Advisor? (Choose three.)

  • A. It can be run only manually.
  • B. It can recommend changes to improve the statistics gathering process.
  • C. It runs automatically every night by default.
  • D. It is part of the DBMS_ADVISORpackage.
  • E. It always analyzes all schemas in the database.
  • F. It is part of the DBMS_STATSpackage.

正解：B、E、F

解説：
Explanation/Reference: https://oracle-base.com/articles/12c/optimizer-statistics-advisor-12cr2


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

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

正解：A、D、E

解説：
Explanation/Reference: https://books.google.com.pk/books?id=DeQkU5E75DUC&pg=PA869&lpg=PA869&dq=By+default,
+AWR+snapshots+are+automatically+purged+after+eight
+days&source=bl&ots=DfoGmJfCMy&sig=ACfU3U0Pf2RgIs72LUV4HUzs5UIXI8sXEQ&hl=en&sa=X&ved=2ah UKEwjb8bKhu9noAhUwTxUIHRpYAuMQ6AEwA3oECAsQLA#v=onepage&q=By%20default%2C%20AWR%
20snapshots%20are%20automatically%20purged%20after%20eight%20days&f=false


質問 # 118
Which three are true about managing memory components in an Oracle database instance?

  • A. Automatic Memory Management must be used together with locking the System Global Area into physical memory.
  • B. With Automatic Shared Memory Management, the database instance can increase the Program Global Area size by reducing the System Global Area size.
  • C. With Automatic Shared Memory Management, the database instance can increase the Large Pool size by reducing the Shared Pool size.
  • 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. Automatically tuned and resized System Global Area components will always revert to their initial sizes after an instance restart.

正解：B、C、F


質問 # 119
Which three are true about monitoring waits for sessions and services? (Choose three.)

  • A. V$SERVICE_EVENT displays all waits for all services if the wait has occurred at least once for a service.
  • B. V$SESSION_EVENT displays all waits for all past and existing sessions if the wait has occurred at least once for a session.
  • C. V$SESSION_WAIT_CLASS displays waits broken down by wait class only for waiting sessions.
  • D. V$SESSION_EVENT displays all waits for all past sessions if the wait has occurred at least once for a session.
  • E. V$SESSION_WAIT and V$SESSION both contain details of the event on which a session is currently waiting.
  • F. V$SESSION_WAIT and V$SESSION both contain details of the event on which a non-waiting session last waited.

正解：A、E、F

解説：
A, E - False : V$SESSION_EVENT displays information on waits for an event by a session.
V$SESSION_WAIT_HISTORY displays the last 10 wait events for each active session.
B - V$SERVICE_EVENT displays aggregated wait counts and wait times for each wait statistic.
C - False : V$SESSION_WAIT_CLASS displays the time spent in various wait event operations on a per-session basis.
D, F - True : V$SESSION_WAIT displays the current or last wait for each session.
V$SESSION.EVENT If the session is currently waiting, then the resource or event for which the session is waiting. If the session is not in a wait, then the resource or event for which the session most recently waited.
Resource :
https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/V-
SESSION_EVENT.html#GUID-5723D404-83F7-4C8D-8BF2-031B3FFEAAA8


質問 # 120
Which three are true about an application container?

  • A. It can contain a single application.
  • B. It must have an application seed PDB.
  • C. An application PDB can belong to multiple application containers.
  • D. Two application containers can share an application seed PDB.
  • E. It can contain multiple applications.
  • F. It must have an application root PDB.

正解：A、D、E


質問 # 121
In one of your databases, unified auditing is enabled and an SH.SALES table exists. You successfully execute these commands:
SQL> CREATE AUDIT POLICY sales_pol ACTIONS select on sh.sales;
SQL> AUDIT POLICY sales_pol;
Which statement is true about SALES_POL?

  • A. Only successful queries of SH.SALES are written to the audit trail.
  • B. It is only enabled for user SH.
  • C. Audit records are always stored in an external audit file.
  • D. It is enabled for all users having SELECT privilege on SH.SALES.

正解：D


質問 # 122
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 the SYNC operation is not allowed when constraints are added to common objects.
  • B. SAL will be added to APP_PDB1.EMP, with NULLs in columns of existing rows.
  • C. It will return an error because EMP.SAL is empty in APP_ROOT.
  • D. It will return an error because EMP is not empty in APP_ROOT.
  • E. SAL will be added to APP_PDB1.EMP, with 0 in columns of existing rows.

正解：D


質問 # 123
Examine the description of the SALES table:

Examine this statement:
CREATE TABLE mysales (prod_id, cust_id, quantity_sold, price)
AS
SELECT product_id, customer_id, quantity_sold, price
FROM sales
WHERE 1 = 2;
Which two statements are true?

  • A. MYSALES will have no constraints defined regardless of which constraints might be de-fined on SALES.
  • B. MYSALES has NOT NULL constraints on any selected columns which had that constraint in the SALES table.
  • C. MYSALES is created with no rows.
  • D. MYSALES is created with 2 rows.
  • E. MYSALES is created with 1 row.

正解：B、C


質問 # 124
Which two are true about the SQL Tuning Advisor?

  • A. It prevents performance regressions for SQL statements when changes are made.
  • B. It only recommends syntactic changes to SQL statements.
  • C. It can recommend semantic changes to SQL statements.
  • D. It considers all SQL statements being analyzed by the advisor task as a group.
  • E. It checks each query being analyzed for missing or stale statistics.

正解：C、E


質問 # 125
You have configured RMAN SBT channels to write backups to media.
You then take an RMAN backup by using this command:

Which three are true? (Choose three.)

  • A. The SPFILE is included in the self-contaied archival backup.
  • B. The restore point is a label for the system change number (SCN) that will be saved two years after the archival backup was taken.
  • C. All archive logs created after this backup are kept for two years.
  • D. The data file backups in the self-contained archive backup are not considered obsolete for two years regardless of the retention policy.
  • E. The control file is included in the self-contained archival backup.
  • F. The restore point is a label for the system change number (SCN) before the archival backup was taken.

正解：A、C、E


質問 # 126
Your container database, CDB1, is in local undo mode.
You successfully execute this command while connected to CDB1:
CREATE PLUGGABLE DATABASE pdb1
ADMIN USER pdb1_admin IDENTIFIED BY pdb123 ROLES=(CONNECT)
CREATE_FILE_DEST='/u01/app/oracle/oradata/cdb1/pdb1';
Which three are true about PDB1? (Choose three.)

  • A. It has the same number of roles as CDB1.
  • B. Service PDB1 is created for remote logins to PDB1.
  • C. It is in mount state after creation.
  • D. It has no local users.
  • E. It has only local roles.
  • F. It has the same common users defined as does CDB1.

正解：A、B、C

解説：
You cant create local roles in CDB, only common, so always you will have the same number of roles when you create a pdb, all common roles that you have in CDB.


質問 # 127
Which two are true about Oracle Flashback features? (Choose two.)

  • A. After a database is restored from flashback logs using the FLASHBACK DATABASE command, it is sometimes rolled forward using redo logs.
  • B. FLASHBACK DROP can undrop an index when undropping a table.
  • C. FLASHBACK QUERY can retrieve REDO records from ONLINE and ARCHIVED REDO LOG files.
  • D. FLASHBACK TABLE can undrop a column.
  • E. FLASHBACK VERSION QUERY can retrieve REDO records from ONLINE and ARCHIVED REDO LOG files.

正解：A、B


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

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

正解：B、F

解説：
Reference:
https://docs.oracle.com/en/database/oracle/oracle-database/18/multi/administering-pdb- snapshots.html#GUID-35B03C37-00BA-4945-BF20-9A7C4C541955


質問 # 129
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:
What is the outcome?

  • A. It fails because PDB2 is not in UPGRADE state.
  • B. CDB$ROOT, PDB$SEED, PDB1, and PDB2 are upgraded.
  • C. Only CDB$ROOT, PDB$SEED, and PDB2 are upgraded.
  • D. Only CDB$ROOT, PDB$SEED, and PDB1 are upgraded.
  • E. Only CDB$ROOT and PDB$SEED are upgraded.
  • F. It fails because PDB$SEED is in MIGRATE state.

正解：E


質問 # 130
Which two are true about creating RMAN backups for an Oracle container database? (Choose two.)

  • A. Control file backups can be created while connected to the root container.
  • B. Control file backups can be created while connected to a nonroot container.
  • C. Online Redo Log backups can be created while connected to the root container.
  • D. Archived Redo Log backups can be created while connected to an application root CDB.
  • E. The BACKUP TABLESPACE command can back up a PDB tablespace even if RMAN is connected to CDB$ROOT.

正解：B、D


質問 # 131
......


Oracle 1Z1-083試験に合格すると、候補者はOracle Certified Professional Database Administrator認定を受け取ります。この認定は、Oracleデータベース管理における卓越性の標準として、グローバルに認められています。この認定によって、候補者のスキルと知識がOracleデータベースの管理と保守において証明され、分野の新しいキャリア機会が広がります。

 

更新されたのはOracle 1Z1-083問題集PDFオンラインエンジン：https://www.passtest.jp/Oracle/1Z1-083-shiken.html

PDF試験材料は2024年最新の実際に出る1Z1-083問題集：https://drive.google.com/open?id=1XA5bSjudHMQPeMqX5OTWKyOOFahFwC54

関するブログ

もっと
1Z1-083 無料問題集