Oracle
1Z0-882 · Question #33
1Z0-882 Question #33: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-882 to reveal the answer and full explanation for question #33. The question stem and answer options stay visible for context.
Question
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?
Options
- AThe command succeeds and o rows are affected.
- BThe command succeeds and five rows are affected.
- CThe command fails owing to syntax error.
- DThe command fails owing to permissions error.
Unlock 1Z0-882 to see the answer
You've previewed enough free 1Z0-882 questions. Unlock 1Z0-882 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.