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 71 discussion

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

You have access to a MySQL 5.6 database with the SELECT ,INSERT, and DELETE privileges on all tables in the mydb database.
The mydb database.
The mydb t1 table has five rows of data.
You use the statement below to remove all rows in the t1 table:
Mysql> TRUNCATE TABLE mysql.t1;
What is the result?

  • A. The command succeeds and o rows are affected.
  • B. The command succeeds and five rows are affected.
  • C. The command fails owing to syntax error.
  • D. The command fails owing to permissions error.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
by Lara at Feb. 17, 2019, 12:33 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
mschnittker
4 years, 2 months ago
I think its a typo. normally you must have the DROP privileges for the TRUNCATE statement since version 5.1.
upvoted 1 times
...
Lara
5 years, 9 months ago
Isn't it C? If you run the code the result would be mysql.t1 doesn't exist. The database name is mydb not mysql.
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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago