MCQ IN COMPUTER SCIENCE & ENGINEERING

Previous
Next

COMPUTER SCIENCE AND ENGINEERING

SQL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
What is the commands that define a database, including creating, altering, and dropping tables and establishing constraints
A
DCL
B
DDL
C
DML
D
SQL
Explanation: 

Detailed explanation-1: -SQL(Structured Query Language) commands are used to create and maintain Databases. Data Definition Language(DDL) is a type of SQL command used to define the components of databases using Database Management Systems. DDL in DBMS is used to create or modify the database objects like tables, views etc.

Detailed explanation-2: -Data manipulation language (DML) commands are used to define a database, including creating, altering, and dropping tables and establishing constraints.

Detailed explanation-3: -CREATE TABLE statement. The CREATE TABLE is a DDL statement which is used to create tables in the database.

Detailed explanation-4: -The DDL commands in SQL are used to create database schema and to define the type and structure of the data that will be stored in a database.

There is 1 question to complete.
Previous
Next