Intro Quiz DBMS

Which of the following is NOT a characteristic of a database?

• Data persistence

• Data independence

• Data redundancy

• Data security

What is a DBMS?

• A program that stores and retrieves data from a database

• A set of instructions for creating and maintaining a database

• A database system that uses a network of computers to store and retrieve data

• A system for managing digital content on the web

What is SQL?

• A programming language used for creating web applications

• A programming language used for creating mobile applications

• A query language used for managing data in a database

• A markup language used for creating web pages

What is a primary key in a database?

• A field that is used to create a relationship between two tables

• A field that can have duplicate values

• A field that is not required for a table to function

• A field that uniquely identifies each record in a table

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

• CREATE

• SELECT

• CHOOSE

• EXTRACT

Which SQL command is used to add a new row to a database table?

• ADD

• UPDATE

• INSERT

• CREATE

Which of the following is not a function of a DBMS?

• Data storage

• Data analysis

• Data retrieval

• Data backup