Tag: databases

SELECT COLUMNS(*) FROM Persons ;

SELECT COUNT() FROM Persons;

SELECT COUNT(*) FROM Persons;

SELECT COLUMNS() FROM Persons;

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

SELECT * FROM Persons WHERE FirstName LIKE 'Peter' AND LastName LIKE 'Jackson';

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

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

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

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

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

SELECT LastName LIKE'%Hansen%' AND LastName LIKE '%Pettersen%' FROM Persons ;

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

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

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

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

INSERT INTO Persons ('Olsen') INTO LastName ;

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

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

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

DELETE

TRUNCATE

REMOVE

None of the Above

SELECT Persons.FirstName ;

EXTRACT FirstName FROM Persons ;

SELECT FirstName FROM Persons;

EXTRACT Persons.FirstName

SELECT DIFFERENT

SELECT DISTINCT

SELECT UNIQUE

All of the above

Structured Query Language

Strong Question Language

Structured Question Language

None of the Above

True

False