An Administrator has a table named SALES_DATA which needs some edits, but the Administrator does not want to change the main table data. The Administrator decides to make a transient copy of this table and wants the transient table to have all the same permissions as the original table.
How can the Administrator create the transient table so it inherits the same permissions as the original table, and what considerations need to be made concerning the requirements? (Select TWO).

Question

An Administrator has a table named SALES_DATA which needs some edits, but the Administrator does not want to change the main table data. The Administrator decides to make a transient copy of this table and wants the transient table to have all the same permissions as the original table.

How can the Administrator create the transient table so it inherits the same permissions as the original table, and what considerations need to be made concerning the requirements? (Select TWO).

Alessandro Cristofori · Accepted Answer

Use the following SQL command: create transient table TRANSIENT SALES DATA as select * from SALES_DATA copy grants;

Alessandro Cristofori · Accepted Answer

Transient tables will persist until explicitly dropped and contribute to overall storage costs.

Alessandro Cristofori · Answer

Use the following SQL command: create transient table TRANSIENT_SALES_DATA as select * from SALES_DATA;

Alessandro Cristofori · Answer

Use the following SQL commands: create transient table TRANSIENT_SALES_DATA like SALES_DATA copy grants; insert into TRANSIENT_SALES_DATA select * from SALES_DATA;

Alessandro Cristofori · Answer

Transient tables will be purged at the end of the user session and do not have any Fail-safe period.

Question list

List of questions

Question 1

(0)

Question 2

(0)

Question 3

(0)

Question 4

(0)

Question 5

(0)

Question 6

(0)

Question 7

(0)

Question 8

(0)

Question 9

(0)

Question 10

(0)

Related questions

Question 31 - ADA-C01 discussion

Suggested answer: B, D

0 comments