You execute this command: CREATE SMALLFILE TABLESPACE sales DATAFILE `/u01/app/oracle/sales01.dbf SIZE

By Singh | January 1, 2023

You execute this command:
CREATE SMALLFILE TABLESPACE sales
DATAFILE `/u01/app/oracle/sales01.dbf
SIZE 5G
SEGMENT SPACE MANAGEMENT AUTO;
Which two statements are true about the SALES tablespace? (Choose two.)

A. Any data files added to the tablespace must have a size of 5 gigabytes

B. It uses the database default blocksize

C. Free space is managed using freelists

D. It must be smaller than the smallest BIGFILE tablespace

E. It is a locally managed tablespace

Correct Answer: B,E

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