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

To modify the SQL*Plus display settings click ____ on the menu bar,and then click Environment.

A search condition begins with the keyword ____.

To add two string values together to form one string,use the ____________________ function.

The ____ command is used to run a script.

Explain what a search condition is and describe the SQL syntax.

The = operator is used by an exact search condition.

You can choose to increment a sequence by a number other than 1 when each next value is retrieved.

____ is the default date format.

Duplicate values will automatically be suppressed from query results unless you specify otherwise.

If you do not wish to save the changes made in a transaction,use the ____________________ command to undo them.

Which query is executed first in a nested subquery?

To remove privileges from a user,use the ____ command.

To sort query output,use the ____________________ clause.

ROUND is a ____ function.

If you are selecting from a table in another user's schema,you must qualify the table name with the schema name.

Which character is used to indicate the outer table in an outer join?

DML commands that insert,update,or delete database data are called ____________________.

What character is used to retrieve all columns in a table?

If o_date is a DATE column,the expression o_date + 10 will give a value 10 days from o_date.

The set operator ____________________ returns only rows returned by both queries.