PostgreSQL RDBMS, Databases

Question: How do you alter a column to forbid null values?
A
alter table foo alter bar set not null;

B
alter table foo alter bar avoid null;

C
alter table foo alter bar forbid null;

D
alter table foo alter bar add not null;

E
None of these above

Note: Not available
1. Report
Question: What is the difference between to_tsvector() and ::tsvector ?
A
to_tsvector () normalizes the string while ::tsvector does not

B
to_tsvector () can be used in select statements, while ::tsvector cannot

C
They are equivalent

D
None of these above

Note: Not available
1. Report
Question: What is the storage size of an integer on a 64bit system?
A
8bytes

B
2bytes

C
16bytes

D
4bytes

E
64bytes

Note: Not available
1. Report
Question: Which function should be used to highlight the results?
A
ts_highlight

B
ts_tag

C
ts_headline

D
ts_select

E
None of these above

Note: Not available
1. Report
Question: Which PostgreSQL version added the enum datatype?
A
8.0

B
8.1

C
7.4

D
8.3

E
PostgreSQL doesn't have an enum type.

Note: Not available
1. Report
Question: When using LIKE to compare strings, what is the wildcard operator (operator which matches zero or more characters)?
A
*

B
$

C
%

D
&

E
None of these above

Note: Not available
1. Report
Question: For proper results, which of the following should contain a tsvector?
A
Lexemes

B
Tokens

C
Integers

D
Sets

E
Enum

Note: Not available
1. Report
Question: What is the command used to import a backup made with pg_dumpall > file.dmp?
A
pg_restore file.dmp

B
psql -f file.dmp

C
pg_restoreall file.dmp

D
postgre --restore -f file.dmp

E
None of these above

Note: Not available
1. Report
Question: 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

Note: Not available
1. Report
Question: 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 these above

Note: Not available
1. Report

First Prev 2 3 4 5 6 Next Last

Question: How do you alter a column to forbid null values?

Question: What is the difference between to_tsvector() and ::tsvector ?

Question: What is the storage size of an integer on a 64bit system?

Question: Which function should be used to highlight the results?

Question: Which PostgreSQL version added the enum datatype?

Question: When using LIKE to compare strings, what is the wildcard operator (operator which matches zero or more characters)?

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

Question: What is the command used to import a backup made with pg_dumpall > file.dmp?

Question: Which of the following statements will produce an error?

Question: What is the difference between tokens and lexemes?