nerdexam
CompTIA

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.

Database Fundamentals

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)
  • A
    4% (1)
  • B
    4% (1)
  • C
    85% (22)
  • D
    8% (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.

AManipulating data

Manipulating data involves inserting, updating, or deleting records, which is a different operation from merely asking a question to retrieve data.

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

CCreating a queryCorrect

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.

DMaking a report

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

#database query#SQL#data retrieval

Community Discussion

No community discussion yet for this question.

Full FC0-U61 Practice