Rdbms -2-bulit in functions

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'