최신 1Z0-082 무료덤프 - Oracle Database Administration I

A. stored procedures

B. sequences

C. index

D. tables

E. undo

F. clusters

A. INTERVAL year to month columns only support monthly Intervals within a single year.

B. The value in an interval day to SECOND column can be copied into an interval year to month column.

C. INTERVAL year TO month columns support yearly intervals.

D. INTERVAL year to month columns only support monthly intervals within a range of years.

E. INTERVAL day to second columns support fractions of seconds.

F. The year field in an interval year to month column must be a positive value.

A. SYSDATE can be queried only from the DUAL table

B. CURRENT_DATE returns the current date and time as per the session time zone

C. SYSDATE can be used in expressions only if the default date format is DD-MON-RR

D. CURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of fractional seconds

E. CURRENT_TIMESTAMP returns the same date as CURRENT_DATE

F. SYSDATE and CURRENT_DATE return the current date and time set for the operating system of the database server

A. EXPIRY_ DATE cannot be used in arithmetic expressions.

B. PRODUCT _price contains the value zero by default if no value is assigned to it.

C. PRODUCT_NAKE cannot contain duplicate values.

D. EXPIRY_ DATE contains the sysdate by default if no date is assigned to it.

E. PRODUCT _ic can be assigned the PRIMARY KEY constraint.

F. PRODUCT _price can be used in an arithmetic expression even if it has no value stored in it.

A. It displays the PRIMARY KEY constraint for any column or columns that have that constraint

B. It can be used to display the structure of an existing view

C. It displays the NOT NULL constraint for any columns that have that constraint

D. It can be used from SQL Developer

E. It displays all constraints that are defined for each column

F. It can be used only from SQL*Plus

A. when a CREATE INDEX statement is executed successfully in the same session

B. when a DBA issues a successful SHUTDOWN IMMEDIATE statement and the user then issues a COMMIT

C. when a DBA issues a successful SHUTDOWN TRANSACTIONAL statement and the user then issues a COMMIT

D. when the session logs out successfully

E. when a COMMIT statement is issued by the same user from another session in the same database instance

F. when a CREATE TABLE AS SELECT statement is executed unsuccessfully in the same session

A. Unexpired UNDO is always retained.

B. UNDO_RETENTION specifies how long all types of UNDO are retained.

C. UNDO_RETENTION specifies for how long Oracle attempts to keep unexpired UNDO.

D. Active UNDO is always retained.

E. UNDO_RETENTION specifies for how long Oracle attempts to keep expired and unexpired UNDO.

A. undo segments are owned by SYSBACKUP.

B. An undo tablespace may be owned by only one instance.

C. undo segments are owned by SYSTEM.

D. An instance will crash if the active undo tablespace is lost.

E. There can be only one undo tablespace created in a database.

A. one instance on one server associated with two or more databases on the same server

B. one instance on one server not associated with any database

C. two or more instances on separate servers all associated with one database

D. one instance on one server associated with two or more databases on separate servers

E. one instance on one server associated with one database

A. SELECT &col1, &col2FROM "&table"WHERE &condition;

B. SELECT &col1, &col2FROM &&tableWHERE &condition;

C. SELECT &&col1, &&col2FROM &tableWHERE &&condition;

D. SELECT &&col1, &&col2FROM &tableWHERE &&condition = &&cond;

E. SELECT '&&col1', '&&col2'FROM &tableWHERE '&&condition' = '&cond';