Lesson 2: March 12, 2024

Question 1

DML

Answer 1

Data Manipulation Language

Question 2

DQL

Answer 2

Data Query Language

Question 3

DDL

Answer 3

Data Definition Language

Question 4

Command for viewing

Answer 4

SELECT * FROM tableName;

Question 5

Command for viewing specific columns

Answer 5

SELECT colName1, colName2, colName3 FROM tableName;

Question 6

Command for viewing specific row

Answer 6

SELECT * FROM tableName WHERE colName=’condition’;

Question 7

Command for viewing values that are unique

Answer 7

SELECT DISTINCT colName FROM tableName;

Question 8

SQL Arithmetic Operators

Answer 8

*
/
%
^ (exponent)

Question 9

Select command with alias

Answer 9

SELECT colname1, colname1+colname 2 aliasName FROM tableName;

Question 10

SQL Comparison Operators

Answer 10

=
>
<
>=
<=
<> (not equal)

Question 11

SQL Logical Operators

Answer 11

AND - both true
(WHERE City=’London’ AND ‘Paris’);

BETWEEN - within the range
(WHERE Price BETWEEN 50 AND 60, includes 50 and 60)

EXISTS (WHERE EXISTS Condition)

IN
(WHERE City IN(‘Paris’, ‘London’);

LIKE
(WHERE City LIKE ‘s%’)

NOT LIKE ‘’

OR
(same syntax with and)

Question 12

‘a%’

Answer 12

starting with a

Question 13

‘%a’

Answer 13

ending with a

Question 14

‘%a%’

Answer 14

contains a

Question 15

‘V%a%’

Answer 15

Starts with V and contains a