Structured Query Language
Strong Question Language
Structured Question Language
None
SELECT Persons.FirstName
SELECT FirstName FROM Persons
EXTRACT FirstName FROM Persons
Can Primary Key be Null?
True
False
Can Sec Key be Null?
Can Composite Key be Null?
OBject Relational Database have entity relations?
Is DB2 database managament system?
Which SQL keyword is used to sort the result-set?
SORT BY
SORT
ORDER
ORDER BY
How can you change "Hansen" into "Nilsen" in the "LastName" column in the Persons table?
MODIFY Persons SET LastName='Nilsen' WHERE LastName='Hansen'
MODIFY Persons SET LastName='Hansen' INTO LastName='Nilsen
UPDATE Persons SET LastName='Hansen' INTO LastName='Nilsen'
UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen'
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