Database in Brief

1.      When was the first computer database built?

• A. 1960s

• B. 1970s

• C. 1980s

• D. 1990s

1.      What is a database management system (DBMS)?

• A. An electronic filing cabinet

• B. A collection of structured information

• C. A software that controls a database

• D. A programming language used for querying data

1.      How is data typically modeled in databases?

• A. In rows and columns in a series of tables

• B. In paragraphs and sentences in a document

• C. In images and videos in a folder

• D. In audio files in a playlist

1.      What is SQL?

• A type of computer virus

• A type of computer hardware

• A programming language used by nearly all relational databases to query, manipulate, and define data

• A special software for managing database

1.      What is the purpose of using SQL in databases?

• A. To store data efficiently

• B. To access data easily

• C. To update data effectively

• D. All of the above

1.      What is RDBMS used for?

• To store, manage, query and retrieve data in a relational database.

• To manipulate data in spreadsheets.

• To create tables in databases.

• None of the above.

1.      What is a distributed database?

• A database that stores records in one physical location

• A database that replicates/distributing data across different parts of the network

• A database built in a public cloud environment

• A database that uses NoSQL technology

1.      What is a cloud database?

• A database that stores records or files in several physical locations

• A database built using NoSQL technology

• A database built in a virtualized environment on a public, private or hybrid cloud

• A database that focuses on organizing objects rather than actions

1.      What is the role of a programming language in a database?

• To provide an intuitive graphical user interface

• To organize data in a specific way

• To perform specific tasks such as adding or retrieving data

• To manage large amounts of data