Question

Howie is a business analyst who is given access to the database of a product prior to its launch. He needs to understand the data presented and take appropriate action. Which of the following is Howie most likely to do?
A) Send the database back to the source to interpret the data
B) Uses the data present in the database in its raw format
C) Encrypt the data to secure the product's authenticity
D) Use SQL or graphical tools to query the database

Answer 1

Answer:

D) use SQL or graphical tools to query the database            

Explanation:

To query the database using SQL or graphical tools will help Howie to retrieve bulk of records from the database according to his requirements and it will help to understand and work with the data in a better way than using the data in raw form.

SQL is a language of database used to manipulate and manage the data in the relational database and to query the database.

It is an easy and faster way to query using SQL or graphical tools because no coding is required here.

Different graphical tools are used to present the data in the database in a way that can be easily understood by a person. Different interfaces are provided to visualize the database tables or schema diagrammatically e.g in the form of graphs etc. Different views of the database can be provided to different users according to their requirement and what information they required to be presented.