1Z0-497 –Dumps

  1. Which statement about CDB architecture is true?
  2. Oracle-supplied metadata resides only in the root container.
  3. A seed PDB can sometimes be opened for particular operations.
  4. Multiple PDBs with the same name can reside in the same CDB.
  5. A CDB can have an infinite number of PDBs.
  6. You can create common users in PDBs.

Answer: A

  1. As part of your Oracle Database 12c post-installation tasks, you run these commands:

cd $ORACLE_HOME/bin

srvctl stop database -d myDb

chopt enable dm

srvctl start database -d myDb

What does this do?

  1. It enables the Oracle Data Mining option in your Oracle binary files.
  2. It creates the Fast Recovery Area disk group.
  3. It generates Client Static Library.
  4. It configures one of the Oracle user accounts.
  5. It configures Oracle Net Services.
  6. It configures Oracle Messaging Gateway.

Answer: A

  1. Examine the command below:

SELECT SID, SERIAL#, STATUS FROM V$SESSION WHERE USERNAME=’SCOTT’;

SID SERIAL# STATUS

------

715ACTIVE

1263INACTIVE

Which three statements are true about terminating a session?

  1. Without any error, you can terminate the active session by executing:

SQL> ALTER SYSTEM KILL SESSIOU '7, 15';

  1. You can terminate the active session by executing:

SQL> ALTER SYSTEM KILL SESSIOM '7, 15';

But you also get the error message:

ORA-00028: your session has been killed

  1. You cannot terminate the active session. You have to wait until that session becomes inactive.
  1. Without any error, you can terminate the inactive session by executing:

SQL> ALTER SYSTEM KILL SESSION '12, 63';

  1. When an inactive session is killed, the status of that session remains visible in V$SESSION withstatus KILLED. The row of the terminated session is removed from V$SESSION after the user attemptsto use the session again.
  1. You cannot terminate the inactive session. You have to wait until that session becomes activeagain.

Answer: B,D,E

  1. Which two statements are true about shared server sessions?
  2. No Program Global Area (PGA) is allocated for shared server processes.
  3. User Global Area is stored in System Global Area (SGA).
  4. Shared SQL Area is allocated from Program Global Area (PGA).
  5. Private SQL Area is allocated from Library Cache.
  6. Large Pool is used for SQL work areas.

Answer:B,D

  1. Which targets can be managed by using Enterprise Manager Cloud Control?
  2. Hosts and databases
  3. Hosts, databases, and application servers
  4. Application servers and web applications
  5. Databases, Oracle Management Server (OMS), and Oracle Management Repository (OMR)
  6. Databases, application servers, and web applications
  7. Hosts, databases, application servers, web applications, OMS, and OMR

Answer: F

  1. Which two statements are true regarding SQL*Plus?
  2. It has commands for performing database administration operations.
  3. It can be used in interactive but not batch mode for SQL commands.
  4. It has to be installed separately after the Oracle Database 12c installation.
  5. Operating system commands can be executed from the SQL*Plus command prompt.

Answer:A,D

  1. Which two statements about the Process Monitor (PMON) process are true?
  2. PMON performs process recovery when a client process fails.
  3. During instance startup, PMON takes care of instance recovery.
  4. PMON performs listener registration.
  5. PMON restarts background and dispatcher processes when they fail.
  6. PMON resolves failures of distributed transactions.

Answer:A,D

  1. Which statement is true about loading data by using the conventional path of SQL*Loader?
  2. Redo is not generated while performing conventional path loads.
  3. Only PRIMARY KEY, UNIQUE KEY and NOT NULL constraints are checked.
  4. No exclusive locks are acquired when the conventional path loads are performed.
  5. Instead of performing transactions, SQL*Loader directly writes data blocks to the data files.
  6. INSERT triggers are disabled before the conventional path load and re-enabled at the end of theload.

Answer: B

  1. Identify three key properties of a transaction in Oracle Database 12c.
  2. Durability
  3. Consistency
  4. Concurrency
  5. Isolation
  6. Scalability
  7. Manageability

Answer:A,B,D

  1. Which type of file system is NOT valid for storing data files, online redo log files, and control files fora pluggable database?
  2. Automatic Storage Management (ASM)
  3. OS file system
  4. Logical VolumeManager (LVM)
  5. Clustered File System
  6. RAW

Answer: E

  1. Which two statements about ADDM are true?
  2. Real-Time ADDM uses AWR snapshots of the last 10 minutes.
  3. Real-Time ADDM uses ASH recent activity from SGA data.
  4. Real-Time ADDM analyzes performance in a completely different fashion than regular ADDM.
  5. Regular ADDM uses AWR snapshots that are not yet purged.

