Search Header Logo

SQL-Query 1

Authored by Văn Phương

Education

1st - 5th Grade

11 Questions

Used 25+ times

SQL-Query 1
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

SQL is the abbreviation of

Stream Query Language

State Query Language

Structured Query Language

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

SQL is include

DDL, DML, DCL

DDL, DML, ACL

DLL, DML, DCL

3.

MULTIPLE SELECT QUESTION

45 sec • 1 pt

Data Manipulation Language - DML is used to

create a table

Insert data

Delete data

create a database

update data

4.

MULTIPLE SELECT QUESTION

1 min • 1 pt

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>

5.

FILL IN THE BLANK QUESTION

45 sec • 1 pt

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


Select ______from hocvien

6.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

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

7.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

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

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?