SQL Basico CBTIS 153

What is a database?

• A program to browse the internet

• A set of organized and structured data

• A type of text file

• An operating system

Which of the following is NOT a relational database?

• MySQL

• PostgreSQL

• MongoDB

• Microsoft SQL Server

What is the smallest unit of information within a database?

• Record

• Table

• Data

• Schema

What does a record represent in a relational database?

• A column in a table

• A set of related data in a row

• A type of system user

• A storage software

Which of the following statements is correct about a DBA (Database Administrator)?

• They are responsible for managing and maintaining the database

• It is a software that stores data

• It is a programming language

• It is a file transfer protocol

What is a main function of a Database Management System (DBMS)?

• Design web pages

• Manipulate, store, and protect data

• Create documents in the cloud

• Program in Python

What type of information can a data in a database contain?

• Only numbers

• Only text

• Only images

• Numbers, text, dates, images, etc.

What is the main advantage of a DBMS over text files?

• Greater organization, security, and efficiency in data handling

• Allows faster document writing

• Does not consume memory in the system

• Does not require an internet connection

In what environment are relational databases used?

• Social networks

• Banks

• Online stores

• All of the above

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

• Google Drive

• Microsoft Excel

• PostgreSQL

• Notepad