Oracle 1Z1-083リアルに2024年最新のブレーン問題集で模擬試験問題集
1Z1-083試験問題 リアルな1Z1-083練習問題集
質問 # 118
Which three tasks can be automatically performed by the Automatic Data Optimization feature of Information lifecycle Management (ILM)?
- A. Tracking the most recent write time for a table segment in the SYSAUX tablespace Correct
- B. Tracking the most recent read time for a table segment in a user tablespace
- C. Tracking the most recent write time for a table block
- D. Tracking the most recent read time for a table segment in the SYSTEM tablespace
- E. Tracking insert time by row for table rows
- F. Tracking the most recent write time for a table segment in a user tablespace
正解：B、E、F
質問 # 119
Which two are true about an Oracle gold image-based installation in Oracle 18c and later releases? (Choose two.)
- A. It can be used to install and upgrade Oracle Database for single-instance and cluster configurations.
- B. It does not require the setup wizard.
- C. It can be used for both Oracle Database and Oracle Grid Infrastructure installation.
- D. It uses a single RPM that automatically extracts and installs the Oracle Database software.
- E. It can only install and configure Oracle Database software. The database has to be created separately.
正解：A、C
解説：
Using image-based installation, you can install and upgrade Oracle Database for single-instance and cluster configurations.
https://docs.oracle.com/en/database/oracle/oracle-database/21/upgrd/image-based-oracle- database-installations.html#GUID-0315AA15-1C03-4E96-B801-3A8E5F5D4B39
質問 # 120
Examine this output:
Which two are true? (Choose two.)
- A. Any PDB not specified in the plan will be unable to execute statements in parallel.
- B. PDB2 is guaranteed at least 25% of the available parallel execution processes if there is enough demand.
- C. Any PDB not specified in the plan will be able to use a maximum of 16.5% of the available system resources.
- D. PDB3 can use all available parallel execution processes at times.
- E. PDB1 is always limited to 40% of the available system resources regardless of demand.
- F. PDB3 is guaranteed to receive at least 20% of the available system resources if there is enough demand.
正解：A、D
解説：
A). Correct as then a PDB will get assigned the default directive with parallel_server_limit set to 0
B). Correct as parallel_server_limit is not specified for PDB3 and it defaults to 100 Quote:
https://docs.oracle.com/database/121/ADMIN/dbrm.htm#ADMIN14008
"If PARALLEL_SERVER_LIMIT is not specified, then it defaults to 100%."
C). Incorrect. A PDB can use more resources:
Quote from
https://docs.oracle.com/database/121/ADMIN/cdb_dbrm.htm#ADMIN13777
"However, any PDB can use more than the guaranteed amount of a resource if there is no resource contention."
D). Incorrect. Shares is a minimum guaranteed value. But a PDB can use more as explained above in C.
E). Incorrect. Nothing confirms that there are only 3 PDBs attached. There may be others using the default pdb directive. Then the share for PDB2 is not 20%
F). Incorrect. parallel_server_limit is an upper limit.
質問 # 121
Which three true about recovering tables using RMAN? (Choose three.)
- A. RMAN can recover tables in a standby database.
- B. RMAN can recover tables in the SYSTEM tablespace.
- C. RMAN always uses an auxiliary instance.
- D. RMAN can recover tables owned by the SYS user.
- E. RMAN can recover a table after a DDL operation has altered the table structure.
- F. RMAN can recover tables in the SYSAUX tablespace.
- G. RMAN can recover tables owed by the SYSTEM user.
正解：B、C、F
質問 # 122
Choose the best answer. How do you configure a CDB for local undo mode?
- A. Open the CDB instance in upgrade mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON, and then restart the CDB instance.
- B. Open the CDB instance in restricted mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON. create an UNDO tablespace in each PDB, and then restart the CDB instance.
- C. Open the CDB instance in restricted mode. In CDB$ROOT, drop the UNDO tablespace. Execute ALTER DATABASE LOCAL UNDO ON in each PDB, and then restart the CDB instance.
- D. Open the CDB instance in upgrade mode. In each PDB, execute ALTER DATABASE LOCAL UNDO ON, create an UNDO tablespace, and then restart the CDB instance.
- E. Open the CDB in read-only mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON, and then change the CDB to read/write mode.
正解：A
質問 # 123
A user complains about poor database performance.
You want to verify if the user's session has waited for certain types of I/O activity.
Which view displays all waits waited on by a session at least once?
- A. V$SESSION_WAIT
- B. VSSESSION_WAIT_CLASS
- C. VSSESSION
- D. VSSESSTAT
- E. VSSESSION_EVENT
正解：A
質問 # 124
You enable Flashback Data Archive for a table for which you want to track and save all transactions for four years. After some time, the requirement changes for keeping transactions from four to two years. You execute the following command to change the requirement:
SQL> ALTER FLASHBACK ARCHIVE fdal MODIFY RETENTION 2 YEAR;
What is the outcome?
- A. All historical data older than two years, if any, is archived to flashback logs and the flashback archive is set to new retention time.
- B. An error is returned because the retention period cannot be reduced.
- C. All historical data older than two years, if any, is purged from the flashback archive FDA1.
- D. All the flashback data archives are purged and the subsequently created flashback archives are maintained for two years
正解：C
質問 # 125
Which two are true about poorly performing SQL statements and their tuning in Oracle database instances?
(Choose two.)
- A. SQL statements doing only logical reads never require tuning because they do no physical I/O.
- B. The solution that best optimizes one SQL statement can degrade the performance of others.
- C. SQL statements doing joins always do more physical I/O than single table queries.
- D. SQL statements performing many physical I/Os can always have their performance improved by creating indexes.
- E. Poorly performing SQL statements can be tuned automatically by the Oracle server.
正解：A、E
質問 # 126
In a recent Automatic Workload Repository (AWR) report for your database, you notice a high number of buffer busy waits. The database consists of locally managed tablespaces with free list managed segments. On further investigation, you f ind that buffer busy waits is caused by contention on data blocks. Which option would you consider first to decrease the wait event immediately?
- A. Decreasing PCTUSED
- B. Decreasing PCTFREE
- C. Increasing the number of DBWN process
- D. Increasing db_buffer_cache based on t he V$DB_CACHE_ADVICE recommendation
- E. Using Automatic Segment Space Management (ASSM)
正解：E
質問 # 127
A container database (CDB) contains two pluggable databases PDB1 and PDB2.
The local_undo_enabled database property is set to false in the CDB.
Data file 24 of PDB2 was deleted and you need to restore and recover it.
The only RMAN backup that exists was created with the backup database command while connected to CDB$ROOT.
Which three are true?
- A. Data file 24 can be recovered while connected to PDB2.
- B. Data file 24 can be restored only while connected to CDB$ROOT.
- C. Data file 24 can be restored only while connected to PDB2.
- D. Data file 24 can be recovered while connected to CDB$ROOT.
- E. Data file 24 can be recovered only while connected to PDB2.
- F. Data file 24 can be restored and recovered while connected to CDB$ROOT.
正解：A、D、F
質問 # 128
Which three can be done using Oracle Database Configuration Assistant (DBCA) starting from Oracle Database 19c? (Choose three.)
- A. relocating a remote container database in interactive mode
- B. relocating a remote pluggable database in interactive mode
- C. relocating a remote container database in silent mode
- D. cloning a remote container database in interactive mode
- E. cloning a remote pluggable database in silent mode
- F. cloning a remote container database in silent mode
- G. relocating a remote pluggable database in silent mode
正解：E、F、G
解説：
Reference:
https://docs.oracle.com/en/database/oracle/oracle-database/19/clone-pdbs-using-dbca-silent- mode/index.html? learningpath=true&appuser=nobody&appsession=170971049395&contentid=26693&activityname=Clone% 20PDBs%20using%20DBCA%20in%20Silent%20Mode&eventid=6352
質問 # 129
Choose two. 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: SELECT containers_default, container_map, table_name FROM dba_tables WHERE owner='FIN' ; CONTAINERS_DEFAULT CONTAINER_MAP CONTAINER_MAP_OBJECT TABLE_NAME -------------------------------------------------------------------------------------------------------------------------------NO YES NO REVENUE NO NO YES MAPTABLE Which two are true?
- A. The REVENUE table must be a composite-partitioned table.
- B. The CONTAINERS clause cannot be used in queries on the REVENUE table.
- C. The REVENUE table must be a list-partitioned table.
- D. The MAPTABLE table defines a logical partition key on a commonly used column for the REVENUE table.
- E. The REVENUE table partitions are not pruned across the PDBs automatically.
正解：A、E
質問 # 130
Examine these queries and their output: After a system crash, an instance restart and an attempted opening of the PDBs result in: Which two are true? (Choose two.)
- A. Data file 24 must be recovered while the CDB is opened.
- B. Data file 24 must be recovered while PDB2 is closed.
- C. Data file 24 can be recovered while CDB$ROOT and PDB$SEED are opened.
- D. Data file 24 cannot be recovered while the CDB is opened.
- E. Data file 24 can be recovered while PDB2 is opened.
正解：C、E
質問 # 131
What is the effect of specifying the "ENABLE PLUGGABLE DATABASE" clause in a "CREATE DATABASE" statement?
- A. ItwillcreateaCDBwithrootopenedandseedmounted.
- B. It will create a CDB that must be plugged into an existing CDB.
- C. It will create a multitenant container database (CDB) with only the root opened.
- D. It will create a CDB with root and seed opened and one PDB mounted.
- E. ItwillcreateaCDBwithrootopenedandseedreadonly.
正解：E
質問 # 132
Which two are true about changing the LOCAL_UNDO_ENABLED property to false in a CDB? (Choose two.)
- A. After the change, each existing PDB has to be reopened for the new undo mode to take effect.
- B. Undo tablespaces existing in PDBs must be dropped before the change.
- C. Any new PDB and existing PDBs are automatically configured to use the default undo tablespace in CDB$ROOT.
- D. After the change, any user with the required privilege can create an undo tablespace in the PDBs.
- E. After the change, only a common user with the required privilege can create an undo tablespace in CDB&ROOT.
- F. After the change, only one undo tablespace can exist in CDB$ROOT.
正解：D、E
質問 # 133
Which three are true about unified auditing in full mode?
- A. Audit records are created for non-sys users.
- B. The unified audit trail is written to a read-only table.
- C. Audit records are created for SYS.
- D. The unified audit trail is written to a read-only external file.
- E. Audit records are created for COMMIT, ROLLBACK, and SAVEPOINT statements.
正解：A、B、C
質問 # 134
Choose three. 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 logically corrupt.
- C. If a row lock is held by a nonexistent transaction, the block containing the row is media corrupt.
- D. DB_LOST_WRITE_PROTECT=TYPICAL causes extra logging overhead on the standby database.
- E. A media corrupt block is one where the block is not formatted correctly.
- F. The ANALYZE TABLE VALIDATE STRUCTURE CASCADE command verifies that each table row has an index entry pointing to it.
正解：B、D、F
質問 # 135
In performance management, which two factors might reduce the ability of an application to scale to a large number of users? (Choose two.)
- A. issuing multiple savepoints during a transaction
- B. poorly trained users who do not commit transactions
- C. poorly written SQL
- D. the number of tablespaces containing tables updated by a transaction
- E. the number of data files containing extents belonging to tables updated by a transaction
正解：B、C
解説：
About Concurrency and Scalability
The better your application handles concurrency, the more scalable it is.
Concurrency is the simultaneous execution of multiple transactions. Statements within concurrent transactions can update the same data. Concurrent transactions must produce meaningful and consistent results. Therefore, a multiuser database must provide the following:
Data concurrency , which ensures that users can access data at the same time.
Data consistency, which ensures that each user sees a consistent view of the data, including visible changes from his or her own transactions and committed transactions of other users
質問 # 136
......
厳密検証された1Z1-083試験問題集と解答で無料提供の1Z1-083問題と正解付き：https://jp.fast2test.com/1Z1-083-premium-file.html