Database System

note!Answer: C) 12
Dr. E. F. Codd defined 12 rules (numbered 0 to 12) for a fully relational database.

note!Answer: A) Column
In a database table, a field is a column, and a record is a row.

note!Answer: C) Primary key, Foreign key
The master table holds the primary key, and the transaction table holds the foreign key that refers to it.

note!Answer: B) Form
A switchboard in MS Access is a special form used to navigate the application.

note!Answer: C) Create
The Create operation makes a new database, while Open and Save work with existing ones.

note!Answer: B) One to many
The hierarchical data model represents one-to-many relationships in a parent-child tree.

note!Answer: A) Exclusive Mode
Opening a database in Exclusive mode is required to set or change a password in MS Access.

note!Answer: C) Macro
A macro is a saved set of actions that Access performs as one object.

note!Answer: A) Object
Tables, forms, queries, and reports are all database objects in MS Access.

note!Answer: D) Switchboard
A switchboard is a special form that links different objects together to integrate the application.

note!Answer: D) Front End
In database terminology, the front end is the user interface, such as MS Access forms, while the back end stores the data.

note!Answer: C) Table Structure and Data
Copying a table in MS Access gives you the choice of copying the structure only, the data only, or both.

note!Answer: C) Database Management System
DBMS stands for Database Management System.

note!Answer: B) Raw facts
Data are raw, unprocessed facts; information is data that has been processed into a useful form.

note!Answer: B) Report
Reports are the MS Access object designed for formatting and printing data.

note!Answer: A) Filter
The main objects of an MS Access database are tables, queries, forms, reports, macros, and modules; a filter is an operation, not an object.

note!Answer: A) Value cannot be entered into second table other than specified in the first table's field
Referential integrity ensures that a foreign key value in the related table must match an existing primary key value in the first table.

note!Answer: B) Report wizard
Report Wizard is one of the standard methods for creating a report in MS Access.

note!Answer: D) PL/1
Oracle, MySQL and Sybase are database management systems, while PL/1 is a programming language.

note!Answer: D) Design View
Design View is used to modify the structure and layout of a form.