1z0-497 Oracle Database 12c Essentials Questions and Answers

Without any error, you can terminate the active session by executing:

SQL> ALTER SYSTEM KILL SESSION '7, 15';

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

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

Without any error, you can terminate the inactive session by executing:

SQL> ALTER SYSTEM KILL SESSION '12, 63';

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.

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

It is ignored by the query optimizer.

It is not used while the index is being rebuilt.

The index cannot be rebuilt, and has to be re-created.

The index is automatically rebuilt when used the next time.

It starts the second listener without affecting current sessions.

It starts the second listener and terminates all current sessions.

It gives an error because multiple listeners cannot run simultaneously.

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

Moving a data file online prevents DML operations on segments stored in the data file.

Flashing back a database to a point in time before a data file had been renamed online retains the new name.

Moving a data file online can be performed if the data file is in OFFLINE mode.

Moving a data file online cannot be performed if the data file is under BEGIN BACKUP.

listener

user process

service name

server process

Automatic Storage Management (ASM)

Online Data and Application change

Global Data Services (GDS)

Real Application Clusters (RAC)

Oracle Streams

Online Table Redefinition

Oracle Database Vault

It replaces the first four digits of the value from the SALARY column with the number 9.

It replaces the first digit of the value from the SALARY column with the number 4.

It replaces the first digit of the value from the COMMISSION_PCTcolumn with 9.

It replaces the first nine digits of the value from the COMMISSION_PCTcolumn with 1.

It uses the full data redaction method.

It uses the random redaction method.

Uni-directional for 1

Peer-to-peer for 2

Bi-directional for 3

Consolidation for 4

Peer-to-peer for 1

Broadcast for 2

Bi-directional for 3

Consolidation for 4

Uni-directional for 1

Broadcast for 2

Bi-directional for 3

Consolidation for 4

Peer-to-peer for 1

Consolidation for 2

Broadcast for 3

Cascading for 4

You should not install the Oracle Database software into an existing Oracle home from a different release.

A multitenant container database (CDB) can have several pluggable databases (PDBs) with different character sets.

Oracle recommends that you back up the root. sh script after you complete the installation.

Cloning an Oracle home is useful if you are performing multiple Oracle Database Installations.

You can stop existing Oracle processes, including the listener and the database running in the Oracle home, before the database software installation.

Oracle-supplied metadata resides only in the root container.

A seed PDB can sometimes be opened for particular operations.

Multiple PDBs with the same name can reside in the same CDB.

A CDB can have an infinite number of PDBs.

You can create common users in PDBs.

A common user is created in the root container.

A local user is created in the root container.

A local user is created in all the PDBs.

The second SQL statement fails because a local user cannot be created in the root container.

Nothing else happens.

The database is mounted but not opened.

The database is mounted and finally opened.

The database is opened and finally mounted.

The database advances a checkpoint.

A client process commits a transaction.

The redo log buffer becomes full.

A server process cannot find non-dirty blocks after scanning a threshold number of buffers.

A tablespace is changed to read-only status.

The database is shut down in immediate mode.

when upgrading from Oracle Database 12c to the first patch set of Oracle Database 12c

when upgrading from Oracle Database 10g to Oracle Database 12c

when upgrading from Oracle Database 11g to Oracle Database 12c

when upgrading from any previous version of Oracle Database to Oracle Database 12c

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

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

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

Regular ADDM uses AWR snapshots that are not yet purged.

select patch from vSoption where opatch_data=' 333333' ;

select xmltransform(dbms_qopatch.get_opatch_data(3333333), dbms_qopatch.GET_OPATCH_XSLT()) from dual

select opatch from vSpatchsets where opatch_number = '333333';

opatchlsinventory -xml

Listeners use only the TCP/IP protocol.

Multiple listener processes can run simultaneously on a host.

Multiple database instances can be registered with a single listener,

Listener-related errors can be traced only at the administrative level.

Only one database instance can be registered with a single listener at any time.

db_name

maxdatafiles

control_files

instance_name

They can perform only queries.

They are not affected and continue to function normally.

They are terminated and the active transactions are rolled back.

They are not allowed to perform any operations till the listener is started.