SQL-Query 1

SQL is the abbreviation of

• Stream Query Language

• State Query Language

• Structured Query Language

SQL is include

• DDL, DML, DCL

• DDL, DML, ACL

• DLL, DML, DCL

Data Manipulation Language - DML is used to

• create a table

• Insert data

• Delete data

• create a database

• update data

Which syntax is correct

• SELECT *

  FROM <table_name>

• SELECT *

  FROM <database_name>.<table_name>

• SELECT <column_name_1>,

  <column_name_2> AS <alias_name>

  FROM <table_name>

• SELECT <column_name_1>,

  <column_name_2> AS <alias_name>

  FROM <database_name>.<table_name>

Add 1 word to this sentence which selects all column in Hocvien table

Select ______from hocvien

Hocvien table have column: MaHV, Ho, Ten, NamSinh.

which columns print out if you run the query:

select MaHV, Ten from HocVien

• All columns

• MaHV, Ho, Ten

• MaHV, Ten

Hocvien table have column: MaHV, Ho, Ten, NamSinh.

which columns print out if you run the query:

select Ho + Ten as HoTen from HocVien

• All columns

• MaHV, Ho, Ten, NamSinh.

• Ho, Ten

• HoTen

Hocvien table has columns: MaHV, Ho, Ten, NamSinh.

which values/ records print out if you run the query:

select *

from HocVien

where mahv is not null

• all records in HocVien table

• No records print out

• records which mahv > 100

Hocvien table has columns: MaHV, Ho, Ten, NamSinh.

which values/ records print out if you run the query:

select *

from HocVien

where mahv in (1, 5)

• records which have mahv = 1 or mahv = 5

• records which have mahv from 1 to 5

Hocvien table has columns: MaHV, Ho, Ten, NamSinh.

which values/ records print out if you run the query:

select *

from HocVien

order by ten

• print out the values with order ten ascending (ASC)

• print out the values with order ten descending (DESC)