SQL Database

What is commonly known as a Database Management System (DBMS)?

• A tool for organizing and cataloging data

• A system to store, retrieve, and modify data

• A programming language for databases

• A type of computer hardware

What type of database model does MySQL use?

• Hierarchical model

• Network model

• Relational model

• Object-oriented model

What is a relational database?

• A database system that cannot relate different types of data.

• A database system that allows data to be associated and grouped by common attributes.

• A database system that stores data in a single table.

• A database system that only uses rows and no columns.

In a relational database, what does a row represent?

• A data record

• A field

• A data attribute

• A table name

What does a column in a relational database table typically represent?

• A data record

• A data type

• A field

• A database name

What is the term used to identify the name at the top of each column in the table?

• Row header

• Cell name

• Field name or column name

• Table title

What does SQL stand for?

• Standard Query Language

• Structured Query Language

• Simple Query Language

• Sequential Query Language

What is SQL primarily used for?

• Communicating with relational databases

• Creating spreadsheets

• Managing word documents

• Editing images

Which of the following tasks can SQL perform?

• Creating databases and tables

• Saving and retrieving data

• Deleting and updating data in databases

• All of the above

Which SQL statement is used to retrieve data from a database?

• INSERT

• SELECT

• CREATE

• ALTER