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
What library is used by PostgreSQL for encryption?
Which one of the following text search functions does not exist?
Out of the following backup approaches, which ones are applicable to PostgreSQL?
Which of the following statements will cast the integer value 1 to type text?
What is the storage size of an integer on a 64bit system?
What is the default ordering when ORDER BY is not specified?
What interfaces are available in the base distribution of PostgreSQL?
What is the ~ operator?
What can be stored in a column of type decimal(4,3)?
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?