A text string is a string of text like this: 'Hello world'.
A trigger is (usually) a piece of code that is kicked off ("triggered") by some event - usually by an insert, update or delete of a row in a table.
A cursor is a pointer to the rows from a select statement.
I suggest you get yourself an introductory book on databases to learn more.