Understanding Databases and DBMS

What are the three main elements of a database?

• Data, Server, Network

• Data Model, Query Language, User Interface

• Data, Application, Storage

• DBMS

What does DBMS stand for?

• Digital Business Management Software

• Database Management System

• Data Backup Management System

• Database Backup Service

What is the primary function of a DBMS?

• To manage user authentication and access control.

• To store, retrieve, and manage data in databases.

• To create and design websites.

• To process and analyze financial transactions.

How does an RDBMS differ from a DBMS?

• An RDBMS does not support transactions.

• its a type of DBMS that uses a relational model.

• An RDBMS stores data in a flat file format.

• A DBMS is always more complex than an RDBMS.

What is a table in the context of a database?

• A table is a type of software used for managing databases.

• A table is a single piece of data in a database.

• A table is a graphical representation of data without any structure.

• A table is a structured collection of data organized in rows and columns in a database.

Define a field in a database.

• A field is a row in a database that contains all attributes.

• A field is a column in a database table that holds data for a specific attribute.

• A field is a database that holds entire datasets.

• A field is a type of database that stores multiple tables.

What is a record in a database?

• A record is a collection of related data items stored together in a database.

• A record is a method for querying a database.

• A record is a type of database management system.

• A record is a single data type in programming.

What is the first step to create a database in MS Access 2019?

• Open an existing database file.

• Select 'Create New Table' from the menu.

• Open MS Access 2019 and select 'Blank Database'.

• Click on 'Import Data' to start a new database.

What should you do after selecting a template in MS Access?

• Delete the template immediately.

• Print the template without any changes.

• Customize the template by adding fields and entering data.

• Share the template with other users.

How do you specify the location to save a database in MS Access?

• Use the 'Save As' option in the 'File' menu to choose the location and name for the database.

• Use the 'Print' option to save a copy of the database.

• Select 'Export' from the 'File' menu to save the database.

• Click on 'Help' to find the save location for the database.