Oracle database 10g:new features for Oracle8i ocps - 1Z0-045 FREE EXAM DUMPS QUESTIONS & ANSWERS

CORRECT TEXT
View the Exhibit and examine the sparsely populated EMP table segment.
You execute the following SQL command: ALTER TABLE emp SHRINK SPACE;
Identify how the data in the segment will be reorganized as a result of the above statement.
Correct Answer: B Vote an answer
Consider the following scenario:
You have a directory, data, under the disk group tdgroupA. You want to create an alias for one of
the data files and you execute the following command:
ALTER DISKGROUP tdgroupA
ADD ALIAS '+tdgroupA/data/datafile.dbf'
FOR '+tdgroupA.231.45678';
Which task would be accomplished by the command?
Correct Answer: B Vote an answer
Which two statements regarding unusable indexes are correct? (Choose two.)
Correct Answer: B,D Vote an answer
View the Exhibit and examine the recommendation graph provided for a test database by the Undo Advisor.
The graph recommends that the size of undo tablespace should be set to _____.
Correct Answer: C Vote an answer
Which statement regarding the COMPATIBLE parameter is correct?
Correct Answer: B Vote an answer
What are three benefits provided by the enhanced Unicode support? (Choose three.)
Correct Answer: A,C,D Vote an answer
You want an ASM instance to manage the files of your production database. To achieve this objective, you specify the following parameters in the parameter file.
INSTANCE_TYPE = RDBMS LARGE_POOL_SIZE = 8MB DB_BLOCK_SIZE = 4K LOG_ARCHIVE_DEST = +dgroupA LOG_ARCHIVE_FORMAT = "$ORACLE_SID_%s_%t.%t" DB_CREATE_FILE_DEST = +dgroupA COMPATIBLE = 10.1.0.2.0 CONTROL_FILES = +dgroupA
Which parameter would be ignored while starting up the instance of the production database?
Correct Answer: D Vote an answer
You have three temporary tablespace groups named G1, G2, and G3 in your database. You are creating a new temporary tablespace as follows:
CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE '/u1/data/temp1.dbf' SIZE 10M TABLESPACE GROUP '';
Which statement regarding the above command is correct?
Correct Answer: E Vote an answer
An AFTER SUSPEND system event trigger containing no exception handler is fired, and runs out of space after inserting some audit records. Which two events happen? (Choose two.)
Correct Answer: C,D Vote an answer
What is true if you want to switch undo tablespaces from the current one, called UNDO1, to a new one called UNDO2?
Correct Answer: B Vote an answer
View the Exhibit.
Which two statements regarding the result of the query shown in the Exhibit are correct? (Choose two.)
Correct Answer: A,D Vote an answer
You executed the following command to drop a user:
DROP USER scott CASCADE;
Which two statements regarding the above command are correct? (Choose two.)
Correct Answer: C,D Vote an answer
Identify three key features of ASM. (Choose three.)
Correct Answer: A,C,D Vote an answer
You created a locally managed tablespace by using the following SQL statement:
CREATE TABLESPACE hr_tbs DATAFILE 'data.dat' SIZE 1M REUSE AUTOEXTEND ON MAXSIZE 100M;
The warning and critical tablespace usage threshold values are set to 85% and 97%, respectively. Which two statements regarding the threshold-based alerts generation for the HR_TBS tablespace are correct? (Choose two.)
Correct Answer: C,H Vote an answer
Examine the statement:
SQL> CREATE TABLESPACE user_data 2> EXTENT MANAGEMENT LOCAL 3> SEGMENT SPACE MANAGEMENT AUTO;
Which two assumptions must be true for this statement to execute successfully? (Choose two.)
Correct Answer: A,C Vote an answer
0
0
0
10