Database-Related Questions

What is a database?

• A single table of data

• A collection of data organized in tables

• A software used to process data

• A data entry form

Answer explanation

A database is best defined as a collection of data organized in tables, allowing for efficient data management and retrieval. The other options describe components or tools related to databases, but not the database itself.

Which of the following is a primary key?

• Student’s Name

• Student's ID

• Student's Address

• Student's Grade

Answer explanation

The primary key uniquely identifies each record in a database. 'Student's ID' is a unique identifier for each student, while the other options can be duplicated or are not unique.

In a relational database, how is data from two different tables related?

• Using foreign keys

• Using primary keys

• Using fields

• Using queries

Answer explanation

Data from two different tables in a relational database is related using foreign keys. A foreign key in one table points to a primary key in another, establishing a link between the two tables.

Which of the following data types is used for storing numbers in a database?

• String

• Boolean

• Numeric

• Date

Answer explanation

The correct choice is 'Numeric' as it is specifically designed for storing numbers in a database. Other options like 'String', 'Boolean', and 'Date' serve different purposes and are not suitable for numeric data.

What does SQL stand for?

• Simple Query Language

• Structured Query Language

Answer explanation

SQL stands for Structured Query Language, which is the standard language used for managing and manipulating databases. The other option, Simple Query Language, is incorrect.

Which of the following is NOT a valid data type in databases?

• Integer

• Date

• Text

• Function

Answer explanation

In databases, valid data types include Integer, Date, and Text. However, Function is not a standard data type; it refers to operations or procedures rather than a type of data that can be stored.

What does the "SELECT" command do in SQL?

• Adds a new record

• Removes a record

• Retrieves data from a database

• Updates data in a database

Answer explanation

The "SELECT" command in SQL is used to retrieve data from a database. It allows users to specify which columns to fetch and from which tables, making it essential for data retrieval.

Which of the following is a feature of relational databases?

• Data is stored in one big table

• Data is organized into separate tables that can be linked

• Data is not structured

• No links exist between tables

Answer explanation

Relational databases feature data organized into separate tables that can be linked through relationships. This allows for efficient data management and retrieval, unlike a single large table or unstructured data.

What is the purpose of a "form" in database management?

• To enter and view data

• To store data

• To create queries

• To design reports

Answer explanation

The purpose of a form in database management is primarily to enter and view data. It provides a user-friendly interface for users to input information and retrieve it easily, unlike storing data, creating queries, or designing reports.

What is a “Foreign Key”?

• A field that uniquely identifies a record in a table

• A key used to link two tables

• A key that encrypts data

• A data type for text

Answer explanation

A foreign key is a field in one table that links to the primary key of another table, establishing a relationship between the two. This is essential for maintaining referential integrity in a database.