Create Temporary Tables - Quiz

Each question is worth one point. Select the best answer or answers for each question.

1.	Which SQL*Loader mode can load data without requiring a control file? Please select the best answer.
	A.	`SQL*Loader express mode`
	B.	Conventional-path mode with the `CONTROL` parameter
	C.	Direct-path mode with a control file
	D.	Parallel direct-path mode with a control file

2.	In Oracle Database 23ai, which expression describes the maximum supported size of an internal LOB value? Please select the best answer.
	A.	`4GB`
	B.	`2GB`
	C.	The LOB tablespace block size multiplied by `2³² - 1`
	D.	There is no implementation limit

3.	Which statement correctly describes an Oracle global temporary table? Please select the best answer.
	A.	Its definition persists in the database, while its rows are private to a transaction or session according to the `ON COMMIT` clause.
	B.	The table definition is automatically dropped whenever a transaction commits.
	C.	Rows inserted by one session are immediately visible to every other session using the table.
	D.	A global temporary table cannot have an index.