exam questions

Exam 1z0-071 All Questions

View all questions & answers for the 1z0-071 exam

Exam 1z0-071 topic 1 question 31 discussion

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

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

  • 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 rows in a GLOBAL TEMPORARY TABLE for the issuing session to be deleted.
  • D. Any GLOBAL TEMPORARY TABLE rows existing at session termination will be deleted.
  • E. A DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back.
  • F. A GLOBAL TEMPORARY TABLE'S definition is available to multiple sessions.
Show Suggested Answer Hide Answer
Suggested Answer: CDF 🗳️

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
jm9999
4 months ago
When I delete from GTT and then Rollback, response is "Rollback complete" but the rollback does not occur. The rows are still gone from the table
upvoted 3 times
...
TheOracleWasTaken
5 months, 2 weeks ago
Selected Answer: CDF
Delete operation can totally be rolled back!
upvoted 1 times
...
zouve
6 months, 2 weeks ago
Selected Answer: CDF
A global temporary table is a type of table in Oracle that holds data only for the duration of a session or transaction. It is a persistent database object, visible to all sessions, until the user drops it explicitly using the DROP TABLE statement. Data is only visible to the session which inserts it. The data stored in the global temporary table is private to the session1. In contrast, a regular table is a permanent database object that stores data on disk and is visible to all sessions. The data stored in a regular table is not private to any session and can be accessed by any session with the appropriate privileges. In summary, the main differences between a global temporary table and a regular table are: A global temporary table holds data only for the duration of a session or transaction, while a regular table holds data permanently. Data stored in a global temporary table is private to the session, while data stored in a regular table is not private to any session.
upvoted 4 times
...
holdfaststrongly
1 year, 3 months ago
https://www.oracletutorial.com/oracle-basics/oracle-global-temporary-table/ will explain the differences between session or transaction specific GTT.
upvoted 3 times
...
karols32
1 year, 4 months ago
A. Can someone explain me when a space allocation occurs? B. It's not true because GTT are avaible for everyone even without permissions like SELECT. C. Changing in private session causes only for private data in GTT. D. Any rows existing at GTT retain after close a session but are not avaible. E. It can be rolled back, GTT works like a normal table. F. GTT for everyone LOCAL TEMPORARY TABLE only for a current session. If what I wrote is not true, please correct me.
upvoted 1 times
holdfaststrongly
1 year, 3 months ago
A) The space is allocated at the time of the first DML operation.
upvoted 5 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
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago