In the SALES database, DEFERRED_SEGMENT_CREATION is TRUE. Examine this command: SQL> CREATE TABLE

By Singh | January 1, 2023

In the SALES database, DEFERRED_SEGMENT_CREATION is TRUE.
Examine this command:
SQL> CREATE TABLE T1(c1 INT PRIMARY KEY, c2 CLOB);
Which segment or segments, if any, are created as a result of executing the command?

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

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

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

D. no segments are created

E. T1 only

Correct Answer: D

Your database instance was shut down normally and then started in NOMOUNT state. You then execute this
Your database instance is started with a PFILE. Examine these parameters: (Exhibit) You want to increase
The SALES_Q1 and USERS tablespaces exist in one of your databases and TEMP is a temporary tablespace.
Which two statements are true about date/time functions in a session where NLS_DATE_FORMAT is set to