Answer: B,D

  1. Which two items are key for maintaining data consistency in Oracle Database 12c?
  2. Undo data
  3. Isolation level
  4. Lock mechanism
  5. Serializability

Answer: B,C

  1. You are about to install Oracle Database 12c Enterprise Edition. Which statement is true?
  2. You should not install the Oracle Database software into an existing Oracle home from a differentrelease.
  3. A multitenant container database (CDB) can have several pluggable databases (PDBs) withdifferent character sets.
  4. Oracle recommends that you back up the root. sh script after you complete the installation.
  5. Cloning an Oracle home is useful if you are performing multiple Oracle Database Installations.
  6. You can stop existing Oracle processes, including the listener and the database running in theOracle home, before the database software installation.

Answer: C

  1. Which logical storage relationship is correct?
  2. Tablespace< Segment < Extent < Oracle Datablock
  3. Segment < Extent < Oracle DatablockTablespace
  4. Tablespace< Extent < Segment < Oracle Datablock
  5. Data File <Tablespace< Segment < Extent < Oracle Datablock

Answer: A

  1. Which two statements about multitenant architecture are true?
  2. Multiple PDBs on a single server need multiple database instances and multiple sets of databasefiles.
  3. Although consolidated into a single physical database, PDBs mimic the behavior of non-CDBs.
  4. A PDB administrator can use Oracle Flashback or point-in-time recovery to retrieve lost data froma PDB, only by shutting down all the PDBs from the CDB.
  5. It is easier to collect performance metrics for many databases in a CDB than individual non-CDBdatabases.
  6. It takes more time to apply a patch to one CDB that holds hundreds of PDBs than to hundreds ofnon-CDB databases.

Answer: B, D

  1. Which three statements represent the benefits of multitenant architecture for databaseconsolidation?
  2. You can unplug a PDB from a development CDB and plug it into a production CDB, which allowsfor easier and more rapid movement of data and code.
  3. You can consolidate shared database memory by combining multiple PDBs in a single CDB.
  4. Patching individual PDBs requires the same amount of time as patching individual databases.
  5. Consolidating separate databases into a single CDB requires the same amount of storageallocation.
  6. In multitenant architecture, a PDB behaves the same as a non-CDB as seen from a clientconnecting with Oracle Net. No client modification is required.

Answer: A,B,E

  1. Which statement about the Oracle Advanced Security Data Redaction feature is true?
  2. It transparently encrypts data at rest in Oracle databases.
  3. It securely manages encryption keys.
  4. It protects against theft or loss of disks and backups.
  5. It prevents OS users from inspecting tablespace files.
  6. It limits the exposure of sensitive data in applications.
  7. It alters data in caches, buffers, and persistent storage.
  8. It impacts operational activities such as backup & restore, upgrade & patch, and replication.

Answer: E

  1. Which three statements about Automatic Database Diagnostic Monitor (ADDM) are true?
  2. It requires the database to be open.
  3. It analyzes the performance of specified objects.
  4. It implements all recommendations automatically.
  5. It recommends solutions and quantifies expected benefits.
  6. It retains snapshots in the SYSAUX tablespace until the database is restarted.
  7. It analyzes the snapshots stored in the Automatic Workload Repository (AWR).

Answer: A,D,F

  1. Which is the default port number for Oracle EM Database Express 12c?
  2. 7801
  3. 5500
  4. 2243
  5. 1521
  6. 22

Answer: A

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

- Online addition and removal of disks should automatically rebalance data across new storageconfigurations 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
  8. Online System Reconfiguration

Answer: A,B,D,H

  1. Your database instance is down because there was a user-initiated shutdown. Which optionrepresents the actions performed, in the correct order, if you start up the instance?

a - The control file is read.

b - Memory is allocated.

c - Background processes pre started.

d -The initialization parameter file is read,

e- Redo log files and data files are opened.

  1. b, c, a
  2. d, a, e
  3. a, e, d, b
  4. d, b, c, a, e
  5. c, b, d, a, e

Answer: D

  1. Which three components are always parts of System Global Area?
  2. Database Buffer Cache
  3. Undo Log Buffer
  4. Shared Pool
  5. Small Pool
  6. Java Pool
  7. Private SQL Area

Answer: A,C,E

  1. Which two statements about Database Express are true?
  2. It uses internal infrastructure components, such as XDB and SQL*Net.
  3. It can perform actions outside the database.
  4. It has background tasks and processes that periodically collect information via FTP.
  5. It has two new features: Performance Hub and Composite Active Reports.
  6. It is not supported on Standard Edition (SE) and Express Edition (XE).

