Correct Answer: SELECT * FROM tab ORDER BY random() LIMIT 1;
Explanation:
Note: This Question is unanswered, help us to find answer for this one
PostgreSQL Skill Assessment
Your Skill Level: Poor
Retake Quizzes to improve it
More PostgreSQL MCQ Questions
PostgreSQL triggers can be written in C directly.
A steel production company has two sales outlets. Both outlets are maintaining their data separately in servers SVA and SVD. Both outlets use the same structure for the Sales table. Which method will you use to create a combined sales report for both the outlets?
Which of the following is correct with regard to Password Authentication?
What is the default variable for the PROMPT3?
What is the default location of the standard elog?
When using LIKE to compare strings, what is the wildcard operator (operator which matches zero or more characters)?
What kind of triggers are offered by PostgreSQL?
What is the well known port number for the postgresql database service?
The following statement will retrieve the second element of the array column products in table store_products.SELECT products[1] FROM store_products;
An ISO-8601 time may be entered into a table using the numeric format 012411 instead of 01:24:11.