Database Basics

What is a database?

• A musical instrument

• A type of software for editing photos

• A type of computer monitor

• A structured collection of data stored and accessed electronically or manually.

What are the different types of databases?

• Electronic

• Report

• Table

• Manual

What is the acronym DBMS

• Data bank Management Services

• Database Management System

• Database Management Software

• Database Management Server

Explain the concept of tables in a database.

• Tables in a database store data in rows and columns, with each table representing a specific entity and each row representing an instance of that entity.

• Tables in a database do not have any structure

• Tables in a database are only used for storing text data

• Tables in a database are used for storing images and videos

What is a primary key?

• A primary key is a unique identifier for each record in a database table.

• A primary key is a random value assigned to each record in a database table.

• A primary key is a field that can have duplicate values in a database table.

• A primary key is a secondary identifier used for sorting records in a database table.

What is normalization in databases?

• Combining data from multiple tables

• Organizing data efficiently by minimizing redundancy and dependency.

• Storing data in a single table without relationships

• Randomly arranging data in tables

What are the Database Objects?

• Manual, Electronic

• Table, Query, Report, Form

• Address Books, Dictionaries, Student Data, Customers Data

• None of the Above

What is a database management system (DBMS)?

• A hardware device used to store data physically

• A programming language for creating websites

• A type of computer monitor

• A software that allows users to interact with databases by providing an interface to store, retrieve, and manage data efficiently.

What is the purpose of data communication?

• To transfer data between different devices or systems.

• To delete data from a database.

• To organize data in a database.

• To create data visualizations.

Explain the difference between analog and digital data transmission.

• Analog data transmission uses continuous signals while digital data transmission uses discrete signals.

• Analog data transmission is faster than digital data transmission.

• Analog data transmission is more secure than digital data transmission.

• Analog data transmission is only used for voice communication.