Oracle Database 12c Essentials - 1z1-497무료 덤프문제 풀어보기

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

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

C. 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

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

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

F. 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.

A. recompile it

B. rework the applications schema

C. rewrite its SQL queries

D. nothing; it is transparent

E. relink

A. It supports multi master and bidirectional replication architectures where there are multiple databases that all contain the same data, even if they are not synchronized.

B. Any application compatible with a read-only database can run on an Oracle Active Data Guard standby.

C. It provides new support for DML to global temporary tables and the use of sequences in the standby database.

D. It repairs block corruptions detected in the primary or standby database.

E. It supports different software patch levels between a primary database and its physical standby database for the purpose of applying and validating Oracle patches in a rolling fashion.

A. ALTER DATABASE PREPARE TO SWITCHOVER and ALTER DATABASE COMMIT TO SWITCHOVER statements

B. ALTER DATABASE RECOVER MANAGED STANDBY DATABASE statement with the FINISH keyword

C. ALTER DATABASE RECOVER TO STANDBY DATABASE statement with the FINISH keyword

D. D) ALTER DATABASE PREPARE SWITCHOVER and ALTER DATABASE COMMIT TO SWITCHOVER Statements

A. You can perform incomplete recovery by using the command:
RESTORE DATABASE;
FROM TAG "consistent_whole_backup";
RECOVER DATABASE NOREDO;

B. Media recovery is possible in most cases.

C. Only consistent backups can be used for restoring a database in NOARCHIVELOG mode.

D. You can perform complete recovery by using the command:
RESTORE DATABASE
FROM TAG"consistent_whole_backup";
RECOVER DATABASE;

A. Undo protects against inconsistent reads, whereas redo protects against data loss.

B. Undo reverses a change, whereas redo re-creates a change.

C. Redo reverses a change, whereas undo re-creates a change.

D. Redo protects against inconsistent reads, whereas undo protects against data loss.

A. performs database failovers

B. replaces the functionality of Oracle Clusterware and Oracle RAC

C. works seamlessly with Oracle Site Guard

D. coordinates site failovers

E. performs data replication

A. Oracle Database Advanced Queuing is independent of Oracle Streams.

B. Oracle Database Advanced Replication is deprecated in Oracle Database 12c Release 1, including multimaster replication, updatable materialized views, multitier materialized views, and deployment templates.

C. The Oracle Streams information flow consists of three components: capture, redo transfer, arid consumption.

D. Oracle Streams is deprecated in Oracle Database 12c Release 1.

E. The Oracle GoldenGate software architecture is composed of three primary components: capture, propagate, and trail files.

A. It shows a message saying one or more prerequisite checks have failed and the installation aborts.

B. It can be continued.

C. It resizes the swap space automatically when you proceed further.

D. It can be continued, but the instance cannot be started without increasing swap space.

A. Instead of performing transactions, SQL*Loader directly writes data blocks to the data files.

B. Redo is not generated while performing conventional path loads.

C. INSERT triggers are disabled before the conventional path load and re-enabled at the end of the load.

D. Only PRIMARY KEY, UNIQUE KEY, and NOT NULL constraints are checked,

E. No exclusive locks are acquired when the conventional path loads are performed.