CIT 381 Chapter 8, Database Systems: Design, Implementation, and
Management
1. Anonymous PL/SQL Block: A PL/SQL block that has not been given a specific name.
2. Base Table: The table on which a view is based.
3. Batch Update Routine: A routine that pools transactions into a single group to update a master tale in a
single operation.
4. Correlated Subquery: A subquery that executes once for each row in the outer query.
5. CREATE VIEW: A SQL command that creates a table's structures using the characteristics and attributes given.
6. Cross Join: A join that performs a relationship product (or Cartesian product) of two tables.
7. Cursor: A special construct used in procedural SQL to hold the data rows returned by a SQL query. A cursor may
1/2
, be considered a reserved area of memory in which query output is stored, like an array holding columns and rows.
Cursors are held in a reserved memory area in the DBMS server, not in the client computer.
8. Dynamic SQL: An environment in which the SQL statement is not known in advance, but instead is generated
at run time. In a dynamic SQL environment, a program can generate the SQL statements that are required o respond
to ad hoc queries.
9. Embedded SQL: SQL statements contained within application programming languages such as BOCOL, C++,
ASP, Java, and ColdFusion.
10. Explicit Cursor: In procedural SQL, a cursor created to hold the output of a SQL statement that may return
two or more more rows, but could return zero or only one row.
11. Host Language: Any language that contains embedded SQL statements.
12. Implicit Cursor: A cursor that is automatically created in procedural SQL when the SQL statement returns
2/2
Management
1. Anonymous PL/SQL Block: A PL/SQL block that has not been given a specific name.
2. Base Table: The table on which a view is based.
3. Batch Update Routine: A routine that pools transactions into a single group to update a master tale in a
single operation.
4. Correlated Subquery: A subquery that executes once for each row in the outer query.
5. CREATE VIEW: A SQL command that creates a table's structures using the characteristics and attributes given.
6. Cross Join: A join that performs a relationship product (or Cartesian product) of two tables.
7. Cursor: A special construct used in procedural SQL to hold the data rows returned by a SQL query. A cursor may
1/2
, be considered a reserved area of memory in which query output is stored, like an array holding columns and rows.
Cursors are held in a reserved memory area in the DBMS server, not in the client computer.
8. Dynamic SQL: An environment in which the SQL statement is not known in advance, but instead is generated
at run time. In a dynamic SQL environment, a program can generate the SQL statements that are required o respond
to ad hoc queries.
9. Embedded SQL: SQL statements contained within application programming languages such as BOCOL, C++,
ASP, Java, and ColdFusion.
10. Explicit Cursor: In procedural SQL, a cursor created to hold the output of a SQL statement that may return
two or more more rows, but could return zero or only one row.
11. Host Language: Any language that contains embedded SQL statements.
12. Implicit Cursor: A cursor that is automatically created in procedural SQL when the SQL statement returns
2/2
