PostgreSQL RDBMS, Databases

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
Question: What interfaces are available in the base distribution of PostgreSQL?
A
Java

B
PHP

C
C

D
Ruby

E
Perl

Note: Not available
1. Report
Question: What is the default ordering when ORDER BY is not specified?
A
By ID

B
By insertion date

C
By name

D
The ordering is unknown if not specified

E
None of these above

Note: Not available
1. Report
Question: What command will correctly restore a backup made with the following command? pg_dump -Fc dbname > filename
A
psql -f filename dbname

B
psql -Fc filename dbname

C
pg_restore filename dbname

D
pg_restore -d dbname filename

E
None of these

Note: Not available
1. Report
Question: How do you select a single random row from a table?
A
SELECT random() * FROM tab LIMIT 1;

B
SELECT * FROM tab ORDER BY random() LIMIT 1;

C
SELECT * FROM tab RANDOM LIMIT 1 ;

D
SELECT RANDOM 1 from tab;

E
None of these

Note: Not available
1. Report

First Prev 4 5 6 Next Last

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?

Question: What interfaces are available in the base distribution of PostgreSQL?

Question: What is the default ordering when ORDER BY is not specified?

Question: What command will correctly restore a backup made with the following command? pg_dump -Fc dbname > filename

Question: How do you select a single random row from a table?