CLASS XI - MYSQL FLASHCARD

Front

Full form of SQL?

Back

Structured Query Language

Front

Operator for pattern matching:

Back

Like Operator

Front

Operator testing for absence of data

Back

is null operator

Front

MySQL command to modify table values

Back

Update

Front

Table with 3 rows and 5 columns has a degree of:

Back

5

Front

SQL keyword for unique values

Back

Distinct

Front

Not a DML command: Update, Insert into, Delete, Create Table

Back

Create Table

Front

SQL keyword to sort result-set

Back

order by

Front

SQL command to remove rows from customer table.

Back

Delete from customer where condition ;

Front

Must be enclosed in double quotes: Date, Column alias, String.

Back

All of the above