FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Queries are used to ____
A
organize data
B
store data
C
print out data
D
display data on the screen
Explanation: 

Detailed explanation-1: -Solution. Queries are used to retrieve information from database.

Detailed explanation-2: -Queries help you find and work with your data A query can give you an answer to a simple question, perform calculations, combine data from different tables, add, change, or delete data from a database.

Detailed explanation-3: -Data queries allow you to mine information from your company’s data resources by asking questions. You can then sort through that data to find what you’re looking for and gain more insight into your organization and its performance.

Detailed explanation-4: -With SQL, we can store, retrieve, and manipulate data using simple code snippets, called queries, in an RDBMS (relational database management system). The data is stored in the RDBMS in a structured way, where there are relations between the different entities and variables in the data.

Detailed explanation-5: -Structured query language (SQL) is the most common query language because many relational databases, which structure data in the form of tables, use it. You can use SQL to view or manage data in these types of databases.

There is 1 question to complete.