DP - Section 1 (1)

Question 1

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

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

Answer 1

Operating systems / compilers

Question 2

Two components in Oracle Application Express are:

Answer 2

SQL Workshop
Application Builder

Question 3

What does APEX stands for?

Answer 3

Oracle Application Express (APEX)

Question 4

What do you call number 2

Answer 4

Statement window

Question 5

What do you call number 5?

Answer 5

Results window

Question 6

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

Answer 6

Syntax

Question 7

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

Answer 7

SELECT *

Question 8

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

Answer 8

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

Question 9

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

Answer 9

columns (at least as per my understanding now)

Question 10

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

Answer 10

Relational database

Question 11

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

Answer 11

Field

Question 12

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

Answer 12

RDBMS

Question 13

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

Answer 13

1. table
2. column
3. row

Question 14

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

Answer 14

1. field
2. primary key
3. foreign key

Question 15

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 ………………….

Answer 15

1. single-valued
2. same kind
3. unique
4. insignificant
5. insignificant
6. unique name

Question 16

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

Answer 16

organizes

Question 17

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

Answer 17

Question 18

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

Answer 18

many users, servers, and tables

Question 19

There are four main categories of SQL statements:

Answer 19

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

Question 20

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

Answer 20

INSERT, UPDATE, DELETE, or MERGE

Question 21

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

Answer 21

data structures

Question 22

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

Answer 22

CREATE, ALTER, DROP, RENAME, and TRUNCATE

Question 23

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 ………………………………………………

Answer 23

DML statement

returning the results of the query.

Question 24

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

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

Answer 24

manage the changes

logical transactions

Question 25

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

Answer 25

COMMIT, ROLLBACK, and SAVEPOINT

Question 26

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

Answer 26

GRANT and REVOKE