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.
