stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
Intro to Database - Week 01 Flashcards | StudBud
Explore
/
Intro to Database - Week 01
Intro to Database - Week 01
17 terms
·
StudBud Administration
·
3 plays
Imported from external platform
Flashcards
17 cards
F
Practice quiz
P
Host live
L
Questions
17
Answers
1
2. What are the Disadvantages of Electronic File-Based Systems ?
All of above
Security problems
Concurrency access
Integrity problems
2
12. What electronic data storage methods are commonly used in organizations?
Ledgers
Hard Disk
File Cabinets
Registers
3
10. "Metadata is a set of ________ that describes and gives information about other data."
Datums
Data
Database
Dataset
4
17. What is the main challenge in maintaining data integrity in a file-based system?
Implementing data security measures
Managing data redundancy and inconsistency in a single file
Optimizing data retrieval and storage efficiency
Ensuring data consistency across multiple files
5
3. What is incorrect statement about database ?
Ability to update old data
Ability to insert new data
Ability to delete necessary data
Ability to retrieve data
6
8. What is the incorrect disadvantage of databases?
Complex piece of software
May be faster than retrieving from files.
Large storage requirements and associated costs
System failure and its implications
7
13. What is the full form of DBMS?
Database Management Service
Database Management System
Data Backup Management System
Data of Binary Management System
8
5. Database is …
Sometimes different formats are used.
Data is scattered everywhere.
The same data may be stored more than once - duplicated.
Data is stored in a common format for all applications to use.
9
4. What is the incorrect statement about "Why do Organizations Need Data?"
Better & Quick decision-making
Customer relationship management
Decreased Productivity/Improved Performance
Be Strategic In Your Approaches
10
7. What is the first database system ?
Relational Model Proposed
ER model
XML
Manual File based systems
11
11. What are the Difficulties Faced With Manual File Based Systems ?
Lack of security
Limited access and collaboration
All of above
High Costs
12
5. " File-based systems were born as an attempt to computerize the traditional manual filing system."
False
True
13
1.
What is DBMS?
DBMS stores, modifies and retrieves data
DBMS is a high-level language
DBMS is a programming language
DBMS is a collection of queries
14
9. What are the Difficulties Faced With Manual File Based Systems ?
Manual File based systems
Relational Model Proposed
ER model
XML
15
10. What is the incorrect disadvantage of databases?
Complex piece of software
System failure and its implications
Large storage requirements and associated costs
May be faster than retrieving from files.
16
15. Which of the following is not an example of DBMS?
IBM DB2
Google
MySQL
Microsoft Access
17
16. What is a file-based system?
A system used to store files in a sequential manner.
A system used to store files in a relational manner.
A system used to store files in a network.
A system used to store files in a hierarchical manner.