With SQL, how can you return the number of records in the "Persons" table?
SELECT COLUMNS(*) FROM Persons ;
SELECT COUNT() FROM Persons;
SELECT COUNT(*) FROM Persons;
SELECT COLUMNS() FROM Persons;
With SQL, how do you select all the records from a table named "Persons" where the "FirstName" is "Peter" and the "LastName" is "Jackson"?
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
With SQL, how do you select all the records from a table named "Persons" where the "LastName" is alphabetically between (and including) "Hansen" and "Pettersen"?
SELECT * FROM Persons WHERE LastName>'Hansen' AND LastName
SELECT * FROM Persons WHERE LastName BETWEEN 'Hansen' AND 'Pettersen' ;
SELECT LastName>'Hansen' AND LastName
SELECT LastName LIKE'%Hansen%' AND LastName LIKE '%Pettersen%' FROM Persons ;
With SQL, how can you insert a new record into the "Persons" table?
INSERT ('Jimmy', 'Jackson') INTO Persons ;
INSERT VALUES ('Jimmy', 'Jackson') INTO Persons ;
INSERT INTO Persons VALUES ('Jimmy', 'Jackson') ;
INSERT VALUES ('Jimmy', 'Jackson') INTO Table Persons ;
With SQL, how can you insert "Olsen" as the "LastName" in the "Persons" table?
INSERT INTO Persons ('Olsen') INTO LastName ;
INSERT INTO Persons (LastName) VALUES ('Olsen');
INSERT ('Olsen') INTO Persons (LastName) ;
INSERT INTO Table Persons (LastName) VALUES ('Olsen');
Which SQL statement is used to delete data and its tablespace from a database?
DELETE
TRUNCATE
REMOVE
None of the Above
With SQL, how do you select a column named "FirstName" from a table named "Persons"?
SELECT Persons.FirstName ;
EXTRACT FirstName FROM Persons ;
SELECT FirstName FROM Persons;
EXTRACT Persons.FirstName
Which SQL statement is used to return only different values?
SELECT DIFFERENT
SELECT DISTINCT
SELECT UNIQUE
All of the above
What does SQL stand for?
Structured Query Language
Strong Question Language
Structured Question Language
Identify whether the following statement is true or false
True
False