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

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

Oracle Database 12c Essentials

Question No: 1

Which two statements describe data dictionary views?

  1. They are stored in the SYSTEM tablespace.

  2. They are based on virtual tables.

  3. They are owned by the SYS user.

  4. They speed up query and data manipulation language (DML) operations.

  5. The VSFIXED_TABLEview can be queried to list the names of these views.

Answer: A,C

Explanation: https://docs.oracle.com/database/121/CNCPT/datadict.htm#CNCPT1210

Question No: 2

When you start up a CDB, which operations are performed automatically and in what order?

a – The instance is started. b – Control files are opened.

c – The root container is opened (redo logs and root data files). d – Seed pluggable database is in READ ONLY mode.

e – Other PDBs are still in MOUNTED mode.

f – Triggers may fire if they exist to open other PDBs.

  1. a, b, c, d, e, f

  2. b, c, a, d, e, f

  3. c, b, a, d, f, e

  4. a, b, c, d

  5. b, c, a, d

Answer: A

Explanation: http://oracle-base.com/articles/12c/multitenant-startup-and-shutdown-cdb- and-pdb-12cr1.php

Question No: 3

You want to clone PDB1 and PDB2 into the same CDB. Which statement is correct?

  1. You cannot do this, because you can only clone PDBs into another CDB.

  2. You can clone only one PDB (either PDB1 or PDB2) into the same CDB.

  3. Cloning a PDB can use the source files copy method to the target PDB files.

  4. Cloning a PDB can use the NOCOPY clause if the target PDB files use the source files.

Answer: C

Question No: 4

Which statement about CDB architecture is true?

  1. Oracle-supplied metadata resides only in the root container.

  2. A seed PDB can sometimes be opened for particular operations.

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

  4. A CDB can have an infinite number of PDBs.

  5. You can create common users in PDBs.

Answer: A

Reference: http://docs.oracle.com/cd/E16655_01/server.121/e17633/cdbovrvw.htm#CNCPT89235

Question No: 5

You are in the middle of transaction, updating a table. The machine on which the database is running reboots because of a power outage. This causes a database instance failure.

Which statement is true in this situation?

  1. The online redo log files and archived redo log files are required to accomplish a recovery.

  2. The uncommitted transaction is committed at the next startup of the database instance.

  3. The uncommitted transaction is rolled back automatically at the next opening of the


  4. The DBA has to perform a recovery on the database to recover the uncommitted transaction.

Answer: C

Question No: 6

What happens if you execute these SQL statements? SQLgt; show con_name


—————- CDB$ROOT

SQLgt; create user 1_freed identified by y container=current;

  1. A common user is created in the root container.

  2. A local user is created in the root container.

  3. A local user is created in all the PDBs.

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

Answer: D

Question No: 7

YOU want to move all objects of the CONSULTANT user from the test database to theDB- USER schema of the production database. Which option of IMPDP would you use to accomplish this task?

  1. FULL





Answer: D

Question No: 8

Examine the statements:

SQLgt; CREATE TABLESPACE MYTBS DATAFILE #39;/disk1/mytbs_l.dbf #39; SIZE 10M;


partition pi values loss than (100000) tablespacemytbs storage (initial lm), partition p2 values less than (MAXVALUE) tablespacemytbs storage (initial 1m)


When inserting data, you get the error:

ORA-01688: unable to extend table SYS.MYTAB partition P2 by 128 in tablespace MYTBS Which three operations would allow you to insert data without getting the error message?

  1. Extend the logical volume by 10 MB where the data files are stored;

    # lvextend -L 10M /diskl

  2. Add a data file:

    SQLgt;ALTER TABLESPACE MYTBS ADD DATAFILE #39; /disk1/mytbs_2 .dbf SIZE 10M;

  3. Move a partition to another tablespace:

    SQLgt; CREATE TABLESPACE ADDITIONAL_TBS DATAFILE #39;/disk1/additional_tbs_1 .dbf#39; SIZE 10M;


  4. Resize the existing data file:

SQLgt; ALTER DATABASE DATAFILE #39;/diskl/mytbs_l .dbf#39; RESIZE 20M;

E) Remove a data file:

SQLgt; ALTER TABLESPACE MYTBS DROP DATAFILE #39;/diskl/mytbs_l – dbf#39;;

Answer: B,C,D

Question No: 9

Which two items are key for maintaining data consistency in Oracle Database 12c?

  1. undo data

  2. isolation level

  3. lock mechanism

  4. serializability

Answer: B,C

Reference: http://docs.oracle.com/cd/E11882_01/server.112/e25789/consist.htm#CNCPT88969 (overview of the oracle database locking mechanism)

Question No: 10

Ensurepass 2018 PDF and VCE

  1. Option A

  2. Option B

  3. Option C

  4. Option D

  5. Option E

Answer: A,C,E

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