1) What does DML stand for ?
Different Mode Level![]()
Data Model Language![]()
Data Mode Lane![]()
Data Manipulation language![]()
Answer : D Discuss
2) With SQL, how do you select all the records from a table named “Persons” where the value of the column “FirstName” ends with an “a” ?
SELECT * FROM Persons WHERE FirstName=’a’![]()
SELECT * FROM Persons WHERE FirstName LIKE ‘a%’![]()
SELECT * FROM Persons WHERE FirstName LIKE ‘%a’![]()
SELECT * FROM Persons WHERE FirstName=’%a%’![]()
Answer : C Discuss
3) With SQL, how can you return all the records from a table named “Persons” sorted descending by “FirstName” ?
SELECT * FROM Persons SORT BY ‘FirstName’ DESC![]()
SELECT * FROM Persons ORDER FirstName DESC![]()
SELECT * FROM Persons SORT ‘FirstName’ DESC![]()
SELECT * FROM Persons ORDER BY FirstName DESC![]()
Answer : D Discuss
4) With SQL, how can you return the number of not null records in the “Persons” table ?
SELECT COUNT() FROM Persons![]()
SELECT COLUMNS() FROM Persons![]()
SELECT COLUMNS(*) FROM Persons![]()
SELECT COUNT(*) FROM Persons![]()
Answer : A Discuss
5) What does the ALTER TABLE clause do ?
The SQL ALTER TABLE clause modifies a table definition by altering, adding, or deleting table columns and/or constraints![]()
The SQL ALTER TABLE clause is used to insert data into database table![]()
THE SQL ALTER TABLE deletes data from database table![]()
The SQL ALTER TABLE clause is used to delete a database table![]()
Answer : A Discuss
6) The UPDATE SQL clause can
update only one row at a time![]()
update more than one row at a time![]()
delete more than one row at a time![]()
delete only one row at a time![]()
Answer : B Discuss
7) The UNION SQL clause can be used with
SELECT clause only![]()
DELETE and UPDATE clauses![]()
UPDATE clause only![]()
All oF the mentioned![]()
Answer : A Discuss
8) Which SQL statement is used to return only different values ?
9) Which SQL keyword is used to sort the result-set ?
10) How can you change “Hansen” into “Nilsen” in the “LastName” column in the Persons table?
UPDATE Persons SET LastName=’Hansen’ INTO LastName=’Nilsen’![]()
MODIFY Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’![]()
MODIFY Persons SET LastName=’Hansen’ INTO LastName=’Nilsen’![]()
UPDATE Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’![]()
Answer : D Discuss