Oracle 1Z0-060 問題集

質問 1：
Which two statements are true about Oracle Managed Files (OMF)?
A. OMF may affect the location of the redo log files and archived log files.
B. OMF can be used with ASM disk groups, as well as with raw devices, for better file management.
C. The file system directions that are specified by OMF parameters are created automatically.
D. OMF automatically creates unique file names for table spaces and control files.
E. OMF cannot be used in a database that already has data files created with user-specified directions.
正解：A,D
解説: (Topexam メンバーにのみ表示されます)

質問 2：
Your are the DBA supporting an Oracle 11g Release 2 database and wish to move a table containing several DATE, CHAR, VARCHAR2, and NUMBER data types, and the table's indexes, to another tablespace.
The table does not have a primary key and is used by an OLTP application.
Which technique will move the table and indexes while maintaining the highest level of availability to the application?
A. Online Table Redefinition.
B. Edition-Based Table Redefinition.
C. Oracle Data Pump.
D. An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD ONLINE to move the indexes.
E. An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD to move the indexes.
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 3：
Your multitenant container (CDB) contains two pluggable databases (PDB), HR_PDB and ACCOUNTS_PDB, both of which use the CDB tablespace. The temp file is called temp01.tmp.
A user issues a query on a table on one of the PDBs and receives the following error:
ERROR at line 1:
ORA-01565: error in identifying file
`/u01/app/oracle/oradata/CDB1/temp01.tmp'
ORA-27037: unable to obtain file status
Identify two ways to rectify the error.
A. Take the temporary tablespace offline, recover the missing temp file by applying redo logs, and then bring the temporary tablespace online.
B. Add a new temp file to the temporary tablespace and drop the temp file that that produced the error.
C. Shut down the database instance, restore the temp01.tmp file from the backup, and then restart the database.
D. Shut down the database instance and then restart the CDB and PDBs.
E. Shutdown the database instance, restore and recover the temp file from the backup, and then open the database with RESETLOGS.
正解：B,D
解説: (Topexam メンバーにのみ表示されます)

質問 4：
The tnsnames.ora file has an entry for the service alias ORCL as follows:

The TNSPING command executes successfully when tested with ORCL; however, from the same OS user session, you are not able to connect to the database instance with the following command:
SQL > CONNECT scott/tiger@orcl
What could be the reason for this?
A. The orcl.oracle.com database service is not registered with the listener.
B. The listener is running on a different port.
C. The TNS_ADMIN environment variable is set to the wrong value.
D. The DEFAULT_DOMAIN parameter is set to the wrong value in the sqlnet.ora file.
E. The listener is not running on the database node.
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Examine the following impdp command to import a database over the network from a pre-12c Oracle database (source):

Which three are prerequisites for successful execution of the command? (Choose three.)
A. All the user-defined tablespaces must be in read-only mode on the source database.
B. The import operation must be performed by a user on the target database with the DATAPUMP_IMP_FULL_DATABASE role, and the database link must connect to a user on the source database with the DATAPUMP_EXD_FULL_DATABASE role.
C. The export dump file must be created before starting the import on the target database.
D. The path of data files on the target database must be the same as that on the source database.
E. The impdp operation must be performed by the same user that performed the expdp operation.
F. The source and target database must be running on the same platform with the same endianness.
正解：A,B,F
解説: (Topexam メンバーにのみ表示されます)

質問 6：
Your multitenant container database (CDB) contains some pluggable databases (PDBs), you execute the following command in the root container:

Which two statements are true? (Choose two.)
A. The command will, create a common user whose description is contained in the root and each PDB.
B. The command will create a user in the root container only because the container clause is not used.
C. Schema objects owned by the C# # A_ADMIN common user can be shared across all PDBs.
D. The C # # A_ADMIN user will be able to use the TEMP_TS temporary tablespace only in root.
E. The schema for the common user C # # A_ADMIN can be different in each container.
正解：A,E
解説: (Topexam メンバーにのみ表示されます)

質問 7：
Which two statements are true concerning Information Lifecycle Management (ILM) policies?
A. ILM policy functions return a Boolean value.
B. Segment-level policies override row-level policies.
C. Multiple ILM policies may exist for the same segment and any compression levels may be specified for any policy.
D. Multiple ILM policies may exist for the same segment but greater compression levels must be specified at greater elapsed times.
E. Multiple ILM policies may exist for the same table, if the action is compression and the scope is at the row level.
正解：A,E

質問 8：
You run a script that completes successfully using SQL*Plus that performs these actions:
1. Creates a multitenant container database (CDB)
2. Plugs in three pluggable databases (PDBs)
3. Shuts down the CDB instance
4. Starts up the CDB instance using STARTUP OPEN READ WRITE
Which two statements are true about the outcome after running the script?
A. The seed will be opened read-only.
B. The seed will be opened read/write.
C. The seed will be in mount state.
D. The other PDBs will be in mount state.
E. The PDBs will be opened read/write.
F. The other PDBs will be opened read-only.
正解：A,D
解説: (Topexam メンバーにのみ表示されます)