Database System

note!Answer: D) Back End
The back end holds the actual data tables, while the front end holds forms, reports and queries.

note!Answer: B) Picture
Access data types include Number, Text and OLE Object, but 'Picture' is not a data type.

note!Answer: D) All of the above
A primary key enforces uniqueness, disallows nulls, and is used to link tables in relationships.

note!Answer: D) Primary key must be numeric field only
A primary key can be text, number or other types; it does not have to be numeric only.

note!Answer: D) Both A & B
A primary key field rejects both null values and duplicate values.

note!Answer: D) will not repeat
A Report Footer prints only once, at the end of the last page of the report.

note!Answer: D) form is the front-end part and report is the final output of database
Forms are used for data entry and display on the front end, while reports present the final formatted output.

note!Answer: C) Database administrators
A Database Administrator (DBA) is the person responsible for managing an organization's database.

note!Answer: D) all of above
A DBA designs the schema, grants user authentication, and manages database performance.

note!Answer: C) Structured Query Language
SQL stands for Structured Query Language.

note!Answer: C) Yes/no
In MS Access, the Yes/No data type stores Boolean values.

note!Answer: B) Report Footer
Grand totals are placed in the Report Footer, which appears once at the end of the report.

note!Answer: B) 3
Database architecture has three levels: external (view), conceptual (logical), and internal (physical).

note!Answer: A) Query
The Show Table command is found in the Query menu when working in query design view.

note!Answer: B) Sub schema
The view level is also called the subschema, which describes the part of the database a user sees.

note!Answer: B) Desktop database
MS Access is a desktop database management system used on a single computer or small network.

note!Answer: C) MS Jet Engine 4
Access 2000 uses the Microsoft Jet Engine version 4.0.

note!Answer: C) 3
The three types of cardinality are one-to-one, one-to-many, and many-to-many.

note!Answer: B) Data of database at particular time
An instance is the set of data stored in the database at a particular moment in time.

note!Answer: B) Query
A dynaset is the dynamic result set produced by a query in MS Access.