Multiple choice database

Which of the following are valid CREATE statements in the world of DDL?

  1. CREATE SCHEMA

  2. CREATE TABLE

  3. CREATE DOMAIN

  4. CREATE INDEX

  5. All of the above
Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

All four statements are valid DDL (Data Definition Language) commands. CREATE SCHEMA defines a namespace, CREATE TABLE defines table structure, CREATE DOMAIN defines a custom data type, and CREATE INDEX builds an index. DDL commands define database structures, not manipulate data.

Keep practicing — related questions