Summer Special Limited Time 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 8w52ceb345

Which two are true about global temporary tables?

Which two are true about global temporary tables?

A.

They can be created only by a user with the DBA role,but can be accessed by all users who can create a session.

B.

Backup and recovery operations are available for these tables.

C.

If the ON COMMIT clause is session-specific,the table is dropped when the session is terminated.

D.

Their data is always stored in the default temporary tablespace of the user who created them.

E.

Indexes can be created on them.

F.

If the ON COMMIT clause Is transaction-specific, all rows in the table are deleted alter each COMMIT or ROLLBACK.

1z0-071 PDF/Engine
  • Printable Format
  • Value of Money
  • 100% Pass Assurance
  • Verified Answers
  • Researched by Industry Experts
  • Based on Real Exams Scenarios
  • 100% Real Questions
buy now 1z0-071 pdf
Get 60% Discount on All Products, Use Coupon: "8w52ceb345"