PostgreSQL, Databases

Question: Which clause should be used to display the rows of a table in ascending order of a particular column?
A
Where

B
Order By

C
Group By

D
Having

E
First Group By and then Having

F
Like

G
Between

Note: Not available
1. Report
Question: Which of the following holds true if you have installed PL/pgSQL in the PgDatabase?
A
For all the subsequent databases that are created with PgDatabase as their template, the user must install PL/pgSQL

B
All the subsequent databases that are created with PgDatabase as their template, will have PL/pgSQL installed

C
For all the subsequent databases that are created with PgDatabase as their template, the user may or may not install PL/pgSQL

D
None of these above are correct

Note: Not available
1. Report
Question: Which of the following is not defined in the PL/pgSQL?
A
%Type

B
%Coltype

C
%Rowtype

D
ALIAS

Note: Not available
1. Report
Question: A handler named 'plpgsqlHandle()' is created for installing PL/pgSQL. For creating the handler on 'SwineDB' database you would issue a command:
A
SwineDB=# CREATE LANGUAGE 'pl/pgsql' HANDLER plpgsqlHandle SwineDB-# LANCOMPILER 'Install PL/pgSQL'; CREATE

B
SwineDB=# CREATE LANGUAGE 'pl/pgsql' EXECUTE plpgsqlHandle SwineDB-# LANCOMPILER 'Install PL/pgSQL'; CREATE

C
SwineDB=# CREATE LANGUAGE 'plpgsql' HANDLER plpgsqlHandle SwineDB-# LANCOMPILER 'Install PL/pgSQL'; CREATE

D
SwineDB=# CREATE LANGUAGE 'plpgsql' EXECUTE plpgsqlHandle SwineDB-# LANCOMPILER 'Install PL/pgSQL'; CREATE

Note: Not available
1. Report
Question: Normalization divides tables in a more useful and meaningful manner. Which statement is correct for the FIRST NORMAL FORM?
A
It includes only tables that do not have composite primary keys

B
It must have data stored in a two-dimensional table with no repeating groups

C
Every non-key column is non transitively dependent upon its primary key

D
None of these above

Note: Not available
1. Report
Question: What is the default location of the standard elog?
A
/var/log/messages

B
$PGDATA/serverlog

C
Any of these above

D
None of these above

Note: Not available
1. Report
Question: What does the pg_dump command do? pg_dump CustomerDatabase
A
It copies the database to specified location

B
It creates a list of SQL commands used to create db from scratch

C
None of these above

Note: Not available
1. Report
Question: What does the RAISE statement do in PL/pgSQL?
A
It logs the error to the logging utility

B
It displays the error to stderr

C
Both of these above

D
None of these above

Note: Not available
1. Report
Question: There are two tables A and B. You are retrieving data from both tables where all rows from table B and only matching rows from table A should be displayed. Which type of join will you apply between tables A and B?
A
Inner join

B
Left outer join

C
Right outer join

D
Self join

Note: Not available
1. Report
Question: Food Cart Accounting System (FOCAS) is maintaining products in the products table, and wants to see the products which are 50 or more numbers far from the minimum stock limit. The structure of the Products table is: ProductID ProductName CurrentStock MinimumStock Two possible queries are: Statement 1: select * from products where currentStock>MinimumStock+50 Statement 2: select * from products where currentStock-50>MinimumStock Select an option which is more suitable for these queries:
A
Only statement 1 is correct

B
Only statement 2 is correct

C
Both statements 1 and 2 are correct

D
Both statements 1 and 2 are incorrect

Note: Not available
1. Report

First Prev 2 3 4 5 6 Next Last

Question: Which clause should be used to display the rows of a table in ascending order of a particular column?

Question: Which of the following holds true if you have installed PL/pgSQL in the PgDatabase?

Question: Which of the following is not defined in the PL/pgSQL?

Question: A handler named 'plpgsqlHandle()' is created for installing PL/pgSQL. For creating the handler on 'SwineDB' database you would issue a command:

Question: Normalization divides tables in a more useful and meaningful manner. Which statement is correct for the FIRST NORMAL FORM?

Question: What is the default location of the standard elog?

Question: What does the pg_dump command do? pg_dump CustomerDatabase

Question: What does the RAISE statement do in PL/pgSQL?

Question: There are two tables A and B. You are retrieving data from both tables where all rows from table B and only matching rows from table A should be displayed. Which type of join will you apply between tables A and B?