ITEC36 MIDTERM

Question 1

It is a DBMS from Microsoft.

Answer 1

Microsoft Access

Question 2

What is the file extension of MS Access 2007 above version of Microsoft?

Answer 2

.accdb

Question 3

It provides all the data definition, data
manipulation, and data control features
that you need to manage large volumes of
data.

Answer 3

MS Access

Question 4

It is an object that is used to define and store data.

Answer 4

Tables

Question 5

It is an object that provides a custom view of data from one or more tables.

Answer 5

Query

Question 6

It is a way of searching for and compiling data from one or more tables.

Answer 6

Queries

Question 7

It is an object used for data input or display of control of application execution.

Answer 7

Form

Question 8

It is an object designed for formatting, calculating, printing, and summarizing selected data.

Answer 8

Report

Question 9

This object is a structured definition of one or more actions that you want Access to perform in response to a defined event.

Answer 9

Macro

Question 10

It is an object containing custom procedures that you code using Visual Basic.

Answer 10

Module

Question 11

It is used to set the data types, insert or delete fields, and set the Primary Key.

Answer 11

Design View

Question 12

It is used to enter and view the data for the records.

Answer 12

Datasheet View

Question 13

It is an element of a table that contains a specific item of information.

Answer 13

Data

Question 14

It determines what kind of data the field can store.

Answer 14

Data Type

Question 15

It is a alphanumeric data up to 255 characters.

Answer 15

Short Text

Question 16

It is a data type with large amounts of alphanumeric data, sentences and paragraphs – 64,000 characters.

Answer 16

Long Text

Question 17

It is a data type used for numeric data.

Answer 17

Number

Question 18

It is a data type used for monetary values.

Answer 18

Currency

Question 19

It is a data type used for unique value generated by Access for each new record.

Answer 19

AutoNumber

Question 20

It is a data type used for date and time.

Answer 20

Date/Time

Question 21

It is a data type used to display pictures, graphs, or other ActiveX objects from another Windows-based application.

Answer 21

OLE Object

Question 22

It is a data type used to link address to a document or file on the Internet.

Answer 22

Hyperlink

Question 23

It is a data type used to attach files such as pictures, documents, spreadsheets, or charts.

Answer 23

Attachment

Question 24

It is a data type used to create an expression that uses data from one or more fields.

Answer 24

Calculated

Question 25

It generally refers to the suppression of details of data organization and storage.

Answer 25

Data Abstraction

Question 26

It is a collection of concepts that can be used to describe the structure of a database.

Answer 26

Data Model

Question 27

It is a category of data models that uses concepts such as entities, attributes, and relationships.

Answer 27

High-level or Conceptual Data Model

Question 28

It represents a real-world object or concept.

Answer 28

Entity

Question 29

It represents some property of interest that further describes an entity.

Answer 29

Attribute

Question 30

It represents an association among the entities.

Answer 30

Relationship

Question 31

It provides concepts that describe the details of how data is stored on the computer storage media.

Answer 31

Low-level or Physical Data Model

Question 32

It provides concepts that may be easily understood by end users but that are not too far removed from the way data is organized in computer storage.

Answer 32

Implementation or Representational Data Model

Question 33

It defines the statements to implement the database schema.

Answer 33

DDL (Data Definition Language)

Question 34

It provides operations that handle user requests.

Answer 34

DML (Data Manipulation Language)

Question 35

It is a user interface which allows for the ability to input queries to a database without using the query language itself.

Answer 35

DBMS Interface

Question 36

it is a collective system of components that consist of software, hardware, people, techniques and data.

Answer 36

Database Environment

Question 37

It is a type of database architecture which includes the DBMS is the only entity where the user directly sits on the DBMS and uses it.

Answer 37

Tier 1

Question 38

It is a type or database architecture where programmers access the DBMS by means of an application.

Answer 38

Tier 2

Question 39

It is most widely used architecture to design a DBMS.

Answer 39

Tier 3

Question 40

It is a conceptual model that represents the information structure of a problem domain in terms of entities and relationships.

Answer 40

ER Model

Question 41

What is the symbol for entity in entity relationship diagram?

Answer 41

Rectangle

Question 42

What is the symbol for attribute in entity relationship diagram?

Answer 42

Eclipse

Question 43

What is the symbol for relationship in entity relationship diagram?

Answer 43

Diamond

Question 44

It is a type of attribute which cannot be divided further.

Answer 44

Simple Attribute

Question 45

It is a type of attribute that are made of more than one simple attribute.

Answer 45

Composite Attribute

Question 46

It is a type of attribute that contain more than one values.

Answer 46

Multi-value Attribute

Question 47

It is a type of attributes that do not exist in the physical database.

Answer 47

Derived Attribute

Question 48

This are the set of statements, that are used to define and manipulate a database.

Answer 48

Database Languages

Question 49

It represents the logical configuration of all part of a relational database. It can exist both as visual representation and as a set of formulas known as integrity constraints that govern a database.

Answer 49

Database Schema

Question 50

It refers to the content of a database at a moment in time.

Answer 50

Database State or Snapshot