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

A. Strong Question Language

B. Structured Question Language

C. Structured Query Language

A. Get

B. Open

C. Extract

D. Select

A. Truncate

B. Delete

C. Remove

A. Update

B. Save as

C. Modify

D. Save

A. Extract FirstName FROM Persons

B. Select FirstName FROM Persons

C. Slect Persons.FirstName

A. Add recrd

B. Add into

C. Insert

D. Add new

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

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

C. SELECT * FROM Persons WHERE LastName>’Hansen’ AND LastName

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

A. Đúng

B. Sai

A. Đúng

B. Sai

A. EXPLICIT

B. IMPLICIT

C. EXCLUSIVE

D. SHARED

A. DROP

B. REMOVE ROW

C. DELETE

D. DELETE ROW

A. Đúng

B. Sai

A. Đúng

B. Sai

A. Right

B. Right outer

C. Full outer

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

A. GET

B. OPEN

C. SELECT

D. EXTRACT

A. MODIFY

B. SAVE AS

C. SAVE

D. UPDATE

A. REMOVE

B. DELETE

C. COLLAPSE

D. DROP

A. ADD RECORD

B. ADD NEW

C. INSERT INTO

D. INSERT NEW

A. EXTRACT FirstName FROM Persons

B. SELECT FirstName FROM Persons

C. SELECT Persons.FirstName

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

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

C. SELECT * FROM Persons WHERE FirstName'Peter'

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

A. SELECT [all] FROM Persons

B. SELECT * FROM Persons

C. SELECT *.Persons

D. SELECT Persons

A. SELECT * FROM Persons WHERE FirstName LIKE '%a'

B. SELECT * FROM Persons WHERE FirstName LIKE 'a%'

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

D. SELECT * FROM Persons WHERE FirstName='a'

A. Đúng

B. Sai

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

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

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

A. SELECT * FROM Persons WHERE LastName>'Hansen' AND LastName

B. SELECT LastName>'Hansen' AND LastName

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

A. SORT BY

B. SORT

C. ORDER

D. ORDER BY

A. SELECT UNIQUE

B. SELECT DISTINCT

C. SELECT DIFFERENT

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

B. SELECT * FROM Persons ORDER BY FirstName DESC

C. SELECT * FROM Persons SORT 'FirstName' DESC

D. SELECT * FROM Persons ORDER FirstName DESC

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

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

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

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

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

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

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

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

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

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

A. SELECT COLUMNS(*) FROM Persons

B. SELECT COUNT(*) FROM Persons

C. SELECT LEN(*) FROM Persons

D. SELECT NO(*) FROM Persons

A. DELETE FirstName='Peter' FROM Persons

B. DELETE ROW FirstName='Peter' FROM Persons

C. DELETE FROM Persons WHERE FirstName = 'Peter'

A. RANGE

B. BETWEEN

C. WITHIN

A. INNER JOIN

B. INSIDE JOIN

C. JOINED TABLE

D. JOINED

A. Đúng

B. Sai

A. 1

B. 2

C. 3

D. Câu trả lời khác