これらのコマンドを正常に実行します。 CREATE GLOBAL TEMPORARY TABLE invoices _ gtt (顧客ID INTEGER、 invoice_ total NUMBER(10、2) )コミット保存行について; INSERT INTO invoices_ gtt VALUES(1、100); コミット; どちらが正しいですか?
正解:B,E
A: This statement is false. You cannot add a foreign key to a global temporary table because the data in a global temporary table is session-specific, while a foreign key constraint implies a permanent relationship. B: This statement is false. The ON COMMIT PRESERVE ROWS clause specifies that the data in the table should be preserved until the end of the session, not deleted at the end of the transaction. C: This statement is false. You can drop a global temporary table without truncating it first. D: This statement is true. You can alter a global temporary table to add columns within a session. E: This statement is false. Data in a global temporary table with the ON COMMIT PRESERVE ROWS clause is private to the session that inserted the data, and cannot be seen by other sessions.