In context to Database management system which of the following is CORRECT…
2023
In context to Database management system which of the following is CORRECT regarding query by example?
I. A Query by example form collects all information from a user for composing query language statements for search criterion. II. Query by example relieves users from remembering query language keywords and using them with correct syntax to form quires.
- A.
Only I
- B.
Neither I nor II
- C.
Both I and II
- D.
Only II
Attempted by 160 students.
Show answer & explanation
Correct answer: C
Query by Example (QBE) is a user-friendly, graphical database query language meant for relational databases. Instead of making users write structured code like SQL (e.g., SELECT * FROM Users WHERE Age > 25), it provides a visual grid or form template that resembles the database table structure.
Analyzing Statement I:
"A Query by example form collects all information from a user for composing query language statements for search criterion."
Analysis: Correct. In a QBE interface, the user specifies their search parameters directly inside a blank form or skeleton table layout. The database engine then takes these filled details (the criteria/examples provided by the user) and converts them internally into operational query statements (like SQL commands) to search and retrieve the requested data.
Analyzing Statement II:
"Query by example relieves users from remembering query language keywords and using them with correct syntax to form quires."
Analysis: Correct. Since QBE is completely graphical, users do not need to memorize strict keyword syntaxes, proper command nesting, or comma/semicolon rules. They simply type what they are looking for directly into the appropriate column boxes of the table view. This heavily lowers the barrier to entry for non-technical users.
Because both statements accurately define the mechanism and the fundamental purpose of QBE, Both I and II are correct.