Database Section 6 Lesson 1-4 Quiz
which software is used to manage reading and manipulating a relational database
DBMS software
The stages of SQL processing are Parsing, Optimization, Row Source Generation and ____
Execution
To see all fields and records in the employees tables you can run the following query
SELECT * FROM employees
you use the ___ option to mark one or more columns as unused
SET UNUSED
Oracle Application Express is an application platform used to share and learn ___ and ___
SQL & PL/SQL
the __ clause in a query comes immediately after the SELECT and FROM
WHERE
when issuing a SQL DELETE command all rows in the table are deleted if you omit the __ clause
WHERE
in SQL Workshop/SQL Commands ___ tabs you can view and retrieve previously run queries
history
a collection of DML statements that form a logical unit of work is called a __
transaction
When you have constraints in place on columns, an error is returned if you try to violate the constraint rule (true/false)
true
a table is the basic storage structure of an RDBMS (true/false)
true
Once you have created a table, you can use the ____ command to confirm that it was created (2 correct) -SELECT -LIST -DESCRIBE -ORDER BY
-SELECT -DESCRIBE
Application programs enable us to __ -check email -create documents -edit photographs -all of the above
-all of the above
the Data Definition Language preforms all of the following except: -alter tables -insert data into tables -create tables -add constraints to tables
-insert data into tables
Data Manipulation Language includes all of the following except: -DELETE -UPDATE -COMMIT -INSERT
COMMIT
to issue a CREATE TABLE statement, you must have the __ privilege
CREATE TABLE
Any column that is not listed explicitly obtains a null value in the new row unless we have ___ values for the missing columns that are used
DEFAULT
columns without the NOT NULL constraint can contain null values by default (true/false)
true
When altering a table, you can decrease the width of a column if ____ (3 correct) -the decrease in column width is not less than existing values in that column -the table has no rows -the column contains only null values -the column contains only numeric values
-the decrease in column width is not less than existing values in that column -the table has no rows -the column contains only null values
constraints ensure the consistency and integrity of the database (true/false)
true
to use a computer application you must understand how it is built and how it works inside (true/false)
false
when you define a table, you can specify that a column should be given a default value by using the LITERAL option (true/false)
false
a ___ can be found at the intersection of a row and column and contains one value
field
You can logically relate data from multiple tables using ____
foreign keys
Structure Query Language (SQL) is the set-based, declarative language used to access data in an Oracle database (true/false)
true
all of the following are tools to access a relational database except: -Oracle SQL Developer -Oracle SQL Data Modeler -SQL * Plus -Oracle Application Express
-Oracle SQL Data Modeler
SQL Commands can be entered and run from the ___ option within the APEX Application
SQL Workshop