최신 1z1-497 무료덤프 - Oracle Database 12c Essentials

A. It starts the second listener and terminates all current sessions.

B. It starts the second listener without affecting current sessions.

C. It gives an error because multiple listeners cannot run simultaneously.

D. It gives an error because multiple listeners can run simultaneously only if there are multiple net service names.

A. when multiple databases are to be registered with the listener

B. when the database instance to be registered with the listener is configured in shared server mode

C. when users need to connect the database instance by using the host naming method

D. when DBAs need to connect remotely to start up the database instance

A. You cannot terminate the inactive session. You have to wait until that session becomes active
again.

B. You cannot terminate the active session. You have to wait until that session becomes inactive.

C. Without any error, you can terminate the active session by executing:
SQL> ALTER SYSTEM KILL SESSION '7, 15';

D. When an inactive session is killed, the status of that session remains visible in VSSESSION
with status KILLED. The rowf the terminated session is removed from VSSESSION after the user
attempts to use the session again.

E. You can terminate the active session by executing:
SQL> ALTER SYSTEM KILL SESSION "7, 15';
But you also get the error message:
ORA-00028: your session has been killed

F. Without any error, you can terminate the inactive session by executing:
SQL> ALTER SYSTEM KILL SESSION '12, 63';

A. full redaction

B. regular expressions

C. no redaction

D. random redaction

E. partial redaction

A. It has to be installed separately after the Oracle Database 12c installation.

B. It can be used in interactive but not batch mode for SQL commands.

C. It has commands for performing database administration operations.

D. Operating system commands can be executed from the SQL*Plus command prompt.

A. SGA is used to speed up queries by caching data blocks, program data, information about database objects, and query results

B. Each server process has its own SGA.

C. SGA contains shared memory structures for all Oracle processes running on a single server.

D. SGA is allocated automatically when a database is started.

E. SGA is allocated automatically when a database is mounted.

F. SGA is read and written by server and background processes.

A. Row-level security

B. Triggers

C. Partitioning

D. Index

E. Database vault

A. The uncommitted transaction is rolled back automatically at the next opening of the database.

B. The DBA has to perform a recovery on the database to recover the uncommitted transaction.

C. The uncommitted transaction is committed at the next startup of the database instance.

D. The online redo log files and archived redo log files are required to accomplish a recovery.

A. Real-Time ADDM analyzes performance in a completely different fashion than regular ADDM.

B. Real-Time ADDM uses AWR snapshots of the last 10 minutes.

C. Real-Time ADDM uses ASH recent activity from SGA data.

D. Regular ADDM uses AWR snapshots that are not yet purged.

A. There is only one SYSTEM tablespace per CDB.

B. There is one SYSAUXtablespace per PDB.

C. There is a set of redo log files per PDB.

D. There is only one instance per PD

E. There is only one UNDO tablespace per CDB.