Oracle 1Z0-072 問題集

質問 1：
Which two statements are true about VSTABLESPACE and DBA_ TABLESPACE?
A. VSTABLESPACE and DBA_ TABLESPACES are view based on base tables in the data dictionary.
B. VSTABLESPACE metadata is lost at shutdown, but DBA_ TABLESPACE metadata persists across shutdowns.
C. VSTABLESPACE is a dynamic view that is populated with data from the DBA_ TABLESPACES data queried only when a database is open.
D. VSTABLESPACE is a dynamic view that is populated with data from th DBA_ TABLESPACE dictionary view.
E. VSTABLESPACE cab be queries by all users, but DBA_ TABLESPACEs cab be queries only by SYSDBA users.
正解：A,B

質問 2：
Which two tasks can you perform by using DBCA for a new database?
A. Create user tablespaces.
B. Configure a nonstandard block size.
C. Configure incremental backups.
D. Register it with an available Enterprise Manager Management server.
E. Enable flashback.
正解：A,D

質問 3：
The ORCL database has DEFERRED_SEGMENT_CREATION set to TRUE.
UNDOTBS2 is the active undo tablespace.
Examine these commands:

USER1 executes DML, which generates more than 2 MB of UNDO.
What is the result and why?
A. It returns an error because UNDOTBS2 has RETENTION GUARANTEE.
B. It suspends the transaction, which can be resumed by increasing USER1's quota on UNDOTBS2.
C. It returns an error because UNDOTBS2 is fixed size and has RETENTION GUARANTEE.
D. It suspends the transaction, which can be resumed by setting UNDOTBS1 as the active undo tablespace.
E. It suspends the transaction, which can be resumed by increasing the size of UNDOTBS2.
F. It returns an error because UNDOTBS2 is fixed size.
正解：F

質問 4：
In your database, you create a user, HR, and then execute this command:
GRANT CREATE SESSION TO hr WITH ADMIN OPTION;
Which three actions can HR perform? (Choose three.)
A. Grant the CREATE SESSION privilege with ADMIN OPTION to other users.
B. Log in to the database instance.
C. Execute DDL statements in the HR schema.
D. Revoke the CREATE SESSION privilege from other users.
E. Grant the CREATE SESSION privilege without ADMIN OPTION to other users.
F. Execute DML statements in the HR schema.
正解：A,B,D

質問 5：
Which two are prerequisites for shrinking a table online?
A. It must be in a tablespace that uses Automatic Segment Space Management (ASSM) .
B. It must have a unique key constraint.
C. It must not have any DML triggers.
D. It must have row movement enabled.
E. It must not have any referential integrity constraints.
正解：B,E

質問 6：
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

質問 7：
As the DBA, you execute this command:
GRANT SELECT ON hr.emp TO brown WITH GRANT OPTION;
BROWN then executes this command:
GRANT SELECT ON hr.emp TO scott WITH GRANT OPTION;
Which is true?
A. You can revoke only WITH GRANT OPTION from BROWN.
B. When you revoke the SELECT privilege from BROWN, only the WITH GRANT OPTION is revoked from SCOTT.
C. When you revoke the SELECT privilege from BROWN, it is automatically revoked from SCOTT.
D. BROWN can revoke only WITH GRANT OPTION from SCOTT.
E. When you revoke the SELECT privilege from BROWN, nothing is revoked from SCOTT.
正解：D

質問 8：
Which three failures do not require intervention for recovery? (Choose three.)
A. statement failure
B. transaction failure
C. user process failure
D. network interface card (NIC) failure
E. media failure
正解：A,B,C

質問 9：
In your database, you want to create a tablespace of non-standard block size by using this command:
CREATE TABLESPACE ns_tbs
DATAFILE '/u01oracle/data/nstbs_f01.dbf' SIZE 100M
BLOCKSIZE 16K;
Which is a requirement for this command to succeed?
A. The DB_16K_CACHE_SIZE parameter should be set to a value that can be accommodated in the available SGA.
B. The DB_16K_CACHE_SIZE parameter should be set to a value less than that of DB_CACHE_SIZE.
C. The DB_BLOCK_SIZE parameter must be set to a value greater than 16 KB.
D. The value of the DB_CACHE_SIZE parameter should not be 16 KB.
E. All other DB_nK_CACHE_SIZE parameters should be set to zero.
正解：A