[Free] 2018(Jan) Dumps4cert Testking IBM M9520-233 Dumps with VCE and PDF 81-90

Dumps4cert.com : Latest Dumps with PDF and VCE Files
2018 Jan IBM Official New Released M9520-233
100% Free Download! 100% Pass Guaranteed!

Oracle Database 12c Essentials

Question No: 81

Which type of file system is NOT valid for storing data files, online redo log files, and control files for a pluggable database?

  1. Automatic Storage Management (ASM)

  2. OS file system

  3. logical volume (LVM)

  4. clustered file system

  5. RAW

Answer: E Explanation:


Question No: 82

Which two statements correctly distinguish between undo and redo data?

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

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

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

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

Answer: A,C

Question No: 83

For which database operation do you need the database to be in MOUNT state?

  1. renaming the control files

  2. re-creating the control files

  3. dropping a user in your database

  4. dropping a tablespace in your database

  5. configuring the database instance to operate in ARCHIVELOG or NOARCHIVELOG mode

Answer: E

Explanation: To enable or disable archiving, the database must be mounted but not open.

Note: See step 5 below.

Changing the Database Archiving Mode

To change the archiving mode of the database, use the ALTER DATABASE statement with the ARCHIVELOG or NOARCHIVELOG clause. To change the archiving mode, you must be connected to the database with administrator privileges (AS SYSDBA).

The following steps switch the database archiving mode from NOARCHIVELOG to ARCHIVELOG:

1.Shut down the database instance 2.Back up the database.

  1. Edit the initialization parameter file to include the initialization parameters that specify the destinations for the archived redo log files

  2. Start a new instance and mount, but do not open, the database.


    To enable or disable archiving, the database must be mounted but not open.

  3. Change the database archiving mode. Then open the database for normal operations. ALTER DATABASE ARCHIVELOG;


  4. Shut down the database. SHUTDOWN IMMEDIATE

  5. Back up the database.

Question No: 84

Consider 10 scenarios that result in database downtime. Which five of them are considered as planned downtime?

  1. addition or removal of nodes, memory, or disks

  2. changing configuration parameters, upgrading, or patching Oracle software

  3. file deletion

  4. migrating to cluster architecture

  5. dropped database object

  6. table definition changes

  7. runaway processes that consume system resources

  8. adding table partitioning

  9. operating system or storage device / driver failure

  10. database or application deadlocks

Answer: A,B,D,F,H Explanation:

http://docs.oracle.com/cd/E11882_01/server.112/e10803/schedule_outage.htm#HABPT50 83

Question No: 85

You add the following code in the tnsnames.ora file on a client PC: sales=




Which statement is true about the code with respect to creating a new connect identifier?

  1. It is created for the SALES database in the network domain ACME on the SALESDATA


  2. It is created for the SALESDATA database on the SALES server in the network domain called ACME.

  3. It generates an error because the connect identifier name cannot be a part of SERVICE_NAME.

  4. It generates an error because the server configuration mode (dedicated or shared) is not specified.

Answer: A

Explanation: * Example, Basic Format of tnsnames.ora File

net_service_name= (DESCRIPTION=

(ADDRESS=(protocol_address_information)) (CONNECT_DATA=


  • This tnsnames.ora file is a configuration file that contains net service names mapped to connect descriptors for the local naming method, or net service names mapped to listener protocol addresses.

    A net service name is an alias mapped to a database network address contained in a connect descriptor. A connect descriptor contains the location of the listener through a protocol address and the service name of the database to which to connect. Clients and database servers (that are clients of other database servers) use the net service name when making a connection with an application.

    Reference: Oracle Database Net Services Reference

    Question No: 86

    For which use case would you use a rolling upgrade with the Oracle Active Data Guard feature?

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

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

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

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

    Answer: A

    Explanation: You will be able to use this feature to perform database version upgrades starting with the first patchset of Oracle Database 12c (that is, you cannot use it to upgrade from any version earlier than the first Oracle Database 12c patchset). This means that the manual Transient Logical Standby upgrade procedure must still be used when upgrading from Oracle Database 11g to Oracle Database12c, or when upgrading from the initial Oracle Database 12c release to the first patchset of Oracle Database 12c.

    Reference: Oracle Data Guard Concepts and Administration, 12c, Using DBMS_ROLLING to Perform a Rolling Upgrade

    Question No: 87

    You create a CDB with four containers: the loot, the seed, and two pluggable databases PDB1 and PDB2. Which four items can reside In PDB1, but not in the root?

    1. shared UNDO and default database temporary tablespace

    2. Oracle-supplied metadata

    3. shared Oracle-supplied data

    4. CDB views providing information across PDBs

    5. application tablespaces

    6. local temporary tablespaces

    7. local users and local roles

    8. non-shared local metadata

    Answer: E,F,G,H

    Question No: 88

    Examine the error:

    GSM-45054: GSM error or NET-40006: unable to start GSH

    What is the cause of this error, and what troubleshooting steps should you perform?

    1. The GDS catalog database of its listener may be down. Verify that the GDS catalog

      database and its local listener are running.

    2. The GDS pool database may be down. Make sure that the GDS pool databases are up and the service is enabled and started.

    3. The GDS pool database#39;s local listener may be down. Make sure that it is running.

    4. The global service may be down. Verify that the pool databases are up and the service is started.

    5. The global service may be disabled. Make sure that the pool databases are up and the service is enabled and started.

    Answer: A

    Explanation: https://docs.oracle.com/database/121/GSMUG/trouble.htm#GSMUG706

    Question No: 89

    Your customer is looking for a solution to address these downtime needs:

    • Online addition and removal of disks should automatically rebalance data across new storage configurations while storage, database, and applications remain online.

    • Dynamically add or remove clustered nodes without disrupting the database or applications.

    • Automate the sizing and distribution of shared memory.

    • Add a column with a default value without disrupting the database or applications.

    • Perform rolling patch upgrades.

    Which four would you recommend to address those needs?

    1. Automatic Storage Management (ASM)

    2. Online Data and Application change

    3. Global Data Services (GDS)

    4. Real Application Clusters (RAC)

    5. Oracle Streams

    6. Online Table Redefinition

    7. Oracle Database Vault

    Answer: A,B,D,F

    Question No: 90

    In Oracle Database 12c, when does a transaction begin?

    1. when a transaction ID is allocated for it.

    2. when a user explicitly issues a quot;beginquot; statement

    3. when a transaction is assigned to an available undo data segment to record undo entries for the new transaction

    4. when the first executable SQL statement is encountered

    Answer: D

    Explanation: https://docs.oracle.com/database/121/CNCPT/transact.htm#CNCPT038

    100% Dumps4cert Free Download!
    Download Free Demo:M9520-233 Demo PDF
    100% Dumps4cert Free Guaranteed!
    M9520-233 Dumps

    Dumps4cert 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

Leave a Reply

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