Sql Quiz

Where does the CREATE Command belong?

• DML

• DDL

• DCL

An SQL command used to add a record in a table.

• Insert

• Create

• Update

• Add

A clause in the SELECT command that specifies the condition the records must satisfy.

• Table_name

• WHERE

• LIKE

• Database name

It is a DML command that is used to display records.

• DISPLAY

• STRUCTURE

• WHERE

• SELECT

It is a flexible language that is used to communicate with a relational database such as MariaDB

• Java

• PhpMyAdmin

• SQL

• MariaDB

This symbol is placed immediately after the SELECT command to display all the fields.

• $

• %

• =

• *

This symbol is an SQL wildcard that can substitute for one or more characters when searching for data in a database.

• $

• %

• =

• *

What is the meaning of DDL?

• Data Definition Language

• Database definition Language

• Data Definition Link

• Data Division Language

What is the meaning of DML?

• Database Manipulation Language

• Data Manipulative Language

• Data Manipulation Language

• Data Management Language

What is the command that defines a database, including creating, altering, and dropping tables and establishing constraints

• DCL

• DDL

• DML

• SQL