What is a ‘table’ and what is a ‘tablespace’ in Oracle9i? Write an SQL statement to create a tablespace, say MyTableSpace, with default storage. You can use a datafile called ‘MyDataFile.dbf’ for this tablespace.

What will be an ideal response?


A table is a basic conceptual structure that stores data. A table represents an
entity or a relationship.
A tablespace is logical name for a database storage unit that stores related
database objects.

CREATE TABLESPACE MyTableSpace
DATAFILE '\\ict-oracle-s\o$\oracle\oradata\ MyDataFile.dbf' SIZE 5M REUSE
DEFAULT STORAGE (INITIAL 5K

NEXT 5K
MINEXTENTS 5
MAXEXTENTS 100
)
ONLINE;

Computer Science & Information Technology

You might also like to view...

What makes IP spoofing possible for computers on the Internet?

A. network address translation B. the lack of authentication C. the 32-bit address space D. the DNS hierarchy

Computer Science & Information Technology

A large memory ____ is required to print color images and graphics-intensive documents.

A. drive B. capacity C. disk D. card

Computer Science & Information Technology

It is a good idea to use a passphrase and replace some letters with numbers and symbols

Indicate whether the statement is true or false.

Computer Science & Information Technology

Holds a computer system hostage and demands a ransom payment. If _ is on your computer, the data is encrypted and a password is placed on your computer. You then must pay the ransom to receive the code required to retrieve the data.

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology