Database System

note!Answer: A) Relationship
In database design, the third stage is establishing relationships between the tables.

note!Answer: B) Field
A field is a column that stores one category of information. A record is a row.

note!Answer: A) Primary Key
A primary key uniquely identifies each record in a table and cannot contain duplicates.

note!Answer: B) Relationship
A relationship is an association between tables based on common fields.

note!Answer: C) DDL
Data Definition Language (DDL) defines the database structure and schema.

note!Answer: C) Date/time
In Access, the Date/Time field type uses 8 bytes of storage.

note!Answer: C) In An Indexed Field You May Or May Not Enter Duplicate Value Depending Upon Setting
Foreign key fields can hold duplicates, primary key fields cannot, and indexed fields allow duplicates only if the index is set to allow them.

note!Answer: D) None
Network, relational and object-oriented are all recognised database models, so none of them is excluded.

note!Answer: A) RDBMS
Microsoft Access is a relational database management system (RDBMS).

note!Answer: C) Authorizing Access And Other Control Over Database
DCL (Data Control Language) controls access and permissions, such as GRANT and REVOKE. Changing table structure is DDL, and inserting or updating records is DML.

note!Answer: B) DML
DML (Data Manipulation Language) is used to access and maintain data, using commands like SELECT, INSERT, UPDATE and DELETE.

note!Answer: B) 255
In Microsoft Access, a Text field can hold a maximum of 255 characters.

note!Answer: B) Query
A query selects and displays data from tables based on specified criteria.

note!Answer: C) Fields
In a database table, columns are called fields and rows are called records.

note!Answer: C) Worksheets
Worksheets belong to spreadsheet applications such as Excel, not to Access database objects.

note!Answer: D) All of the above
Access allows tables to be created in Design View, through a datasheet by entering data, or with a wizard.

note!Answer: D) Tables
Tables are the only database objects that actually store data.

note!Answer: C) Queries
Queries store commands that retrieve data from one or more tables.

note!Answer: B) Reports
Reports format data for printing or presentation as the final output.

note!Answer: D) All Of Above
Access provides Design View, the Table Wizard and Datasheet entry as ways to create a table.