PostgreSQL RDBMS, Databases

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
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

First Prev 3 4 5 6 Next Last

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?

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?