[Free] 2018(Jan) EnsurePass Passguide Oracle 1z0-497 Dumps with VCE and PDF Download 91-100

Ensurepass.com : Ensure you pass the IT Exams 2018 Jan Oracle Official New Released 1z0-497
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/1z0-497.html

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?

  1. cluster

  2. database link

  3. mapping table

  4. materialized view

Answer: B

Reference: http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_5005.htm

Question No: 92

Which two statements about Data Recovery Advisor are true?

  1. Data Recovery Advisor can be used to diagnose and repair data corruptions in non- CDBs.

  2. Data Recovery Advisor cannot be used to diagnose and repair data corruptions in the root of a CDB.

  3. Data Recovery Advisor can be used to diagnose and repair data corruptions in PDBs.

  4. You can use the ADVISE FAILURE command to display repair options after running

LIST FAILURE in an RMAN session.

Answer: A,D

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

Exhibit below:

Ensurepass 2018 PDF and VCE

Which three statements are true about terminating a session?

  1. Without any error, you can terminate the active session by executing: SQLgt; ALTER SYSTEM KILL SESSION #39;7, 15#39;;

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

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

  4. Without any error, you can terminate the inactive session by executing: SQLgt; ALTER SYSTEM KILL SESSION #39;12, 63#39;;

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

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

Answer: B,D,E

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:

    http://docs.oracle.com/cd/B28359_01/server.111/b28310/manproc008.htm#ADMIN11192

    Question No: 94

    To revoke unnecessary and unused privileges, you can use Privilege Analysis. Which sequence should you follow?

    1. -Start the analysis.

    2. – 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:

    https://docs.oracle.com/database/121/DVADM/priv_analysis.htm#DVADM1005

    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;

    1. The database stops (shutdown abort).

    2. B) The database Stops (shutdown immediate).

    3. You activate Automatic Shared Memory Management.

    4. You get an error message.

    Answer: C

    Reference: http://www.orafaq.com/forum/t/67825/0/ (see the second post)

    Question No: 96

    An Oracle instance is a combination of .

    1. database files and parameter file (initialization parameter file or server parameter file)

    2. System Global Area (SGA) and background processes

    3. a listener process, server processes, and background processes

    4. System Global Area (SGA), server processes, and background processes

    5. database files, System Global Area (SGA), and background processes

    Answer: B

    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?

    1. It transparently encrypts data at rest in Oracle databases.

    2. It securely manages encryption keys.

    3. It protects against theft or loss of disks and backups.

    4. It prevents OS users from inspecting tablespace files.

    5. It limits the exposure of sensitive data in applications.

    6. It alters data in caches, buffers, and persistent storage.

    7. It impacts operational activities such as backup amp; restore, upgrade amp; patch, and

    replication.

    Answer: E

    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?

    1. There is only one SYSTEM tablespace per CDB.

    2. There is only one instance per PDB.

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

    4. There is only one UNDO tablespace per CDB.

    5. There is one SYSAUXtablespace per PDB.

    Answer: D,E

    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?

    1. Oracle Data Guard

    2. Oracle Streams

    3. Oracle Real Application Clusters

    4. Oracle GoldenGate

    Answer: C

    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?

    1. Tablespacelt; Segment lt; Extent lt; Oracle Datablock

    2. B) Segment lt; Extent lt; Oracle Datablocklt;Tablespace

    3. Tablespacelt; Extent lt; Segment lt; Oracle Datablock

    4. Data File lt;Tablespacelt; Segment lt; Extent lt; Oracle Datablock

    Answer: A

    Reference: http://www.dummies.com/how-to/content/basics-of-logical-structures-in-oracle- 12c.html

    100% Ensurepass Free Download!
    Download Free Demo:1z0-497 Demo PDF
    100% Ensurepass Free Guaranteed!
    1z0-497 Dumps

    EnsurePass ExamCollection Testking
    Lowest Price Guarantee Yes No No
    Up-to-Dated Yes No No
    Real Questions Yes No No
    Explanation Yes No No
    PDF VCE Yes No No
    Free VCE Simulator Yes No No
    Instant Download Yes No No

    Add a Comment

    Your email address will not be published. Required fields are marked *

    This site uses Akismet to reduce spam. Learn how your comment data is processed.