Free 1Z0-045 Questions for Oracle database 10g:new features for Oracle8i ocps 1Z0-045 Exam as PDF & Practice Test Engine
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.
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: D
Vote an answer
The Automatic Database Diagnostic Monitor (ADDM) analysis runs every 60 minutes on your database. Your database is facing a series of interrelated problems over a period of two hours. You need to ensure that the ADDM analysis is run over a time span of two hours in future. What would you do?
Correct Answer: D
Vote an answer
Identify four uses of the Oracle Scheduler. (Choose four.)
Correct Answer: B,C,E,G
Vote an answer
Which parameter avoids the overwriting of archived redo log files when you recover the database with the RESETLOGS option?
Correct Answer: E
Vote an answer
Which three statements regarding resumable statements are correct? (Choose three.)
Correct Answer: A,B,C
Vote an answer
Which three parameters are ignored when creating an automatic space management segment? (Choose three.)
Correct Answer: C,D,E
Vote an answer
Which three methods can you use to run an Automatic Database Diagnostic Monitor (ADDM) analysis over a specific time period? (Choose three.)
Correct Answer: A,C,E
Vote an answer
The Oracle 10g LogMiner needs a data dictionary copy to display the object names. From which three locations can LogMiner retrieve the data dictionary information? (Choose three.)
Correct Answer: C,D,F
Vote an answer
You want to retain the job entries for the last five days and purge all job entries from the job log that are older than five days. Select the command that will enable you to do the job.
Correct Answer: A
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?
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: E
Vote an answer
0
0
0
10