Home » Oracle » 1z0-071 v.2 » Which three statements are true about GLOBAL TEMPORARY TABLES?
Which three statements are true about GLOBAL TEMPORARY TABLES?
A. A GLOBAL TEMPORARY TABLE can have multiple indexes.
B. A GLOBAL TEMPORARY TABLE cannot have a PUBLIC SYNONYM.
C. A trigger can be created on a GLOBAL TEMPORARY TABLE.
D. A GLOBAL TEMPORARY TABLE can be referenced in the defining query of a view.
E. A GLOBAL TEMPORARY TABLE can have only one index.
F. Data Manipulation Language (DML) on GLOBAL TEMPORARY TABLES generates no REDO.
Correct Answer: CDF
Explanation/Reference:
Reference: https://books.google.com.pk/books?id=oP88fSdbQJIC&pg=PA11&lpg=PA11&dq=oracle+database+GLOBAL+TEMPORARY+TABLES+Data+Manipulation+Language+(DML)+on+GLOBAL+TEMPORARY+TABLES+generates+no+REDO&source=bl&ots=F7EL8Y0ST9&sig=ACfU3U1KuLlqyyJFxqAG1LRT4OxprsVZdg&hl=en&sa=X&ved=2ahUKEwi0xdPU94vlAhWp34UKHUYpBtAQ6AEwAHoECAkQAQ#v=onepage&q=oracle%20database%20GLOBAL%20TEMPORARY%20TABLES%20Data%20Manipulation%20Language%20(DML)%20on%20GLOBAL%20TEMPORARY%20TABLES%20generates%20no%20REDO&f=false
|
Download Printable PDF. VALID exam to help you PASS.
|
 |
acd
Acd
ACD
C – False. Triggers cannot be created on GTT
D – False. Views cannot reference GTT
E – False. GTT can be indexed multiple times
ABF
that’s cap GTT can have triggers associated with them
A,C,D