Only E is OK
Wrong A. Online redefinition can be done at table or cluster level
Wrong B. Specify all columns in col_mapping parameter to move whole table
Wrong C. db_securefile to NEVER prevents use securefile, all options like compress/dedup will thrown exception
Wrong D. NOLOGGING storage parameter is permitted but is recommended? Nologging is faster but not safe. Maybe this quote is key for this question:
Maybe "NOLOGGING setting is converted internally to FILESYSTEM_LIKE_LOGGING. FILESYSTEM_LIKE_LOGGING ensures that data is completely recoverable after a server failure."
D and E are correct. Based on Oracle documentation pasted by @orakell:
D: To prevent generation of redo space during migration make sure that you specify the NOLOGGING storage parameter for the new SecureFiles LOB column(s). You can turn LOGGING on once your migration is complete.
E: Online redefinition is the only recommended method for migration of BasicFiles LOBs to SecureFiles LOBs. It can be done at the table or partition level.
upvoted 1 times
...
...
...
This section is not available anymore. Please use the main Exam Page.1z0-148 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
chrishillinger
2 years, 8 months agoorakell
5 years, 5 months agoyurijk
5 years, 3 months agoszefco
4 years, 10 months ago