Oracle 1Z0-083模擬練習、1Z0-083出題内容PassTestはたくさんOracle関連1Z0-083認定試験の受験者に利便性を提供して、多くの人がPassTestの問題集を使うので試験に合格しますた。彼らはPassTestの問題集が有効なこと確認しました。PassTestが提供しておりますのは専門家チームの研究した1Z0-083問題と真題で弊社の高い名誉はたぶり信頼をうけられます。安心で弊社の商品を使うために無料なサンブルをダウンロードしてください。 Oracle Database Administration II 認定 1Z0-083 試験問題 (Q180-Q185):質問 # 180
Choose three. Which three are true about actions that can or cannot be performed by users with the SYSBACKUP privilege?
A. They cannot create restore points.
B. They can view data from any data dictionary view or dynamic performance view.
C. They can view data from any user-defined tables.
D. They can drop any tablespace.
E. They cannot drop tablespaces.
F. They can create any table.
正解：B、D、F
質問 # 181
Choose three. Which three are true about recovering tables using RMAN?
A. RMAN can recover tables owned by the SYS user.
B. RMAN can recover tables owned by the SYSTEM user.
C. RMAN can recover tables in the SYSAUX tablespace.
D. RMAN always uses an auxiliary instance.
E. RMAN can recover a table after a DDL operation has altered the table structure.
F. RMAN can recover tables in a standby database.
G. RMAN can recover tables in the SYSTEM tablespace.
正解：B、D、E
質問 # 182
You upgrade your database from pre-12c to a multitenant container database (CDB) that contains pluggable databases (PDBs). Examine the query and its output:
SQL> SELECT * FROM v $PWFILE_users;
USERNAME SYSDB SYSOP SYSAS SYSBA SYSDG SYSKM CON_ID
----------------------------- ------------------------------------------- SYS TRUE TRUE FALSE FALSE FALSE FALSE 0 Which two tasks must you perform to add users with the SYSBACKUP, SYSDG, and SYSKM prileges to the password file?
A. Re-create or migrate the password file to the Oracle Database 12c format
B. Copy the password file from a sample file in the DBS dierectory
C. Assign appropriate operating system groups to SYSBACKUP, SYSDG, and SYSKM.
D. Grant the SYSBACKUP, SYSDG, and SYSKM privileges to the intended users.
正解：A、D
質問 # 183
Choose three. The HR_ROOT application container must support the execution of a query on a table shared by application local PDBs PDB1 and PDB2, and remote PDB PDB3. Which three are true?
A. A proxy PDB must exist in the application root in the local CDB.
B. PDB3's application root replica must exist in the local CDB.
C. A proxy PDB must exist in the application root in the remote CDB.
D. The HR_ROOT replica must exist in the remote CDB.
E. A database link must exist in the remote CDB referring to the local CDB.
F. A database link must exist in the local CDB root referring to the remoteCDB.
正解：A、B、F
質問 # 184
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. Setting DBWR_IO_SLAVESto a non zero value can improve backup performance when using synchronous I/O.
B. If an RMAN BACKUP VALIDATEcommand takes noticeably less than an actual backup, then write I/O is a likely bottleneck.
C. If an RMAN BACKUP VALIDATEcommand takes roughly the same time as an actual backup, then read I/O is a likely bottleneck.
D. 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.
E. If an RMAN BACKUP VALIDATEcommand takes roughly the same time as an actual backup, then both read and write I/O are likely bottlenecks.
F. Setting DBWR_IO_SLAVESto a non zero value can improve backup performance when using asynchronous I/O/
G. Data files with a high value in V$BACKUP_ASYNC_IO.SHORT_WAITSare a potential performance bottleneck when asynchronous I/O is used.