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.

  1. A.

    Only I

  2. B.

    Neither I nor II

  3. C.

    Both I and II

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

Explore the full course: Niacl Ao It Specialist