• ホーム
  • ブログ
  • [2022年09月] 学習材料には有効な1Z1-083効率的問題集！ [Q53-Q68]

[2022年09月] 学習材料には有効な1Z1-083効率的問題集！ [Q53-Q68]

Share

[2022年09月] 学習材料には有効な1Z1-083効率的問題集！

最新の1Z1-083テストエンジンPDF無料問題集保証！


Oracle 1Z1-083 認定試験の出題範囲：

トピック出題範囲
トピック 1
  • RMANバックアップの圧縮と暗号化
  • PDBの構造の調査
  • データベース以外のファイルのバックアップ
トピック 2
  • パフォーマンスチューニング方法論の理解と使用
  • アプリケーションルートとアプリケーションシードの目的を説明する
トピック 3
  • アプリケーションPDBの定義と作成
  • フラッシュバックをサポートするようにデータベースを構成する
  • フラッシュバック操作を実行する
トピック 4
  • 非常に大きなファイルのマルチセクションバックアップの作成
  • アプリケーションPDBSの作成と管理
  • データベースとデータベースブロックの破損の検出と修復

 

質問 53
Choose three. Which three are true about upgrading an application in an application container?

  • A. An application root clone gets created automatically.
  • B. After an application upgrade, the application container's PDBs remain synchronized with the existing application root.
  • C. An application name and version number must be specified to upgrade the application.
  • D. The upgrade can be performed when connected either to CDB$ROOT or to PDB$SEED.
  • E. The upgrade must be performed when connected to CDB$ROOT.
  • F. After an application upgrade, the application container's PDBs are automatically synchronized with the application root clone.

正解: A,C,F

 

質問 54
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. creating the oracle OS user
  • B. configuring the OS for Oracle Automatic Storage Management shared storage access
  • C. creating the OSDBA (dba) group
  • D. performing checks to ensure minimum configuration requirements for Oracle Grid Infrastructure are met
  • E. creating thte oraInventory (oinstall) group
  • F. creating the grid OS user

正解: B,C,E

 

質問 55
Choose two. Which two are true about RMAN Multisection backups when a very large data file is divided into four sections?

  • A. Each of the file sections must be processed serially.
  • B. The four sections can be created in parallel.
  • C. The four sections can be created serially.
  • D. The four sections must be contained in backup sets.
  • E. The four sections must be image copies.

正解: B,D

 

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

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

正解: B,D

 

質問 57
Which two are true about Oracle Database Configuration Assistant (DBCA)? (Choose two.)

  • A. It can be launched from both the command line and the Universal Installer (OUI) interfaces.
  • B. It can be used to create container databases and non-container databases.
  • C. It can only be launched from the command line interface.
  • D. It can be used to convert a non-container database to a container database.
  • E. It can be used to change the character set of an existing database.

正解: C,E

 

質問 58
Examine this output:

Which two are true? (Choose two.)

  • A. PDB1 is always limited to 40% of the available system resources regardless of demand.
  • B. PDB3 can use all available parallel execution processes at times.
  • C. Any PDB not specified in the plan will be able to use a maximum of 16.5% of the available system resources.
  • D. Any PDB not specified in the plan will be unable to execute statements in parallel.
  • E. PDB3 is guaranteed to receive at least 20% of the available system resources if there is enough demand.
  • F. PDB2 is guaranteed at least 25% of the available parallel execution processes if there is enough demand.

正解: D,E

 

質問 59
Which three are true? (Choose three.)

  • A. Application-common OLS policies can be created in an application root inside an install/patch BEGIN-END block.
  • B. Fine-grained auditing (FGA) policies in an application root are automatically synchronized to all application PDBs contained in the application container.
  • C. Application-common TSDP policies are always container specific.
  • D. Unified auditing can be automatically synchronized to all application PDBs in an application container.
  • E. Application-common Transparent Security Data Protection (TSDP) policies can be created only within an application install/patch BEGIN-END block.
  • F. Virtual Private Database (VPD) policies on objects in an application root are automatically synchronized with all application PDBs contained in the application container.
  • G. Application-common Oracle Label Security (OLS) policies cannot be created in an application root outside an install/patch BEGIN-END block.

正解: C,D,G

 

質問 60
For which two requirements can you use the USER_TABLESPACE clause with the CREATE PLUGGABLE DATABASE command? (Choose two.)

  • A. to specify the list oftablespaces to include when creating a PDB from the CDB seed
  • B. to exclude all tablespaces except SYSTEM, SYSAUX, and TEMPwhen plugging in a PDB
  • C. to exclude a temp tablespace when plugging in a PDB
  • D. to specify the list of user tablespaces to include when moving a non-CDB to a PDB
  • E. to specify a default tablespace in a PDB cloned from another PDB in the same CDB.
  • F. to include specific user tablespaces only when relocating a PDB

