Computer & IT

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.

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.