WorksheetsPagtatapos Isa
Total questions: 45
Worksheet time: 33mins
The process on how the computer must work with the data.
(a)
A body of information (i.e. electronic files) that needs to be shared but has no network connection.
(a)
Having multiple copies of data increases the chances for a copy of the data to be susceptible to unauthorized access.
(a)
It exists when the same data are stored unnecessarily at different places.
(a)
The condition in which all of the data in the database are consistent with the real-world events and conditions.
(a)
There are no data inconsistencies.
(a)
The data will always yield consistent results.
(a)
It develops when not all of the required changes in the redundant data are made successfully.
(a)
It exists when different and conflicting versions of the same data appear in different places.
(a)
It shows how the human being views the data
(a)
The process of creating a specific data model for a determined problem domain
(a)
It is used to refer to the implementation of a data model in a specific database system.
(a)
It refers to a characteristic of an entity.
(a)
It describes an association among entities.
(a)
An employee may learn many job skills, and each job skill may be learned by many employees. Database designers label the relationship.
(a)
A retail company’s management structure may require that each of its stores be managed by a single employee. In turn, each store manager, who is an employee, manages only a single store.
(a)
It refers to the time-stamped commercial document that itemizes and records a transaction between a buyer and a seller. If goods or services were purchased on credit, the invoice usually specifies the terms of the deal and provides information on the available methods of payment.
(a)
It defines the environment in which data can be managed and to work with the data in the database.
(a)
The conceptual organization of the entire database as viewed by the database administrator.
(a)
A collection of like entities.
(a)
Representational data models represent data by using record structures.
(a)
It refers to the structure that makes the search for particular database records efficient.
Object data model
Followers
Access path
Relationship
It describe the properties of an object.
Schema
Relation
Attributes
Data Design
Two or more entities represents an association among
the entities.
Models
Relationship
Prototype
attributes
A collection of concepts that can be used to describe the structure of a database.
Data Model
Data Design
Data Attributes
Data Collection
It is a composite data type consisting of a group of related data items stored as fields, each with its own name and datatype.
PL/SQL Record
PL/SQL Transaction Record
PL/SQL Transaction
PL/SQL Record Transaction
What is the syntax in defining a record?
record_name cursor_name&ROWTYPE
record_name table_name%ROWTYPE
record_name table_name%TYPE
record_name cursor_name%TYPE
It allows us to declare a variable as a record based on a particular table's structure.
%TYPE
%ROWTYPE
%TYPEROW
PL/SQL records must:
Have one or more components/fields of any scalar or composite type
have the same as rows in a database table
can be assigned initial values and can be defined as NULL
can be components of other records (nested records).
It is the keyword that defines the structure of your record.
ROWTYPE
TYPE
RECORD
TRANSACT
When defining a record, It must include at least one field and the fields may be defined using scalar data types such as DATE, VARCHAR2, or NUMBER, or using attributes such as %TYPE and %ROWTYPE.
True
False
You can declare a type (and a record based on the type) in an outer block and reference them within an inner block.
True
False
Types and records are composite structures that can only be declared in a specific location.
True
False
The type and the record declared in the outer block are
not visible within the outer block and the inner block.
True
False
It is a named set of many occurrences of the same kind of data stored as a variable.
PL/SQL Sets
PL/SQL Frequency
PL/SQL Collection
PL/SQL Records
It is a type of composite variable, similar to userdefined
records.
Sets
Frequency
Collection
Records
It is based on a single field or column
INDEX BY table
INDEX BY table of records
It is based on a composite record type
INDEX BY table
INDEX BY table of records
Every INDEX BY table must have a _______ that serves as an index to a data
UNIQUE KEY
FOREIGN KEY
PRIMARY KEY
CONSTRAINT
This key must be a meaningful business data (e.g. employee ID)
FOREIGN KEY
PRIMARY KEY
UNIQUE KEY
CONSTRAINT
TYPE type_name IS TABLE OF DATA_TYPE
INDEX BY PRIMARY_KEY_DATA_TYPE;
identifier type_name;
This is the syntax of an INDEX BY table
True
False
DECLARE
TYPE type_name IS TABLE OF DATA_TYPE
INDEX BY PRIMARY_KEY_DATA_TYPE;
identifiertype_name;
BEGIN
FOR record IN (SELECT column FROM table)
LOOP
identifier(primary_key) := record.column;
END LOOP;
END;
This is the syntax to populate the INDEX BY table
True
False
An INDEX BY table can have multiple data fields
True
False
If the field can be a composite data type (e.g. RECORD), it is called the INDEX BY table of records.
True
False
The record in the INDEX BY table of records can be %ROWTYPE or a user-defined record.
True
False
