최신Oracle Database 12cR2 Administration - 1z1-072무료샘플문제

A. TEMP

B. UNDOTBS1

C. SYSTEM

D. SYSAUX

E. DATA

A. creating a user session in the System Global Area (SGA)

B. connecting a user process to a server process

C. verifying a user's authentication credentials

D. verifying the service name in an incoming user request

E. maintaining the connection to a client's user process until the user request is completed

F. returning the results of processing from the server process to the user process

A. It must have a unique key constraint.

B. It must not have any referential integrity constraints.

C. It must be in a tablespace that uses Automatic Segment Space Management (ASSM) .

D. It must have row movement enabled.

E. It must not have any DML triggers.

A. It can be granted to any user and any role.

B. It is overridden by any specified user space quota.

C. It can be revoked from a user and replaced with a specific space quota only if no user schema objects exist.

D. It allows a user to have unlimited space only in his or her default permanent tablespace.

E. It allows a user to have unlimited space in any tablespace in the database.

A. They are maintained at the session and system level.

B. All events might be used by an instance regardless of parameter settings.

C. They reveal the cause of performance problems.

D. They display how often a database instance performs particular operations.

E. They are grouped into classes.

A. as SCOTT in BOSTON_DB

B. as SYS in both the databases

C. as SCOTT in DALLAS_DB

D. as SCOTT in BOSTON_DB and SYS in DALLAS_DB

E. as SCOTT in both the databases

A. All rows in EMP.DAT are inserted into U1.EMP but ENAME is set to ### for the second and third rows.

B. All rows in EMP.DAT are inserted into U1.EMP but ENAME is set to NULL for the second and third rows.

C. Only the first and fourth rows in EMP.DAT are inserted into U1.EMP.

D. Only the first row in EMP.DAT is inserted into U1.EMP.

E. It fails because EMP.DAT has some records with more than three characters corresponding to U1.EMP.ENAME.

A. The database opens after the roll forward phase of instance recovery.

B. It occurs after a SHUTDOWN IMMEDIATE.

C. It is guaranteed to complete within fast_start_mttr_target number of seconds.

D. Archived REDO log files are never required to perform instance recovery.

E. Archived REDO log files are required to perform instance recovery.

F. It is performed when mounting a database.

A. Private database link creation requires the same user to exist in both the local and the remote database.

B. A database link can be created only between Oracle databases.

C. A database link created in a database allows a connection from that database instance to another, but not vice versa.

D. A public database link can be used by a user in the local database to connect to any schema in the remote database.

E. A public database link can be created only by SYS.