PDF問題（2023年最新）実際のOracle 1Z1-083試験問題 [Q29-Q47]

PDF問題（2023年最新）実際のOracle 1Z1-083試験問題

問題集返金保証付きの1Z1-083問題集には90%オフされます

質問 # 29
Choose three. Which three are true about Oracle Restart?

A. If you shut down a database instance with SQL*Plus, Oracle Restart interprets this as a database failure and attempts to restart the instance.
B. It is used in both clustered and non-clustered environments.
C. You can add and remove components from an Oracle Restart configuration with Server Control (SRVCTL) commands.
D. It runs from the Oracle Grid Infrastructure home.
E. The Server Control (SRVCTL) utility can be used to start and stop Oracle Restart.
F. It can manage Oracle Database instances, Oracle Net Listeners, and Oracle Automatic Storage Management instances.

正解：B、C、F

質問 # 30
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 17th of August
B. all backups prior to 20th of August
C. all backups prior to 22nd of August
D. all backups prior to 24th of August
E. all backups prior to 10th of August

正解：D

質問 # 31
Choose three. Which three are true about using an RMAN Recovery Catalog with a pluggable database (PDB) target connection in Oracle Database 19c and later releases?

A. The target PDB must be registered in a Virtual Private Catalog.
B. The target PDB must be registered in a base catalog.
C. The base catalog must be used by RMAN when performing point-in-time recovery for the PDB registered in the Virtual Private Catalog.
D. The base catalog owner must give the Virtual Private Catalog access to metadata for one or more PDBs.
E. The target PDB must be registered in both the base catalog and the Virtual Private Catalog.
F. The base catalog must be enabled for Virtual Private Catalog use.

正解：A、C、D

質問 # 32
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 TABLE can undrop a column.
D. FLASHBACK QUERY can retrieve REDO records from ONLINE and ARCHIVED REDO LOG files.
E. FLASHBACK VERSION QUERY can retrieve REDO records from ONLINE and ARCHIVED REDO LOG files.

正解：D、E

質問 # 33
Which two are true about Rapid Home Provisioning (RHP), which has been available since Orcale 18c?
(Choose two.)

A. It can be used to provision applications.
B. It cannot be used to upgrade Oracle Database homes.
C. It is an Oracle Database service
D. It can be used to patch Grid Infrastructure homes containing Oracle Restart.
E. It can be used to provision middleware.

正解：A、E

質問 # 34
Choose two. Which two are true about RMAN backups when using a media manager?

A. A media manager is required to create RMAN image copies.
B. By default, a request for a proxy copy may result in a backup set being created.
C. A media manager always writes RMAN requested backups to tape.
D. A media manager is required to create RMAN proxy copies.
E. The media manager layer (MML) routines provided by Oracle support any vendors' media management products.

正解：C、E

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

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

正解：D、E

質問 # 36
Choose the best answer. A schema owner truncated a table in error and must recover the dat a. Which Oracle Flashback feature could be used to recover the data?

A. FLASHBACK DATABASE
B. FLASHBACK DATA ARCHIVE
C. FLASHBACK VERSION QUERY
D. FLASHBACK TRANSACTION
E. FLASHBACK TABLE

正解：B

質問 # 37
The USERS tablespace consists of data files 3 and 4 and must always be online in read/write mode.
Which two are true about using RMAN to perform an open database back up of this tablespace? (Choose two.)

A. Only consistent backups can be created.
B. Backups must be contained in backup sets.
C. Backups must be done incrementally.
D. Backups can be taken only if the database is in ARCHIVELOG mode.
E. The database must be registered in an RMAN catalog.
F. Backups can be done incrementally.

正解：D、F

質問 # 38
Choose two. Which two are true about reclaiming space used by Flashback logs in Oracle Database 19c and later releases?

A. Space is always reclaimed automatically when the retention period for Flashback logs is lowered.
B. Space is always reclaimed proactively before space pressure occurs.
C. Space might be reclaimed automatically when the retention period for Flashback logs is lowered.
D. Space might be reclaimed proactively before space pressure occurs.
E. Space is only reclaimed when there is space pressure in the Fast Recovery Area (FRA).

正解：D、E

質問 # 39
Which two are true about diagnosing Oracle Database failure situations using Data Recovery Advisor?
(Choose two.)

