DP - Section 1 (1) Flashcards
System software consists of low level programs designed to interact with the computer hardware.
……… …………, …………, and system utilities are examples of system software
Operating systems / compilers
Two components in Oracle Application Express are:
SQL Workshop
Application Builder
What does APEX stands for?
Oracle Application Express (APEX)
What do you call number 2
Statement window
What do you call number 5?
Results window
………………..: The rules governing the formation of statements in a programming language.
Syntax
The ……………. command returns all the rows in a table
SELECT *
The starts with the word ………….. followed by a and a ………………….. followed by a value or …………………..
WHERE / column name / Comparison Operator (=, >,
The select command select ………………..
columns (at least as per my understanding now)
………….. ………….: Collections of objects or relations, set of operators to act on those relations, and data integrity for accuracy and consistency.
Relational database
……………: Intersection of a row and column
Field
……………: A relational database management system.
RDBMS
Let’s review the following key terms:
- …………. – basic storage structure
- ………. – one kind of data in a table
- ……… – data for one table instance
- table
- column
- row
Let’s review the following key terms:
- …………… – the one value found at the intersection of a row and a column
- ……….. ……….. – unique identifier for each row
- ………. ………. – column that refers to a primary-key column in another table
- field
- primary key
- foreign key
There are six properties of tables in a relational database:
- Property 1: Entries in columns are …………………….
- Property 2: Entries in columns are of the ……………………
- Property 3: Each row is ………………
- Property 4: Sequence of columns is …………….
- Property 5: Sequence of rows is …………….
- Property 6: Each column has a ………………….
- single-valued
- same kind
- unique
- insignificant
- insignificant
- unique name