ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-062 All Questions

View all questions & answers for the 1z0-062 exam
Go to Exam

Exam 1z0-062 topic 1 question 304 discussion

Actual exam question from Oracle's 1z0-062
Question #: 304
Topic #: 1
[All 1z0-062 Questions]

You want to create a table, DAILY_ORDERS, for an OLTP application, where data should be compressed during both direct-path INSERT and conventional DML.
The table will also be used for queries.
Which compression option should be used?

  • A. ROW STORE COMPRESS
  • B. COLUMN STORE COMPRESS FOR QUERY
  • C. COLUMN STORE COMPRESS FOR ARCHIVE LOW
  • D. ROW STORE COMPRESS ADVANCED
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
by NorthKorean at March 24, 2020, 2:35 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
NorthKorean
Highly Voted 5 years, 4 months ago
When you enable table compression by specifying ROW STORE COMPRESS ADVANCED, you enable Advanced Row Compression. Oracle Database compresses data during all DML operations on the table. This form of compression is recommended for OLTP environments.
upvoted 6 times
...
DANG257315
Most Recent 4 years, 7 months ago
basic compression for direct-path insert operationes 10x advance row compression for all DML operations 2 -4x Answer: D
upvoted 4 times
...
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.

SaveCancel