Databases - Upwork

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
Question: Which kind of index can be declared unique?
A
Hash

B
A-tree

C
B-tree

D
GIN

E
GiST

Note: Not available
1. Report
Question: SELECT !!3; What output will this statement give?
A
true

B
3

C
6

D
The statement is invalid.

E
None of these above.

Note: Not available
1. Report
Question: How do you create a table with a field of the int array type?
A
create table foo (bar int array);

B
create table foo (bar integer[]);

C
create table foo (bar array int);

D
create table foo (bar[] int);

E
None of these above

Note: Not available
1. Report
Question: What is the name of the special time input with value 00:00:00.00 UTC?
A
zero

B
noon

C
midnight

D
allballs

E
None of these above

Note: Not available
1. Report
Question: Consider the following empty table: CREATE TABLE example ( a integer, b integer, c integer, UNIQUE (a, c) ); Which of the following inserts will cause an error?
A
insert into example (a, b, c) values (1, 2, 3), (1, 2, 4);

B
insert into example (a, b, c) values (1, 2, 3), (3, 3, 3);

C
insert into example (a, b, c) values (1, 1, 1), (3, 3, 3);

D
insert into example (a, b, c) values (1, 2, 3), (1, 4, 3);

E
None will cause an error

Note: Not available
1. Report

First Prev 47 48 49 50 51 Next Last

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?

Question: Which kind of index can be declared unique?

Question: SELECT !!3; What output will this statement give?

Question: How do you create a table with a field of the int array type?

Question: What is the name of the special time input with value 00:00:00.00 UTC?

Question: Consider the following empty table: CREATE TABLE example ( a integer, b integer, c integer, UNIQUE (a, c) ); Which of the following inserts will cause an error?