Question

How do users retrieve data stored in a database? Select one: a. by viewing the appropriate...

How do users retrieve data stored in a database?

Select one:

a. by viewing the appropriate data tables

b. by executing a query

c. by performing a search

d. by specifying the primary keys

Homework Answers

Answer #1

Users retrieve data stored in a database by executing a query i.e. option b.

Data retrieval is basically reobtaining data from the software of managing databases eq.Database Management system.Two primary forms of obtaining data from DBMS are Reports and Queries.The two are almost similar but Reports show relatively large amount of data as compared to Queries.Also queries are the standard formats in which data is displayed on the screens .Hence,the desired data is retrieved from DBMS by executing a query and DBMS selects the demanded data and the same could be stored in file or it could be printed as well.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
How do the light reactions produce ATP? Select one: a. Potential energy stored in a hydrogen...
How do the light reactions produce ATP? Select one: a. Potential energy stored in a hydrogen ion (H+) gradient is used to synthesize ATP. b. Photosystem I directly adds a phosphate to ADP. c. Photosystem II directly adds a phosphate to ADP. d. Energy released by electrons is directly used to synthesize ATP.
Three key decisions when designing your primary research plan include Select one: a. Deciding which database...
Three key decisions when designing your primary research plan include Select one: a. Deciding which database to use, choosing qualitative or quantitative methods, designing sampling plan b. Determining data collection method and preparation of the research instrument, determining how to contact subjects, designing a sampling plan c. Designing a survey, selecting a sampling methodology, choosing a reporting template d. None of the above are key decisions that need to be made in regard to primary research.
Advantages of a web/database system as compared to a more traditional database approach include: Select one:...
Advantages of a web/database system as compared to a more traditional database approach include: Select one: a. improved functionality and ease of administration b. ease of administration and transaction tracking c. rapid development and flexible information presentation d. easy deployment and improved functionality
The relational schema for the Academics database is as follows: DEPARTMENT(deptnum, descrip, instname, deptname, state, postcode)...
The relational schema for the Academics database is as follows: DEPARTMENT(deptnum, descrip, instname, deptname, state, postcode) ACADEMIC(acnum, deptnum*, famname, givename, initials, title) PAPER(panum, title) AUTHOR(panum*, acnum*) FIELD(fieldnum, id, title) INTEREST(fieldnum*, acnum*, descrip) Some notes on the Academics database: An academic department belongs to one institution (instname) and often has many academics. An academic only works for one department. Research papers (PAPER) are often authored by several academics, and of course an academic often writes several papers (AUTHOR). A research field...
Which of the following is most accurate regarding stored and purchased liquidity? Select one: a. Stored...
Which of the following is most accurate regarding stored and purchased liquidity? Select one: a. Stored Liquidity is using interbank markets for short-term loans b. Larger Financial Institutions(FIs) are more likely to use purchased liquidity than smaller FIs c. Purchased liquidity involves liquidating cash stores and selling existing assets d. When managers utilize stored liquidity to fund deposit drains, the size of the balance sheet is reduced and its composition is unchanged
Create 2 stored procedures: sp_AddNewUser and sp_AddNewRole. Use the ManyToMany script as your base table structures....
Create 2 stored procedures: sp_AddNewUser and sp_AddNewRole. Use the ManyToMany script as your base table structures. The stored procedure should accept the parameters needed to input the data for each table. NOTE: You do not need to input the UserID or RoleID. These are surrogate keys and the system automatically inserts them when you insert a row in the tables.   On execution, the stored procedure should check the database to see if the user exists, if so, return a message...
1. Consider the following tables in a relational database. Provide the appropriate "SELECT" SQL statement necessary...
1. Consider the following tables in a relational database. Provide the appropriate "SELECT" SQL statement necessary to answer the queries that follow. Primary keys are underlined and foreign key fields have an asterisk at the end of the field. CUSTOMERS (CUST-NO, C-NAME, C-ADDRESS, BALANCE) SALESPERSONS (SP-NO, S-NAME, DATE-EMPLOYED, SALARY) SALES (INVOICE-NO, DATE, CUST-NO*, SP-NO*) a) List the salesperson name and salary for all sales to customers whose balance outstanding is greater than 20000. b) List the names and addresses of...
How do you make an inverse hash from an existing hash (swap the keys/value pairs)? Select...
How do you make an inverse hash from an existing hash (swap the keys/value pairs)? Select one: a. revise(%original_hash); b. %swapped_hash = reverse(%original_hash); c. my %swapped_hash = inverse %original_hash; d. my %swapped_hash = reverse %original_hash;
15- Analysis of large and complex data set can benefits Select one: a. organization and Individual...
15- Analysis of large and complex data set can benefits Select one: a. organization and Individual both b. organizations only c. Individuals only 16- Relational database management system and Excel spreedsheets are examples of Select one: a. strucured Data b. Quasi structured Data c. Semistructured Data d. unstructured Data 17- The shopping mall wants to analyze the path taken by you while purchasing groceries for your home, The shopping mall is Select one: a. Data buyer b. Data collector c....
Match Data Independence to one of the following choices: A. An integrated decision support database with...
Match Data Independence to one of the following choices: A. An integrated decision support database with content derived from various operational databases and external sources B. A logical description of some portion of the database that is required by a user to perform some task C. A software system that is used to create, maintain and provide controlled access to user databases D. A centralized knowledge base of all data definitions, data relationships, screen and report formats, and other system...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT