Oracle 1Z0-072 問題集

質問 1：
Which two are true about conventional path SQL load? (Choose two.)
A. It cannot load data into clustered tables.
B. It always generates redo.
C. It enforces referential integrity constraints.
D. It does not generate UNDO.
E. It locks objects being processed.
正解：C,D

質問 2：
Which three actions are required to manually upgrade a database to Oracle Database 12c Release 2? (Choose three.)
A. Copy the network configuration files from the existing database home to the new Oracle home location.
B. Run the Pre-Upgrade information tool on the source database.
C. Run the Parallel Upgrade utility from the new Oracle home.
D. Make all user tablespaces "read only" before starting the upgrade.
E. Start the existing database in upgrade mode.
F. Take all user tablespaces offline before starting the upgrade.
G. Run Oracle Net Configuration Assistant (NETCA) to configure the listening protocol address and service information for the new release of Oracle Database.
正解：B,C,E

質問 3：
Which two are true about instance recovery for a database that is open in read write mode? (Choose two.)
A. No users can log on until instance recovery has completed.
B. It is always performed when opening a database.
C. It is guaranteed to complete within fast_start_mttr_target number of seconds.
D. Only the CURRENT REDO log group is required to perform instance recovery.
E. It always occurs during instance startup performed immediately after a SHUTDOWN ABORT.
F. The database opens after the roll forward phase of instance recovery has completed.
正解：B,E

質問 4：
You execute this command:
CREATE SMALLFILE TABLESPACE sales
DATAFILE '/u01/app/oracle/sales01.dbf' SIZE 5G
SEGMENT SPACE MANAGEMENT AUTO;
Which two statements are true about the SALES tablespace? (Choose two.)
A. It is a locally managed tablespace.
B. It uses the default blocksize used at database creation.
C. The FREELISTS and FREELIST GROUPS parameters are used to manage extent allocation.
D. It is read-only by default.
E. It is offline by default.
F. DML operations performed on objects in this tablespace are not logged by default.
正解：B,C

質問 5：
Which two tasks can be performed in the NOMOUNT state? (Choose two.)
A. creating a database
B. re-creating control files
C. enabling online redo log archiving
D. renaming data files
E. full database recovery
正解：A,B

質問 6：
Which two statements are true about Oracle Data Pump? (Choose two.)
A. expdp and impdp are its client components.
B. It cannot be used to export data as of a previous SCN.
C. impdp always uses conventional path inserts when importing data.
D. impdp can change target data file names, schemas, and tablespaces during import.
E. The DBMS_DATAPUMP package can be used only with Data Pump clients
正解：A,E

質問 7：
Which two are true about roles? (Choose two.)
A. The SET ROLE statement can be used once per session.
B. The SET ROLE statement enables as well as disables roles in a session.
C. All privileges and roles granted to a user are enabled by default when the user logs in.
D. A role must be disabled before it can be revoked from a user.
E. The ALTER USER statement must be used to set specific default roles for a user.
正解：B,C

質問 8：
In a database, the default temporary tablespace is TEMP and USER1's default tablespace is DATA.
Examine these parameters:

Which tablespace stores UNDO generated by USER1's DML on temporary tables?
A. DATA
B. UNDOTBS1
C. SYSAUX
D. TEMP
E. SYSTEM
正解：D

質問 9：
You want to use table compression suitable for OLTP that will:
1. Compress rows for all DML statements on that table
2. Minimize the overheads associated with compression.
Which compression option is best suited for this?
A. COLUMN STORE COMPRESS FOR ARCHIVE LOW
B. ROW STORE COMPRESS ADVANCED
C. COLUMN STORE COMPRESS FOR ARCHIVE HIGH
D. COLUMN STORE COMPRESS FOR QUERY LOW
E. ROW STORE COMPRESS BASIC
正解：B