550+ Câu hỏi trắc nghiệm lập trình cơ sở dữ liệu SQL - Phần 1

Strong Question Language

Structured Question Language

Structured Query Language

Get

Open

Extract

Select

Update

Save as

Modify

Save

Truncate

Delete

Remove

Add recrd

Add into

Insert

Add new

Extract FirstName FROM Persons

Select FirstName FROM Persons

Slect Persons.FirstName

Select [all] FROM Persons

Select All Persons

Select *.Persons

Select * FROM Persons

Select [all] FROM Persons WHERE FirstName=’Peter’

Select * FROM Persons WHERE FirstName LIKE’Peter’

Select [all] FROM Persons WHERE FirstName LIKE’Peter’

Select * FROM Persons WHERE FirstName=’Peter’

Select * From Persons WHERE FirstName='%a%'

Select * From Persons WHERE FirstNameLIKE %

Select * From Persons WHERE FirstName=’a’

Select * From Persons WHERE FirstName='a%'

Đúng

Sai

SELEC * FROM Persons WHERE FirstName LIKE ‘Peter” AND LastName LIKE ‘Jackson’

SELEC * FROM Persons WHERE FirstName=’Peter’ AND LastName=’Jackson’

SELECT FirstName=’Peter’, LastName=’Jackson’ FROM Persons

SELECT LastName>’Hansen’ AND LastName<’Pettersen’ FROM Persons

SELECT * FROM Persons WHERE LastName BETWEEN ‘Hansen” AND ‘Pettersen’

SELECT * FROM Persons WHERE LastName>’Hansen’ AND LastName<’Pettersen’

SELECT UNIQUE

SELECT INDENTITY

SELECT DIFFERNT

SELECT DISTINCT

SORT BY

ORDER

ORDER BY

SORT

SELECT * FROM Persons SORT BY ‘FirstName’ DESC

SELECT * FROM Persons ORDER BY FirstName DESC

SELECT * FROM Persons ORDER FirstName DESC

SELECT * FROM Persons SORT ‘FirstName’ DESC

INSERT INTO Persons VALUES (‘Jimmy’, ‘Jackson’)

INSERT (‘Jimmy’, ‘Jackson’) INTO Persons

INSERT VALUES (‘Jimmy’, ‘Jackson’) INTO Persons

INSERT INTO Persons (LastName) VALUES (‘Olsen’)

INSERT (‘Olsen’) INTO Persons (LastName)

INSERT INTO Persons (‘Olsen’) INTO LastName

UPDATE Persons SET LastName='Hansen' INTO LastName='Nilsen'

UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen'

MODIFY Persons SET LastName='Hansen' INTO LastName='Nilsen'

MODIFY Persons SET LastName='Nilsen' WHERE LastName='Hansen'

DELETE FROM Persons WHERE FirstName = ‘Peter’

DELETE ROW FirstName= ‘Peter’ FROM Persons

DELETE FirstName= ‘Peter’ FROM Persons

SELECT COLUMNS () FROM Persons

SELECT COUNT (*) FROM Persons

SELECT COLUMNS (*) FROM Persons

SELECT COUNT () FROM Persons

1

2

3

Câu trả lời khác

Đúng

Sai

Đúng

Sai

EXPLICIT

IMPLICIT

EXCLUSIVE

SHARED

DROP

REMOVE ROW

DELETE

DELETE ROW

Đúng

Sai

Đúng

Sai

Right

Right outer

Full outer

Tất cả đáp án trên

GET

OPEN

SELECT

EXTRACT

MODIFY

SAVE AS

SAVE

UPDATE

REMOVE

DELETE

COLLAPSE

DROP

ADD RECORD

ADD NEW

INSERT INTO

INSERT NEW

SELECT FirstName FROM Persons

SELECT Persons.FirstName

SELECT [all] FROM Persons

SELECT * FROM Persons

SELECT *.Persons

SELECT Persons

SELECT [all] FROM Persons WHERE FirstName='Peter'

SELECT [all] FROM Persons WHERE FirstName LIKE 'Peter'

SELECT * FROM Persons WHERE FirstName<>'Peter'

SELECT * FROM Persons WHERE FirstName='Peter'

SELECT * FROM Persons WHERE FirstName LIKE '%a'

SELECT * FROM Persons WHERE FirstName LIKE 'a%'

SELECT * FROM Persons WHERE FirstName='%a%'

SELECT * FROM Persons WHERE FirstName='a'

Đúng

Sai

SELECT * FROM Persons WHERE FirstName='Peter' AND LastName='Jackson'

SELECT * FROM Persons WHERE FirstName<>'Peter' AND LastName<>'Jackson'

SELECT FirstName='Peter', LastName='Jackson' FROM Persons

SELECT * FROM Persons WHERE LastName>'Hansen' AND LastName<'Pettersen'

SELECT LastName>'Hansen' AND LastName<'Pettersen' FROM Persons

SELECT * FROM Persons WHERE LastName BETWEEN 'Hansen' AND 'Pettersen'

SELECT UNIQUE

SELECT DISTINCT

SELECT DIFFERENT

SORT BY

SORT

ORDER

ORDER BY

SELECT * FROM Persons SORT BY 'FirstName' DESC

SELECT * FROM Persons ORDER BY FirstName DESC

SELECT * FROM Persons SORT 'FirstName' DESC

SELECT * FROM Persons ORDER FirstName DESC

INSERT INTO Persons VALUES ('Jimmy', 'Jackson')

INSERT VALUES ('Jimmy', 'Jackson') INTO Persons

INSERT ('Jimmy', 'Jackson') INTO Persons

INSERT ('Olsen') INTO Persons (LastName)

INSERT INTO Persons ('Olsen') INTO LastName

INSERT INTO Persons (LastName) VALUES ('Olsen')

MODIFY Persons SET LastName='Nilsen' WHERE LastName='Hansen'

UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen'

MODIFY Persons SET LastName='Hansen' INTO LastName='Nilsen

UPDATE Persons SET LastName='Hansen' INTO LastName='Nilsen'

DELETE FirstName='Peter' FROM Persons

DELETE ROW FirstName='Peter' FROM Persons

DELETE FROM Persons WHERE FirstName = 'Peter'

SELECT COLUMNS(*) FROM Persons

SELECT COUNT(*) FROM Persons

SELECT LEN(*) FROM Persons

SELECT NO(*) FROM Persons

INNER JOIN

INSIDE JOIN

JOINED TABLE

JOINED

RANGE

BETWEEN

WITHIN

Đúng

Sai