NEW
Font size
WorksheetsDatabase Fundamentals Quiz
Total questions: 10
Worksheet time: 5mins
What is the primary purpose of a Database Management System (DBMS)?
To create and maintain user databases
To store data in a file system
To eliminate data redundancy
To provide hardware for data storage
Which of the following is a characteristic of a database?
Data is stored in separate files
Data can be accessed by multiple users simultaneously
Data is always unstructured
Data is only accessible by one department
What does the term 'NoSQL' refer to?
A database management system developed by IBM
Databases that do not use SQL for data manipulation
A database that only supports structured data
A type of relational database
Which of the following is NOT a type of database mentioned?
Operational database
Analytical database
Hierarchical database
Transactional database
What is the main advantage of using a database over a file system?
Improved data consistency
Limited user access
Increased data redundancy
More complex data access
Which of the following describes the '3 level ANSI SPARC architecture'?
Data, metadata, and user data
User, application, and database levels
External, conceptual, and internal levels
Structured, unstructured, and semi-structured data
What is a characteristic of Big Data?
Data is always structured
Data is stored in a single location
Data is processed slowly
Data comes in multiple formats
Which of the following is an example of a relational database management system (RDBMS)?
MongoDB
Oracle
Hadoop
Cassandra
What does 'data independence' refer to in a database context?
The requirement for all data to be structured
The ability to store data in multiple formats
The separation of data descriptions from application programs
The ability to access data without user permissions
What is the purpose of metadata in a database?
To store user data
To describe the properties of end-user data
To provide security for the database
To increase data redundancy
