KC1 - Database

Which type of database is often referred to as a SQL database?

• Semi-structured database

• Object-based database

• Nonrelational database

• Relational database

What is the purpose of a DBMS?

• To access data models

• To manage database functionality

• To create databases

• To store data in tables

Name one component of a database.

• Data integrity

• Schema

• Small scale or distributed

• Data models

What is a data model used for?

• To determine how data can be stored and organized

• To manage database transactions

• To define database constraints

• To create database tables

Which database model is based on relational algebra?

• Semi-structured data model

• Relational data model

• Object-based data model

• Entity relationship model

What is a schema in a database?

• A database query language

• A database schema defines the organization of a database

• A database table

• A database management system

Where are databases stored in a cloud-based setup?

• Remote servers

• Local networks

• Virtualized data center

• On-premises data center

What is the primary benefit of using a DBaaS?

• Enhanced data security

• Improved data consistency

• Increased data integrity

• Reduced cost of installing and maintaining servers

Which database service is fully managed and compatible with MySQL and PostgreSQL?

• Oracle Database

• Amazon Aurora

• Amazon DynamoDB

• Amazon RDS

What is the main difference between relational and nonrelational databases?

• Nonrelational databases are more secure than relational databases

• Relational databases use tables, while nonrelational databases do not

• Nonrelational databases use SQL, while relational databases do not

• Relational databases are cloud-based, while nonrelational databases are on-premises