正解: A,C

 

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

  • A. On Line Transaction Processing systems often use less Program Global Area than Decision Support Systems.
  • B. With Automatic Shared Memory Management, the database instance can increase the Large Pool size by reducing the Shared Pool 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. Automatically tuned and resized System Global Area components will always revert to their initial sizes after an instance restart.
  • F. With Automatic Memory Management, the database instance can increase the System Global Area size by reducing the Program Global Area size.

正解: A,B,C

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

 

質問 62
Which three are true about Database Point-in-Time Recovery? (Choose three.)

  • A. Thedatabase must be in MOUNT state when performing Database Point-in-Time Recovery.
  • B. The database must be open RESETLOGS after Database Point-in-Time Recovery.
  • C. The Database must be in ARCHIVELOG mode.
  • D. Database Point-in-Time Recovery is performed by the Managed Recovery Process (MRP)
  • E. The database must have FLASHBACK DATABASE ON to perform Database Point-in-Time Recovery.
  • F. The target point for the recovery must bespecified as a stime or System Change Number (SCN).

正解: B,D,E

 

質問 63
Your sales_root application container has two application PDBs.
The sales_app application has a common table, FIN.REVENUE, in the two PDBs.
Examine this query and its output:

Which two are true?

  • A. The maptable table is a metadata-linked table.
  • B. The revenue table partitions are not pruned across the PDBs automatically.
  • C. The revenue table must be a list-partitioned table.
  • D. The containers clause cannot be used in queries on the revenue table.
  • E. A container map exists for the revenue table, but Is not enabled.
  • F. The maptable table defines a logical partition key on a commonly used column for the revenue table.

正解: A,E

 

質問 64
Choose two. RMAN has just been connected to a target database and the recovery catalog database. In which two cases would an automatic full resynchronization occur between this target database's control file and the RMAN recovery catalog?

  • A. when control file metadata for data file backups or image copies has been overwritten in the target database's control file due to being older than CONTROL_FILE_RECORD_KEEP_TIME
  • B. when a new tablespace is added to a registered target database
  • C. when a backup of the current control file is created
  • D. when the target is first registered
  • E. when control file metadata for archive log backups or image copies has been overwritten in the target database's control file due to being older than CONTROL_FILE_RECORD_KEEP_TIME

正解: B,D

 

質問 65
choose two Examine these RMAN commands: RMAN> CONNECT TARGET "sbu@prod AS SYSBACKUP"; RMAN> CONNECT AUXILIARY "sbu@dup_db AS SYSBACKUP"; RMAN> DUPLICATE TARGET DATABASE TO dup_db FROM ACTIVE DATABASE PASSWORD FILE SECTION SIZE 400M; Which two statements are true about the DUPLICATE command?

  • A. No catalogued backup of the TARGET is used to duplicate the database.
  • B. It fails because no parallel channels are allocated for the auxiliary database.
  • C. It fails because connection to the AUXILIARY instance must be as SYSDBA.
  • D. It succeeds.
  • E. Itsucceeds only if the target database is greater than 400M.

正解: A,D

 

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

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

正解: A,C,F

解説:
Explanation
https://mikedietrichde.com/2017/08/22/oracle-optimizer-statistics-advisor-in-oracle-database-12-2-0-1/
https://www.oracle.com/technetwork/database/bi-datawarehousing/twp-bp-for-stats-gather-19c-5324205.pdf

 

質問 67
A container database called CDB1 is OMF-enabled.
PDB_FILE_NAME_CONVERT is not configured in CDB1. PDB1 was unplugged from CDB1 earlier in the week. Examine this command, which will be executed in CDB1:
CREATE PLUGGABLE DATABASE pdb1
USING '/u01/app/oracle/oradata/pdb1.xml'
SOURCE_FILE_NAME_CONVERT =
('/u01/app/oracle/oradata/', '/u02/app/oracle/oradata/');
Which two are true? (Choose two.)

  • A. PDB1 data files already exist in the correct location.
  • B. /u01/app/oracle/oradata/pdb1.xml does not contain the current locations of data files for PDB1.
  • C. PDB_FILE_NAME_CONVERT must be set before executing the command.
  • D. PDB1 must be dropped from CDB1.
  • E. DBMS_PDB.CHECK_PLUG_COMPATIBILITY must be run in CDB1 before executing the command.

正解: B,C

 

質問 68
......

1Z1-083問題集最新の練習テストと279独特な解答：https://www.passtest.jp/Oracle/1Z1-083-shiken.html

最新Oracle Database 19c 1Z1-083実際の無料試験解答：https://drive.google.com/open?id=1XA5bSjudHMQPeMqX5OTWKyOOFahFwC54

関するブログ

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