Databases & SQL

What is a database?

• A collection of tables

• A structured collection of data

• A collection of queries

• A collection of records

Answer explanation

While a database often consists of tables, it's important to note that the term "database" itself refers to a structured collection of data. The data within a database can be organized into tables, relationships, and other structures.

What is the main purpose of a database?

• Storing and managing data

• Running applications

• Creating reports

• Designing websites

In a relational database, what is a table?

• A row

• A column

• A database

• A collection of related data

Define DBMS.

• Database Management System

• Data Backup and Management System

• Digital Business Management System

• Database Modeling System

Which of the following are category of SQL commands?

• Data Definition Language (DDL)

• Data Manipulation Language (DML)

• Data Communication Language (DCL)

• Transaction Control Language (TCL)

What is the role of a DBMS in a database?

• Running applications

• Creating reports

• Managing databases

• Designing websites

What does a row represent in a table?

• Table

• Column

• Record

• Attribute

Which SQL command is used to create a new database?

• CREATE DATABASE

• USE DATABASE

• ADD DATABASE

• NEW DATABASE

What does the SQL command SHOW TABLES; do?

• Lists all tables in the current database

• Displays the contents of a table

• Adds a new table

• Removes a table

What does the term "tuple" refer to in the context of a relational database?

• A row

• A column

• A record

• An attribute