Answer: A,D

  1. Which three operations can the PUBLIC user with the SYSOPER privilege perform?
  2. STARTUP
  3. SHUTDOWN
  4. CREATE DATABASE
  5. DROP DATABASE
  6. ALTER DATABASE RECOVER (Only complete recovery)

Answer: A,B,E

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

1 -Start the analysis.

2 - Set up the analysis policy type (database, role, and context).

3 - Generate the results.

4 -View the results in DBA_USED_PRIVS and DBA_UNUSED_PRIVS.

5 - Stop the analysis.

  1. 1, 2, 3, 4, 5
  2. 2, 1, 5, 3, 4
  3. 5, 1, 2, 3, 4
  4. 2, 3, I, 5, 4
  5. 1, 2, 4, 5, 2

Answer: B

  1. Which command do you use to create a local role while you are connected as the local user?
  2. create local role l_hr;
  3. create role c##_hr container=current;
  4. create role l_hr container=current;
  5. create role l_hr container=all;

Answer: C

  1. You want to move all objects of the CONSULTANT user from the test database to theDB-USERschema of the production database. Which option of IMPDP would you use to accomplish this task?
  2. FULL
  3. SCHEMAS
  4. TRANSFORM
  5. REMAP_SCHEMA
  6. REMAP_TABLESPACE

Answer: D

  1. For which database operation do you need the database to be in MOUNT state?
  2. Renaming the control files
  3. Re-creating the control files
  4. Dropping a user in your database
  5. Dropping a tablespace in your database
  6. Configuring the database instance to operate in ARCHIVELOG or NOARCHIVELOG mode

Answer: E

  1. Examine the table:

Table name: PRODUCTS

Schema: SCOTT

Tablespace: USERS

Organization: Standard (Heap Organized)

Rows: 20

Columns:

PROD_ID NUMBER(1)

PROD_NAME CHAR(5)

PROD_RATE NUMBER(4)

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

  1. PROD_NAMEsize can be increased from 5 to 10 characters.
  2. PROD_IDcan be changed from CHAR to NUMBER data type.
  3. PROD_RATEsize can be changed from NUMBER(4) to NUMBER(6, 2).
  4. New columns can be added only if they have a NOT NULL constraint.
  5. None of the existing columns can be dropped because they contain data.

Answer: A,C

  1. A DBA informs you that an Oracle instance has started. What does this imply?
  2. Users can access the data in the database.
  3. Only SGA has been allocated for the database.
  4. Only background and user processes are running.
  5. Memory areas have been allocated and background processes have been started.

Answer: D

  1. Real-Time ADDM detects a high-load performance issue within the database. Which conditiontriggered it?
  2. The average active sessions were more than 3 times the number of CPU cores.
  3. Active sessions were more than 10% of total load and CPU utilization was more than 50%.
  4. Memory allocations were more than 95% of physical memory.
  5. Hung sessions were more than 10% of total sessions.4
  6. A deadlock was detected.
  7. The session limit was close to 100%.

Answer: A

  1. Which command do you use to check for block corruption by validating the database?
  2. RMAN> VALIDATE CHECK LOGICAL
  3. RMAN> VALIDATE BACKUP
  4. RMAN> VALIDATE CORRUPT BLOCKS
  5. RMAN> VALIDATE DATABASE

Answer: D

  1. Which tool is recommended for moving a PDB to a non-CDB?
  2. RMAN
  3. Cold Backup
  4. Traditional Export / Import
  5. Data Pump
  6. SQL*Plus

Answer: D

  1. Which two statements describe data dictionary views?
  2. They are stored in the SYSTEM tablespace.
  3. They are based on virtual tables.
  4. They are owned by the SYS user.
  5. They speed up query and data manipulation language (DML) operations.
  6. TheV$FIXED_TABLEview can be queried to list the names of these views.

Answer: A, C

  1. Which two statements about this policy are true?

BEGIN

DBMS_REDACT.ADD_POLICY(

object_schema => 'HR',

object_name => 'EMPLOYEES',

column_name => 'SALARY',

column_description ='emp_sal_comm shows employee salary and commission');

policy_name => 'redact_emp_sal_comm',

function_type => DBMS_REDACT.PARTIAL,

function_parameters => '9,1,4',

expression => '1=1',

END;

/

BEGIN

