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

Exam 1z0-882 All Questions

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

Exam 1z0-882 topic 1 question 57 discussion

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

Consider the statement:
CREATE TABLE t1 (a INT) PARTITION BY KEY
/*150611 ALGORITHM = 1*/
What does this statement do?

  • A. Create the t1 table partitioned by KEY with the default algorithm in all versions.
  • B. Create the t1 table partitioned by KEY using algorithm 1 only in MYSQL version 5.6.11 and the default algorithm in other versions.
  • C. Create the t1 table partitioned by KEY using algorithm 1 only in MYSQL versions 5.6.11 or newer and the default algorithm in older versions.
  • D. Create the t1 table partitioned by KEY using algorithm 1 only if the preceding statement returned error condition 50611.
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
by chehin at May 14, 2022, 4:06 p.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
chehin
3 years ago
13:06:18 CREATE TABLE t1 (a INT) PARTITION BY KEY /*150611 ALGORITHM = 1*/ Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2 0.000 sec
upvoted 1 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