DP - Section 1 (1) Flashcards

1
Q

System software consists of low level programs designed to interact with the computer hardware.

……… …………, …………, and system utilities are examples of system software

A

Operating systems / compilers

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

Two components in Oracle Application Express are:

A

SQL Workshop
Application Builder

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

What does APEX stands for?

A

Oracle Application Express (APEX)

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

What do you call number 2

A

Statement window

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

What do you call number 5?

A

Results window

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

………………..: The rules governing the formation of statements in a programming language.

A

Syntax

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

The ……………. command returns all the rows in a table

A

SELECT *

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

The starts with the word ………….. followed by a and a ………………….. followed by a value or …………………..

A

WHERE / column name / Comparison Operator (=, >,

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

The select command select ………………..

A

columns (at least as per my understanding now)

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

………….. ………….: Collections of objects or relations, set of operators to act on those relations, and data integrity for accuracy and consistency.

A

Relational database

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

……………: Intersection of a row and column

A

Field

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

……………: A relational database management system.

A

RDBMS

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

Let’s review the following key terms:

  1. …………. – basic storage structure
  2. ………. – one kind of data in a table
  3. ……… – data for one table instance
A
  1. table
  2. column
  3. row
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Let’s review the following key terms:

  1. …………… – the one value found at the intersection of a row and a column
  2. ……….. ……….. – unique identifier for each row
  3. ………. ………. – column that refers to a primary-key column in another table
A
  1. field
  2. primary key
  3. foreign key
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

There are six properties of tables in a relational database:

  1. Property 1: Entries in columns are …………………….
  2. Property 2: Entries in columns are of the ……………………
  3. Property 3: Each row is ………………
  4. Property 4: Sequence of columns is …………….
  5. Property 5: Sequence of rows is …………….
  6. Property 6: Each column has a ………………….
A
  1. single-valued
  2. same kind
  3. unique
  4. insignificant
  5. insignificant
  6. unique name
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

A relational database-management system (RDBMS) …………… data into related rows and columns

A

organizes

17
Q

As shown in the diagram, communicating with an RDBMS is accomplished by entering a SQL statement in Oracle Application Express

The request is then sent to the Oracle Server (a database running on a computer), the request is processed and the data returned is displayed

A
18
Q

In very large database systems, ……….., …………., and ………….. make up the RDBMS

A

many users, servers, and tables

19
Q

There are four main categories of SQL statements:

A
  1. Data manipulation language (DML)
  2. Data definition language (DDL)
  3. Transaction control language (TCL)
  4. Data control language (DCL)
20
Q

Data manipulation language (DML) statements begin with ……, …….., ………… ,or ………….. and are used to modify the table data by entering new rows, changing existing rows, or removing existing rows

A

INSERT, UPDATE, DELETE, or MERGE

21
Q

Data definition language (DDL) statements create, change, and remove ………. ……….. from the database

A

data structures

22
Q

The keywords ……, ………., …………., …………, and …………… begin Data definition language (DDL) statements

A

CREATE, ALTER, DROP, RENAME, and TRUNCATE

23
Q

The SELECT statement is a limited form of ………… …………. in that it can only access data in the database.

It cannot manipulate data in the database, although it can operate on the accessed data before ………………………………………………

A

DML statement

returning the results of the query.

24
Q

Transaction control language (TCL) statements are used to ………….. ……….. …………… made by Data manipulation language (DML) statements

TCL changes can be grouped together into …………… …………..

A

manage the changes

logical transactions

25
Q

Transaction control language (TCL): Changes to the data are executed using ……………………. 3

A

COMMIT, ROLLBACK, and SAVEPOINT

26
Q

Data control language (DCL) keywords …………….. and …………. are used to give or remove access rights to the database and the structures within it

A

GRANT and REVOKE