PostgreSQL RDBMS Test

PostgreSQL RDBMS Test


For proper results, which of the following should contain a tsvector?

a. Lexemes
b. Tokens
c. Integers
d. Sets
e. Enum

To backup a database, the postmaster daemon must be halted.

a. True
b. False

The following statement will retrieve the second element of the array column products in table store_products.

SELECT products[1] FROM store_products;

a. True
b. False

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;
e. None

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

SELECT ‘infinity’::timestamp;

Will this statement produce an error?

a. Yes
b. No

SELECT rtrim(‘foobar’, ‘abr’);

The result of this statement is foo.

a. True
b. False


What output will this statement give?

a. true
b. 3
c. 6
d. The statement is invalid.
e. None of the above.

Prev1 of 7

Share This Post