Which three statements are true about single-row functions? (Choose three.)

A. They can be used only in the WHERE clause of a SELECT statement

B. The argument can be a column name, variable, literal or an expression

C. The data type returned can be different from the data type of the argument

D. They can be nested to any level

E. They can accept only one argument

F. They return a single result row per table

You execute this command:

During the export operation, you detach from the job by using CTRL+C and then execute this command:

Export> STOP_JOB=immediate Are you sure you wish to stop the job ([yes]/no): yes Which two statements are true about the job? (Choose two.)

A. You can no longer monitor it

B. You can reattach to it and monitor it

C. It is paused and can be resumed

D. It continues to run in the background

E. It terminates

Which two are true about a SQL statement using SET operators such as UNION? (Choose two.)

A. The data type group of each column returned by the second query must match the data type of the corresponding column returned by the first query.

B. The number, but not names, of columns must be identical for all SELECT statements in the query.

C. The data type of each column returned by the second query must exactly match the data type of the corresponding column returned by the first query.

D. The names and number of columns must be identical for all SELECT statements in the query.

E. The data type of each column returned by the second query must be implicitly convertible to the data type of the corresponding column returned by the first query.

You execute this command:

CREATE SMALLFILE TABLESPACE sales DATAFILE `/u01/app/oracle/sales01.dbf SIZE 5G SEGMENT SPACE MANAGEMENT AUTO;

Which two actions must you take to ensure UNDOTBS01 is used as the default UNDO tablespace? (Choose two.)

A. It must be smaller than the smallest BIGFILE tablespace

B. Free space is managed using freelists

C. Any data files added to the tablespace must have a size of 5 gigabytes

D. It uses the database default blocksize E. It is a locally managed tablespace

In the SALES database, DEFERRED_SEGMENT_CREATION is TRUE.

Examine this command:

SQL> CREATE TABLE T1(c1 INT PRIMARY KEY, c2 CLOB);

Which segment or segments, if any, are created as a result of executing the command?

A. T1, an index segment for the primary key, a LOB segment, and a lobindex segment

B. no segments are created

C. T1 only

D. T1 and an index segment created for the primary key only

E. T1, an index segment for the primary key, and a LOB segment only