Section 6 Lessons 1-4 Review

Check email, Create documents, Edit photographs

Application programs enable us to ________.

SQL Workshop

SQL Commands can be entered and run from the ________________ option within the APEX Application.

unique

A primary key must contain a value and the value must be _______.

basic storage

A table is the _______________ structure of an RDBMS.

foreign key, primary key

A _____________ value must match an existing _____________ value otherwise, it must be null.

Row Source Generation, Execution, Parsing, and Optimization

All of the following are stages of SQL Processing:

can

Constraints ________ be added to a table after its creation.

consistency and integrity

Constraints ensure the ___________________ of the database.

UPDATE, INSERT, DELETE

Data Manipulation Language includes all of the following:

initially null or takes the default value

If a table already contains rows when a column is added, the new column is ________________ for all the rows.

schema

In the APEX application a ______ is a collection of logical structures of data. A _______ is owned by a database user and has the same name as that user.

Only one

In the SQL Commands option of APEX, you can run __________ SQL command at a time.

History

In the SQL Workshop/SQL Commands ___________ tab you can view and retrieve previously run queries.

DESCRIBE and SELECT

Once you have created a table, you can use the ________________ command to confirm that it was created.

SQL, PL/SQL

Oracle Application Express is an application platform used to share and learn _____ and __________.

table

Relational Databases store data in a two-dimensional matrix known as a _________.

set-based, declarative language

Structured Query Language (SQL) is the ____________________ used to access data in an Oracle database.

generates no rollback information

The TRUNCATE statement is a data definition language (DDL) statement and ______________________.

SET

The UPDATE statement modifies the values of a specific row or rows if the _______ clause is specified.

DDL

The type of SQL Command used to define database structures is :

DML

The type of SQL Command used to modify data is :

client

To connect to an Oracle database you need to use a _____________ program.

Table name, Field names, Field data types

To create a table you must identify all of the following:

SELECT * FROM employees;

To see all the fields and records in the employees table you can run the following query :

It alters the DEPT_TEST table to add a composite unique key comprising of the DEPT_ID and DEPARTMENT_NAME.

What does the following statement do: ALTER TABLE DEPT_TEST ADD CONSTRAINT unq_dept_det UNIQUE (DEPT_ID, DEPARTMENT_NAME) ;

The table has no rows, The column contains only null values, or The decrease in column width is not less than the existing values in that column

When altering a table, you can decrease the width of a column if ...

WHERE

When issuing a SQL DELETE command all rows in the table are deleted if you omit the __________ clause.

DROP

When you _______ a table, the database loses all the data in the table.

error is returned if you try to violate the constraint rule

When you have constraints in place on columns, an ________________________.

foreign keys

You can logically relate data from multiple tables using ___________.

SYS_Cn

You can name a constraint or the Oracle server generates a name by using the ________ format.

SQL Scripts

You can upload and save a SQL Script from the _____________ option.

Not Null

___________ constraints can only be created at the column level.