MCQ IN COMPUTER SCIENCE & ENGINEERING

COMPUTER SCIENCE AND ENGINEERING

SQL

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

Where does the CREATE Command belong?

A	DML
B	DDL
C	DCL
D	None of the above

Explanation:

Detailed explanation-1: -Overview : Data Definition Language(DDL) is a subset of SQL and a part of DBMS(Database Management System). DDL consist of Commands to commands like CREATE, ALTER, TRUNCATE and DROP. These commands are used to create or modify the tables in SQL.

Detailed explanation-2: -List of DDL commands: CREATE: This command is used to create the database or its objects (like table, index, function, views, store procedure, and triggers).

Detailed explanation-3: -The DDL commands are used to define or alter the structure of the table. Some common examples of DDL commands are create table command, alter table command, etc. The DML commands are used to insert or manipulate the records of the particular table.

Detailed explanation-4: -Oracle Database divide SQL commands to different types. They are. Data definition language (DDL) statements let you to perform these tasks: Create, alter, and drop schema objects.

There is 1 question to complete.