Databases - Upwork

Question: Which of the following statements will create a table with a multidimensional array as second column?
A
CREATE TABLE favorite_books (customer_id integer, themes_and_titles text[[]]);

B
CREATE TABLE favorite_books (customer_id integer, themes_and_titles text[][]);

C
CREATE TABLE favorite_books (customer_id integer, themes_and_titles text{2});

D
CREATE TABLE favorite_books (customer_id integer, themes_and_titles text[text]);

Note: Not available
1. Report
Question: If max_connections is 10 and 10 connections are currently active, how can you be sure the superuser will be available to connect?
A
You cannot

B
Leave a superuser connected all the time

C
Set superuser_reserved_connections in postgresql.conf

D
Kill postmaster and connect to it

E
None of these above

Note: Not available
1. Report
Question: How will you rank text search results?
A
With the ORDER BY operator

B
With the ts_rank function

C
Search results are automatically ranked

D
Search results cannot be ranked

E
None of these above

Note: Not available
1. Report
Question: Which of the following statements will create a table special_products which is a child of the table store_products?
A
CREATE TABLE special_products (quality int) INHERITS store_products;

B
CREATE TABLE special_products (quality int) EXTENDS store_products;

C
CREATE TABLE special_products (quality int) EXPANDS store_products;

D
CREATE TABLE special_products (quality int) FROM store_products;

E
CREATE TABLE special_products (quality int) WITH PARENT store_products;

Note: Not available
1. Report
Question: Which of the following statements will create a table?
A
SELECT INTO products_backup FROM special_products;

B
SELECT FROM special_products * INTO products_backup;

C
SELECT * INTO products_backup LIKE special_products;

D
SELECT * INTO products_backup FROM special_products;

E
SELECT COPY special_products INTO products_backup;

Note: Not available
1. Report
Question: Which of the following statements will retrieve the number of values stored in an array column?
A
SELECT array_dims(products) FROM store_products;

B
SELECT products[] FROM store_products;

C
SELECT dimensions(products) FROM store_products;

D
SELECT array_dim(products) FROM store_products;

E
SELECT count(products) FROM store_products;

Note: Not available
1. Report
Question: What is the effect of turning fsync off in postgresql.conf?
A
File synchronization will be deactivated

B
fsync is not a valid configuration option

C
PostgreSQL will not enforce write ahead log flush

D
It will turn off fast synchronization

E
None of these above

Note: Not available
1. Report
Question: Given a table special_products that inherits from a table store_products, which of the following statements will modify store_products only without affecting its child table?
A
UPDATE store_products ONLY SET name = 'Wine' WHERE id = 2;

B
UPDATE store_products SET name= 'Wine' WHERE id = 2;

C
UPDATE ONLY store_products SET name = 'Wine' WHERE id = 2;

D
UPDATE JUST store_products SET name = 'Wine' WHERE id = 2;

E
UPDATE store_products NOT special_products SET name = 'Wine' WHERE id = 2;

Note: Not available
1. Report
Question: What can be stored in a column of type decimal(4,3)?
A
4 numeric values with up to 3 digits to the right of the decimal point.

B
A numeric value with up to 7 digits in total, 3 of which can be to the right of the decimal point.

C
A numeric value with up to 4 digits in total, 3 of which can be to the right of the decimal point.

D
A numeric value with at least 4 digits, 3 of which must be to the right of the decimal point.

Note: Not available
1. Report
Question: What is the ~ operator?
A
POSIX regular expression match operator

B
XOR operator

C
NOT operator

D
Home directory ENV variable

E
None of these above

Note: Not available
1. Report

First Prev 48 49 50 51 52 Next Last

Question: Which of the following statements will create a table with a multidimensional array as second column?

Question: If max_connections is 10 and 10 connections are currently active, how can you be sure the superuser will be available to connect?

Question: How will you rank text search results?

Question: Which of the following statements will create a table special_products which is a child of the table store_products?

Question: Which of the following statements will create a table?

Question: Which of the following statements will retrieve the number of values stored in an array column?

Question: What is the effect of turning fsync off in postgresql.conf?

Question: Given a table special_products that inherits from a table store_products, which of the following statements will modify store_products only without affecting its child table?

Question: What can be stored in a column of type decimal(4,3)?

Question: What is the ~ operator?