TZ set to America/New_york
OC4J Configuration issue. /u01/app/oracle/product/10.1.0/db_1/oc4j/j2ee/OC4J_DBConsole_orcl.us.oracle.com not found.
Which two environment variables do you need to set appropriately to avoid such errors, and start the Database Control successfully? (Choose two.)
A. NLS_LANG
B. ORACLE_SID
C. ORACLE_HOME
D. ORACLE_BASE
E. LD_LIBRARY_PATH
Answer: BC
2. The UNDO_RETENTION parameter in your database is set to 1000 and undo retention is not guaranteed. Which statement regarding retention of undo data is correct?
A. Undo data becomes obsolete after 1,000 seconds.
B. Undo data gets refreshed after every 1,000 seconds.
C. Undo data will be stored permanently after 1,000 seconds.
D. Committed undo data would be retained for 1,000 seconds if free undo space is available.
E. Undo data will be retained in the UNDO tablespace for 1,000 seconds, then it gets moved to the TEMPORARY tablespace to provide read consistency.
Answer: D
3. You want the size of the tablespace to increase when it is full. Which option would you use?
A. use automatic extent allocation
B. disable threshold for the tablespace
C. use freelists to manage the free space
D. use automatic segment space management
E. create the tablespace as a bigfile tablespace
F. use the RESIZE clause while creating the tablespace
G. enable AUTOEXTEND for at least one of the data files in the tablespace
Answer: G
4. You want to administer your PROD database from a remote host machine using a Web-enabled interface. Which Oracle tool would you use to accomplish this task efficiently without using command-line interfaces?
A. SQL*Plus
B. iSQL*Plus
C. Management Server
D. Management Repository
E. Oracle Enterprise Manager 10g Database Control
Answer: E
5. The database is open. A media failure has occurred, resulting in loss of all the control files in your database. Which statement regarding the database instance is true in this scenario?
A. The instance would hang.
B. The instance needs to be shut down.
C. The instance would be in the open state.
D. The instance would abort in such cases.
E. The instance would be in the open and invalid state.
F. The instance would be in the open state, but all the background processes will be restarted.
Answer: D
最新评论