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

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

The user SCOTT owns the CUST table that is placed in the SALES tablespace. The user SCOTT opens a session and executes commands as follows:
SQL> INSERT INTO cust VALUES(101, 'JACK');
1 row created.
SQL> INSERT INTO cust VALUES(102, 'SMITH');
1 row created.
As a DBA, you execute the following command from another session:
ALTER TABLESPACE sales READ ONLY;
Which statement is true regarding the effect of this command on the transaction in Scott's session?

  • A. The command fails as a transaction is still pending.
  • B. The transaction in Scott's session is rolled back and the tablespace becomes readonly.
  • C. The command waits and the user SCOTT can execute data manipulation language (DML) statements only as part of the current transaction.
  • D. The command hangs until all transactions on the objects in the tablespace commit or rollback, and then the tablespace is placed in readonly mode.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
by khan at April 14, 2019, 10:19 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
NorthKorean
Highly Voted 4 years, 8 months ago
D is ,surely
upvoted 9 times
...
khan
Highly Voted 5 years, 8 months ago
Answer D. The command hangs until all transactions on the objects in the tablespace commit or rollback, and then the tablespace is placed in readonly mode.
upvoted 7 times
...
luizyto
Most Recent 2 years, 1 month ago
Selected Answer: D
specify READ ONLY to place the tablespace in transition read-only mode. In this state, existing transactions can complete (commit or roll back), but no further DML operations are allowed to the tablespace except for rollback of existing transactions that previously modified blocks in the tablespace.
upvoted 1 times
...
jackymak
2 years, 9 months ago
Selected Answer: D
it should have behavior like shutdown normail
upvoted 1 times
...
duMaurier
3 years ago
Selected Answer: D
Tested the scenario it should be D.
upvoted 2 times
...
Clozoerie
3 years, 4 months ago
Answer is D
upvoted 2 times
...
TuxBingo
4 years, 4 months ago
It is D !!! Test it yourself, you will get a ORA-00372 for every further DML that modifys cust table and the transaction is not terminated nor rolled back automatically.
upvoted 3 times
...
sherifelia
5 years ago
Answer is D
upvoted 6 times
...
PerkDizzzle
5 years, 3 months ago
"Which statement is true regarding the effect of this command on the transaction in Scott's session?" Answer is correctly B, it's asking specifically about Scott's session.
upvoted 3 times
loveroba
4 years ago
right,checked
upvoted 2 times
...
charan94
3 years, 7 months ago
Even it is scott's session, The answer is D only..
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