GK
TECHNOLOGY
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
DML
|
|
|
DDL
|
|
|
QCL
|
|
|
DCL
|
Detailed explanation-1: -The CREATE TABLE is a DDL statement which is used to create tables in the database. The table gets created as soon as the CREATE TABLE script is executed and is ready to hold the data onwards. The user must have the CREATE TABLE system privilege to create the table in its own schema.
Detailed explanation-2: -The CREATE TABLE statement is used to create a table in a database. Tables are organized into rows and columns; and each table must have a name.
Detailed explanation-3: -Data definition language (DDL) describes the portion of SQL that creates, alters, and deletes database objects. These database objects include schemas, tables, views, sequences, catalogs, indexes, variables, masks, permissions, and aliases.