試験の準備方法-最新な1Z0-083模擬試験問題集試験-効率的な1Z0-083無料模擬試験どのようにOracle 1Z0-083試験に準備すると悩んでいますか。我々社の1Z0-083問題集を参考した後、ほっとしました。弊社の1Z0-083ソフト版問題集はかねてより多くのIT事業をしている人々は順調にOracle 1Z0-083資格認定を取得させます。試験にパースする原因は我々問題集の全面的で最新版です。 Oracle Database Administration II 認定 1Z0-083 試験問題 (Q13-Q18):質問 # 13
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?
質問 # 14
A container database called CDB1is OMF-enabled.
PDB_FILE_NAME_CONVERTis not configured in CDB1.
PDB1was unplugged from CDB1earlier in the week.
Examine this command, which will be executed in CDB1:
CREATE PLUGGABLE DATABASE pdb1
USING '/u01/app/oracle/oradata/pdb1.xml'
SOURCE_FILE_NAME_CONVERT =
('/u01/app/oracle/oradata/', '/u02/app/oracle/oradata/');
Which two are true? (Choose two.)
A. PDB_FILE_NAME_CONVERT must be set before executing the command.
B. DBMS_PDB.CHECK_PLUG_COMPATIBILITY must be run in CDB1 before executing the command.
C. PDB1 data files already exist in the correct location.
D. PDB1 must be dropped from CDB1.
E. /u01/app/oracle/oradata/pdb1.xml does not contain the current locations of data files for PDB1.
正解：D、E
解説：
The question gives the impression that the source files were held at /u01/app/oracle/oradata, but are now physically located at /u01/app/oracle/oradata. The xml description file is still at
/u01/app/oracle/oradata/pdb1.xml
A: FALSE - SOURCE_FILE_NAME_CONVERT is only needed if the XML file does not accurately describe the current location of the pdb's files.
B: FALSE - If pdb1 ran correctly before, it will run correctly now - assuming that no major upgrade of CDB1 has happened.
C: FALSE - PDB_FILE_NAME_CONVERT is needed only when OMF is not used. The question tells us that OMF is enabled.
D: TRUE - The use of the SOURCE_FILE_NAME_CONVERT parameter indicates that the DB files have been moved, so the xml file does not hold the correct locations E: TRUE - Unplugging a database will result in the PDB remaining in a MOUNT state. It is still part of the CDB and will still be backed up etc... After unplugging, a PDB needs to be dropped before a new PDB can be created with the same name.
質問 # 15
Choose three. Which three are true about Data Pump in an Oracle multitenant environment?
A. It can be used to clone a CDB.
B. It can be used to transport data from a PDB to a non-CDB.
C. It can be used to transport data between PDBs.
D. It can be used to create a new PDB.
E. It can be used to transport data from a non-CDB to a PDB.
正解：B、C、E
質問 # 16
Which two are prerequisites for using FLASHBACK TABLE? (Choose two.)
A. Row Movement must be enabled on the table being flashed back.
B. The FLASHBACK ANY TABLE system privilege or the FLASHBACK object privilege must be granted to the table owner.
C. A table's indexes must be set to unusable before issuing the flashback.
D. The FLASHBACK ANY TABLE system privilege or the FLASHBACK object privilege must be granted to the user performing the flashback.
E. A table's constraints must be disabled before issuing the flashback.
正解：B、D
質問 # 17
You must transport the UNIVERSITY tablespace from one database to another.
The UNIVERSITY tablespace is currently open read/write.
The source and destination platforms have different endian formats. Examine this list of actions:
1.Make the UNIVERSITY tablespace read-only on the source system.
2.Export the UNIVERSITY tablespace metadata using EXPDP.
3.Convert the UNIVERSITY tablespace data fies to the destination platform format using RMAN on the source system.
4.Copy the UNIVERSITY tablespace data files to the destination system.
5.Copy the Data Pump dump set to the destination system.
6.Convert the UNIVERSITY tablespace data files to the destination platform format using RMAN on the destination system.
7.Import the UNIVERSITY tablespace metadata using IMPDP.
8.Make the UNIVERSITY tablespace read/write on the destination system.
Which is the minimum number of actions required, in the correct order, to transport the UNIVERSITY tablespace?