Database Fundamentals Quiz

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