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

Exam 1z0-908 All Questions

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

Exam 1z0-908 topic 1 question 75 discussion

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

Your MySQL server was upgraded from an earlier major version.
The sales database contains three tables, one of which is the transactions table, which has 4 million rows.
You are running low on disk space on the datadir partition and begin to investigate.
Examine these commands and output:

Which two statements are true? (Choose two.)

  • A. Executing SET GLOBAL innodb_row_format=COMPRESSED and then ALTER TABLE transactions will free up disk space.
  • B. Executing ALTER TABLE transactions will enable you to free up disk space.
  • C. Truncating the sales and leads table will free up disk space.
  • D. Truncating the transactions table will free up the most disk space.
  • E. The transactions table was created with innodb_file_per_table=OFF.
Show Suggested Answer Hide Answer
Suggested Answer: AE 🗳️
by Dhanushka at July 31, 2023, 3:23 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
LrnsTgh
6 months, 1 week ago
is it AE or CE? is it crazy to truncate sales data?
upvoted 1 times
...
marklv
11 months, 1 week ago
If was E was true, the individual tables, wouldn't exist, and empty database on disk would, it is wrong.
upvoted 1 times
marklv
11 months, 1 week ago
A and C. compresion will most likely work. truncate will work because truncate now drops and adds the table.
upvoted 1 times
marklv
9 months, 2 weeks ago
It is C and E. the transactions table doesn't have its own data file, so it uses the general tablespace. truncate won't free up space. Is was created when the variable was OFF. Ignore my other comments.
upvoted 1 times
...
...
...
Dhanushka
1 year ago
Selected Answer: CE
Row compress may not shrink down ibdata file
upvoted 2 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