WorksheetsRdbms -2-bulit in functions
Total questions: 15
Worksheet time: 8mins
TRUNC(25.456,-1)
25.45
25.4
20
30
POWER(5,3)
15
53
25
125
ABS(-1000)
-1
-1000
+1
1000
SIGN(+50)
+1
-1
50
51
MOD(3,5)
3
5
2
1
FLOOR(54.7)
54
55
54.0
CEIL(54.3)
54
54.0
55
54.5
WHICH STATEMENT IS USED TO WRITE DML STATEMENTS TO THE DISK
COMMIT
INSERT
ROLLBACK
WRITE
WHICH STATEMENTS IS USED TO UNDO THE LAST SET OF DML STATEMENT
ROLL BACK
COMMIT
INSERT
UNDO
With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" starts 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'
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 FirstName='Peter', LastName='Jackson' FROM Persons
SELECT FROM Persons WHERE FirstName='Peter' AND LastName='Jackson'
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 LastName>'Hansen' AND LastName<'Pettersen' FROM Persons
SELECT FROM Persons WHERE LastName>'Hansen' AND LastName<'Pettersen'
SELECT FROM Persons WHERE LastName BETWEEN 'Hansen' AND 'Pettersen'
How can you change "Hansen" into "Nilsen" in the "LastName" column in the Persons table?
MODIFY Persons SET LastName='Nilsen' WHERE LastName='Hansen'
UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen
'MODIFY Persons SET LastName='Hansen' INTO LastName='Nilsen
UPDATE Persons SET LastName='Hansen' INTO LastName='Nilsen'
With SQL, how can you return the number of records in the "Persons" table?
SELECT NO(*) FROM Persons
SELECT COUNT(*) FROM Persons
SELECT COLUMNS(*) FROM Persons
SELECT LEN(*) FROM Persons
ROUND(25.456,2)
25.2
25.4
2.45
25.5
