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