1Z1-083 試験問題を無料オンラインアクセス

Which two are true about an RPM-based Oracle Database installation? (Choose two.)

• A.It performs a software-only Oracle Database installation.
• B.From Oracle Database 18c, a single RPM can be used to install only Oracle Database Server for a single instance.
• C.It includes the Oracle Preinstallation RPM.
• D.It uses a service configuration script to create a single-instance database as part of the installation.
• E.It requires an Unbreakable Linux Network (ULN) subscription.

Which three true about recovering tables using RMAN? (Choose three.)

• A.RMAN can recover tables owned by the SYS user.
• B.RMAN can recover tables in the SYSAUX tablespace.
• C.RMAN can recover tables owed by the SYSTEM user.
• D.RMAN can recover tables in the SYSTEM tablespace.
• E.RMAN can recover tables in a standby database.
• F.RMAN can recover a table after a DDL operation has altered the table structure.
• G.RMAN always uses an auxiliary instance.

In your Database, the TBS PERCENT USED parameter is set to 60 and the TBS PERCENT FREE parameter is set to 20. Which two storage-tiering actions might be automated when using information Lifecycle Management (ILM) to automate data movement?

• A.The movement of some blocks to a target tablespace with a lower degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED Correct
• B.Settingthetargettablespacetoread-only
• C.The movement of all segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED
• D.Setting the target tablespace offline
• E.The movement of some segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED

Examine this configuration:
1. CDB1is a container database.
2. PDB1and PDB2 are pluggable databases in CDB1.
You execute these commands successfully:

Which two are true? (Choose two.)

• A.CDB$ROOT is in MOUNT state.
• B.Redo logs are opened.
• C.PDB$SEED is in READ ONLY state.
• D.PDB1 and PDB2 are in READ ONLY state.
• E.PDB1 and PDB2 are in MOUNT state.

While backing up to the Oracle Fast Recovery Area (FRA), you determined the backup is taking too long and suspect a performance bottleneck.
Which three are true about diagnosing and tuning these problems? (Choose three.)

• A.Data files with a high value in V$BACKUP_ASYNC_IO.SHORT_WAITSare a potential performance bottleneck when asynchronous I/O is used.
• B.If an RMAN BACKUP VALIDATEcommand takes noticeably less than an actual backup, then write I/O is a likely bottleneck.
• C.Data files with a high value in V$BACKUP_SYNC_IO.DISCRETE_BYTES_PER_SECONDare a potential performance bottleneck when synchronous I/O is used.
• D.If an RMAN BACKUP VALIDATEcommand takes roughly the same time as an actual backup, then both read and write I/O are likely bottlenecks.
• E.If an RMAN BACKUP VALIDATEcommand takes roughly the same time as an actual backup, then read I/O is a likely bottleneck.
• F.Setting DBWR_IO_SLAVESto a non zero value can improve backup performance when using asynchronous I/O/
• G.Setting DBWR_IO_SLAVESto a non zero value can improve backup performance when using synchronous I/O.