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.

Answer: C. Both I and IIQuery by Example (QBE) is a user-friendly, graphical database query language meant for relational databases. Instead of making users write structured code…

  1. A.

    Only I

  2. B.

    Neither I nor II

  3. C.

    Both I and II

  4. D.

    Only II

Attempted by 636 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

Loading lesson…