2022年最新のの問題Oracle Database 19cと1Z1-083リアル試験問をマスターせよ！
突破受験者のシミュレーションされた1Z1-083試験PDF問題を試そう
Oracle 1Z1-083 認定試験の出題範囲：
| トピック | 出題範囲 |
|---|---|
| トピック 1 |
|
| トピック 2 |
|
| トピック 3 |
|
| トピック 4 |
|
| トピック 5 |
|
質問 54
Choose two. Some archived log backups have been accidentally deleted from storage. Which two commands should be used to update the status of backups in the recovery catalog to display only the missing backups?
- A. LIST EXPIRED
- B. RESYNC CATALOG
- C. LIST ARCHIVELOG
- D. LIST ARCHIVELOG ALL
- E. CROSSCHECK BACKUP OF ARCHIVELOG ALL
- F. REPORT OBSOLETE
正解: A,E
質問 55
T schema owned by the RC12C user. The RCAT11 database contains an Oracle Database version 11g catalog schema owned by the RC11 user in which several databases are registered. Both the databases are open. You execute the RMAN commands: RMAN> CONNECT CATALOG rcl2c/passl2c@catdbl2c RMAN> IMPORT CATALOG rcll/pwdcatll@ractll Which two tasks are performed as part of the import?
- A. Imported databases are unregistered from the RC11 catalog.
- B. All databases registered in the RC11 catalog are registered in the RC12C catalog.
- C. Databases from the RC12C catalog are implicitly unregistered if the RC11 catalog has registered databases with same name.
- D. Recovery catalog is resynchronized with the control files of the registered databases.
- E. Local and global stored scripts that have the same name as existing scripts in the RC12C catalog are automatically renamed.
正解: B,E
質問 56
Which three are true about the FLASHBACK DATABASE feature? (Choose three.)
- A. FLASHBACK LOGS are archived after a log switch.
- B. It always generates REDO and UNDO.
- C. FLASHBACK DATABASE only uses FLASHBACK LOGS to get the database to the desired flashback time.
- D. A database can be flashed back using SQL*PLUS.
- E. It requires that the target database be in ARCHIVELOG mode.
- F. Queries and DML have the same FLASHBACK LOG overhead when flashback is enabled for a database.
正解: D,E,F
質問 57
1.Which two are prerequisites for creating a backup-based duplicate database?
- A. creating an SPFILE for the target database
- B. connecting to the target database and a recovery catalog to execute the duplicate command
- C. matching the database identifier (DBID) of the source database and the duplicate database
- D. connecting to an auxiliary instance
- E. creating a password file for an auxiliary instance
正解: D,E
質問 58
Which two are true about Oracle Database Configuration Assistant (DBCA) templates? (Choose two.)
- A. Oracle DBCA templates can store only logical structure and not database files.
- B. The General Purpose of Transaction Processing templates are most suitable when concurrency and recoverability are key criteria.
- C. Oracle DBCA templates can be used to create new databases and duplicate existing databases.
- D. The Data Warehouse template is most suitable when transaction response time is the key criterion.
- E. New templates can only be created by modifying an existing user-created template.
正解: B,C
解説:
Explanation/Reference: https://docs.oracle.com/database/121/ADMQS/GUID-2B8A3B5E-D319-4377-8B22-
8BB67DCC9885.htm#ADMQS0235
質問 59
Your production database is running in archivelog mode. You use RMAN with a recovery catalog to back up your database to media and the database is uniquely identified in the recovery catalog. You want to create a test database from the production database and allow the production database to remain open during the duplicate process. You restore the database backups to a new host with the same directory structure as the production database and want to use the recovery catalog for future backups after the database is successfully restored to the new host. How would you achieve this?
- A. by using the RMAN duplicate command with dbid and set new name for tablespace to recover the database to the new host
- B. by creating a new database in the new host, and then using the RMAN recover command
- C. by using the RMAN duplicate command with nofilenamecheck to recover the database to the new host
- D. by using the RMAN switch command to set the new location for the data files
正解: C
質問 60
Choose the best answer. 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 10th of August
- B. all backups prior to 20th of August
- C. all backups prior to 17th of August
- D. all backups prior to 22nd of August
- E. all backups prior to 24th of August
正解: C
質問 61
Choose two. A database is configured in ARCHIVELOG mode. A full RMAN backup exists but no control file backup to trace has been taken. A media failure has occurred. In which two scenarios is incomplete recovery required?
- A. after losing all members of the CURRENT online redo log group
- B. after losing all copies of the control file
- C. after losing a SYSAUX tablespace data file
- D. after losing all members of an INACTIVE online redo log group
- E. after losing an UNDO tablespace that is in use
正解: A,B
質問 62
Which three tasks can be automatically performed by the Automatic Data Optimization feature of Information lifecycle Management (ILM)?
- A. Tracking the most recent read time for a table segment in a user tablespace
- B. Tracking the most recent write time for a table segment in the SYSAUX tablespace Correct
- C. Tracking insert time by row for table rows
- D. Tracking the most recent write time for a table segment in a user tablespace
- E. Tracking the most recent read time for a table segment in the SYSTEM tablespace
- F. Tracking the most recent write time for a table block
正解: A,C,D
質問 63
Which two are true about OS groups and users for Oracle Grid Infrastructure and the Oracle Relational Database Management System (RDBMS)? (Choose two.)
- A. By default, members of the OSASM group can access Automatic Storage Management and RDBMS instances.
- B. The Oracle Grid Infrastructure owner must have OSOPER, OSBACKUPDBA, and OSKMDBA as secondary groups.
- C. The same OSDBA group must be used for Automatic Storage Management and the Oracle Database.
- D. The Oracle Grid Infrastructure owner owns Oracle Restart and Oracle Automatic Storage Management binaries.
- E. The Oracle Grid Infrastructure installation must be owned by the grid user.
- F. The primary group for the Oracle Grid Infrastructure and Oracle Database owners must be the Oracle Inventory group.
正解: B,C
解説:
Reference:
https://docs.oracle.com/database/121/CWWIN/usrgrps.htm#CWWIN-GUID-6FD3C6AE-5A99- 4C6D-85D6-868CBA6F5DAE
質問 64
Which two are true about common objects? (Choose two.)
- A. They can be created only in an application root.
- B. They can be only metadata-linked in an application container.
- C. They can be extended data-linked in CDB$ROOT.
- D. They can exist in CDB$ROOT and 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
質問 65
Choose two. Which two are true in Oracle 19c and later releases?
- A. All the Oracle-supplied accounts are Schema Only accounts.
- B. Schema Only accounts can be granted administrator privileges.
- C. Unified Auditing can be configured to audit only events that are issued indirectly by all users
- D. If the password file location changes, then the instance must be restarted.
- E. Unified Auditing can be configured to audit only events that are issued directly by an audited user.
正解: B,E
質問 66
Examine this configuration:
While CDB1 is open, '/u02/app/oracle/fast_recover_area/cdb1/CDB1/controlfile02.ctl' is accidentally deleted.
To recover from this critical failure, you execute these commands:
What will be the outcome?
- A. It will create '/u01/app/oralce/oradata/CDB1/controlfile/controlfile02.ctl'.
- B. It will create '$ORACLE_HOME/dbs/cdb1/CDB1/controlfile02.ctl'
- C. It will create '/u01/app/oracle/product/12.2.0.1/db_1/dbs/snapcf_cdb1control02.ctl'.
- D. It will fail because there is no autobackup of the controlfiles.
- E. It will re-create '/u02/app/oracle/fast_recover_area/cdb1/CDB1/controlfile02.ctl'
正解: E
質問 67
RMAN is connected to a target database instance and an auxilary instance. You execute 3625the command: RMAN> DUPLICATE TARGET DATABASE TO dupdb FROM ACTIVE DATABASE SECTION SIZE 1G; What is the outcome?
- A. RMAN uses the pull method to restore files using image copies
- B. RMAN uses the pull method to restore files using backup sets
- C. RMAN uses the push method to transfer image copies
- D. RMAN uses the push method to transfer backup sets
正解: B
質問 68
Choose three. Which three are true about actions that can or cannot be performed by users with the SYSBACKUP privilege?
- A. They can view data from any data dictionary view or dynamic performance
- B. They can create any table.
- C. They can drop any tablespace.
- D. They cannot drop tablespaces.
- E. They cannot create restore points.
- F. They can view data from any user-defined tables.
正解: A,B,C
質問 69
Which are three of the steps taken by Database Configuration Assistant (DBCA) to clone a remote pluggable database (PDB) starting from Oracle 19c?
- A. backing up the cloned PDB
- B. creating a database link from CDB$ROOT in the local database to the PDB in the remote system that is to be cloned
- C. leaving the cloned PDB in mount state
- D. creating a database link from CDB$ROOT in the local database to CDB$ROOT in the remote system that is to be cloned
- E. opening the cloned PDB
正解: D,E
質問 70
Which three are true about Optimizer Statistics Advisor? (Choose three.)
- A. It always analyzes all schemas in the database.
- B. It runs automatically every night by default.
- C. It can recommend changes to improve the statistics gathering process.
- D. It is part of the DBMS_ADVISOR package.
- E. It is part of the DBMS_STATS package.
- F. It can be run only manually.
正解: B,C,E
質問 71
......
突破受験者のシミュレーションされた1Z1-083問題集：https://www.passtest.jp/Oracle/1Z1-083-shiken.html
売上ナンバーワン試験参照問題：https://drive.google.com/open?id=1XA5bSjudHMQPeMqX5OTWKyOOFahFwC54