Multiple choice technology databases

For CREATING a TABLE object, what are the pre-requisites? Choose all that apply

  1. A SCHEMA with CREATE SESSION system privilege

  2. CREATE SYNONYM system privilege

  3. A storage area with required access

  4. CREATE TABLE system privilege

  5. CREATE INDEX system privilege
Reveal answer Fill a bubble to check yourself
A,C,D Correct answer
Explanation

To create a table, you need CREATE TABLE privilege, CREATE SESSION to connect, and storage area access (tablespace quota). CREATE SYNONYM and CREATE INDEX are separate privileges - a synonym is an alias and indexes are optional database objects that can be created separately.

Keep practicing — related questions