Comptia ITF+ 5.2 Practice

What is a structured database typically divided into?

• Keys and values

• Tags and elements

• Rows and columns

• Documents and records

Which type of data is typically text-heavy and lacks a pre-defined data model?

• Non-structured data

• Relational data

• Semi-structured data

• Structured data

What is a primary key in a relational database?

• A default value for a column

• A foreign key in another table

• A composite key

• A unique identifier for each row

Which of the following is a common type of semi-structured data?

• SQL

• JSON

• CSV

• HTML

What is the purpose of a foreign key in a relational database?

• To enforce data integrity

• To relate two tables together

• To uniquely identify each row

• To provide a default value

Which constraint ensures that all values in a column are different?

• CHECK

• UNIQUE

• NOT NULL

• DEFAULT

What is a key characteristic of non-relational databases?

• They use SQL for data manipulation

• They require a fixed schema

• They are only used for small data sets

• They do not use the table/key model

Which of the following is an example of a document database?

• Oracle

• PostgreSQL

• MongoDB

• MySQL

What is the role of a schema in a relational database?

• To store data in a flat file

• To encrypt the data

• To define the structure of the database

• To provide a user interface

Which type of database is known for its flexibility in data storage?

• Structured database

• Relational database

• Semi-structured database

• Non-structured database