CIT 325 - Chapter 1

Which of the following is a capability of PL/SQL?

All of the above Call SQL Implement object types Wrap C-callable programs\Wrap Java programs pg 5

SQL*Plus provides which of the following? (Multiple answers possible)

An interactive mode A call mode A server mode pg 10

Which of the following converts a relational model to an object-relational model? (Multiple answers possible)

An object data type An imperative language that lets you build native object types A JVM inside the database

Which of the following are types of SQL statements? (Multiple answers possible)

DDL, DML, DCL, and TCL pg 12

Which of the following are Data Manipulation Language (DML) statements?

DELETE INSERT UPDATE SELECT

PL/SQL replaces SQL

False

The concept of a Relation Database Management System is simple.

False

You can't call SQL statements from inside a PL/SQL block.

False

A two-tier model works between a browser and a database server.

False pg 13

SQL is an imperative language that lets you work in the Oracle database.

False pg 4

The Oracle database relies on an external Java Virtual Machine to run stored Java libraries.

False pg 5

The relational database model evolved from the object-relational database model.

False pg 5

PL/SQL serves which of the following purposes?

I/O (input/output) External procedures Internally developed Java libraries

Which of the following describes the roles of the Oracle listener? (Multiple answers possible)

Listen for incoming client requests Forward requests to a SQL*Plus session pg 13

PL/SQL can simplify which of the following?

Optimize execution Simplify application development Improve resource utilization

Which of the following are Transaction Control Language (TCL) statements

SAVEPOINT COMMIT ROLLBACK

PL/SQL was developed with which of the following modeling concepts?

Structured programming Static data typing Modularity Parallel of concurrent processing Exception management

DDL stands for Data Definition Language.

True

PL/SQL was and remains an innovative, imperative programming language that supports both event-driven and object oriented programming.

True

A three-tier model is a specialized form of an n-tier model.

True pg 13

PL/SQL is the procedural extension of SQL.

True pg 4

Relational Software, Inc. became Oracle Corporation.

True pg 4

Relational databases store data.

True pg 4

Relational databases store information about how data is stored.

True pg 4

PL/SQL is an imperative language that is both event-driven and object-oriented.

True pg 9