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

Exam 1z0-082 All Questions

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

Exam 1z0-082 topic 1 question 147 discussion

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

Which two statements are true about GLOBAL TEMPORARY TABLES? (Choose two.)

  • A. GLOBAL TEMPORARY TABLE space allocation occurs at session start.
  • B. GLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session whose user has been granted select on the table.
  • C. A TRUNCATE command issued in a session causes all news in a GLOBAL TEMPORARY TABLE for the issuing session to be deleted.
  • D. A GLOBAL TEMPORARY TABLE 's definition is available to multiple sessions.
  • E. A DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back.
Show Suggested Answer Hide Answer
Suggested Answer: CD 🗳️
by Darkseid1231 at June 28, 2023, 8:26 a.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
Oracle2020
3 months ago
C,D are true The global temporary table definition is visible to all sessions. Only the data you insert into a session is visible to that session.
upvoted 1 times
...
nautil2
10 months, 2 weeks ago
Selected Answer: CD
A – false; space is allocated when it is requested/needed, see https://asktom.oracle.com/pls/apex/asktom.search?tag=about-temporary-tables B – false; table is visible to other sessions but each session can see only its own data, see https://www.oracletutorial.com/oracle-basics/oracle-global-temporary-table/ C – true D – true E – false; commit and rollback are possible in Global Temporary Tables
upvoted 1 times
...
auwia
1 year ago
Selected Answer: CD
Provided answer are corrects.
upvoted 1 times
...
Darkseid1231
1 year ago
D C are correct
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