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.