LESSON 2

What is the key function of databases related to data storage?

• Data Integrity

• Data Storage

• Data Maintenance

• Data Retrieval

Which key function of databases ensures that stored information meets predefined rules and standards?

• Data Relationships

• Data Integrity

• Data Analysis

• Data Security

What is the role of databases in an enterprise?

• Only external databases are used

• Only internal databases are used

• No role in an enterprise

• Both internal and external databases are used

What does RDBMS stand for?

• Rapid Database Management System

• Random Database Management System

• Repetitive Database Management System

• Relational Database Management System

What is the feature of RDBMS that ensures no two records in a database table can be completely duplicate?

• Referential Integrity

• User-Defined Integrity

• Domain Integrity

• Entity Integrity

Which characteristic of RDBMS ensures that data must be stored in tabular form organized in rows and columns?

• Data Consistency

• Data Redundancy

• Data Integrity

• Data Handling

What is an advantage of RDBMS related to data handling?

• Data fetching is slower

• Data fetching is faster

• Data redundancy is encouraged

• Data consistency is not ensured

What is the disadvantage of RDBMS related to scalability?

• No additional hardware required

• No additional power required

• Additional power and memory required

• No additional memory required

Where are all data, metadata, and logs stored in RDBMS architecture?

• Quaternary Storage devices

• Tertiary Storage devices

• Secondary Storage devices

• Primary Storage devices

What is the job of the Database Administrator (DBA) in RDBMS architecture?

• Execute compiled queries

• Store data on secondary storage device

• Set up database structure

• Compile applications