With SQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"?
SELECT * FROM Persons ORDER FirstName DESC
SELECT * FROM Persons SORT BY 'FirstName' DESC
SELECT * FROM Persons ORDER BY FirstName DESC
SELECT * FROM Persons SORT 'FirstName' DESC
With SQL, how can you insert a new record into the "Persons" table?
INSERT INTO Persons VALUES ('Jimmy', 'Jackson')
INSERT ('Jimmy', 'Jackson') INTO Persons
INSERT VALUES ('Jimmy', 'Jackson') INTO Persons
With SQL, how can you insert "Olsen" as the "LastName" in the "Persons" table?
INSERT ('Olsen') INTO Persons (LastName)
INSERT INTO Persons (LastName) VALUES ('Olsen')
INSERT INTO Persons ('Olsen') INTO LastName
INSERT FROM Persons ('Olsen') INTO LastName
How can you change "Hansen" into "Nilsen" in the "LastName" column in the Persons table?
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'
With SQL, how can you delete the records where the "FirstName" is "Peter" in the Persons Table?
DELETE FROM Persons WHERE FirstName = 'Peter'
DELETE FirstName='Peter' FROM Persons
DELETE ROW FirstName='Peter' FROM Persons
DELETE FROM Persons WHERE FirstName <> 'Peter'
With SQL, how can you return the number of records in the "Persons" table?
SELECT COUNT() FROM Persons
SELECT COLUMNS() FROM Persons
SELECT COLUMNS(*) FROM Persons
SELECT COUNT(*) FROM Persons
In how many ways the Funnel Stage can operate?
Four
Three
Two
Only one
Select statement in Sybase can include columns not specified in the GROUP BY clause
True
False
This tool compares two files and produces a detailed report on the mismatches and successful matches. Used extensively in data validation.
QUEST TOAD FOR ORACLE 9
None
SCOOTER SOFTWARE BEYOND COMPARE 3
EMBARCADERO DB ARTISAN 8
In Sybase we can not compare a date column with a varchar value.