1300+ câu trắc nghiệm Quản trị hệ thống có đáp án - Phần 25

A. Strong Question Language

B. Structured Question Language

C. Structured Query Language

A. Get

B. Open

C. Extract

D. Select

A. Update

B. Save as

C. Modify

D. Save

A. Truncate

B. Delete

C. Remove

A. Add recrd

B. Add into

C. Insert

D. Add new

A. Extract FirstName FROM Persons

B. Select FirstName FROM Persons

C. Slect Persons.FirstName

A. Select [all] FROM Persons

B. Select All Persons

C. Select *.Persons

D. Select * FROM Persons

A. Select [all] FROM Persons WHERE FirstName='Peter'

B. Select * FROM Persons WHERE FirstName LIKE'Peter'

C. Select [all] FROM Persons WHERE FirstName LIKE'Peter'

D. Select * FROM Persons WHERE FirstName='Peter'

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

B. Select * From Persons WHERE FirstNameLIKE %

C. Select * From Persons WHERE FirstName='a'

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

A. Đúng

B. Sai

A. SELEC * FROM Persons WHERE FirstName LIKE 'Peter" AND LastName LIKE 'Jackson'

B. SELEC * FROM Persons WHERE FirstName='Peter' AND LastName='Jackson'

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

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

B. SELECT * FROM Persons WHERE LastName BETWEEN 'Hansen" AND 'Pettersen'

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

A. SELECT UNIQUE

B. SELECT INDENTITY

C. SELECT DIFFERNT

D. SELECT DISTINCT

A. SORT BY

B. ORDER

C. ORDER BY

D. SORT

A. SELECT * FROM Persons SORT BY 'FirstName' DESC

B. SELECT * FROM Persons ORDER BY FirstName DESC

C. SELECT * FROM Persons ORDER FirstName DESC

D. SELECT * FROM Persons SORT 'FirstName' DESC

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

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

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

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

B. INSERT ('Olsen') INTO Persons (LastName)

C. INSERT INTO Persons ('Olsen') INTO LastName

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

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

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

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

A. DELETE FROM Persons WHERE FirstName = 'Peter'

B. DELETE ROW FirstName= 'Peter' FROM Persons

C. DELETE FirstName= 'Peter' FROM Persons

A. SELECT COLUMNS () FROM Persons

B. SELECT COUNT () FROM Persons

C. SELECT COLUMNS () FROM Persons

D. SELECT COUNT () FROM Persons