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

A. It returns the date for the last Monday of the current month

B. It generates an error

C. It returns the date for the first Monday of the next month

D. It executes successfully but does not return any result

A. The number of columns selected in each SELECT statement must be identical

B. The output is sorted by the UNION ALL operator

C. The names of columns selected in each SELECT statement must be identical

D. NULLS are not ignored during duplicate checking

E. Duplicates are eliminated automatically by the UNION ALL operator

A. no segments are created

B. T1 only

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

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

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

A. The initialization parameter file is read

B. The online redo logs are opened

C. The Oracle background processes are started

D. The control file is read

E. The online data files are opened

F. The alert log records the execution details

A. You can use a single instance of EM Express to manage multiple database running on the same server.

B. EM Express uses a separate repository database to store target database metadata.

C. By default, EM express is available for a database after database creation using DBCA.

D. You cannot start up a database instance using EM Express.

E. You can shut down a database instance using EM Express.

A. Online index segment shrink

B. Automatic data file extension (AUTOEXTEND)

C. Capacity planning growth reports based on historical data in the Automatic Workload Repository (AWR)

D. Oracle Managed Files (OMF)

E. Online table segment shrink

A. The LOCAL_LISTENER database parameter is not set to a service name that refers to LISTENER_1

B. The listener is not listening on the default port 1521

C. The SID_LIST_LISTENER section is not contained in the LISTENER.ORA file

D. The service DB01.abc.com is statically registered

E. The service DB01.abc.com is dynamically registered

A. the ability to prevent a password from ever being reused

B. the number of hours for which an account is locked after the configured number of login attempts has been reached

C. the number of password changes required within a period of time before a password can be reused

D. the number of days for which an account may be inactive before it is locked

E. the maximum amount of CPU time allowed for a user's sessions before their account is locked

F. the maximum number of sessions permitted for a user before the account is locked

G. the number of days for which an account is locked after the configured number of login attempts has been reached

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. A DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back.

B. A TRUNCATE command issued in a session causes all rows in a GLOBAL TEMPORARY TABLE for the issuing session to be deleted.

C. Any GLOBAL TEMPORARY TABLE rows existing at session termination will be deleted.

D. GLOBAL TEMPORARY TABLE space allocation occurs at session start.

E. A GLOBAL TEMPORARY TABLE'S definition is available to multiple sessions.

F. GLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session whose user has been granted select on the table.