FC0-U61 · Question #525
A database administrator is writing code to ask the database a question. Which of the following is the administrator doing?
The correct answer is C. Creating a query. This question describes the act of formulating a request for specific information from a database and asks for the correct term for this action.
Question
A database administrator is writing code to ask the database a question. Which of the following is the administrator doing?
Options
- AManipulating data
- BMining data
- CCreating a query
- DMaking a report
How the community answered
(26 responses)- A4% (1)
- B4% (1)
- C85% (22)
- D8% (2)
Why each option
This question describes the act of formulating a request for specific information from a database and asks for the correct term for this action.
Manipulating data involves inserting, updating, or deleting records, which is a different operation from merely asking a question to retrieve data.
Mining data is the process of discovering patterns and insights from large datasets, which is a more complex analytical process than simply asking a question.
When a database administrator writes code to "ask the database a question," they are creating a query. A query is a request for data or information from a database, often using a language like SQL, to retrieve specific records or perform calculations.
Making a report involves presenting retrieved data in a structured and formatted way, which typically comes after querying the database, but is not the act of asking the database a question itself.
Concept tested: Database querying fundamentals
Source: https://learn.microsoft.com/sql/relational-databases/queries/queries?view=sql-server-ver16
Topics
Community Discussion
No community discussion yet for this question.