Oracle 1Z0-060 問題集

質問 1：
You are administering a database stored in Automatic Storage management (ASM). The files are stored in the DATA disk group. You execute the following command:

What is the result?
A. The file `+data.231.45678' remains in the same location andasynonym'myfile.dbf' is created.
B. The file `+data.231.45678' is physically relocated to `+data/prod' and renamed as `myfile.dbf'.
C. The file `+data.231.45678' is renamed as `myfile.dbf', and copied to `+data/prod'.
D. The file `myfile.dbf' is created in `+data/prod' and the reference to `+data.231.45678' in the data dictionary removed.
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 2：
Your database uses Automatic Memory Management, and has the large pool configured.
You issue the following command:
SQL> ALTER SYSTEM SET SHARED_SERVERS = 5;
Which statement is true about the shared server configuration?
A. It is enabled and the UGA is located in the large pool for connections that use the shared server configuration.
B. It is enabled only if at least five dispatchers are configured.
C. It is enabled and all the DBA and non-DBA sessions function in shared server mode.
D. It is enabled only if the SHARED_SERVER_SESSIONS parameter is configured.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 3：
Which three statements are true concerning unplugging a pluggable database (PDB)?
A. The PDB must be open in read only mode.
B. The PDB must be dosed.
C. The PDB data files are automatically removed from disk.
D. The unplugged PDB becomes a non-CDB.
E. The unplugged PDB can be plugged into another CDB.
F. The unplugged PDB can be plugged into the same multitenant container database (CDB)
正解：B,E,F
解説: (Topexam メンバーにのみ表示されます)

質問 4：
You issue the following commands:

The directories '/u0l/app/oracle/oradata/orcl'and '/u0l/app/oracle/mydata' exist.
Which statement describes the outcome?
A. The two tablespaces are created with the data file and temp file in their respective locations as specified in the CREATE commands.
B. The TEMP101 tablespace is created with its temp file in the DB_CREATE_FILE_DEST location and the tablespace is created with its data file in the '/u01/app/oracle/mydata/ AUGUST_SALES location.
mysales.dbf'
C. The AUGUST_SALES tablespace is created with its data file in the DB_CREATE_FILE_DEST location and the TEMP101 tablespace is created with its temp file in the '/u01/app/oracle/mydata' location.
D. Tablespace creation ignores the data file and temp file locations specified in the CREATE commands, and creates both the tablespaces in the DB_CREATE_FILE_DEST location.
正解：A

質問 5：
Which five actions are prerequisites for using extended data types for VARCHAR2, NVARCHAR2, and RAW columns in Oracle Database 12c?
A. Run the ut132k.sql script in $ORACLE_HOME/rdbms/admin.
B. Restart the database Instance in RESTRICTED mode.
C. Restart the database instance in UPGRADE mode.
D. Set the MAX_STRING_SIZE parameter to EXTENDED.
E. Restart the instance in normal mode.
F. Run the Database Migration Assistant.
G. Shut down the database instance.
正解：A,C,D,E,G
解説: (Topexam メンバーにのみ表示されます)

質問 6：
Examine the query and its output executed In an RDBMS Instance:

Which three statements are true about the users (other than sys) in the output?
A. The C # # C_ADMIN user can perform the data guard operation with Data Guard Broker.
B. The C # # D_ADMIN user can perform backup and recovery operations for Automatic Storage Management (ASM).
C. The C# # B_ADMIN user can perform all backup and recovery operations using RMAN or SQL* Plus.
D. The C # # B_ADMIN user can perform all backup and recovery operations using RMAN only.
E. The C # # A_ADMIN user can perform wallet operations.
正解：A,B,C
解説: (Topexam メンバーにのみ表示されます)

質問 7：
You executed this command to create a password file:
$ orapwd file = orapworcl entries = 10 ignorecase = N
Which two statements are true about the password file?
A. It contains usernames and passwords of database users who are members of the OSDBA operating system group.
B. It will permit the use of lowercase passwords for database users who have granted the SYSDBA role.
C. It will not permit the use of mixed case passwords for the database users who have been granted the SYSDBA role.
D. It will permit the use of uppercase passwords for database users who have been granted the SYSOPER role.
E. It contains username and passwords of database users who are members of the OSOPER operating system group.
正解：B,D
解説: (Topexam メンバーにのみ表示されます)

質問 8：
An administrator account is granted the CREATE SESSION and SET CONTAINER system privileges.
A multitenant container database (CDB) instant has the following parameter set:
THREADED_EXECUTION = FALSE
Which four statements are true about this administrator establishing connections to root in a CDB that has been opened in read only mode?
A. You can conned as a common user by using the connect statement.
B. You can connect as a local user by using the connect statement.
C. You can connect by using a Net Service name.
D. You can connect by using easy connect.
E. You can connect as a local user by using the SET CONTAINER statement.
F. You can connect by using OS authentication.
正解：A,C,D,F
解説: (Topexam メンバーにのみ表示されます)