ITSE-1345 - Topic Quiz - Oracle PL/SQL Overview -1

SQL*Plus provides which of the following?

A. An interactive mode - B. A call mode - C.A server modeB. SQL*Plus supports an interactive mode, which is also known as the client software. Calls made by external programs run through a portion of SQL*Plus known as the call mode.

Which of the following converts a relational model to an object-relational model?

C.An object data type D. An imperative language that lets you build native object types E. A JVM inside the database You require an object data type and an imperative language to create the objects. PL/SQL is that language, and the JVM runs the objects.

Which of the following are not types of SQL statements?

Create, replace, update, and delete (CRUD) statements. CRUD is a description of functionality, not of the DML type of statements

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

False - A two-tier model does NOT work between a browser and a database server.

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

False - SQL is a set-based declarative language that lets you work in the Oracle database

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

False. The Oracle internal JVM runs all stored Java libraries.

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

False. The object-relational database model evolved from the relational database model because object-oriented database models required too much memory to marshal objects.

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

PL/SQL can call SQL, implement object types, wrap C-callable programs, and wrap Java programs.

Which of the following describes the roles of the Oracle listener?

The Oracle listener listens for incoming client requests and forwards requests to a SQL* Plus session. The actual SQL*Plus session is a different executable from the interactive one that you launch when working with Oracle Database 12c.

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

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

PL/SQL is the procedural extension of SQL?

True. PL/SQL is the Procedure Language/Structured Query Language.

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

True. A three-tier model is a specialized form of an n-tier model, where you have a browser, an Apache server, and a database server.

Relational databases store data?

True. Relational databases store data in tables.

Relational databases store information about how data is stored?

True. Relational databases store information about how data is stored, and this type of information is called the data catalog or data dictionary.

Relational Software, Inc. became Oracle Corporation?

True. Software Development Laboratories (SDL) led to the formation of Relational Software, Inc. (RSI), which in turn led to the formation of Oracle Corporation.