A.T1, an index segment for the primary key, and a LOB segment only

B.T1, an index segment for the primary key, a LOB segment, and a lobindex segment

C.T1 and an index segment created for the primary key only

D.T1 only

E.no segments are created

A.If they exist for a session, Private Temporary Tables (PTTs) are always dropped at the next COMMIT OR ROLLBACK statement

B.An index that is altered to be UNUSABLE will retain its segment

C.An index created with the UNUSABLE attribute has no segment

D.A table that is truncated will always have its segment removed

E.Private Temporary Tables (PTTS) store metadata in memory only

A.SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id;

B.SELECT dept_id, MAX(AVG(salary)) FROM employees GROUP BY dept_id;

C.SELECT dept_id, AVG(MAX(salary)) FROM employees GROUP BY dept_id;

D.SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id, join_date;

A.It will be a dictionary-managed tablespace by default

B.It will always have a 32K blocksize

C.It must be bigger than the largest SMALLFILE tablespace

D.AUTOEXTEND is possible for the datafile

E.Additional data files may not be added

A.Data Manipulation Language (DML) can always be used on views

B.The WITH CHECK clause prevents certain rows from being displayed when querying the view

C.Tables in the defining query of a view must always exist in order to create the view

D.Deleting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error

E.Inserting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error

F.Views can be updated without the need to re-grant privileges on the view

G.The WITH CHECK clause prevents certain rows from being updated or inserted