Databases - Upwork

Question: While creating a table with a field of the serial type, a sequence will be created.
A
True

B
False

Note: Not available
1. Report
Question: An ISO-8601 time may be entered into a table using the numeric format 012411 instead of 01:24:11.
A
True

B
False

Note: Not available
1. Report
Question: SELECT rtrim('foobar', 'abr'); The result of this statement is foo.
A
True

B
False

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

Note: Not available
1. Report
Question: To backup a database, the postmaster daemon must be halted.
A
True

B
False

Note: Not available
1. Report
Question: While creating a trigger, the function it will call may be created after it and attached to it.
A
True

B
False

Note: Not available
1. Report
Question: On a UNIX system, what is the best way to prevent all non-local connections to the postmaster?
A
Using ipfilte

B
Using UNIX sockets

C
Using TCP port 0

D
Using an empty pg_hba.conf

E
None of these above

Note: Not available
1. Report
Question: After a PostgreSQL installation, how will you create the database cluster?
A
With created

B
With initd

C
With createdbs

D
With postmaste

E
None of these above

Note: Not available
1. Report
Question: How will you change the TCP port which PostgreSQL will listen to?
A
PostgreSQL does not support TCP

B
By changing "port" in postgresql.conf

C
By issuing UPDATE config SET port = <newvalue

D
TCP port cannot be changed

E
None of these above

Note: Not available
1. Report
Question: Which of the following queries will create a table with two fields, "id" and "name" with "id" as an auto incrementing primary key?
A
create table foo (id int serial primary key auto, name varchar(255));

B
create table foo (id int auto_increment primary key, name varchar(255));

C
create table foo (id auto_increment primary key, name varchar(255));

D
create table foo (id serial primary key, name varchar(255));

E
None of these above

Note: Not available
1. Report

First Prev 45 46 47 48 49 Next Last

Question: While creating a table with a field of the serial type, a sequence will be created.

Question: An ISO-8601 time may be entered into a table using the numeric format 012411 instead of 01:24:11.

Question: SELECT rtrim('foobar', 'abr'); The result of this statement is foo.

Question: The following statement will retrieve the second element of the array column products in table store_products. SELECT products[1] FROM store_products;

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

Question: While creating a trigger, the function it will call may be created after it and attached to it.

Question: On a UNIX system, what is the best way to prevent all non-local connections to the postmaster?

Question: After a PostgreSQL installation, how will you create the database cluster?

Question: How will you change the TCP port which PostgreSQL will listen to?

Question: Which of the following queries will create a table with two fields, "id" and "name" with "id" as an auto incrementing primary key?