Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Reviewers > ITEC36 MIDTERM > Flashcards

ITEC36 MIDTERM Flashcards

1
Q

It is a DBMS from Microsoft.

A

Microsoft Access

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

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

A

.accdb

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

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

A

MS Access

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

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

A

Tables

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

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

A

Query

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

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

A

Queries

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

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

A

Form

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

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

A

Report

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

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

A

Macro

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

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

A

Module

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

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

A

Design View

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

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

A

Datasheet View

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

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

A

Data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

It determines what kind of data the field can store.

A

Data Type

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

It is a alphanumeric data up to 255 characters.

A

Short Text

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

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

A

Long Text

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

It is a data type used for numeric data.

A

Number

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

It is a data type used for monetary values.

A

Currency

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

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

A

AutoNumber

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

It is a data type used for date and time.

A

Date/Time

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

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

A

OLE Object

22
Q

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

A

Hyperlink

23
Q

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

A

Attachment

24
Q

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

A

Calculated

25
Q

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

A

Data Abstraction

26
Q

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

A

Data Model

27
Q

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

A

High-level or Conceptual Data Model

28
Q

It represents a real-world object or concept.

A

Entity

29
Q

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

A

Attribute

30
Q

It represents an association among the entities.

A

Relationship

31
Q

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

A

Low-level or Physical Data Model

32
Q

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.

A

Implementation or Representational Data Model

33
Q

It defines the statements to implement the database schema.

A

DDL (Data Definition Language)

34
Q

It provides operations that handle user requests.

A

DML (Data Manipulation Language)

35
Q

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

A

DBMS Interface

36
Q

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

A

Database Environment

37
Q

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.

A

Tier 1

38
Q

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

A

Tier 2

39
Q

It is most widely used architecture to design a DBMS.

A

Tier 3

40
Q

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

A

ER Model

41
Q

What is the symbol for entity in entity relationship diagram?

A

Rectangle

42
Q

What is the symbol for attribute in entity relationship diagram?

A

Eclipse

43
Q

What is the symbol for relationship in entity relationship diagram?

A

Diamond

44
Q

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

A

Simple Attribute

45
Q

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

A

Composite Attribute

46
Q

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

A

Multi-value Attribute

47
Q

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

A

Derived Attribute

48
Q

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

A

Database Languages

49
Q

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.

A

Database Schema

50
Q

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

A

Database State or Snapshot

Reviewers (5 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions