Exam 3: Using SQL Queries to Insert, update, delete, and View Data

To get the current value of a sequence you would select the ____________________ pseudocolumn.

To suppress duplicate values from a query result use the ____________________ qualifier.

All database views are read-only.

If you think that you may wish to rollback part of a transaction,but not the whole thing,it is a good idea to create a ____.

The default sort order for the ORDER BY clause is ascending.

What is the result of selecting CONCAT(s_first,s_last)from student where s_first is "Emily" and s_last is "Smith"

Subqueries can be nested to many levels.

To get the current date and time,use the ____________________ pseudocolumn.

When you truncate a table by mistake,you can use the roll back command to retrieve the data.

An inner join is also known as a(n)____________________.

It is necessary to use the TO_DATE function and a format model to insert "01-JAN-2005" into a date column.

The ____________________ logical operator can be used to combine two search conditions.The result will evaluate to true if both conditions are true.

A series of action queries which represents a logical unit of work is known as a(n)____________________.

A join can only be used to retrieve data from two tables that are related via a foreign key relationship.

What is the difference between deleting all records from a table and truncating the table?

A(n)____ is an alternate name for a query column.

Use ____ to save a transaction.

You must use a table alias when creating a self-join.

Instead of typing "START script-path" at the prompt in SQL*Plus you can use the @ character: @script-path.

What format model would you use to display 1237.35 as $1237.35