DBMS_REDACT.ALTER_POLICY(

object_schema => 'HR',

object_name => 'EMPLOYEES',

policy_name => 'redact_emp_sal_comm',

action => DBMS_REDACT.ADD_COLUMN,

column_name => 'COMMISSION_PCT',

function_type => DBMS_REDACT.PARTIAL,

function_parameters => '9,1,1',

expression => '1=1',

END;

/

  1. It replaces the first four digits of the value from the SALARY column with the number 9.
  2. It replaces the first digit of the value from the SALARY column with the number 4.
  3. It replaces the first digit of the value from the COMMISSION_PCTcolumn with 9.
  4. It replaces the first nine digits of the value from the COMMISSION_PCTcolumn with 1.
  5. It uses the full data redaction method.
  6. It uses the random redaction method.

Answer: A,C

  1. Which option represents a function of Global Data Services (GDS)?

A. Performs data replication

B. Performs database failovers

C. Replaces the functionality of Oracle Clusterware and Oracle RAC

D. Coordinates site failovers

E. Works seamlessly with Oracle Site Guard

Answer: E

  1. Which two statements represent where Oracle Net must reside?
  2. Only on the client for traditional client/server applications
  3. Only on the database server for web-based applications
  4. On both the web server and database server for web-based applications
  5. On both the client and database server for traditional client/server applications.

Answer: C,D

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

  1. Which new process was introduced as of Oracle Database 12c?
  2. Result Cache Background process (RCBG)
  3. AQ Coordinator process (QMNC)
  4. Change Tracking Writer process (CTWR)
  5. Listener Registration process (LREG)

Answer: D

  1. Examine the SQL statement:

SQL> select con_id, name, open_mode from v$containers;

CON_IDNAMEOPEN_MODE

------

1CDB$ROOTREAD WRITE

2PDB$SEEDREAD ONLY

3PDB1READ WRITE

4PDB2MOUNTED

Connected as SYS to CDB$ROOT, you create a new common user c##usr –

SQL> CREATE USER c#usr IDNETIFIED BY pwd CONTAINER=ALL;

SQL> GRANT CREATE SESSION TO c#user CONTAINER=ALL;

Then, you open PDB2:

SQL> ALTER PLUGGABLE DATABASE pdb2 OPEN;

Which two statements are true about this common user?

  1. SQL> conn c##usr/pwd@pdb1

You are connected to PDB1 successfully.

  1. SQL> conn c##usr/pwd@pdb2

You are connected to PDB2 successfully.

  1. SQL> conn c##usr/pwd@pdb2

You are unable to create a connection. You first need to sync PDB2 by executing:

SQL> conn / as sysdba

SQL>exec DBMS_PDB.SYNC_PDB;

  1. SQL> conn c##usr/pwd@pdb2

You are unable to create a connection. You need to create the common user c# #usr explicitly in PDB2by executing:

SQL>conn system/pwd@pdb2

SQL> CREATE USER c##usrIDENTIFIEDBYpwd CONTAINER=CURRENT;

Now you are able toconnect as common user c##usr to PDB2.

NOTE: exec DBMS_PDB.SYNC_PDBis used while creating PDB from Non-CDB.

Answer: A,B

  1. Which two statements are true regarding undo data records?
  2. They are required to support Flashback features.
  3. They are not required if Flashback features are enabled.
  4. They are retained until the session making the changes ends.
  5. Undo records contain copies of data as it appears after a change is made.
  6. Undo records contain copies of data as it appears before a change is made.

Answer: A,E

  1. Your customer has two CDBs: one for Production and one for development. You are asked to create anew development PDB (salesdev) from an existing production PDB (salesprd). Which two options wouldaccomplish this?
  1. You copy all the PDB$SEEDdata files from the production CDB into the development CDB andexecute this on the development CDB;

SQL> CREATE PLUGGABLE DATABASE salesdev ADMIN USER salesdm IDENTIFIED by password;

  1. You alter the salesprd source database to open in read-only mode, and start cloning the sourcedatabase:

SQL> ALTER PLUGGABLE DATABASE salesprd OPEN READ ONLY;

SQL> CREATE PLUGGABLEDATABASE salesdev FROM salesprd;

  1. You alter the salesprd source database to open in read-only mode:

SQL> ALTER PLUGGABLE DATABASE salesprd OPEN READ ONLY;

In the development CDB, youcreate a databaselink "PRD" that connects to the root of the source CDB, and start cloning the sourcePDB:

SQL> CREATE PLUGGABLE DATABASE salesdevFROMsalesprd@prd;

  1. Connected as the salesprd local DBA, you create an XML using:

SQL> ALTER PLUGGABLE DATABASE salespdb UNPLUG INTO '/tmp/salesprd-xml';