Database System

note!Answer: B) Primary key
A primary key uniquely identifies each record in a table.

note!Answer: A) Primary key
A primary key must contain unique values and cannot contain duplicates.

note!Answer: A) 1 bit
The Yes/No data type in Access uses a field size of 1 bit.

note!Answer: A) Relate multiple tables
A relationship links two or more tables based on common fields.

note!Answer: B) Picture
Access has no Picture data type; images are stored using the OLE Object or Attachment types.

note!Answer: A) Primary key
A primary key field holds unique values for each record.

note!Answer: B) Entity relational diagram
E-R stands for Entity-Relationship, a diagram that models entities and their relationships.

note!Answer: D) All of the above
Forms let users add, delete and modify records in a table.

note!Answer: A) Row and column
A table is organised into rows and columns, which hold the records and fields of data.

note!Answer: B) Access
Microsoft Access is a database application. Excel and spreadsheets are not database applications.

note!Answer: A) Oracle
Oracle is a relational database management program. Word is a word processor and Excel is a spreadsheet.

note!Answer: A) Exclusive mode
Opening a database in exclusive mode prevents other users from accessing the file at the same time.

note!Answer: C) Query
A query selects and extracts a subset of data from one or more tables based on criteria.

note!Answer: D) All of the above
A table contains records (rows), fields (columns), and indexes that speed up searches.

note!Answer: A) Object
Forms, reports, tables, and queries are all database objects.

note!Answer: C) Object oriented relational database
Object-oriented relational databases are the most widely used modern database type, combining relational and object features.

note!Answer: A) Primary key
A primary key uniquely identifies each record in a table.

note!Answer: D) All of the above
Consistency, independence and security are all properties or goals of a database system.

note!Answer: B) Database management system
DBMS stands for Database Management System.

note!Answer: A) Table and query
A form can be based on a table or a query, which supply its data.