PostgreSQL RDBMS Test
For proper results, which of the following should contain a tsvector?
To backup a database, the postmaster daemon must be halted.
The following statement will retrieve the second element of the array column products in table store_products.
SELECT products FROM store_products;
Which of the following statements will produce an error?
a. SELECT now()::timestamp;
b. SELECT now()::int;
c. SELECT now()::varchar;
d. SELECT now()::char;
What is the difference between tokens and lexemes?
a. Tokens are always in upper case
b. Lexemes are normalized
c. A lexeme is a string while a token is an intege
d. Lexemes are always in upper case
e. None of the above
Will this statement produce an error?
SELECT rtrim(‘foobar’, ‘abr’);
The result of this statement is foo.
What output will this statement give?
d. The statement is invalid.
e. None of the above.