Computer & IT

note!Answer: C) Double click the right side of the column heading
Double-clicking the right border of a column heading auto-fits the column width. The option text is a close paraphrase of this.

note!Answer: C) Click the report, and on the Pivot Table toolbar, click the refresh data button
The Refresh Data button on the PivotTable toolbar reloads the report from the updated source data.

note!Answer: B) Set theory
The relational database model is based on set theory and relations.

note!Answer: B) Tuple
In relational theory, a row (record) of a table is called a tuple.

note!Answer: D) All of above
Access allows importing tables, queries, forms and other objects from other databases.

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

note!Answer: A) information
Processing raw data produces meaningful information.

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) B and C
Data is raw and unprocessed, and processing it turns it into information.

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).