A. A failure can be closed only when it has been repaired.
B. Data Recovery Advisor can be used if a database is closed.
C. Data Recovery Advisor can proactively check for failures.
D. The Data Recovery Advisor CHANGE FAILUREcommand can be used only to change failure priorities.
E. Using the Data Recovery Advisor LIST FAILUREcommand always requires that the database for which failures are to be listed is in MOUNTstate.

正解：C、D

解説：
Explanation/Reference:

質問 # 40
Which three are true about the SQL Tuning Advisor? (Choose three.)

A. It can recommend semantic changes to SQL statements.
B. It builds SQL profiles for each poorly performing SQL statement to prevent regressions.
C. It only recommends syntactic changes to SQL statements.
D. It checks each query being analyzed for stale statistics.
E. It considers all SQL statements being analyzed by the advisor task as a group.
F. It checks each query being analyzed for missing statistics.

正解：B、D、F

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

A. SPFILEbackups can be created while connected to an application root PDB.
B. The BACKUP DATABASEcommand will create a pluggable database (PDB) backup when RMAN is connected to a PDB.
C. The BACKUP DATABASE PLUS ARCHIVELOGcommand will back up archive logs when RMAN is connected to a PDB.
D. Tablespaces from different PDBs with identical names must be backed up by connecting RMAN separately to each PDB to back up the tablespaces.
E. The BACKUP PLUGGABLE DATABASEcommand can be used to back up CDB$ROOT.

正解：B、D

質問 # 42
Choose three. Which three actions will add a resource to an Oracle Restart configuration?

A. creating a disk group using the CREATE DISKGROUP SQL statement
B. creating an Oracle Database service by modifying the SERVICE_NAMES parameter
C. creating a database service using Oracle Database Configuration Assistant (DBCA)
D. creating a database service using DBMS_SERVICE.CREATE_SERVICE
E. creating an Oracle Automatic Storage Management (ASM) instance with ASM Configuration Assistant (ASMCA)
F. creating a database using the CREATE DATABASE SQL statement

正解：A、C、E

質問 # 43
Examine this configuration:
* CDB1 is an Oracle Database 12c Release 2 database containing pluggable databases PDB$SEED, PDB1, and PDB2.
* PDB$SEED is open READ ONLY
* PDB1 is open READ WRITE
* PDB2 is MOUNTED.
* ORACLE_HOME is /u01/app/oracle/product/18.1.0/dbhome_1.
You execute these commands before upgrading the database to the current release:

For which databases will fixup scripts be created?

A. CDB1, PDB$SEED, and PDB1 only
B. CDB1 and PDB$SEED only
C. CDB1, PDB$SEED, PDB1, and PDB2
D. PDB$SEED, PDB1, and PDB2 only
E. CDB1, PDB1, and PDB2 only

正解：A

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

A. Online Redo Log backups can be created while connected to the root container.
B. Control file backups can be created while connected to the root container.
C. Control file backups can be created while connected to a nonroot 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.

正解：C、D

質問 # 45
Which three are true about Automatic Workload Repository (AWR)? (Choose three.)

A. The taking of AWR snapshots can be disabled.
B. AWR data is stored in the SYSTEMtablespace.
C. By default, AWR snapshots are retained for 7 days.
D. By default, AWR snapshots are taken every 60 minutes.
E. Its collection level is determined by the value of the STATISTICS_LEVELdatabase parameter.

正解：A、D、E

解説：
Explanation/Reference: https://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams240.htm#REFRN10214

質問 # 46
Which two are true about Rapid Home Provisioning (RHP), which has been available since Orcale 18c?
(Choose two.)

A. It can be used to patch Grid Infrastructure homes containing Oracle Restart.
B. It cannot be used to upgrade Oracle Database homes.
C. It is an Oracle Database service
D. It can be used to provision applications.
E. It can be used to provision middleware.

正解：A、E

質問 # 47
......

更新された2023年11月合格させる1Z1-083試験リアル練習テスト問題：https://www.passtest.jp/Oracle/1Z1-083-shiken.html

あなたを合格させる試験には100%確認済み1Z1-083試験問題：https://drive.google.com/open?id=13CrT80KvWQX0wsUoDCnjeNDZp6FVcsD-

関するブログ

もっと

1Z1-083 無料問題集