is the primary command line interface to your Oracle database.

Connecting to the Database with SQL*Plus: When you connect with SQL*Plus, you are connecting to

When you connect with SQL*Plus, you are connecting to the Oracle instance

What are several ways to submit SQL statements and commands to Oracle Database?

using the command-line interface of SQL*Plus.

a graphical user interface: such as

Oracle Enterprise Manager Database Express

Oracle Enterprise Manager Cloud Control

Oracle Enterprise Manager Database Express (EM Express) or Oracle Enterprise Manager Cloud Control (Cloud Control) With these tools, you use a graphical interface to

Directly, using SQL Developer: Developers use SQL Developer to

Directly, using SQL Developer: Developers use

Oracle Database also supports a superset of SQL, which includes commands for

Oracle Database supports a superset of SQL

Oracle Database not supports a superset of SQL

You use SQL*Plus to

You use SQL*Plus to

Before you can submit SQL statements and commands, you must connect to the database. With ..............................................

Before you can submit SQL statements and commands, you must connect to the database. With SQL*Plus

With SQL*Plus, you can connect ................................. or .............................................

means connecting to an Oracle database running on the same computer on which you are running SQL*Plus.

means connecting over a network to an Oracle database that is running on a remote computer. Such a database is referred to as a remote database.

The SQL*Plus executable on the local computer is provided by

is a collection of processes and memory, and a set of disk files that contain user data and system data.

Take the necessary action on your platform to open a window into which you can enter operating system commands

Depending on your platform, you may have to set environment variables before starting SQL*Plus, or at least verify that they are set properly.

Submit the SQL*Plus CONNECT command to initially connect to the Oracle database instance or at any time to reconnect as a different user.

to initially connect to the Oracle database instance or at any time to reconnect as a different user.

Each instance has an

also known as a system ID (SID)

Because there can be multiple Oracle instances on a host computer, each with its own set of data files, you must identify ...............................................

can not be multiple Oracle instances on a host computer

can be multiple Oracle instances on a host computer

you identify the instance by setting operating system environment variables.

you must set environment variables to help the operating system find the SQL*Plus executable and to provide the executable with a path to its support files and scripts.

you identify the instance by specifying a network address and a database service name.

Why do we set environment variables when using SQL*Plus?

Environment variables are needed for:

What does the operating system need to find using environment variables?

What do environment variables provide to SQL*Plus?

pluggable databases (PDBs), such as .....................................................

To manage objects that are shared by the multitenant container database (CDB) and its pluggable databases (PDBs) connect to the

is a collection of container databases where each container is a collection of schemas, objects, and related structures.

is a user-created container that stores the data and code for an application, such as a human resources application.

From which perspective is the PDB appears to be a logically separate, independent database?

From which perspective is the CDB is the database

Objects such as tablespaces, data files, or temp files can be created in the ................................................. or ...........................................

To manage such objects, connect to the ..............................................................................

connecting to the database means connecting to the CDB root.

on most platforms, you must set the environment variables ....................................... and ............................................

you must configure the PATH environment variable to include the .......................................................

set environment variables by entering operating system commands

Oracle Universal Installer (OUI) automatically assigns values to ORACLE_HOME and ORACLE_SID in the Windows registry.

For all platforms, when switching between instances with different Oracle homes, you must change the

If multiple instances share the same Oracle home, you must change

setenv

export

to Start SQL*Plus we use:

Start SQL*Plus

sqlplus /nolog case-sensitive on UNIX and Linux

This command is used to connect to the CDB root or a particular PDB

SQL*Plus prompts for the SYSTEM user ..................................................

connects to a local database as user SYSTEM

connects to a local database as user SYS with the SYSDBA privilege

connects to a local database as user SYS with the

connects to a local database as user SYSBACKUP with the SYSBACKUP privilege

connects locally to a pluggable database (PDB) named sales_pdb as user SYS with the SYSDBA privilege.

connects locally with the SYSDBA privilege with operating system authentication.