InfyTQ SQL Basics Quiz 4

Data Definition Language , a subset of SQL statements that change the structure of the database schema in some way, typically by creating, deleting, or modifying schema objects such as databases, tables, and views DDL command is used to create the database schema..

There are five types of SQL commands: DDL, DML, DCL, TCL, and DQL.

Stored Procedures is not supported by SQL Because all the other options like Temporary Tables, Table Joining, and Regular Expression Matching is supported by MySQL.


 

An integrity constraint is a declarative method of defining a rule for a column of a table. Integrity constraints ensure that the data insertion, updating, and other processes have to be performed in such a way that data integrity is not affected.

The WHERE clause is used to filter records. It is used to extract only those records that fulfill a specified condition. Limits the number of rows returned. Followed by a logical condition that returns either true or false. Works only if the mentioned condition returns true

The SQL WHERE clause is useful when an exact match is not possible in a SELECT Statement.

Virtual table is a temporary which is been viewed by us through the sql commands.

We use the SQL DROP Table command to drop a table from the database. It completely removes the table structure and associated indexes, statistics, permissions, triggers and constraints.

CREATE INDEX ID is valid for Creating an index. And all the other options are incorrect and are not valid SQL for an index.