Oracle Database 12c Essentials
Question No: 91
You have two database servers EMP and EXP. A user of the database from the EXP server wants to extract some information from the database in the EMP server for cross- verification. Which schema object enables the user to access the information from the remote database?
Question No: 92
Which two statements about Data Recovery Advisor are true?
Data Recovery Advisor can be used to diagnose and repair data corruptions in non- CDBs.
Data Recovery Advisor cannot be used to diagnose and repair data corruptions in the root of a CDB.
Data Recovery Advisor can be used to diagnose and repair data corruptions in PDBs.
You can use the ADVISE FAILURE command to display repair options after running
LIST FAILURE in an RMAN session.
Explanation: A (not B): In the current release, Data Recovery Advisor can only be used to diagnose and repair data corruptions in non-CDBs and the root of a multitenant container database (CDB).
Not C: Data Recovery Advisor is not supported for pluggable databases (PDBs).
D: A failure is detected either automatically by the database or through a manual check such as the VALIDATE command. You can use the LIST FAILURE command to view problem statements for failures and the effect of these failures on database operations. Each failure is uniquely identified by a failure number. In the same RMAN session, you can then use the ADVISE FAILURE command to view repair options, which typically include both automated and manual options.
Reference: Oracle Database Backup and Recovery User#39;s Guide, 12c, Diagnosing and Repairing Failures with Data Recovery Advisor
Question No: 93
Which three statements are true about terminating a session?
Without any error, you can terminate the active session by executing: SQLgt; ALTER SYSTEM KILL SESSION #39;7, 15#39;;
You can terminate the active session by executing: SQLgt; ALTER SYSTEM KILL SESSION quot;7, 15#39;;
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: SQLgt; ALTER SYSTEM KILL SESSION #39;12, 63#39;;
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.
Explanation: B (not A, Not C):
You terminate a current session using the SQL statement ALTER SYSTEM KILL SESSION. The following statement terminates the session whose system identifier is 7 and serial number is 15:
Terminating an Active Session
If a user session is processing a transaction (ACTIVE status) when you terminate the session, the transaction is rolled back and the user immediately receives the following message:
ORA-00028: your session has been killed ALTER SYSTEM KILL SESSION #39;7,15#39;;
E (not F): Terminating an Inactive Session
If the session is not making a SQL call to Oracle Database (is INACTIVE) when it is terminated, the ORA-00028 message is not returned immediately. The message is not returned until the user subsequently attempts to use the terminated session.
When an inactive session has been terminated, the STATUS of the session in the V$SESSION view is KILLED. The row for the terminated session is removed from V$SESSION after the user attempts to use the session again and receives the ORA-00028 message.
Reference: Oracle Database Administrator#39;s Guide, Terminating Sessions URL:
Question No: 94
To revoke unnecessary and unused privileges, you can use Privilege Analysis. Which sequence should you follow?
-Start the analysis.
– Set up the analysis policy type (database, role, context). 3 – Generate the results.
4 -View the results in DBA_USED_PRIVSand DBA_UNUSED_PRJVS. 5 – Stop the analysis.
A. 1, 2, 3, 4, 5
B. 2, 1, 5, 3, 4
C. 5, 1, 2, 3, 4
D. 2, 3, I, 5, 4
E. 1, 2, 4, 5, 2
Answer: B Explanation:
Question No: 95
What happens when you execute these SQL statements?
ALTER SYSTEM SET SGA_TARGET = 992M; ALTER SYSTEM SET SHARED_POOL_SIZE = 0; ALTER SYSTEM SET LARGE_POOL_SIZE = 0; ALTER SYSTEM SET JAVA_POOL_SIZE = 0; ALTER SYSTEM SET DB_CACHE_SIZE = 0;
ALTER SYSTEM SET STREAMS POOL SIZE = 0;
The database stops (shutdown abort).
B) The database Stops (shutdown immediate).
You activate Automatic Shared Memory Management.
You get an error message.
Reference: http://www.orafaq.com/forum/t/67825/0/ (see the second post)
Question No: 96
An Oracle instance is a combination of .
database files and parameter file (initialization parameter file or server parameter file)
System Global Area (SGA) and background processes
a listener process, server processes, and background processes
System Global Area (SGA), server processes, and background processes
database files, System Global Area (SGA), and background processes
Reference: http://docs.oracle.com/cd/A57673_01/DOC/server/doc/SCN73/ch9.htm#o instance
Question No: 97
Which statement about the Oracle Advanced Security Data Redaction feature is true?
It transparently encrypts data at rest in Oracle databases.
It securely manages encryption keys.
It protects against theft or loss of disks and backups.
It prevents OS users from inspecting tablespace files.
It limits the exposure of sensitive data in applications.
It alters data in caches, buffers, and persistent storage.
It impacts operational activities such as backup amp; restore, upgrade amp; patch, and
Explanation: Redacting Sensitive Data for Display
Data Redaction provides selective, on-the-fly redaction of sensitive data in query results prior
to display by applications so that unauthorized users cannot view the sensitive data. It enables
consistent redaction of database columns across application modules accessing the same data.
Data Redaction minimizes changes to applications because it does not alter actual data in internal database buffers, caches, or storage, and it preserves the original data type and formatting when transformed data is returned to the application. Data Redaction has no impact on database operational activities such as backup and restore, upgrade and patch, and
high availability clusters.
Reference: Oracle Advanced Security, 12c, Oracle Data Sheet
Question No: 98
Which two statements about PDBs and CDBs are true?
There is only one SYSTEM tablespace per CDB.
There is only one instance per PDB.
There is a set of redo log files per PDB.
There is only one UNDO tablespace per CDB.
There is one SYSAUXtablespace per PDB.
Question No: 99
Your customer needs server availability that provides uninterrupted access to database services, handling any unexpected failure of one or more machines hosting the database server, due to a hardware or software fault. Which product should your customer use?
Oracle Data Guard
Oracle Real Application Clusters
Reference: http://www.oracle.com/technetwork/database/availability/maximum-availability- wp-12c-1896116.pdf (page 5, Server HA: Oracle Real Application Clusters)
Question No: 100
Which logical storage relationship is correct?
Tablespacelt; Segment lt; Extent lt; Oracle Datablock
B) Segment lt; Extent lt; Oracle Datablocklt;Tablespace
Tablespacelt; Extent lt; Segment lt; Oracle Datablock
Data File lt;Tablespacelt; Segment lt; Extent lt; Oracle Datablock
Reference: http://www.dummies.com/how-to/content/basics-of-logical-structures-in-oracle- 12c.html