• Register
0 votes
119 views

Problem:


Can anyone give the right solution by filling in the blanks?

A database is used instead of a spreadsheet when ________?
A) lists of data involve a single theme
B) structures of data lists are simple
C) lists involve data with multiple themes
D) users do not want to store all data in one place

7 5 3
5,380 points

Please log in or register to answer this question.

2 Answers

0 votes

Solution:

The correct answer is: lists involve data with multiple themes.

Hope this might help you.

8 6 2
10,530 points
0 votes

A database is used instead of a spreadsheet when the list involves the data with multiple themes.

Reasons to use the database:

There are the following reasons for using the database over the spreadsheet.

Storage limit:

A spreadsheet can store only a limited amount of data by its rows and columns while the database can store an unlimited amount of data.

Data sharing:

Sharing the spreadsheet is a nightmare, making the sense of a shared spreadsheet more than one. The online database allows for easy and secure sharing.

Security is fickle:

Confidential data does not remain that way for long, Data in the database is encrypted by the SQL standards.

Version Control:

A spreadsheet is a lack of version control when someone you have shared the sheet with makes the changes to data. You are left with the two versions, with no way of knowing which one is correct. While the online database changes the versions every time the changes are made.

Data relationship:

A spreadsheet structure can not support the extensive data relationship. This makes solving real-world problems nearly impossible. The database is multidimensional and supports complex relationships between the tables.

Storage of data:

The database is used for back end storage while a spreadsheet is used as a front end to present the data and perform ad-hoc manipulations.

11 5 2
3,890 points

Related questions

0 votes
2 answers 190 views
190 views
Problem: Can anyone help it was actually asked in exam as following: In a database, a group of related records is referred to as a(n) ________. A) memo B) field C) object D) table
asked Feb 18, 2020 maddi86 5.4k points
0 votes
1 answer 1.9K views
1.9K views
Problem: I am new, I need help, can anyone help me by filling in the blanks? The ________ built-in function is used to read a number that has been typed on the keyboard? A. get() B. input() C. keyboard() D. read()
asked Feb 19, 2020 maddi86 5.4k points
0 votes
2 answers 470 views
470 views
Problem: Data ________ occurs when the same data is duplicated in multiple files of a database?
asked Apr 12, 2020 ArifulIslam 7.5k points
0 votes
1 answer 1 view
1 view
Problem: I need assistance and any recommendations will be deeply appreciated,"import spreadsheet wizard subscript out of range."
asked 3 days ago sumaiya simi 8.4k points
0 votes
1 answer 3 views
3 views
Problem: I used Google to try to find a solution on the web of the above question, But I got no useful hints. Can I get Pointer information about my problem with this?
asked Mar 23 shamimkhan 15.1k points
0 votes
1 answer 5 views
5 views
Problem: I was always of the impression that a query with no specified 'Order by' rule, would order this by the results by what was specified within your where clause.
asked Mar 14 ummesalma 22.9k points
0 votes
1 answer 118 views
118 views
Problem: Hello! I want to know how I can delete data from the database? Is there more than one ways to do so?
asked Mar 3 Code Learner 9.2k points
0 votes
1 answer 22 views
22 views
Problem: How do we see the data that exists in a database?
asked Mar 3 Code Learner 9.2k points
0 votes
1 answer 23 views
23 views
Problem: How do we insert new records in a database?
asked Mar 3 Code Learner 9.2k points
0 votes
1 answer 15 views
15 views
Problem: I want to know how can we change the data in a database? Thanks!
asked Mar 3 Code Learner 9.2k points