Skip to main content

1Z0-497 Real Exam Questions

Oracle Database 12c Essentials

150 questions available · Page 1 of 15

Updated Exam DumpsVerified AnswersPass Guarantee

Get Complete Exam Dumps
Question 1 Multiple choice

Which four items exist in the root of a CDB, but not in the PDBs?

  1. A

    shared UNDO and default database temporary tablespace

  2. B

    Oracle-supplied metadata

  3. C

    shared Oracle-supplied data

  4. D

    CDB views providing information across PDBs

  5. E

    application tablespaces

  6. F

    local temporary tablespaces

  7. G

    local users and local roles

  8. H

    non-shared local metadata

Show answer and explanation

Correct answers: A, B, C, D

Question 2 Multiple choice

Which three events signal a database writer (DWR) to write buffers to disk?

  1. A

    The database advances a checkpoint.

  2. B

    A client process commits a transaction.

  3. C

    The redo log buffer becomes full.

  4. D

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

  5. E

    A tablespace is changed to read-only status.

  6. F

    The database is shut down in immediate mode.

Show answer and explanation

Correct answers: A, D, E

Explanation

AE: When tablespace is changed to read only status it will issue a Partial checkpoint. During db shutdown a checkpoint is also issued. DWR writes when there is a checkpoint.

Question 3 Single choice

Which option represents the steps to add a multiplexed copy of the current control file or to rename a control file in Oracle Database 12c?

a - Shut down the database. b - Restart the database. c - Copy an existing control file to a new location by using operating system commands. d - Edit the CONTROL_FILESparameter in the database initialization parameter file to add the new control file name, or to change the existingcontrol file name.

  1. A

    b, c, d

  2. B

    a, c, d, b

  3. C

    a, d, b, c

  4. D

    c, d, b

Show answer and explanation

Correct answer: B

Explanation

References:
http://docs.oracle.com/cd/E16655_01/server.121/e17636/control.htm#ADMIN11287

Question 4 Single choice

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

  1. A

    undo data

  2. B

    isolation level

  3. C

    lock mechanism

  4. D

    serializability

Show answer and explanation

Correct answer: C

Explanation

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

Question 5 Multiple choice

Which three statements about common and local roles are true?

  1. A

    When a role is granted to a user, the privileges in the role are limited to the context of the PDB.

  2. B

    Local roles can be granted only to local users.

  3. C

    Common roles can be granted to both local and common users.

  4. D

    A user can create common roles if the user has the CREATE ROLE privilege, and SET CONTAINER for all PDBs

  5. E

    Common roles can be created in the root and PDBs.

Show answer and explanation

Correct answers: A, C, D

Question 6 Single choice

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

  1. A

    renaming the control files

  2. B

    re-creating the control files

  3. C

    dropping a user in your database

  4. D

    dropping a tablespace in your database

  5. E

    configuring the database instance to operate in ARCHIVELOG or NOARCHIVELOG mode

Show answer and explanation

Correct 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.
3. Edit the initialization parameter file to include the initialization parameters that specify the destinations for the archived redo log files 4. Start a new instance and mount, but do not open, the database.

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

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

6. Shut down the database.
SHUTDOWN IMMEDIATE

7. Back up the database.

Question 7 Multiple choice

Examine the table:

Table name: PRODUCTS
Schema: SCOTT
Tablespace: USERS
Organization: Standard (Heap Organized)

This table contains 20 rows. In the data that has been entered, the PROD_ID column contains only single-digit values, PROD_NAME has a maximum of five characters, and PROD_RATE has four-digit values for all rows.

Which two statements are true regarding the modifications that can be performed to the structure of the PRODUCTS table?

  1. A

    PROD_NAME size can be increased from five to 10 characters.

  2. B

    PROD_ID can be changed from CHAR to NUMBER data type.

  3. C

    PROD_RATE size can be changed from NUMBER(4) to NUMBER(6, 2).

  4. D

    New columns can be added only if they have a NOT NULL constraint.

  5. E

    None of the existing columns can be dropped because they contain data.

Show answer and explanation

Correct answers: A, C

Question 8 Multiple choice

Which three options correctly match environment variables with their specific functionality?

  1. A

    ORACLE_SID specifies the instance name.

  2. B

    ORACLE_SID specifies the global database name.

  3. C

    ORACLE_BASE specifies the root of the Oracle Database directory tree in all platforms.

  4. D

    ORACLE_BASE specifies the root of the Oracle Database directory tree only in UNIX and Linux platforms.

  5. E

    ORACLE_HOME specifies the directory containing the Oracle software executables and network files.

  6. F

    ORACLE_HOME specifies the directory containing only the Oracle software executables, but not the network files.

Show answer and explanation

Correct answers: A, C, E

Question 9 Single choice

Which statement regarding Oracle Active Data Guard 12c is false?

  1. A

    Any application compatible with a read-only database can run on an Oracle Active Data Guard standby.

  2. B

    It provides new support for DML to global temporary tables and the use of sequences in the standby database.

  3. C

    It repairs block corruptions detected in the primary or standby database.

  4. D

    It supports different software patch levels between a primary database and its physical standby

    database for the purpose of applying and validating Oracle patches in a rolling fashion.

  5. E

    It supports multi master and bidirectional replication architectures where there are multiple databases that all contain the same data, even if they are not synchronized.

Show answer and explanation

Correct answer: A

Question 10 Single choice

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

    FULL

  2. B

    SCHEMAS

  3. C

    TRANSFORM

  4. D

    REMAP_SCHEMA

  5. E

    REMAP_TABLESPACE

Show answer and explanation

Correct answer: D