DBASE BASICS

Which term refers to a collection of data organized in a way that allows easy access, retrieval, and modification?

• Database
• Spreadsheet
• Document
• Presentation

What is a unique identifier for each record in a database table called?

• Primary key
• Secondary key
• Index key
• Foreign key

What is a database table row that contains a specific instance of data called?

• Record
• Field
• Schema
• Column

When should you use a foreign key in a database design?

• When you want to establish relationships between tables and enforce data integrity
• When you want to perform complex calculations in a table
• When you want to ignore data validation rules
• When you want to store unrelated data in different tables

What is the purpose of the WHERE clause in an SQL query?

• To filter rows based on a specific condition
• To order the results in ascending order
• To select all columns from a table
• To update existing data in a table

What does the keyword 'SELECT' do in an SQL query?

• Retrieve data from a database
• Delete data from a database
• Insert new data into a database
• Update data in a database

What is the purpose of the 'INSERT INTO' statement in SQL?

• To add new records to a database table
• To retrieve data from a database table
• To update existing records in a database table
• To delete records from a database table

Which data type in SQL is used to store whole numbers?

• INT
• DATE
• FLOAT
• VARCHAR

Which data type in SQL is used to store monetary values?

• DECIMAL
• DATE
• VARCHAR
• INT

What does the 'NOT NULL' constraint do in SQL?

• It ensures that a column cannot have a NULL value
• It allows a column to have only unique values
• It limits the number of rows in a table
• It deletes all rows with NULL values