DFo Final Exam Review

anything in parenthesis

If an arithmetic expression contains more than one operator, __________ are evaluated first.

ORDER BY

In a SELECT statement the ________ clause can be used to sort the rows.

History

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

INSERT

It is not mandatory to specify the column list in the __________ statement.

is not

Null _______ the same as zero or a blank space.

SELECT, DESCRIBE

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

table short name

Primary key constraints are named using the __________________.

table

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

ROWNUM

SQL key word is used to do ranking in top-n-analysis

SET

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

OR

The ______ operator requires either of the component conditions to be true.

NATURAL JOIN

The ________ join clause is based on all the columns in the two tables that have the same name and the same datatype.

WHERE

The _________ clause in a query comes immediately after the SELECT and FROM.

Glossary

The __________ can be used as the naming standard for your Logical Model.

USING

The __________ clause can be used to match columns with the same name, but different data types.

CARTESIAN or CROSS

The ____________ join gets created when a join condition is omitted.

TRUNCATE

The ______________ statement is a data definition language (DDL) statement and generates no rollback information.

Mandatory

The attribute that you assign as primary UID is automatically set to a ______________attribute and will be engineered to a primary key in the relational model.

TRUNCATE

The command that removes all rows from a table, leaving the table empty and the table structure intact is ...

Oracle SQL Developer, SQL * Plus, Oracle Application Express

The following are tools to access a relational database:

Execution

The stages of SQL processing are Parsing, Optimization, Row Source Generation and _____________ .

Select the Logical model, Click the Engineer to Relational Model icon, Accept defaults, Click Engineer

The steps to convert a Logical model to a Relational model using the Oracle SQL Developer Data Modeler are :

DISTINCT

To eliminate duplicate rows in the result, include the _________ keyword in the SELECT clause.

CREATE TABLE

To issue a CREATE TABLE statement, you must have the __________ privilege.

Displays the EMPLOYEE_ID, LAST_NAME, JOB_ID, DEPARTMENT_ID from the EMPLOYEES table where the department id is 90.

What is the result of executing the following statement: SELECT EMPLOYEE_ID, LAST_NAME, JOB_ID, DEPARTMENT_ID AS "DEPTID" FROM EMPLOYEES WHERE DEPARTMENT_ID = 90 ;

WHERE

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

PRIMARY KEY

Which constratint specifies that the column (or combination of column) must contain unique value AND IS NOT NULL for all rows?

BETWEEN

Which operator is used to display rows based on an ordered range of values?

SELECT employee_id, last_name, job_id, salary FROM employees WHERE salary >= 10000 AND job_id LIKE '%JEF%' ;

Which statement will display those employees who have a job title that contains the string 'JEF' and earn $10,000 or more?

COMMIT

With the __________ and ROLLBACK statements, you have control over making changes to the data permanent

concatenation

You can link columns to other columns, arithmetic expressions, or constant values to create a character expression by using the ____________ operator (||).

Developing and expanding your skills with Oracle database, SQL and PL/SQL and Gaining access to SQL and PL/SQL examples shared by the Oracle developer community

You can use Application Express (APEX) for ...

True

You must first select the Logical model you want to work with to Engineer it to a Relational model.

Relational

You must first select the Logical model you want to work with to Engineer it to a ____________ model.

Read

_______ consistency guarantees a consistent view of the data at all times.

Not Null

___________ constraints can only be created at the column level.

Top-n-analysis

______________ is used when you want to retrieve only the top number of records from a result set.

NONEQUIJOIN

A _______________ is a join condition containing something other than an equality operator.

Foreign Key

A column or combination of columns in one table that refers to a primary key in the same or another table.

FULL OUTER

A join between two tables that returns the results of an INNER join as well as the results of a left and right join is a ______________ join.

RDBMS

A table is the basic storage structure of an____________.

A COMMIT or ROLLBACK statement is issued and A DDL statement, such as CREATE, is issued.

A transaction begins when the first DML statement is encountered and ends when one of the following occurs .....

AND

According to the rules of precedence which operator will be evaluated first AND or OR?

A DDL statement is executed., A TCL statement is executed.

An automatic commit occurs when _________ .

null

Arithmetic expressions containing a null value evaluate to _________.

NOT NULL

Columns without the ___________ constraint can contain null values by default.