ITF+ Quiz Part 17

Which of the following statements is true about databases?

• Databases can only manage a single table.

• Databases cannot support concurrent users.

• Databases can manage multiple tables and link fields in different tables.

• Databases are not scalable.

Answer explanation

Databases can manage multiple tables and link fields in different tables, allowing for complex data organization and relationships.

What is a key advantage of a database system over a single file-based data storage solution?

• Lower cost

• Higher speed for large volumes of transactions

• Less complexity

• No need for backup

Answer explanation

A key advantage of a database system over a single file-based data storage solution is higher speed for large volumes of transactions, due to optimized data retrieval and processing capabilities.

In a file-based storage model, what happens when one user opens the file?

• The file becomes available to all users.

• The file becomes locked to other users.

• The file can be edited by multiple users simultaneously.

• The file is deleted.

Answer explanation

In a file-based storage model, when one user opens the file, it becomes locked to other users, preventing simultaneous editing by multiple users.

What does scalability in databases refer to?

• The ability to reduce costs

• The ability to expand usage without increasing costs at the same rate

• The ability to decrease the number of users

• The ability to simplify the database structure

Answer explanation

Scalability in databases refers to the ability to expand usage without increasing costs at the same rate, allowing for growth without proportional cost increase.

Which of the following is an example of a Relational Database Management System (RDBMS)?

• Microsoft SQL Server

• MongoDB

• Cassandra

• Redis

Answer explanation

Microsoft SQL Server is an example of a Relational Database Management System (RDBMS), making it the correct choice from the options provided.

What language is typically used by Relational Database Management Systems (RDBMS) to maintain and query data?

• Python

• Java

• Structured Query Language (SQL)

• HTML

Answer explanation

Relational Database Management Systems (RDBMS) typically use Structured Query Language (SQL) to maintain and query data.

What is the main reason for using multiple linked tables in a relational database?

• To reduce data redundancy and inconsistencies

• To increase data redundancy

• To make data entry more complex

• To avoid using primary keys

Answer explanation

To reduce data redundancy and inconsistencies

In a relational database, what is the term used for a column that uniquely identifies each row in a table?

• Foreign key

• Primary key

• Schema

• Index

Answer explanation

In a relational database, the term used for a column that uniquely identifies each row in a table is called the Primary key.

What is a foreign key in a relational database?

• A column that uniquely identifies each row in its own table

• A column that is used to define the relationship between two tables

• A column that contains only numeric values

• A column that is not used in any relationship

Answer explanation

A foreign key in a relational database is a column that is used to define the relationship between two tables.

What is the term used to describe the structure of the database in terms of the fields defined in each table and the relations between primary and foreign keys?

• Schema

• Index

• Primary key

• Foreign key

Answer explanation

The term used to describe the structure of the database in terms of fields and key relations is called Schema.