Exploring Database Concepts

What is a Database Management System (DBMS)?

• A Database Management System (DBMS) is a programming language for web development.

• A Database Management System (DBMS) is software that facilitates the creation, management, and manipulation of databases.

• A Database Management System (DBMS) is a type of hardware used for data storage.

• A Database Management System (DBMS) is a cloud service for file sharing.

What is the purpose of a primary key in a database?

• The purpose of a primary key in a database is to uniquely identify each record in a table.

• To group related records together in a table.

• To define the structure of a database table.

• To store large amounts of data efficiently.

How do you create a table in a database?

• Use the SQL command: CREATE TABLE table_name (column1 datatype, column2 datatype, ...);

• Use the command: ADD TABLE table_name;

• Define a table with: MAKE TABLE table_name;

• Create a table by using: INSERT INTO table_name;

What are the key components of a database table?

• Table title, fields, value types, main key, linked keys, views.

• Table name, columns, data types, primary key, foreign keys, indexes.

• Row name, attributes, data formats, unique key, secondary keys, constraints.

• Database name, entries, types of data, main identifier, related keys, triggers.

What is the function of a form in database management?

• To store data in a structured format.

• To perform complex calculations on data.

• To generate reports automatically.

• To provide a user-friendly interface for data entry and management.

How can you ensure data integrity using primary keys?

• Allow duplicate values in the primary key column for flexibility.

• Use foreign keys to link tables without defining primary keys.

• Define a primary key for each table to uniquely identify records and enforce uniqueness and non-null constraints.

• Set primary keys to nullable to accommodate missing data.

What is the difference between a primary key and a foreign key?

• A primary key can be null, while a foreign key cannot be null.

• A primary key is always a string, while a foreign key is always an integer.

• A primary key is used for indexing, while a foreign key is used for sorting.

• A primary key uniquely identifies records in a table, while a foreign key links records between tables.

What are the common data types used in database tables?

• Character, Decimal, Time, List, Set

• Text, Number, DateTime, Array, Object

• Integer, Float, String, Date, Boolean

• Currency, Image, File, URL, Email

How do you design a form for effective data entry?

• Avoid any form of validation

• Make the form visually complex with many colors

• Design a user-friendly form with clear labels, grouped fields, input validation, and responsive design.

• Use a single text box for all inputs

What is a query in the context of databases?

• A request for data or information from a database.

• A type of database management system.

• A tool for designing database schemas.

• A method for updating database records.